Bug #17380
closed
Extension Manager does not recognize and report errors when executing sql queries
Added by Christoph Eisenmann over 17 years ago.
Updated almost 11 years ago.
Category:
Extension Manager
Description
No error message is given if something in ext_tables_static+adt.sql went wrong
A malfunctioning create table or insert into statement is not recognized. The extension manager reports extension installed even important parts like data are missing.
It is always possible that an extension has a sql bug. In this case an error message should be given.
(issue imported from #M6008)
Quickpatch to solve the problem:
open typo3/mod/tools/em/class.em_index.php,
move to the function checkDBupdates, look for the line
$GLOBALS['TYPO3_DB']->admin_query($statements_table[$table]);
(line no. 4479 and add this underneath:
if($e = $GLOBALS['TYPO3_DB']->sql_error()) $error = "<div><b>A SQL-error was thrown by statements in the file 'ext_tables_static+adt.sql'</b><br />$e</div>";
A few lines further down find the line
$GLOBALS['TYPO3_DB']->admin_query($v);
and add
if($e = $GLOBALS['TYPO3_DB']->sql_error()) $error = "<div><b>A SQL-error was thrown by statements in the file 'ext_tables_static+adt.sql'</b><br />$e<br><b>Statement:</b><br />$v</div>";
At last add at the end of the foreach-block (above the else statement, line no 4492):
if($error) $content .= $error;
Linenumbers apply to TYPO3 Version 4.1.2
Someone to write a patch? Ernst?
Please put the texts in locallang files then (as it is everywhere else in EM, too).
- Status changed from New to Needs Feedback
- Target version deleted (
0)
- Is Regression set to No
Hi,
as this issue is very old. Does the problem still exists within newer versions of TYPO3 CMS (4.5 or 6.1)?
- Status changed from Needs Feedback to Closed
No feedback within the last 90 days => closing this ticket.
If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.
Also available in: Atom
PDF