Bug #23301
closed
Install some extension will failed with message "Table error!" because of "cache" tables
0%
Description
Trying to install Direct Mail on Typo3 4.4.1, i got the message "Table error! Probably one or more required fields/tables are missing in the database!"
The core find differences in sql in getDatabaseExtra (class t3lib_install) BUT the sql is correct.
The only difference is an extra parameter called CLEAR added because the name of a table contains "cache" (cache_sys_dmail_stat).
But clear can't be compared because not part of SQL syntax.
i can fix this problem adding on line 623 in class t3lib_install the lines below:
----------
if ($fieldN=='CLEAR') {
continue; // CLEAR can't be compared because not part of SQL syntax
}
--------
=> just after the "if ($fieldN=='COLLATE') { ... }" statement.
Dun know if i should make a patch for this (and dun know how to write a patch by the way).
I'm new to typo3...
This problem occurs with DirectMail, but any extension using a table named with "cache" will be affected.
By the way, i still have another error message installing DirectMail : No XCLASS inclusion code found in file "cli/cli_direct_mail.php"... can't find the reason...
(issue imported from #M15285)
Updated by Chris topher over 14 years ago
The missing XClass is nothing to worry about. It is just developer relevant and should not cause problems for end users.
Now to the problem:
If CLEAR is not part of the MySQL syntax, it should not be used, right?
I think you should contact the author of DirectMail and he should fix that in his extension.
You should find an e mail address in the extension manager on the same page which shows the XClass notice.
Updated by Erwan over 14 years ago
Thanks for this information about XClass.
For the problem, "CLEAR" is not used in the SQL code of DirectMail, but added by typo3 in the file "t3lib/class.t3lib_install.php" by the lines below :
----------
if (preg_match('/^(cache|index)_/',$table)) {
// Suggest to truncate (clear) this table
$total[$table]['extra']['CLEAR'] = 1;
}
----------
We can ask the DirectMails authors to rename the table "cache_sys_dmail_stat" (and for all other extension, prevent the use of table starting by "cache") or fix the pb in class t3lib_install.
Updated by Alexander Opitz about 11 years ago
- 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)?
Updated by Alexander Opitz almost 11 years ago
- 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.