Database is being corrupted when changing a blog post
-
Hello!
Since English is not my native language I will try to describe my problem as best as possible:
The problem occured with my WordPress 2.04-based blog, when I tried to change a single blog post. After the changes I pressed “Save” and then the database got corrupt. Instead of the positive affirmation message by WordPress I received this error message:
“WordPress database error: [Incorrect key file for table
‘revier_posts’; try to repair it]
UPDATE IGNORE revier_posts SET post_author = ‘2’, post_date =
‘2006-10-27 16:03:36’, post_date_gmt = ‘2006-10-27 14:03:36’,
post_content = ‘<img id=\”image26\”
src=\”http://www.revier-derby.de/wp-content/uploads/2006/10/dieligashow.gif\”
alt=\”DieLigaShow\” align=\”left\” hspace=\”5\” vspace=\”5\” />Seit
einiger Zeit gibt es von der <a
href=\”http://www.waz.de/\”>WAZ-Mediengruppe einen Podcast namens
DieLigaShow,
der aktuell über die Fußball-Bundesliga berichtet. In der <a
href=\”http://weblog.waz.de/index.php/osrligashow/volltext/spieltag-9-die-erste1/?weblog=osrligashow\”>aktuellen
Ausgabe (Spieltag 9 – Die Erste) ist auch dieses Blog <a
href=\”http://www.revier-derby.de/\”>Revier-Derby präsent – bzw.
ich (Jens Matheuszik) bin als Gast bei Franz und Max in der Sendung.
Thema ist die kommende Partie 1. FC Nürnberg gegen Borussia Dortmund
und dabei viel eher die Diskussion um den Dortmunder Trainer Bert van
Marwijk. Da Revier-Derby DieLigaShow auch so empfiehlt, ist
es sicherlich kein Lob der Kategorie \”Eigenlob st….\”, wenn jetzt
diese Ausgabe des Podcasts besonders empfohlen wird!’,
post_content_filtered = ”, post_title = ‘Revier-Derby in der
WAZ-LigaShow’, post_excerpt = ”, post_status = ‘publish’,
comment_status = ‘open’, ping_status = ‘open’, post_password = ”,
post_name = ‘revier-derby-in-der-waz-ligashow’, to_ping = ‘ ‘, pinged
= ‘ http://weblog.waz.de/index.php/trackback/2074/3smxyRmF/?weblog=osrligashow’,
post_modified = ‘2006-10-28 12:54:12’, post_modified_gmt = ‘2006-10-28
10:54:12′, post_parent = ‘0’, menu_order = ‘0’ WHERE ID = 27The only change which I made was to insert the values hspace=”5″ and vspace=”5″ inside the img-tag.
Some seconds later I received this message after the first one on the same screen:
Warning: Cannot modify header information – headers already sent by (output started at
/xxx/revier-derby.de/wp-includes/wp-db.php:104)
in /xxx/revier-derby.de/wp-includes/pluggable-functions.php
on line 272″After this happened, the database or to be exactly the table “revier_posts” was corrupted. I couldn’t even use phpMyAdmin to get access to this table.
The friendly support managed (don’t know how) to repair the table (unfortunately in a way, which I couldn’t do for myself – I think they’ve done something and then restarted the mySQL-server), so all was running as before.
But when I tried it again to edit the entry I got the same error message.
I don’t think that this behaviour is normal, so I wanted to ask here, if someone knows what to do.
As an additional information: When I try to edit the mentioned posting directly via phpMyAdmin an error with the same results occurs.
When I write a new blog entry (which saves data in the revier_posts table) no problems occur.
The topic ‘Database is being corrupted when changing a blog post’ is closed to new replies.