WordPress.org

1. mafgirl
   Member
   Posted 1 year ago #

   Hello all,

   I have a working -although under construction- MU social networking site http://www.driverszone.co.uk and it was creating blogs just fine, like http://driverszone.co.uk/andanothertestwebsiteagain/ . Two days ago I started a new test blog ( http://driverszone.co.uk/andmoretestingrequired/ )to do some more tests and I got the message that it was successfully created. It also does appear in Network Admin in 'my sites' although it is absolutely blank concerning settings and content. When going to the blog site I get 'Error establishing a Database conecction '. When going to http://driverszone.co.uk/andmoretestingrequired/wp-admin, it tells me i have to repair the database, so I did and got this to copy and paste here for further support
   

   I tried repairing it and got this code to copy paste in here:
   wp_usermeta: 1 client is using or hasn't closed the table properly
   wp_19_posts: Table 'driversz_engine.wp_19_posts' doesn't exist
   wp_19_comments: Table 'driversz_engine.wp_19_comments' doesn't exist
   wp_19_links: Table 'driversz_engine.wp_19_links' doesn't exist
   wp_19_options: Table 'driversz_engine.wp_19_options' doesn't exist
   wp_19_postmeta: Table 'driversz_engine.wp_19_postmeta' doesn't exist
   wp_19_terms: Table 'driversz_engine.wp_19_terms' doesn't exist
   wp_19_term_taxonomy: Table 'driversz_engine.wp_19_term_taxonomy' doesn't exist
   wp_19_term_relationships: Table 'driversz_engine.wp_19_term_relationships' doesn't exist
   wp_19_commentmeta: Table 'driversz_engine.wp_19_commentmeta' doesn't exist
   wp_sitemeta: 1 client is using or hasn't closed the table properly

   Does anyone know what I can do to fix this?
   Thanks Marjolijn

2. Tim Moore
   Code Wrangler
   Posted 1 year ago #

   It looks like your MySQL database is corrupted. Do you have a backup from before these errors started happening that you can revert to?

3. mafgirl
   Member
   Posted 1 year ago #

   Actually, we had a different problem with a classifieds plugin yesterday morning and made a back up before dropping some of the plugins tables and reinstalled the plugin. This broke up the site so we restored the back up which made the blogs work again (and the classifieds pluginl too!)
   It's really weird as we made the back up when the blogs were NOT working, but maybe somehow the database was corrupted and this fixed it anyway :)
   Thanks for your help! :)

4. mlalexz
   Member
   Posted 1 year ago #

   When I got this error..

   before creating a new site, I rename the plugins folder to plugins0, create new site and then rename the plugins0 back to plugins..

   That works fine..

5. Andrea_r
   team pirate
   Posted 1 year ago #

   Then it's a plugin messing you up.

6. tacianomm
   Member
   Posted 4 months ago #

   It seems that the problem was on the Database Charset (on wp-admin.php).
   I was using latin1 and after changing it to utf8 the problem went away.
   Well, at least on my case...

   Hope it helps. ;)

Topic Closed

This topic has been closed to new replies.