Project

General

Profile

Actions

Bug #28637

closed

Old EM: t3lib_DB::exec_INSERTquery errors

Added by Xavier Perseguers over 13 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Category:
Extension Manager
Target version:
-
Start date:
2011-08-01
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
4.6
PHP Version:
Tags:
Complexity:
easy
Is Regression:
Sprint Focus:

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


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #24880: SQL errors in EM when updating extensionlist from TERClosed2011-01-28

Actions
Actions #1

Updated by Thorsten Kahler over 13 years ago

  • Category set to Extension Manager
Actions #2

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.

Actions #3

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

Actions #4

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

Actions #5

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

Actions #6

Updated by Xavier Perseguers over 13 years ago

  • Status changed from New to Under Review
Actions #7

Updated by Jigal van Hemert over 13 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #8

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF