We have done all of that, any other ideas?
Ok, I moved the site to cpanel.
Re-installing and getting this error
One or more database tables are unavailable. The database may need to be repaired.
any idea how to fix?
Ok I figured out to clikc the word repair ands I get
One or more database tables is unavailable. To allow WordPress to attempt to repair these tables, press the “Repair Database” button. Repairing can take awhile, so please be patient.
Repair Database
WordPress can also attempt to optimize the database. This improves performance in some situations. Repairing and optimizing the database can take a long time and the database will be locked while optimizing.
Repair and Optimize Database
I click repair databas
then I get a screeen asking if I’m sure, click please try again
screen then goes back to repair database and nothing happens
Ok got repair to work,( database server was down) here are results it told me to post to forum:
wp_posts: Table ‘advicean_newcolumns.wp_posts’ doesn’t exist
wp_comments: Table ‘advicean_newcolumns.wp_comments’ doesn’t exist
wp_links: Table ‘advicean_newcolumns.wp_links’ doesn’t exist
wp_options: Table ‘advicean_newcolumns.wp_options’ doesn’t exist
wp_postmeta: Table ‘advicean_newcolumns.wp_postmeta’ doesn’t exist
wp_terms: Table ‘advicean_newcolumns.wp_terms’ doesn’t exist
wp_term_taxonomy: Table ‘advicean_newcolumns.wp_term_taxonomy’ doesn’t exist
wp_term_relationships: Table ‘advicean_newcolumns.wp_term_relationships’ doesn’t exist
wp_commentmeta: Table ‘advicean_newcolumns.wp_commentmeta’ doesn’t exist
The db user *must* have ALL permissions on the db. When a site is created, new tables are made. If the db user does not have permission to do that… you get these results.
Ok, after lots of checking by my web host they assure me I have all permissions on the db, can it be anything else?
But do you have access with the ID you have listed in your WP-config.php file?
yes, I do. My webhost verified I have all privileges.
I’m being pedantic for a reason. Did they verify for THAT id or just YOUR id?
In my wp-config.php I have my SQL user ID as ‘ipstenu_wordpress’ for example, and THAT is the ID that needs full privs, not my Ipstenu ID.
My Sql user id name is the same as my wordpress user name, Privileges are listed in the cpanel control panel under databases. All is marked.
Do I or can I change anything in the database using phpadmin to help?
Your WordPress username has jack to do with SQL.
There are multiple IDs, and I’m going to break them down so you can see what I mean.
1) Your server login ID – this is the ID and password combo you use to SSH/FTP into your server. Generally it’s the same as the one you use to get into cPanel.
2) Your WordPress ID – the one you log into WP with 😉
3) Your SQL ID – this is the one defined in the wp-config.php, and it’s actually created FOR the database. In my case, I made it directly in the database admin screen of cPanel, and assigned it to the databases I wanted, with full permissions.
It is Entirely Likely that these are totally different IDs with totally different passwords. In fact, I would urge you, for security, to make sure they’re all different 🙂
I’m trying to make sure that ID #3 is both IN the specific database as a user, AND has full access. They may look similar, but it’s really easy to get them confused. Check under the specific WordPress database that you gave the ID access to THAT database.
Meanwhile, go into the database and verify the tables are actually there. If not, it’s possible when you moved from PLESK to cPanel you didn’t bring them all over.
ID# 3 is all privileges, verified by webhost
The missing tables are not in the cpanel database, nor are they in the plesk database, maybe they got wiped out in one of the plesk re-installs, or?
So how about if I just add the tables to the cpanel database?
I can do this manually, would the number of columns and names be the same as wp_1_*
Did you originally have WPMU or was this a wordpreess 3.0 install? In WPMU, you start with WP_1 as your main site, but in WP 3.0 you start with no numerical prefix… It kind of looks like you didn’t restore your site but made a new site and then imported the old DB.
The missing tables are not in the cpanel database, nor are they in the plesk database,
cpanel and plesk are both web account control panels. normally you do not have both – just one.
Can we go over – in a nutshell – what the actual problem is again?
