wolfmank

Categories are also missing in action… wow I wonder what happened that fubar’d my database so much.

Holy Shit it worked! Thanks Otto, you are the best. much love and thanks.

well it mostly worked, I can’t moderate comments, and akismet is off line… but everything else seems to be ok… it’s workable until I get the fresh install. ??

Well that is in the game plan but I was hoping to pull this one back to life before I had to start over.

So basically if I can find the old version number i can just change that field in phpmyadmin where we were yesterday to what it should be and we should be good to go?

In theory….?

version.php
<?php

// This holds the version number in a separate file so we can bump it without cluttering the SVN

$wp_version = ‘2.3.3’;
$wp_db_version = 6124;

?>

Otto? anyone? Help!

Is there anyway to fix this?

whoa…

No there is no other db_version in the wp_options table… ??

The interesting thing is the site is still up and running, it’s the dashboard that won’t display complains of wanting a db upgrade.

All my articles are there and I can post new content via an offline editor. ??

option_name “db_version” has option_value “1”in the wp_options table.

Is that what you are asking?

ok yeah sorry was using the wrong username to access phpmyadmin posting table structure for wp_users now.

https://img.skitch.com/20080324-3tp3ns15kmcdfgc3ytedkufmn.jpg

Thats a link to a screen grab showing the print version of the table structure.

Here is the paste:

ID 	bigint(20)	No
user_login 	varchar(60)	No
user_pass 	varchar(64)	No
user_nicename 	varchar(50)	No
user_email 	varchar(100)	No
user_url 	varchar(100)	No
user_registered 	datetime	No 	0000-00-00 00:00:00
user_activation_key 	varchar(60)	No
user_status 	int(11)	No 	0
display_name 	varchar(250)	No

How do I give myself permissions? I don’t see that in phpmyadmin.. ?

Actually… I am getting that for every wp_* table. ?? Should that be?

From my phpmyadmin wp_users Structure tab.

Error
SQL query:

SHOW INDEX FROM wp_users ;

MySQL said:

#1142 – SELECT command denied to user ”@’localhost’ for table ‘wp_users’

I am having the exact same problem and also don’t know what to do. Luckily the site is still taking content from my offline post writer, but not having access is annoying as hell.

If I find a solution that works I will post it here, but in the mean time I am looking for help as well. Please help if you can.