Problems with WordPress lately and the importance of doing backups

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.

 


© Copyright 2013 Sorin Mustaca, All rights Reserved. Written For: Sorin Mustaca on Cybersecurity


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

One thought on “Problems with WordPress lately and the importance of doing backups

Comments are closed.