WordPress.org

1. Anonymous
   Unregistered
   Posted 3 years ago #

   due to a misconfiguration of the static homepage-tool of wp ("formerly" running version 2.6) and/or static frontpage-plugin my homepage was unavailable with the comment "you're looking for s.th. that isn't there".

   since i suspected a database corruption i tried to restore from my previous (today before upgradeing to 2.6) backup.

   the procedure crashed/failed and my homepage has become unavailable so ist all the rest of my admin-backend.

   the my-php-admin tool of sitecontrol gives the following comment which i was asked to post here by the author of the restoring-from-backup-description...

   ... the server's comment relates in my humble opinion to a parallell-installation of a podcasting-blog named "loudblog" whose database-tables the restore-procedures tries to rewrite but is unable to find... or similar...

   this is the server's comment:

   Fehler

   SQL-Befehl:

   #
   # Data contents of table lb_postings
   #
   INSERT INTO lb_postings
   VALUES ( 6, 1, 'bitters', '2008-05-29 16:19:00', 1, 'podcast-2008-05-29-68903.mp3', 1, 116, 3145728, 'pah! bitters! das geheime gewisse etwas im cocktail! lächerlich!', ' <p>pah! bitters! das geheime gewisse etwas im cocktail! lächerlich!</p>\n\n\n ', 1, 0, 1, 0, 0, 0, 'bitter bitters longdrink cocktail bar barman barmann bartender cocktail bar ', 3, 0, 0, 0, 0, , , , 0 ) ;

   MySQL meldet: Dokumentation
   #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , , 0)' at line 1

   end of comment

   since i'm promoting me and my profession via this blog/website this is a severe damage done to my daily business.

   who could help me out of that dilemma?

   are all my data gone now?

   your help is kindly appreciated!

   thanks,

   werner

2. Ziyphr
   Member
   Posted 3 years ago #

   You can see from the error message that you have invalid syntax in the query. A comma cannot follow a comma. Depending on the field type replace the comma with ", null" or ", ''" or ", 0". This could be problematic if there are a number of entries, perhaps try doing a string replace in a text editor to replace "0, 0, 0, 0, , , , 0" with "". I would suspect the default values would be zeroes anyway.

   Also, the easiest way to backup WordPress is via regular Exports from the Manage menu. To re-import the posts after a reinstall just go to Manage and click import. No messing with phpMyAdmin.

3. Anonymous
   Unregistered
   Posted 3 years ago #

   thanx so far - problem is, i cannot access my admin backend - because the server doesn't allow it anymore. reason: wp-database restore from backup failed.

   until wp 2.5 there was no reimport function as far as i know and you had to follow cryptical restore procedures you could read about in the wp support base.

   this is exactly what i did believing that this might be failsafe...

   my fault...

   now i can't even access that php document where i should replace those commas by zeros. i'd like to clarify that i am not accustomed to coding... my knowledge about databases and php is not good enough...

   so your answer leaves me with the question how i could regain access to my wp-admin tool. once i'm in i guess i would find a way...

   any ideas? e.g. change the contents of a php-file? what file? where do i find it?

   your help is much appreciated!

Topic Closed

This topic has been closed to new replies.