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

Also available in: Atom PDF