Project

General

Profile

Actions

Bug #23301

closed

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

Added by Erwan over 14 years ago. Updated almost 11 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2010-07-29
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.4
PHP Version:
5.3
Tags:
Complexity:
Is Regression:
No
Sprint Focus:

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)

Actions

Also available in: Atom PDF