Bug #29351: Extensionmanager: You have an error in your SQL syntax - TYPO3 Core - TYPO3 Forge

Actions

Copy link

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:

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

Copy link

Updated by Andreas Wolf about 13 years ago

Category set to Extension Manager
Complexity set to medium

Actions

Copy link

Updated by Markus Klein about 13 years ago

Hi Bernd,

can you please specify exactly what you're doing. What do you mean with "each time I update the table of extensions"?
I had a look at the source code, but didn't see anything that looks obviously wrong. I'm not able to reproduce ether.

Thanks for helping figuring this out.

Actions

Copy link

Updated by Steffen Gebert about 13 years ago

Priority changed from Must have to Could have
Target version deleted (~~4.5.6~~)

Actions

Copy link

Updated by Xavier Perseguers about 13 years ago

Just one note here. It's really weird because we had this bug but (IIRC) Jigal fixed it.

Actions

Copy link

Updated by Bernd Wilke about 13 years ago

Extension Manager
: - > Import Extensions
: - > [Retrieve/Update]
so I have cc_debug installed, SQL-debug is enabled and my IP is in the dev-ip list of all my Installations I work on - each time I do an update on any of these installtions an errorwindow pops up with these errors.

Actions

Copy link

Updated by Helmut Hummel about 13 years ago

Status changed from New to Needs Feedback

Bernd, which TYPO3 Version are you using. This has been fixed recently.

Actions

Copy link

Updated by Bernd Wilke about 13 years ago

today I updated the extension list on two installations and got the errors again.
both are 4.5.6

as I noticed that an installation might behave other wether it is a fresh installation or an update:
both are updated from prior TYPO3 versions (I think one started as 4.5.3, the other might be an early 4.5 (what was newest in march 2011?)

Actions

Copy link