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

Resolved Mark de Scande BlogLines
(@bloglines)

11 years, 9 months 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/

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

Plugin Author Ron Rennick
(@wpmuguru)

11 years, 9 months 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)

Thread Starter Mark de Scande BlogLines
(@bloglines)

11 years, 9 months ago

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

Thread Starter Mark de Scande BlogLines
(@bloglines)

11 years, 9 months 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

Plugin Author Ron Rennick
(@wpmuguru)

11 years, 9 months 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.

Thread Starter Mark de Scande BlogLines
(@bloglines)

11 years, 9 months 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

Thread Starter Mark de Scande BlogLines
(@bloglines)

11 years, 9 months 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 ?

Plugin Author Ron Rennick
(@wpmuguru)

11 years, 9 months ago

Yes. Look in that DB for wp_82353_tablename tables.

Thread Starter Mark de Scande BlogLines
(@bloglines)

11 years, 9 months 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

Thread Starter Mark de Scande BlogLines
(@bloglines)

11 years, 9 months ago

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

Thread Starter Mark de Scande BlogLines
(@bloglines)

11 years, 9 months 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

Plugin Author Ron Rennick
(@wpmuguru)

11 years, 9 months ago

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

Thread Starter Mark de Scande BlogLines
(@bloglines)

11 years, 9 months 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

Thread Starter Mark de Scande BlogLines
(@bloglines)

11 years, 9 months 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.

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

The topic ‘[Plugin: SharDB] Already Installed Bug on New signups.’ is closed to new replies.

Tags