Problems with WordPress lately and the importance of doing backups

January 6, 2013

In case you wonder why the post about Raspberry Pi has disappeared, I am having big problems with the WordPress installation on sorin-mustaca.com.

I am getting errors from the database (MySQL) telling me that the table wp_posts is in use… But actually the table doesn’t exist anymore.

WordPress database error File ‘./sorin_wrdp1/wp_posts.MYD’ not found (Errcode: 2) for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (238) ) AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10 made by require(‘wp-blog-header.php’), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

Fortunately, I have a backup (full SQL dump) and I was able to retrieve all posts, except the last one.

I have two ideas where the problem could be:

– Upgrade of the server to PHP 5.2

Many plugins were not ready and not compatible with it.

PHP Warning: PHP Startup: Suhosin Extension does not officially support
PHP 5.2 and below anymore, because it is discontinued. Use it at your own risk. in Unknown on
line 0

PHP Warning: PHP Startup: Unable to load dynamic library

‘/usr/local/lib/php/extensions/no-debug-non-zts-20100525/sqlite.so’ – /usr/local/lib/php/extensions/no-debug-non-zts-20100525/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0

I don’t know if these initialization errors were the cause of the DB corruption. The same happened without any plugins. So it has to be related to WordPress itself.
– Problems with the server itself

However, the admin told me that everything works correctly. After restoring 4 times the DB, I somehow am starting to  have some doubts about this.

Now, i did a new installation from scratch. Let’s see how much time it lasts.

Of course, I will do backups more often.

Check www.endpoint-cybersecurity.com for seeing the consulting services we offer.

Visit www.itsecuritynews.info for latest security news in English
Besuchen Sie de.itsecuritynews.info für IT Sicherheits News auf Deutsch

Malware delivered with fake Craigslist fax-to-email notifications

If you receive such a message containing an HTML page attached, don’t open it. The email pretends to come from “craigslist – automated message, do not reply <robot@craigslist.org>” and has the subject ”Efax Corporate”. What I find interesting is that the fraudsters didn’t even bother to write JS code to detect if the script runs in […]

How to stay safe when being exclusively online

EN https://www.europol.europa.eu/sites/default/files/documents/safe-at-home_final.pdf DE https://www.europol.europa.eu/sites/default/files/documents/safe-at-home_de.pdf RO https://www.europol.europa.eu/sites/default/files/documents/safe-at-home_ro.pdf More here: https://www.europol.europa.eu/activities-services/public-awareness-and-prevention-guides/make-your-home-cyber-safe-stronghold Recommendations: Wi-Fi: always change the default router password Install antivirus software on all devices connected to the internet Choose strong and different passwords for your email and social media accounts Review your apps’ permissions and delete those you don’t use Back up your data and […]

Avira goes into Managed Security Services by acquiring CleanPort

http://www.avira.com/en/company_news/avira_extends_security_in_the_cloud.html Avira extends Managed Security Services portfolio to offer users security “in-the-cloud” Tue, 02 March 2010 Avira’s acquisition of CleanPort forms the basis for the new business unit Tettnang/ Doetinchem, 2 March 2010 – German IT security provider Avira has acquired CleanPort, an acquisition that extends Avira’s solutions for terminals and server products with a […]