invalid syntax question...?
Posted 17 March 2003 - 08:20 PM
Last time I restored the database (when I transferred to this server last week) I used the same file I\'m using now I did it thru phpMyAdmin, I copied and pasted the mySQL queries like 4000 lines at a time thru myPHPadmin, and it worked fine. I\'m trying this again and now when I enter the queries I get an invalid syntax error...
This is the format that I\'m copying it from the backup file:
INSERT INTO adminlog VALUES(\'1\', \'1\', \'1044752280\', \'index.php\', \'\', \'\', \'220.127.116.11\');
This is the error message that I get:
You have an error in your SQL syntax near \'\'1\', \'1\', \'1044752280\', \'index.php\', \'\', \'\', \'18.104.22.168\')\' at line 1
When it comes back with the error why is there so many more ? Is that what the problem is?
It looks like it may be a newer version of phpMyAdmin because there are more options at the bottom... other than that I have no idea...
Any suggestions would be great!
Posted 17 March 2003 - 08:23 PM
I havent used vbulletin (adminCp) anyways, I use IPB and i can easily backup/restore a database in their!
Am i following you right on this or have i read your post wrong?
Posted 17 March 2003 - 10:20 PM
Posted 18 March 2003 - 12:21 PM
Not easy, I just tested
INSERT INTO `tbl_Person` VALUES (143, \'Jepp\', \'Tha\', \'1973\', \'\', \'Sjælland 73 st.\', \'\', \'\', \'8000\', \'Ås C\', \'email@example.com\', \'\', \'venteliste\', \'8619\', \'2191\', \'\', \'\');
Which worked fine (don\'t worry about the data).
The only difference I see is the backquotes around the table name.
Which version of phpmyadmin are you using?
Posted 18 March 2003 - 12:37 PM
I\'ve found that only some of the tables are giving me errors...
I can do the entire user table with no problem... but the posts I get invalid syntax...? It\'s all from the same backup file...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users