Project

General

Profile

Actions

Bug #20746

closed

"TMPL CONDITIONS - ALL" - too Long for 20 Chars cache_hash field size

Added by Ingo Schmitt over 15 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Must have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2009-07-13
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.2
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

class.t3lib_tstemplate.php tries to store hash values with 21char String as identifier. Since table definition is for this field is 20 chars, this causes an error (see attached image)

have a look into your cache_hash table, there only the entry "TMPL CONDITIONS - AL" (one missing L) as entry.

The error will be shown, if you have SQL Debug enabled and mysql in strict mode (I don't know what will happen in other databases). I got the error first after installing TYPO3 on a fresh XMAPP package on Windows.

Note:
Other solution would be to change the identifier char, searching for any occurrence of the string:"TMPL CONDITIONS - ALL" was not successful, so it might be used in other places as in the core. If it is not used anywhere, the storing of the hash could also be removed from the core.
(issue imported from #M11513)


Files

cache_hash_fix_4.2.diff (442 Bytes) cache_hash_fix_4.2.diff Administrator Admin, 2009-07-13 21:29
bug_field_ident.gif (94.6 KB) bug_field_ident.gif Administrator Admin, 2009-07-13 21:35

Related issues 2 (0 open2 closed)

Has duplicate TYPO3 Core - Bug #20747: "TMPL CONDITIONS - ALL" - too Long for 20 Chars cache_hash field sizeClosedChristian Kuhn2009-07-13

Actions
Has duplicate TYPO3 Core - Bug #20748: "TMPL CONDITIONS - ALL" - too Long for 20 Chars cache_hash field sizeClosedChristian Kuhn2009-07-13

Actions
Actions #1

Updated by Ingo Schmitt over 15 years ago

Sorry, Bugtracker issued a 500 Server Error

Actions #2

Updated by Michael Stucki over 15 years ago

Fixed in TYPO3_4-2. The problem is solved in a different way already in Trunk, so it won't occur in 4.3 anyway.

Thanks Ingo!

Actions #3

Updated by Michael Stucki over 15 years ago

Just a note: This fixes only the DB scheme definition. In order to apply the change, you need to update the database using Install Tool.

Actions #4

Updated by Michael Stucki over 15 years ago

Additionally, I've now changed the value of "TMPL CONDITIONS - ALL" and cut off the last character so these entries can be written again without changing the database.

Actions

Also available in: Atom PDF