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
 #1

Updated by Andreas Becker (Andi) about 13 years ago

  • Target version deleted (0)

Hi Any news in this issue as we are receiving same errors also on
PHP Version5.3.3-7+squeeze1
Web ServerApache/2.2.16 (Debian)
Debian 6
TYPO3 4.5.2

It happens always after we updated extensions from TER!

exec_INSERTquery

caller t3lib_DB::exec_INSERTquery

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

lastBuiltQuery
INSERT INTO cache_extensions (,downloadcounter,version,intversion,extkey,alldownloadcounter,dependencies,category,title,lastreviewedversion,state) VALUES ('','4449','','0','a1_teasermenu','','N;','3','A1 Teasermenu','1','')
debug_backtrace require#51 // SC_mod_tools_em_index->main#2589 // 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

Actions
Copy link
 #2

Updated by Ingo Pfennigstorf over 12 years ago

I guess this may be caused by an incorrect counter in the TER for the extension a1_teasermenu.

Downloads (total / this version)
4555 / 4565

The number of total downloads is lower than the one from the current version. Maybe this simply has to be fixed.

Opened #29816

Actions
Copy link
 #3

Updated by Jigal van Hemert about 12 years ago

  • Category set to Extension Manager
  • Status changed from New to Needs Feedback

Is this still an issue? It seems to be the same problem as fixed in #28637 ...

Actions
Copy link
 #4

Updated by Stefan Galinski about 11 years ago

  • Status changed from Needs Feedback to Closed

No feedback for more than 90 days...

Actions
Copy link

Also available in: Atom PDF