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, "??? Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.