Support » Plugins and Hacks » SharDB » [Resolved] [Plugin: SharDB] Already Installed Bug on New signups.

[Resolved] [Plugin: SharDB] Already Installed Bug on New signups.

  • I have stuff up.

    I was trying to be clever and was trying to mass delete 91K Post on blogline_home db trough PHP MyAdmin so i just emptied all the tables oops BAD idea

    I then tried to do a restore trough WHM and it crash halved way trough.

    SO then i log in to the server with SSH cd /backup and i still had a back up of the blogline_home.sql and blogline_global.sql i then ran

    mysql -p -u blogline_wrdp1 blogline_home < blogline_home.sql
    mysql -p -u blogline_wrdp1 blogline_global < blogline_global.sql

    They restored and all my data were back till a point

    Now here is the strange part when i tried to add a new blog i get this below.

    Already Installed
    You appear to have already installed WordPress. To reinstall please clear your old database tables first.


    The strange thing is every thing elce is working 100% oldblogs / domain / multi domains it is just the sign up page that is not working

    Ps here is a list of things i have done

    /scripts/upcp –force
    /scripts/checkperlmodules –force
    /etc/rc.d/init.d/postgresql restart
    mysqlcheck -u root -pbFtfdmBwIZwT –auto-repair –optimize –all-databases

    I have remove all plugs and the mu-plugins and change to 2010 theme and uploaded a fresh copy for wordpress 3.4.1 but still i get this err.

    Please Ron Rennick Please try an help me get BlogLines Working

    Thank you Kindly
    Mark de Scande South Africa


Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author Ron Rennick


    You probably have tables in one of the shards for a blog that was created after the backup was taken.

    You can find which shard would have a specific blog id (even if the blog isn’t in the wp_blogs table) with

    SELECT substring(md5(blog_id),1,3)

    Ron I will give it a test now 🙂 Thank you again

    I wish i could have 5 munits of your time 🙂

    I did try your code but it did not seem to work it just

    #1054 – Unknown column ‘blog_id’ in ‘field list’

    Thank you Kindly for helping

    Plugin Author Ron Rennick


    blog_id is placeholder for a number. If your last blog id is 1234 then you would replace blog_id in the select statement above with 1235. That will tell you which DB to check.

    Depending on how many sites were created since the backup was taken you may need to check for tables for several blogs/sites.

    Now i have it Ron 🙂

    I must look for the last blog in all the DBs got

    🙂 i will up date now now

    Thank you again

    After Running

    SELECT SUBSTRING( MD5( 82353 ) , 1, 3 )

    ok so i guess blogline_75e is the one that is were the problem is

    Would you say i am on the right track ?

    Plugin Author Ron Rennick


    Yes. Look in that DB for wp_82353_tablename tables.

    Hey Ron

    Thank you for trying to help

    I Suck at this point, it is now that i see that a good back up system is the key to run bloglines i should have set up your db backup script when i first installed shardb..

    Is there no way you can maybe help me out with getting bloglines back online ? it there no way you can make a deal for me please see what you can do for me i know your time is worth lots of gold please help this poor guy from South Africa get back on his feet again.

    Thank you kindly

    Ron it just started working again how …. strange ….

    Hey Ron

    I think i have got the problem no i need to know what should i do from here.

    1) I did a upgrade to MySql 5.5 and i did not know that the new default storage engine is innodb.

    So i have a mix MyISAM innodb Tables.

    Blog signup worked till about 6pm this morning

    So after 8pm i have removed ignore_builtin_innodb and then i get the err Already Installed
    You appear to have already installed WordPress. To reinstall please clear your old database tables first.

    Just on a side note http://bloglines.co.za/wp-admin/my-sites.php shows a bunch of broke sites with ignore_builtin_innodb with if i removed the line then i dont see any more broke sites.

    So recap i think i need to convert all my tables to MyISAM or InnoDB

    What would you recommend i do convert all of them to InnoDB.

    Thank you Kindly
    Mark de Scande

    Plugin Author Ron Rennick


    I haven’t done that type of conversion on a live site so I’m not sure what the best approach would be.

    Conversion done 🙂 to InnoDB on BlogLines.co.za and it is 99% working and users can add new blogs.

    Now to go fix all the accounts on my server with the mix and mach tables some InnoDB and some MyISAM

    Here is the script i use to convert


    @ron Thank you for your help.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘[Resolved] [Plugin: SharDB] Already Installed Bug on New signups.’ is closed to new replies.
Skip to toolbar