Bug #24880
closed
SQL errors in EM when updating extensionlist from TER
0%
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
Updated by Andreas Becker (Andi) over 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
Updated by Ingo Pfennigstorf about 13 years ago
- File Auswahl_003.png Auswahl_003.png added
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
Updated by Jigal van Hemert over 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 ...
Updated by Stefan Galinski over 11 years ago
- Status changed from Needs Feedback to Closed
No feedback for more than 90 days...