Bug #28637
closedOld EM: t3lib_DB::exec_INSERTquery errors
100%
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
Updated by Jigal van Hemert over 13 years ago
- Assignee set to Jigal van Hemert
- Complexity set to easy
Can't reproduce the problem with current master.
Judging from the error messages there was a problem with the XML content. It looks like the storeXMLResult() (Shouldn't that be storeXmlResult ?) function doesn't validate the parsed XML correctly and tries to store nonsense information if the XML is broken.
Patch (in Gerrit) removes fields which are not in the database table and adds the default values of missing fields.
Updated by Mr. Hudson over 13 years ago
Patch set 1 of change I80ca3170c2840b44497398b2b9cf48c285dc2215 has been pushed to the review server.
It is available at http://review.typo3.org/4169
Updated by Mr. Hudson over 13 years ago
Patch set 2 of change I80ca3170c2840b44497398b2b9cf48c285dc2215 has been pushed to the review server.
It is available at http://review.typo3.org/4169
Updated by Mr. Hudson over 13 years ago
Patch set 3 of change I80ca3170c2840b44497398b2b9cf48c285dc2215 has been pushed to the review server.
It is available at http://review.typo3.org/4169
Updated by Xavier Perseguers over 13 years ago
- Status changed from New to Under Review
Updated by Jigal van Hemert over 13 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 203fa1ee6ab53e902ed7e56c913163ac434d211d.