Issue Bug Closed

#23301Install some extension will failed with message "Table error!" because of "cache" tables

Erwan 07/29/10, 12:18 updated 02/20/14, 17:22

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.