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.mustaca.com for the IT Consulting services I offer.
Visit www.itsecuritynews.info for latest security news in English
Besuchen Sie http://de.itsecuritynews.info für IT Sicherheits News auf Deutsch

About the Author

Sorin Mustaca
Sorin Mustaca, (ISC)2 CSSLP, CompTIA Security+ and Project+, is working since year 2000 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 an independent IT Security Consultant 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 .

Comments are closed.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close