• Resolved rprins

    (@rprins)


    When pointing my browser to upgrade.php after uploading all of the RC3 files, I get the following errors:

    WordPress database error: [Table ‘rprins_wordpress.wp_usermeta’ doesn’t exist]
    SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = ‘1’

    Warning: Cannot modify header information – headers already sent by (output started at /home/.sacko/rprins/lazyi.net/wp-includes/wp-db.php:102) in /home/.sacko/rprins/lazyi.net/wp-admin/upgrade.php on line 10

    I am currently running 1.5.2. I saw that somebody else had this problem, but it was buried in an unrelated thread, and I thought I would open this one to give it more visibility. If you have any ideas, I’d love to hear them.

    Thanks!

Viewing 15 replies - 1 through 15 (of 32 total)
  • It does complete the upgrade, even with those messages, right?

    Did you delete User ID 1 from your 2.0 database?

    Hey, I just posted about the the same problem (https://www.ads-software.com/support/topic/52798). I clicked upgrade regardless of these error messages and it works fine. ??

    Nice update, no problem on
    https://perso.argentine-news.com/
    Anyway I will wait before updating the other one

    I hope you made backups. See if it works regardless. I would only be worried about:

    WordPress database error: [Table ‘rprins_wordpress.wp_usermeta’ doesn’t exist]
    SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = ‘1’

    Keep an eye on users to spot bugs early on, if at all.

    I got this errors after upgrading to the latest version & cannot log-in to admin.

    WordPress database error: [Table ‘knoizki_index.wp_usermeta’ doesn’t exist]
    SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = ‘1’

    Thanks for your help.

    WP’s upgrade.php creates wp_usermeta table and works fine regardless of the error message.

    Thread Starter rprins

    (@rprins)

    I was able to backup to 1.5.2 just fine, so I’m safe ??

    But, like K said, I couldn’t log in to the admin panel at all with my old user name.

    Also, when I upgraded, so, step 1, there was a lot of errors, more than I am accustomed to with a WP install. Some had to do with comment counts and the rest had to do with the wp_usermeta table, which in my 1.5.2 install doesn’t exist.

    Now, like zqw said, even after the install completed, it worked fine on the exterior (minus some custom queries I need to fix), but I couldn’t log into the admin panel at all.

    So, would I say that it completes the upgrade? No, not successfully at least. I’d say that the script ran, but that that the upgrade did not run as expected.

    It is so depressing, been re-uploading, deleting & now I lost all my backup. How am I gonna be able to fix the problem? Can I redowngrade it back to 1.5 version?

    Thank you.

    Warning: session_start(): Cannot send session cookie – headers already sent by (output started at /hsphere/local/home/knoizki/knoizki.com/wordpress/wp-includes/wp-db.php:102) in /hsphere/local/home/knoizki/knoizki.com/wordpress/wp-content/themes/squible/comments.php on line 21

    That’s another error found just now. What is going on??

    I guess no one likes to reply and explain what causes this problem.

    There’s a session_start command after the stream has already received header information. As far as I know, this message shouldn’t have any influence on the installation process. Just go with that. ??

    I am having the same problem…I can’t log into my admin with my usual admin user name and password. I just keep getting the errror: “You do not have sufficient permissions to access this page.” Everything else look fine on the exterior.

    I just tried to reset my password by entering my user name and e-mail address. It sent me a new password, but when I tried to log in with it tells me it is incorrect. The old one, however, still gives me the error message “You do not have sufficient permissions to access this page.”

    This is probably the 5th or 6th time I’ve backed up, reloaded, upgraded and installed wp2.

    Finally it’s working. Here’s what I did.

    Leave your 1.5.2 WP intact. Make sure that the 1.5 wordpress install is in the directory that you want WP2 to be installed to.

    Backup your database just in case. In fact, back it up twice or three times just to make sure you always have a copy.

    Make sure you are still logged into your 1.5.2 install. It will have the cookies and such still intact so there is no need to login again. Do not logout.

    Move the 1.5.2 contents into a directory that you create. (Mine happened to be named /old/).

    Upload WP2 to the / directory where 1.5.2 was installed. Now your directory structure should look like: /wp-content/, /wp-admin/, /wp-includes/, /old/

    Navigate to [Wordpress install here]/wp-admin/upgrade.php

    You might (probably will) recieve the error:

    WordPress database error: [Table ‘yourdbname.wp_usermeta’ doesn’t exist]
    SELECT meta_key, meta_value FROM wp_usermeta WHERE user_id = ‘1’

    Ignore it. Click upgrade.

    You will probably still see that same error on the second page. Just ignore it. If you see no other errors then click continue to go to your site.

    Now, you might possibly see a totally blank page. I did. Now, go to /wp-admin/. No need to login since you were already logged in. Hopefully this should stop the password issues you had.

    Click on the presentation tab and since your old theme isn’t compatible (at least mine wasnt) wordpress will default to the default theme.

    Now go to your site homepage and everything should be fine.

    I was having lots of trouble and this is what solved it all for me. (Note: This is exactly what I did, if it doesn’t work for you, sorry, I can try to help but I can’t promise that what I say will work).

    Also, if you screw up your database and you didn’t backup, it’s not my fault.

    If you still are having password issues, you can always manually change the password by hand in the database.

    (This is in phpMyAdmin)

    Navigate to:
    wpdatabase > wp_users
    Click Browse and find the user ‘admin’.
    Click on the little ‘Pen’ icon.
    Go down until you find the user: user_pass

    Use this little tool:
    https://pajhome.org.uk/crypt/md5/

    To MD5 hash your new password and stick it in that field.
    Save the changes and relogin to your wordpress with your new password.

    Enjoy. Once again, if you screw up your database and you didn’t backup, it’s not my fault.

    Edit: I realize the reason my theme wasn’t compatible was because I forgot to move it to the new WP install.

Viewing 15 replies - 1 through 15 (of 32 total)
  • The topic ‘Upgrade Problem in RC3’ is closed to new replies.