Programming Forums - View Single Post

Chris Weimer · May 8th, 2006, 9:25 PM

Hello folks,

I'm having a bit of trouble using phpMyAdmin, and was wondering if anyone knew what was wrong. I lost some information, but luckily I had a backup two weeks earlier.

This is the error message:

(Toggle Plain Text)

#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 'INSERT INTO `smf_messages`
    (`ID_MSG`, `ID_TOPIC`, `ID_BOARD`,

This is the line its talking about:

(Toggle Plain Text)

INSERT INTO `smf_messages` (
`ID_MSG` ,
`ID_TOPIC` ,
`ID_BOARD` ,
`posterTime` ,
`ID_MEMBER` ,
`subject` ,
`posterName` ,
`posterEmail` ,
`posterIP` ,
`smileysEnabled` ,
`modifiedTime` ,
`modifiedName` ,
`body` ,
`icon`
)

Anyone see a problem?

May 8th, 2006, 9:25 PM	#1
Chris Weimer Programmer Join Date: May 2005 Posts: 34 Rep Power: 0	MySQL Problem Hello folks, I'm having a bit of trouble using phpMyAdmin, and was wondering if anyone knew what was wrong. I lost some information, but luckily I had a backup two weeks earlier. This is the error message: (Toggle Plain Text) #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 'INSERT INTO `smf_messages` (`ID_MSG`, `ID_TOPIC`, `ID_BOARD`, #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 'INSERT INTO `smf_messages` (`ID_MSG`, `ID_TOPIC`, `ID_BOARD`, This is the line its talking about: (Toggle Plain Text) INSERT INTO `smf_messages` ( `ID_MSG` , `ID_TOPIC` , `ID_BOARD` , `posterTime` , `ID_MEMBER` , `subject` , `posterName` , `posterEmail` , `posterIP` , `smileysEnabled` , `modifiedTime` , `modifiedName` , `body` , `icon` ) INSERT INTO `smf_messages` ( `ID_MSG` , `ID_TOPIC` , `ID_BOARD` , `posterTime` , `ID_MEMBER` , `subject` , `posterName` , `posterEmail` , `posterIP` , `smileysEnabled` , `modifiedTime` , `modifiedName` , `body` , `icon` ) Anyone see a problem?