WordPress.org

Ready to get started?Download WordPress

Forums

SharDB
[resolved] Already Installed Bug on New signups. (14 posts)

  1. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

    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.

    http://bloglines.co.za/wp-signup.php

    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/easyapache
    /scripts/upcp --force
    /scripts/checkperlmodules --force
    /usr/local/cpanel/bin/setupdbmap
    /etc/rc.d/init.d/postgresql restart
    screen
    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

    http://wordpress.org/extend/plugins/shardb/

  2. Ron Rennick
    MultiSite Guru
    Plugin Author

    Posted 1 year ago #

    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)

  3. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

    Ron I will give it a test now :) Thank you again

  4. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

    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

  5. Ron Rennick
    MultiSite Guru
    Plugin Author

    Posted 1 year ago #

    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.

  6. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

    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

  7. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

    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 ?

  8. Ron Rennick
    MultiSite Guru
    Plugin Author

    Posted 1 year ago #

    Yes. Look in that DB for wp_82353_tablename tables.

  9. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

    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
    Mark
    mark@bloglines.co.za

  10. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

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

  11. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

    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
    My.cnf
    ignore_builtin_innodb
    default_storage_engine=MyISAM

    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

  12. Ron Rennick
    MultiSite Guru
    Plugin Author

    Posted 1 year ago #

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

  13. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

    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

  14. Mark de Scande BlogLines
    Member
    Posted 1 year ago #

    Here is the script i use to convert

    http://premium.wpmudev.org/forums/topic/already-installed-bug-on-new-signups

    @Ron Thank you for your help.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic