Database Tables Missing in Multi-site
We have a multi-site network with over 2000 sites on it. We originally built it using wordpress MU, and have tried to keep it up to date with the merge. We were doing some testing on our development server to upgrade to 3.3 and it failed during the network upgrade when it got to a certain blog on the site. It said.
“Warning! Problem updating . Your server may not be able to connect to sites running on it. Error message: A valid URL was not provided.”
Well, I found the site that kept failing (remembering it goes backward through the list). When I went to the site it showed as “Error Establishing Database Connection”. This is the only site on the whole network (that I know of) that was doing this. All other sites are working fine.
I tried logging into the dashboard and it brought up the “Repair Database” dialog. I ran the repair and it could not fix the errors, and brought up these messages.
wp_1653_posts: Table ‘databasename.wp_1653_posts’ doesn’t exist
wp_1653_comments: Table ‘databasename.wp_1653_comments’ doesn’t exist
wp_1653_links: Table ‘databasename.wp_1653_links’ doesn’t exist
wp_1653_options: Table ‘databasename.wp_1653_options’ doesn’t exist
wp_1653_postmeta: Table ‘databasename.wp_1653_postmeta’ doesn’t exist
wp_1653_terms: Table ‘databasename.wp_1653_terms’ doesn’t exist
wp_1653_term_taxonomy: Table ‘databasename.wp_1653_term_taxonomy’ doesn’t exist
wp_1653_term_relationships: Table ‘databasename.wp_1653_term_relationships’ doesn’t exist
wp_1653_commentmeta: Table ‘databasename.wp_1653_commentmeta’ doesn’t exist
Obviously this was the 1653rd website created on the network. Sure enough, when I went and looked at the tables in the database, none of those tables exist anymore. Not sure what happened.
Question 1: Any idea what happened there? It is possible this happened in an older upgrade and I just missed it. The site owner never really used the site so I don’t think it is plugin related, but who knows. Any idea how to fix this error? Should I just recreate blank tables?
The site owner does not need the site any more so we thought we would just delete the site so the upgrade could complete on the rest of the network. We went into the network admin and deleted the site, but the upgrade network keeps failing on that site. We tried looking for any references to 1653 in the database anywhere, but found nothing.
Question 2: Assuming this is an isolated thing, anyone know how we can get past this failure in the upgrade network dialog?
Thanks for any help you can offer!
University of North Carolina at Chapel Hill
- The topic ‘Database Tables Missing in Multi-site’ is closed to new replies.