Error creating database on a new blog after creating it

  • Hello all,

    I have a working -although under construction- MU social networking site https://www.driverszone.co.uk and it was creating blogs just fine, like https://driverszone.co.uk/andanothertestwebsiteagain/ . Two days ago I started a new test blog ( https://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 https://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

Viewing 5 replies - 1 through 5 (of 5 total)

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

    Thread Starter Marjolijn Harvey

    (@mafgirl)

    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! ??

    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..

    Then it’s a plugin messing you up.

    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. ??

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error creating database on a new blog after creating it’ is closed to new replies.