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
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