problem: plugin_event_backup and phpadmin-restore
Posted: Mon Sep 11, 2006 4:05 pm
To transfer my s9y-installation, I copied my files and want to import the sql-backup from this plugin via phpmyadmin. But I get an error:
error in sql-syntax. please look for the correct syntax in the manual (it could be different for different server-versions) for 'last_backup' on line 1.
For yuor information: It is no version-problem, because I tried it on the same server, where I made the backup, too. He do not want to take his own backup, too.
With the plugin-intern-restore, everything is fine. But after moving the installation, their is no working enviroment, until I fill the tables.
translation of the last german sentences:There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNrtVE1v2kAQ5Rr/iieRIzY7xh9hT3WpmyKBIbab9IYWvAUrxrj2guAn5V92TdMqadVDI6WnPK20
M7tvZrR6sxPG8SzmGBFGNiZhxEEEskGDK99IUn3VMYzRbcJxOc44mm9FJepG1laRL61qU/UOsC3b
h82Y0yfqMxeMcYe466KQ2yHCY4VLY3pKbiYcjkXW0NyKo/E5iTFLegiuwyjt4TbUle7yErN5GAcY
WoyM+TTgOrlnafPTvKX0ZkmbY2ARw904ilJjEkTXHLI09+qreWWcixSiUYulWN3vq85rAQ7zfR8d
tGC/7Y8OMZeR7ZHHfO17A+ag43be8Np4on9ft6VnsqFJZJJr2s5iFIdBGi7u83q1kQuxWsmmsXRX
/2MN0nk976/6k+/QE/1dfeK45OJNnP+A7kthdLsY1VIomWF5gp5ysszyKlenhTzI8mdT9SDQDE+o
iv06L89Bu+pU5+uNwsN5EJpteFDIoygzWWOay0JbLXOjVMX7/WWxW+sJWu6PZqOEaqxdvf6RqFRi
pTiyrSDHf/cn5eVP+7UuLj7Es7mZCSVw2JVIxVIWhcSzP9FSWxrS4P0kxPgjwi/jJE2es74DpCi6
SA==
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 11 12 1387
STR:
: $Id: sqlparser.lib.php,v 2.27 2004/11/05 00:41:55 lem9 Exp $
: 4.1.9-max
OS, AGENT, VER: Win OPERA 9.01
: 2.6.1
VER,OS: 4.3.10 WINNT
: en-utf-8
: last_backup 40777 0 0 0 10501261607 6304 5last_backup/2006-09-11-15-24_CREATE_kirche_access.sql100666 0 0 1741 10501261605 14515 ########################################################### Created by serendipity_event_backup, a s9y plugin## Copyright � 2004- by Alexander Mieland## http://blog.linux-stats.org## Contact: dma147@linux-stats.org################################################################# DROP-data von Tabelle kirche_access##DROP TABLE IF EXISTS kirche_access
----END RAW----
SQL-query:
last_backup 40777 0 0 0 10501261607 6304 5last_backup/2006-09-11-15-24_CREATE_kirche_access.sql100666 0 0 1741 10501261605 14515 ######################################################### ## Created by serendipity_event_backup, a s9y plugin ## Copyright � 2004- by Alexander Mieland ## http://blog.linux-stats.org ## Contact: dma147@linux-stats.org ######################################################### ## ## ## ## DROP-data von Tabelle kirche_access ## DROP TABLE IF EXISTS kirche_access
MySQL said:
#1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen (diese kann f�r verschiedene Server-Versionen unterschiedlich sein) bei 'last_backup' in Zeile 1
error in sql-syntax. please look for the correct syntax in the manual (it could be different for different server-versions) for 'last_backup' on line 1.
For yuor information: It is no version-problem, because I tried it on the same server, where I made the backup, too. He do not want to take his own backup, too.
With the plugin-intern-restore, everything is fine. But after moving the installation, their is no working enviroment, until I fill the tables.