Description:
I am a reseller and do not have root access to server. Trying to help server provider try and fix problem since they appear to be lost.
I encountered a problem running SMF 1.0.4, in that the program was compromised/hacked twice in less than 4 days, each time severely compromising the problem. I had to end up doing a fresh install of SMF 1.0.5, and I saved my database files using Export in phpMyAdmin so that I could update the new SMF install with critical info from the database. Everything went fine with the new install, but when I tried to upload/import the database files, using the SQL Query function, I encountered a parser syntax error that prohibited me from doing the required restoration of my SMF database. Thinking it could have been the old database files, I moved a newly installed database file to my computer, deleted/dropped the file from the server database using phpMyAdmin. When I attempted to restore/upload the file using the same SQL procedure listed above, I encountered the same exact error.
Here is the log:
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----
eNoBfgKB/UVSUk9SOiBDMSBDMiBMRU46IDIgMyA0MDAKU1RSOiADCgpDVlM6ICRJZDogc3FscGFy
c2VyLmxpYi5waHAsdiAyLjI3IDIwMDQvMTEvMDUgMDA6NDE6NTUgbGVtOSBFeHAgJApNeVNRTDog
NC4wLjI0LXN0YW5kYXJkLWxvZwpVU1IgT1MsIEFHRU5ULCBWRVI6IFdpbiBNT1pJTExBIDUuMApQ
TUE6IDIuNi4xLXBsMgpQSFAgVkVSLE9TOiA0LjMuMTEgTGludXgKTEFORzogZW4taXNvLTg4NTkt
MQpTUUw6IFBLAwQUAAAACABJUdcylG7kQU8CAADkBQAAEAAAAHdha2FudGFuX3NtZi5zcWydk9tu
4jAQhu95ipF6AUhNmgTotlS9yJbQ0iWBhVCJKzDEQLSxjRynlLffcTj1gHYLkRJZM/N//zhjGwYs
F0t/7UYs5tD/3YZGxpYFw4BXKtNYcHDMa9M2lomjgwullvWrq9VqZaKMrYmWmZwqndTvk0hVHRIx
JckClzr0SDmVRGlWGDNah+cMqZVLcCyrBkSBbdVtC1xfF/epROOdeR2qpmU6VZ3pJmd0O3Xh5RCu
mLa9M20QRSZhbXA7JEX0eEX+EK4IH6VsNs7z+mOc+RR2DiGZJBRSJbOpyiSFmZCg8tgYjUaMsgmV
cymyZbp1feh5buhB6P5se0eKoFQAGLcao8deZ9AdQ8pIksRclWplyHgazzmNIOiEEAzabSCZEqOY
TyVllKtLLc05AWF0DK9EThdElm6s8kES0RnJEgXFYl4uONLpg0iEJmx0Owicfwhwrl0cIHbKaBRn
TPd2e6zcsLcC8ubTNCVzmv5vlSPwtA==
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 2 3 400
STR:
CVS: $Id: sqlparser.lib.php,v 2.27 2004/11/05 00:41:55 lem9 Exp $
MySQL: 4.0.24-standard-log
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.6.1-pl2
PHP VER,OS: 4.3.11 Linux
LANG: en-iso-8859-1
SQL: PK [Binary code would not cut and paste]
----END RAW----
SQL-query:
[Binary code would not cut and paste]
MySQL said:
#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 'PK' at line 1
Since I am a reseller and do not have root access, I do not have all of the server details except the server is Linux, PHP version 4.3.10, Kernel version: 2.4.21-32.0.1.ELsmp, Machine Type i686, Apache version 1.3.33 (Unix)
The server host appears to be having quite a bit of problems trying to fix this problem so that the phpMyAdmin section will work correctly, and I can properly restore my SMF 1.0.5 program.
How to repeat:
Would be necessary to access site and follow exact steps that I used.
