Guest Posted December 26, 2005 Share Posted December 26, 2005 What does this mean? 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 'group from phpdesk_kb' at line 1 select id,title,message,posted,view,owner,group from phpdesk_kb [TEP STOP] Why do i get this error? Link to comment Share on other sites More sharing options...
tina_boots Posted December 27, 2005 Share Posted December 27, 2005 What does this mean? 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 'group from phpdesk_kb' at line 1 select id,title,message,posted,view,owner,group from phpdesk_kb [TEP STOP] Why do i get this error? Both view and group are reserved words in MySQL so it's likely yelling at you because of that. In order to use those words in a SQL statement, you must include them inside single quotes, i.e. 'view' Be well, Tina If you're not having fun you're not doing it right Teach a person to fish rather than give them a loaf of bread or however that saying goes. Link to comment Share on other sites More sharing options...
Guest Posted December 27, 2005 Share Posted December 27, 2005 Both view and group are reserved words in MySQL so it's likely yelling at you because of that. In order to use those words in a SQL statement, you must include them inside single quotes, i.e. 'view' Be well, Tina //Thanx Tina I get this error when trying to backup my database through the oscommerce controlpanel. I have not changed any code that i im aware of. Does anybody have a clue of where these words could be. // Link to comment Share on other sites More sharing options...
Guest Posted December 28, 2005 Share Posted December 28, 2005 Anyone have any idea to why this shows? When backup is made through OsC this error comes...and only a part of the database is saved. Anyone? // Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.