UPDATE: Jer995 had sent me an email, and we also discussed the "plan" on GoogleTalk, before I had done his upgrade. He gave me his FTP informations, and phpMyAdmin login informations too.
After he had done what I mentioned above, he was still having problems, which he had mentioned above here.
Then, in the email he had sent me, he basically said he uninstalled most of the plugins, and believed that playing with a few "rating plugins" (example: post_star_rating), might have *also* been a factor in his having problems..
While on GoogleTalk, he was talking about the wp-cache database table again, which he mentioned above. I had then told him to put a check by that wp-cache database table, and choose DROP.
Which he had done. NOW, I had gone into his FTP directory, downloaded a copy of his wp-config.php file, ALL his plugin files, a copy of his current running theme, just to be safe.
Also, had made a database backup of ALL the tables, which wasn't much, thank God! Saved the Database backup to my hard drive, with his other stuff..
Then! Deleted EVERYTHING, but the wp-content/ folder, of course. And uploaded ALL NEW 2.0.6-beta1 files. I did this, because it's a beta now anyway, and most likely will be released this month.. besides.. 2.0.5 is buggy, and stuff..
Anyway, after uploading ALL those files, and ran the upgrade script. I had received the following Database error on the "success page", or, 2nd page if you will, after clicking the "UPGRADE WORDPRESS" link.
WordPress database error: [Access denied for user 'hisusername'@'localhost' to database 'blog']
ALTER TABLE wp_posts ADD KEY post_status (post_status)
Which told me, he didn't have ALL his privileges on his database there, however, his blog was fully upgraded to the 2.0.6-beta1. BUT! When trying to delete a post under the Manage => Posts => Deleting - a post.. It gave the "You don't have permission to do that." Message.
I then went to check his "USER" table(s) in the database, following Podz's guide on "restoring admin role".. After checking his database tables, to what was shown on Podz's guide.. it was ALL correct and right, how weird is that right, lol?
After scratching the head for a few minutes, and talking with JeremyVisser about it, on GoogleTalk. By the way, thanks again JeremyVisser! ;) :) He basically said to restore the original database, then, re-run upgrade again.
However, here is what I did.. I then made a backup of the database with 2.0.6-beta1 in it, just to be safe. I saved that Database copy, into a folder called: 206 Database Backup, to keep it apart from the other one. ;)
THEN!(WHILE LEAVING THE 2.0.6-BETA1 FILES STILL IN THE BLOG'S FTP DIRECTORY), I followed Podz's guide on restoring into the existing database. Once the original 2.0.2 copy of the database was done, and everything went well..
Remembering his database user didn't have ALL his privileges for it, I went to the HOME page of the phpMyAdmin .. clicked on the Privileges link, then, found his username listed there.. clicked on the EDIT button..
On next page, scrolled down to the:
Database-specific privileges section, and clicked the EDIT button again, for his Blog database..
I then noticed that ALL the check boxes weren't checked:
The DATA COL was all checked.
The STRUCTURE COL.. just has create checked.
Administrator COL has two options, GRANT and REFERENCES.
I then CHECKED ALL, for it. Then, hit the Go button, everything was applied successfully then.
However, when on the privileges home page, it's showing his user with GLOBAL PRIVILEGES of USAGE.. with a red message on top of page..
"Warning: Your privilege table structure seem to be older than this MySQL version!
Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!"
Which I'm not sure about how to do, maybe he'll have to do that, or the host..
Anyway, after giving the USER ALL PRIVILEGES, as I mentioned a little ways up there.. I then RE-RAN the upgrade.php script, and it upgraded with NO DATABASE ERRORS...
However, at first, when in the admin control panel, I was still getting the "You don't have permission to do that." Message when trying to delete a test post, but, I did a hard clear of cache, and logged out, then back in again.
And was then able to delete the posts.. If anything more comes of this, I'll report back here with another update. I hope this helps someone else down the road..
For now, Merry Christmas!
http://gfsupport.com/blog/
spencerp
Jer995
vkaryl
spencerp
