Issue Bug Closed

#24880SQL errors in EM when updating extensionlist from TER

Rupert Germann 01/28/11, 16:03 updated 03/06/13, 21:43

Description

Clicking “retrieve/update” in EM (old) throws 2 SQL errors:
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

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

debug_backtrace:
require#14136 // SC_mod_tools_em_index->main#14136 // SC_mod_tools_em_index->extensionList_import#14136 // SC_mod_tools_em_index->fetchMetaData#14136 // tx_em_Tools_XmlHandler->parseExtensionsXML#14136 // tx_em_Tools_XmlHandler->storeXMLResult#14136 // t3lib_DB->exec_INSERTquery#14136 // t3lib_DB->debug#14136

error 2:
INSERT INTO cache_extensions (,downloadcounter,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastreviewedversion,state) VALUES (‘’,‘4399’,’‘,‘0’,‘a1_teasermenu’,’‘,‘N;’,‘3’,‘A1 Teasermenu’,‘1’,’‘)

delete file extensions.xml.gz from typo3temp/ dir, empty table cache_extensions and hit “retrieve/update” in EM

(issue imported from #M17391)

Reviews 0

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