Issue Bug Closed

#29351Extensionmanager: You have an error in your SQL syntax

Bernd Wilke 08/30/11, 13:29 updated 08/19/13, 14:43

Description

each time I update the table of extensions I got this errors:

exec_INSERTquery
String (26)     caller     t3lib_DB::exec_INSERTquery
String (226)     ERROR     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 'version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastver' at line 1
String (193)     lastBuiltQuery     INSERT INTO cache_extensions (,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastversion,lastreviewedversion,state) VALUES ('','','0','','','N;','4','','1','1','999')
String (316)     debug_backtrace     require#51 // SC_mod_tools_em_index->main#2597 // SC_mod_tools_em_index->extensionList_import#492 // SC_mod_tools_em_index->fetchMetaData#805 // tx_em_Tools_XmlHandler->parseExtensionsXML#1176 // tx_em_Tools_XmlHandler->storeXMLResult#400 // t3lib_DB->exec_INSERTquery#517 // t3lib_DB->debug#172 
exec_INSERTquery
String (26)     caller     t3lib_DB::exec_INSERTquery
String (226)     ERROR     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 'downloadcounter,version,intversion,extkey,alldownloadcounter,dependencies,catego' at line 1
String (223)     lastBuiltQuery     INSERT INTO cache_extensions (,downloadcounter,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastreviewedversion,state) VALUES ('','4543','','0','a1_teasermenu','','N;','3','A1 Teasermenu','1','')
String (316)     debug_backtrace     require#51 // SC_mod_tools_em_index->main#2597 // SC_mod_tools_em_index->extensionList_import#492 // SC_mod_tools_em_index->fetchMetaData#805 // tx_em_Tools_XmlHandler->parseExtensionsXML#1176 // tx_em_Tools_XmlHandler->storeXMLResult#400 // t3lib_DB->exec_INSERTquery#517 // t3lib_DB->debug#172 

it seems one fieldname is missing.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.