Project

General

Profile

Actions
Copy link

Bug #24880

closed

SQL errors in EM when updating extensionlist from TER

Added by Rupert Germann over 13 years ago. Updated about 11 years ago.

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

0%

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

Description

Clicking "retrieve/update" in EM (old) throws 2 SQL errors:
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

INSERT INTO cache_extensions (,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastversion,lastreviewedversion,state) VALUES ('','','0','','','N;','4','','1','1','999')

debug_backtrace:
require#14136 // SC_mod_tools_em_index->main#14136 // SC_mod_tools_em_index->extensionList_import#14136 // SC_mod_tools_em_index->fetchMetaData#14136 // tx_em_Tools_XmlHandler->parseExtensionsXML#14136 // tx_em_Tools_XmlHandler->storeXMLResult#14136 // t3lib_DB->exec_INSERTquery#14136 // t3lib_DB->debug#14136

error 2:
INSERT INTO cache_extensions (,downloadcounter,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastreviewedversion,state) VALUES ('','4399','','0','a1_teasermenu','','N;','3','A1 Teasermenu','1','')

delete file extensions.xml.gz from typo3temp/ dir, empty table cache_extensions and hit "retrieve/update" in EM

(issue imported from #M17391)

Files

Auswahl_003.png (19.6 KB) Auswahl_003.png Ingo Pfennigstorf, 2011-09-15 15:10

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #28637: Old EM: t3lib_DB::exec_INSERTquery errorsClosedJigal van Hemert2011-08-01

Actions
Actions
Copy link

Also available in: Atom PDF