Issue Bug Closed

#28637Old EM: t3lib_DB::exec_INSERTquery errors

Xavier Perseguers 08/01/11, 12:34 updated 10/02/18, 12:20

Description

When using old EM and updating the list of extensions (be sure to first truncate table cache_extensions), it ends up with two errors:

Error 1:

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

lastBuiltQuery:

INSERT INTO cache_extensions (,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastversion,lastreviewedversion,state) VALUES ('','','0','','','N;','4','','1','1','999')

debug_backtrace:

require#45 // SC_mod_tools_em_index->main#2587 // SC_mod_tools_em_index->extensionList_import#488 // SC_mod_tools_em_index->fetchMetaData#800 // tx_em_Tools_XmlHandler->parseExtensionsXML#1169 // tx_em_Tools_XmlHandler->storeXMLResult#400 // t3lib_DB->exec_INSERTquery#520 // t3lib_DB->debug#113

Error 2:

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

lastBuiltQuery:

INSERT INTO cache_extensions (,downloadcounter,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastreviewedversion,state) VALUES ('','4513','','0','a1_teasermenu','','N;','3','A1 Teasermenu','1','')

debug_backtrace:

require#45 // SC_mod_tools_em_index->main#2587 // SC_mod_tools_em_index->extensionList_import#488 // SC_mod_tools_em_index->fetchMetaData#800 // tx_em_Tools_XmlHandler->parseExtensionsXML#1169 // tx_em_Tools_XmlHandler->storeXMLResult#400 // t3lib_DB->exec_INSERTquery#520 // t3lib_DB->debug#113

Reviews 0

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