• Hey guys,
    I just upgraded my WordPress instalation to 1.2, I did it through the Fantastico automatic installation thingy on my server. Well, I was warned that all themes were going to disappear, what I didn’t know is that not only that was going to happen but also there would be no posts at all and a big fat error on the top part of the blog. I have a backup of the old version, but I really wanna be able to function the same way without having to downgrade. The error I get is the following:
    Database error: [Unknown column ‘post_date_gmt’ in ‘where clause’]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2004-07-30 16:10:59’ AND (post_status = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 20
    Whatever that’s supposed to mean, I checked for the SQL preferences on the server and everything was linked properly. I’t would be highly appreciated if someone could provide me with some help. Thanks a ton in advance!

Viewing 15 replies - 1 through 15 (of 20 total)
  • Run upgrade.php again ?

    Thread Starter Mikel

    (@mikel)

    Well the whole upgrade was taken care of by the automatic installer, which means that i shouldn’t have to do anything manually, moreover, the upgrade.php file already disappeared… Any other ideas? I really would hate to have to downgrade…

    I just typed a load, then went to your site – all is now sorted πŸ™‚
    I just ran the wordpress upgrade script, and it’s fine to stay there – no need to delete it πŸ™‚

    Thread Starter Mikel

    (@mikel)

    Wow, thats amazing! How did you do that? I’m so impressed hahahah. Thanks a lot man, what a helpful board, way to go man! Thanks again.

    Thread Starter Mikel

    (@mikel)

    It seems that it deleted the admin account that I had previously created… How can I log in now?

    That’s a fault of their auto-installer.
    Try here: http://faq.wordpress.net/view.php?p=68

    Thread Starter Mikel

    (@mikel)

    Oh dear I think I might have messed it up big time. I was going through the steps and none of them seemed to work, so I decided to replace the wp-login.php file with the code that was given at that website. Well now nothing seems to work, in fact this is what I get when I try to log in…
    http://mcarmenes.com/blog/wp-login.php
    Thanks in advance for all the help!

    Hmm… that looks like plain text.
    You could try getting the code again, copying only what is between the <?php and ?>, pasting it into WordPad, saving as ‘wp-login.php’ and uploading.
    Alternatively, just upload an original wp-login.php (if you haven’t got a copy, download from the link at the top of the page )
    Once that is sorted, we can get back to the other problem πŸ™‚
    Do you have phpmyadmin ? It will be listed on your cpanel (sometimes called mysql administration tool)

    Thread Starter Mikel

    (@mikel)

    Hey podz, I tried the phpmyadmin, didn’t work, but now I dunno what I did, somehow I repasted the text and it’s working just fine, how awesome haha. thanks for all your helpful answers. Next time I have a problem I know where to go, what a great support xD.

    Good stuff !

    hellooooo!! i just upgarded to version 1.2 and faced the exact same problem! is my template and posts all gone??? help!!!

    @anon – please, what are your problems exactly – this is a long thread.
    A url would be good too – help will be here πŸ™‚

    wow wow, thanks!!! my site is this h t t p : / / l i c e n c e t o s p i l l . n e t
    i upgraded to 1.2 version an hour ago… and after using the fantastico thingie on my server to do the upgrade i got this greeting me on my homepage:
    Database error: [Unknown column ‘post_date_gmt’ in ‘where clause’]
    SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND post_date_gmt <= ‘2004-08-15 20:35:59’ AND (post_status = “publish”) GROUP BY wp_posts.ID ORDER BY post_date DESC LIMIT 6
    and the OLD TEMPLATE! arghhhh!! are all my old stuff and tempalte and posts gone??? i havent done a backup yet!
    and then i tried to login, and to my horror, my password isnt working and so i click on “forgot password?” and was emailed a new password. still i couldnt log in.
    i tried changing the wp-login: Replace:
    $user_login = $user_data[Ò€ℒuser_loginÒ€ℒ];
    with:
    $user_login = $user_data->user_login;
    like what you had suggested in yoru faq, nothing’s changed.
    and then , i copied this thing when the upgrade had taken place… just in case something cocks up…
    Upgrading…
    Initializing Parameters – Done.
    Generating MySQL Backup – Done.
    Generating Files Backup – Done.
    Copying New Files – Done.
    Upgrade completed
    Your installation of WordPress was upgraded.
    You can view it here: http://l i c e n c e t o s p i l l . n e t/
    Please save following information. You will need it in order to restore if something went wrong
    If you don’t have SSH access, ask support to help you:
    – Remove the directory /home/licence/public_html
    – Untar /home/licence/fantastico_backups/.backup.1092597954.tgz
    – Empty the database licence_wrdp1
    – Import the file /home/licence/public_html/backup.sql into the database licence_wrdp1
    how do i restore everything to the original?? with orig post, orig template, orig everything… i hate to lose anything! it was a mistake upgrading to version 1.2! πŸ™

    It works now πŸ™‚
    I ran the upgrade script from with 1.2
    The wp-layout.css is now the default one though – you did have a back-up of that ….. ?

    sorry, im just a little overwhelmed at this moment. cos i had a new site using the newer 1.2 wordpress version, and indeed it’s much better than the old one with better features. that’s the reason why i wanted to do an upgrade. but instead, i’m faced with all these greek instructions after the upgrade. πŸ™

Viewing 15 replies - 1 through 15 (of 20 total)

The topic ‘Database Error, Help Please! xD’ is closed to new replies.