Project

General

Profile

Actions

Bug #29351

closed

Extensionmanager: You have an error in your SQL syntax

Added by Bernd Wilke about 13 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Could have
Assignee:
-
Category:
Extension Manager
Target version:
-
Start date:
2011-08-30
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.5
PHP Version:
Tags:
Complexity:
medium
Is Regression:
Sprint Focus:

Description

each time I update the table of extensions I got this errors:

exec_INSERTquery
String (26)     caller     t3lib_DB::exec_INSERTquery
String (226)     ERROR     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
String (193)     lastBuiltQuery     INSERT INTO cache_extensions (,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastversion,lastreviewedversion,state) VALUES ('','','0','','','N;','4','','1','1','999')
String (316)     debug_backtrace     require#51 // SC_mod_tools_em_index->main#2597 // SC_mod_tools_em_index->extensionList_import#492 // SC_mod_tools_em_index->fetchMetaData#805 // tx_em_Tools_XmlHandler->parseExtensionsXML#1176 // tx_em_Tools_XmlHandler->storeXMLResult#400 // t3lib_DB->exec_INSERTquery#517 // t3lib_DB->debug#172 

exec_INSERTquery
String (26)     caller     t3lib_DB::exec_INSERTquery
String (226)     ERROR     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
String (223)     lastBuiltQuery     INSERT INTO cache_extensions (,downloadcounter,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastreviewedversion,state) VALUES ('','4543','','0','a1_teasermenu','','N;','3','A1 Teasermenu','1','')
String (316)     debug_backtrace     require#51 // SC_mod_tools_em_index->main#2597 // SC_mod_tools_em_index->extensionList_import#492 // SC_mod_tools_em_index->fetchMetaData#805 // tx_em_Tools_XmlHandler->parseExtensionsXML#1176 // tx_em_Tools_XmlHandler->storeXMLResult#400 // t3lib_DB->exec_INSERTquery#517 // t3lib_DB->debug#172 

it seems one fieldname is missing.

Actions

Also available in: Atom PDF