Problems with WordPress lately and the importance of doing backups

Posted By: Sorin Mustaca 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

Sorin Mustaca

Sorin Mustaca, (ISC)2 CSSLP, CompTIA Security+ and Project+, is working since over 20 years in the IT Security industry and worked between 2003-2014 for Avira as Product Manager for the known products used by over 100 million users world-wide. Today he is CEO and owner of Endpoint Cybersecurity GmbH focusing on Cybersecurity, secure software development and security for IoT and Automotive. He is also running his personal blog Sorin Mustaca on Cybersecurity and is the author of the free eBook Improve your security .