4 sites gone blank

  • pigmoose

    (@pigmoose)


    17 years, 9 months ago

    I have a number of domains hosted on a small account. Most of them are wordpress blogs Today I noticed some of them are blank, a summary of their status is listed below

    deanpower.net – blank
    eco2oh.com – blank
    oneearthtv.com – blank
    outbackontv.com – blank
    pigmoose.com – blank

    mentalhawaiians.com – working
    fullmonto.com – working

    I checked the mySQL database and am getting warning messages like the one below. Have I been hacked and how can I clean up the dB’s

    pigmoose_outbackontv is now being checked.

    pigmoose_outbackontv.wp_categories OK pigmoose_outbackontv.wp_comments warning : 1 client is using or hasn’t closed the table properly status : OK pigmoose_outbackontv.wp_link2cat OK pigmoose_outbackontv.wp_links OK pigmoose_outbackontv.wp_options warning : 9 clients are using or haven’t closed the table properly status : OK pigmoose_outbackontv.wp_post2cat OK pigmoose_outbackontv.wp_postmeta OK pigmoose_outbackontv.wp_posts OK pigmoose_outbackontv.wp_usermeta OK pigmoose_outbackontv.wp_users OK

Viewing 10 replies - 1 through 10 (of 10 total)
  • Thread Starter pigmoose

    (@pigmoose)

    17 years, 9 months ago

    Below is the reply I got from the host’s support desk.

    Hello,

    This issue is caused a lot of the time by fault plugins. Try disabling them all and re-enabling them one at a time to narrow down which is having the issues. If you have any further questions please let us know.

    Regards,
    Will

    How can I deactivate plugins when I can’t see wp-admin?

    Will deleting plugins through ftp or cpanel help or hinder?

    whooami

    (@whooami)

    17 years, 9 months ago

    How can I deactivate plugins when I can’t see wp-admin?

    Will deleting plugins through ftp or cpanel help or hinder?

    Its the oft missed snippit on the plugins page that deleting plugins is the way to disable them if you cant access wp-admin/

    Thread Starter pigmoose

    (@pigmoose)

    17 years, 9 months ago

    groovy whooami, i guess I missed that one.

    are the db’s likely to have been corrupted?

    Should I just delete the plugins, update wordpress, then reinstall the plugins?

    Cheers Dean

    whooami

    (@whooami)

    17 years, 9 months ago

    Based on the db errors, if it were me, I would be checking all those tables in phpmyadmin, and repairing any that say they need it.

    Those errors, btw, dont really look like plugin problems but mysql issues that are probably a result of having a crappy host.

    Thread Starter pigmoose

    (@pigmoose)

    17 years, 9 months ago

    groovy whooami, i guess I missed that one.

    are the db’s likely to have been corrupted?

    Should I just delete the plugins, update wordpress, then reinstall the plugins?

    Cheers Dean

    Thread Starter pigmoose

    (@pigmoose)

    17 years, 9 months ago

    groovy whooami, i guess I missed that one.

    are the db’s likely to have been corrupted?

    Should I just delete the plugins, update wordpress, then reinstall the plugins?

    Cheers Dean

    Thread Starter pigmoose

    (@pigmoose)

    17 years, 9 months ago

    groovy whooami, i guess I missed that one.

    are the db’s likely to have been corrupted?

    Should I just delete the plugins, update wordpress, then reinstall the plugins?

    Cheers Dean

    whooami

    (@whooami)

    17 years, 9 months ago

    what am I missing here? Why do you keep posting the same message over and over again?

    If you are upgrading wordpress, you ought to follow the upgrade instructions.

    Thread Starter pigmoose

    (@pigmoose)

    17 years, 9 months ago

    apologies whooami and everyone else. the browser was crashing and I kept refreshing, then walking away. didn’t realise it posted 3 times.

    I am just trying to get my head around why 5 out of 7 sites suddenly go blank due to faulty plugins.

    I am wondering
    1. If someone has hacked my sites via plugins? If so how would I know
    2. If If someone did hack my sites via plugins, could they have put malicious code in the mySQL databases?
    3. Will upgrading WP and reinstalling the plugins perpetuate the going blank and/or malcious code in the mySQL databases? Or is it a suck and see scenario

    Apologies again for multi posting and for not being clearer.

    I appreciate your advice, Dean

    Thread Starter pigmoose

    (@pigmoose)

    17 years, 9 months ago

    Ok some progress

    Upgrade didn’t work, this is what I did
    renamed the plugins folder to deactivate plugins
    downloaded the mySQL database via phpMyAdmin
    deleted wp-admin, deleted wp-includes folders
    uploaded WP2.6
    ran myurl/wp-admin/upgrade.php
    which redirected to a blank wp-login.php page

    Tryed another server, this half worked
    created a new database and imported the old mySQL database
    uploaded WP2.6
    ran myurl/wp-admin/upgrade.php

    go this message

    Warning: Cannot modify header information – headers already sent by (output started at /home/eco2oh/eco2oh/wp-config.php:63) in /home/eco2oh/eco2oh/wp-includes/pluggable.php on line 770

    went into phpMyAdmin and emptied wp_options
    ran myurl/wp-admin/upgrade.php
    got this message

    WordPress database error: [Table ‘eco2oh_eco2ohWP2.wp_categories’ doesn’t exist]
    SELECT cat_ID, cat_name, category_nicename FROM wp_categories

    WordPress database error: [Table ‘eco2oh_eco2ohWP2.wp_post2cat’ doesn’t exist]
    SELECT DISTINCT post_id FROM wp_post2cat

    WordPress database error: [Table ‘eco2oh_eco2ohWP2.wp_categories’ doesn’t exist]
    ALTER TABLE wp_categories ADD INDEX ( category_nicename )

    WordPress database error: [Unknown column ‘user_nickname’ in ‘field list’]
    SELECT ID, user_nickname, user_nicename FROM wp_users

    WordPress database error: [Table ‘eco2oh_eco2ohWP2.wp_categories’ doesn’t exist]
    SELECT * FROM wp_categories ORDER BY cat_ID

    WordPress database error: [Table ‘eco2oh_eco2ohWP2.wp_post2cat’ doesn’t exist]
    SELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id

    WordPress database error: [Table ‘eco2oh_eco2ohWP2.wp_linkcategories’ doesn’t exist]
    SELECT cat_id, cat_name FROM wp_linkcategories
    Upgrade Complete

    Your WordPress database has been successfully upgraded!

    Got the posts back but not the correct blog name/permalinks/

    any thoughts?

    Dean

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

The topic ‘4 sites gone blank’ is closed to new replies.

Tags