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.

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 try an help me get BlogLines Working

Thank you Kindly

Mark de Scande South Africa

  • 3SixtyEvolve
    • New Recruit

    Hi Mark (@Mark de Scande)

    Glad to see you posting away again. I do love to read your posts – always learning something new :slight_smile:

    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

  • aecnu
    • WP Unicorn

    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

  • Mark de Scande
    • Syntax Hero

    Yes i have tried same problem :slight_frown: 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

    Thx

    Mark

  • aecnu
    • WP Unicorn

    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.

    Please advise if we have an htaccess match.

    Cheers, Joe

  • Mark de Scande
    • Syntax Hero
    # BEGIN WordPress
    RewriteEngine On
    RewriteBase /
    RewriteRule ^index.php$ - [L]

    # uploaded files
    RewriteRule ^files/(.+) wp-includes/ms-files.php?file=$1 [L]
    RewriteRule ^(.*/)?sitemap.xml wp-content/sitemap.php [L]

    RewriteCond %{REQUEST_FILENAME} -f [OR]
    RewriteCond %{REQUEST_FILENAME} -d
    RewriteRule ^ - [L]
    RewriteRule . index.php [L]

    # END WordPress

    <IfModule mod_deflate.c>
    AddOutputFilterByType DEFLATE text/html text/xml text/css text/plain
    AddOutputFilterByType DEFLATE image/svg+xml application/xhtml+xml application/xml
    AddOutputFilterByType DEFLATE application/rdf+xml application/rss+xml application/atom+xml
    AddOutputFilterByType DEFLATE text/javascript application/javascript application/x-javascript
    AddOutputFilterByType DEFLATE application/x-font-ttf application/x-font-otf
    AddOutputFilterByType DEFLATE font/truetype font/opentype
    </IfModule>

    # 1 YEAR
    <filesMatch ".(ico|pdf|flv)$">
    Header set Cache-Control "max-age=29030400, public"
    </filesMatch>
    # 1 WEEK
    <filesMatch ".(jpg|jpeg|png|gif|swf)$">
    Header set Cache-Control "max-age=604800, public"
    </filesMatch>
    # 2 DAYS
    <filesMatch ".(xml|txt|css|js)$">
    Header set Cache-Control "max-age=172800, proxy-revalidate"
    </filesMatch>
    # 1 MIN
    <filesMatch ".(html|htm|php)$">
    Header set Cache-Control "max-age=60, private, proxy-revalidate"
    </filesMatch>

  • Mark de Scande
    • Syntax Hero

    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

  • Mark de Scande
    • Syntax Hero

    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 :slight_smile:

    <?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 => $statusn";
    }
    }
    //Clean up after ourselves
    echo "<center>Ignore any errors below this line</center>";
    echo "<center>================================================================================</center>";

    ?>

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.