2944 pointsCommunity rank #20Supreme DeityMind-Blowingly HelpfulLifetime member
DEV Diva
(joined February 2012)
Likes (1)
Liked by:
Hi Mark (@Mark de Scande)
Glad to see you posting away again. I do love to read your posts - always learning something new :)
Got the same when I tried to register a site. Everything went well until I tried to activate my site. However, I am not sure how to fix this on the DB.
Let me get all the support folk in on this one - @masonjames, @Timothy and @aecnu is on in a few hours, so I will ask them to see how you can rectify this 'little' problem.
1523 pointsCommunity rank #31Supreme DeityMind-Blowingly HelpfulLifetime member
Member par excellence
(joined May 2011)
Likes (0)
Yes i have tried same problem :( the sing up page still give me the err
We do believe it is a database problem and have you tried copying the database backup to another folder on the server and un-tarring it there?
Then to copy the database files to the MySQL folder?
I think there is a bug in bloglines_global bloglines_home the problem is i have no idea of were to start
I do have 3 more setup like bloglines.co.za and i even looked trough all the db sets to see if i can see any thing funny but i did not see a thing
21517 pointsCommunity rank #0Supreme DeityWPMU DEV StaffLifetime member
Support Kangaroo
(joined March 2011)
Likes (1)
Liked by:
Greetings Mark,
What about something we have not yet talked about that i can rememeber i.e. the htaccess file, below is a good one and the first four lines are a security preference protecting the wp-config.php file from prying eyes:
<files wp-config.php>
order allow,deny
deny from all
</files>
# BEGIN WordPress
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
# uploaded files
RewriteRule ^files/(.+) wp-includes/ms-files.php?file=$1 [L]
RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule . index.php [L]
# END WordPress
I am getting close to having to call in the big guns on this one.
1523 pointsCommunity rank #31Supreme DeityMind-Blowingly HelpfulLifetime member
Member par excellence
(joined May 2011)
Likes (0)
Hey Cool Cats
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.
The bug on the server was we had a mix and mach of tables from isam to innodb.
The fix was to convert all the tables to innodb
Here is the code i use to convert from isam to innodb
Just save the data as to a text file and then rename it to alter-tables-inodb.php now go to lines 7 8 9 and fill in your db details
Upload it to /root
Putty SSH type screen php alter-tables-inodb.php
Sit back and let the script work :)
<?php
//------------------------------------------------------------------------//
//---Config---------------------------------------------------------------//
//------------------------------------------------------------------------//
//We need info to connect to the databases
$dbhost = 'localhost';
$dbuname = 'MySqluser';
$dbpass = 'MySqlPass';
//------------------------------------------------------------------------//
?>
<?php
//Check to see if we are moving tables yet
$tabletomove = 'copy';
mysql_connect($dbhost, $dbuname, $dbpass) or die("Houston, we have a problem! <br />Database Error: ".mysql_error());
//Get our table list from the original db
$databases = mysql_query('SHOW databases');
while($db = mysql_fetch_array($databases)) {
echo "database => {$db[0]}\n";
mysql_select_db($db[0]);
$tables = mysql_query('SHOW tables');
while($tbl = mysql_fetch_array($tables)) {
echo "table => {$tbl[0]}\n";
$status = mysql_query("ALTER TABLE {$tbl[0]} ENGINE=InnoDB");
echo "status => $status\n";
}
}
//Clean up after ourselves
echo "<center>Ignore any errors below this line</center>";
echo "<center>================================================================================</center>";
?>
Responses (20)
DEV Diva (joined February 2012) Likes (1)Liked by: 
Hi Mark (@Mark de Scande)
Glad to see you posting away again. I do love to read your posts - always learning something new :)
Got the same when I tried to register a site. Everything went well until I tried to activate my site. However, I am not sure how to fix this on the DB.
Let me get all the support folk in on this one - @masonjames, @Timothy and @aecnu is on in a few hours, so I will ask them to see how you can rectify this 'little' problem.
Talk soon again!
Gina
Member par excellence (joined May 2011) Likes (1)Liked by: 
@GinaB thank you for getting the guys in on this :)
Support Kangaroo (joined March 2011) Likes (1)Liked by: 
Greetings Mark,
I know that off forum the other day we tried working this doing database repairs etc. and no luck there and that the database is 65gb large.
We also talked about and covered the replacement of signup.php etc and that did not help either.
We do believe it is a database problem and have you tried copying the database backup to another folder on the server and un-tarring it there?
Then to copy the database files directly to the MySQL folder?
This would not require downloading anything?
Please advise.
Cheers, Joe
Member par excellence (joined May 2011) Likes (0)
Yes i have tried same problem :( the sing up page still give me the err
I think there is a bug in bloglines_global bloglines_home the problem is i have no idea of were to start
I do have 3 more setup like bloglines.co.za and i even looked trough all the db sets to see if i can see any thing funny but i did not see a thing
Thx
Mark
Support Kangaroo (joined March 2011) Likes (1)Liked by: 
Greetings Mark,
What about something we have not yet talked about that i can rememeber i.e. the htaccess file, below is a good one and the first four lines are a security preference protecting the wp-config.php file from prying eyes:
I am getting close to having to call in the big guns on this one.
Please advise if we have an htaccess match.
Cheers, Joe
Member par excellence (joined May 2011) Likes (1)Liked by: 
Member par excellence (joined May 2011) Likes (1)Liked by: 
I dont use these lines any more
I dont see the need to as the server has lots of tricks on it :)
Hey big guns please help a poor guys here in South Africa :)
Lifetime Member (joined February 2011) Likes (0)
Hi Mark,
Are you using whm backup for sql?
Member par excellence (joined May 2011) Likes (0)
Lifetime Member (joined February 2011) Likes (1)Liked by: 
I got it! I'm waiting your mail for learn more technical detail.
Member par excellence (joined May 2011) Likes (0)
Sorry buddy have emailed it all to you thank you again :)
Member par excellence (joined May 2011) Likes (0)
@Mustafa Thank you for trying :)
Still no luck getting rid of this bug "THE BIG GUNS" please see you guys can help out .
Member par excellence (joined May 2011) Likes (0)
Hey guys
Ron also gave some help on this
http://wordpress.org/support/topic/plugin-shardb-already-installed-bug-on-new-signups
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)
It is still geek to me :)
Lifetime Member (joined February 2011) Likes (0)
Your site seems created via sites section but when you try to visit it's not showing. and you'll re-directed signup page.
I guess wordpress installer not working 100%. Try to run - http://bloglines.co.za/wp-admin/network/upgrade.php. Maybe this work for db version upgrade.
I haven't any idea for now.
Member par excellence (joined May 2011) Likes (0)
I have run that last night :) still no luck
Member par excellence (joined May 2011) Likes (0)
@GinaB Please ask the guys if they pleas can help on this :)
Member par excellence (joined May 2011) Likes (0)
Hey Cool Cats
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
Support Kangaroo (joined March 2011) Likes (0)
Greetings Mark,
Check this out for converting the tables:
http://highervisibilitywebsites.com/convert-your-mysql-database-myisam-innodb-and-get-ready-drupal-7-same-time
I hope this helps.
Cheers, Joe
Member par excellence (joined May 2011) Likes (0)
@aecnu
My buddy has his custom script running on the server to convert then he has made one more to SELECT substring(md5(blog_id),1,3)
I just hope the 2 scripts does the jobs :)
If they work i will mail them to you then we can attach them to this post.
Member par excellence (joined May 2011) Likes (2)Liked by: 
The Good News is http://www.BlogLines.co.za is back up and running .
The bug on the server was we had a mix and mach of tables from isam to innodb.
The fix was to convert all the tables to innodb
Here is the code i use to convert from isam to innodb
Just save the data as to a text file and then rename it to alter-tables-inodb.php now go to lines 7 8 9 and fill in your db details
Upload it to /root
Putty SSH type screen php alter-tables-inodb.php
Sit back and let the script work :)
Become a member