spike-spiegel Posted May 11, 2012 Share Posted May 11, 2012 I'm getting this error: #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 '«»)' at line 3 My code: INSERT INTO hwkix_comprofiler_plugin (id, NAME, element, TYPE, folder, backend_menu, access, ordering, published, iscore, client_id, checked_out, params) VALUES (501, "Iframe Integration", "iframe", "user", "plug_iframe", "", 0, 100, 1, 1, 0, 0, ""«»); INSERT INTO hwkix_comprofiler_tabs (tabid, title, description, ordering, ordering_register, width, enabled, pluginclass, pluginid, FIELDS, params, sys, displaytype, POSITION, useraccessgroupid) VALUES (25, "Newsletter", "", 102, 10, 1, 1, "getIFrameTab", 501, 1, "", 1, "tab", "cb_tabmain", -2); Is it something to do with "", 0, 100, 1, 1, 0, 0, "??? Link to comment https://forums.phpfreaks.com/topic/262408-1064-you-have-an-error-in-your-sql-syntax-syntax-to-use-near-%C3%A2%C2%AB%C3%A2%C2%BB/ Share on other sites More sharing options...
StaticFX Posted May 11, 2012 Share Posted May 11, 2012 no... INSERT INTO hwkix_comprofiler_plugin (id, NAME, element, TYPE, folder, backend_menu, access, ordering, published, iscore, client_id, checked_out, params) VALUES (501, "Iframe Integration", "iframe", "user", "plug_iframe", "", 0, 100, 1, 1, 0, 0, ""«»); you have «» in your sql. Link to comment https://forums.phpfreaks.com/topic/262408-1064-you-have-an-error-in-your-sql-syntax-syntax-to-use-near-%C3%A2%C2%AB%C3%A2%C2%BB/#findComment-1344802 Share on other sites More sharing options...
Jessica Posted May 11, 2012 Share Posted May 11, 2012 Actually, he has «» , but it's outside of quotes. The error tells you where the problem is - Your values aren't in quotes. Link to comment https://forums.phpfreaks.com/topic/262408-1064-you-have-an-error-in-your-sql-syntax-syntax-to-use-near-%C3%A2%C2%AB%C3%A2%C2%BB/#findComment-1344873 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.