Bug #16636: INSERT cache_hash ident value needs to be truncated to 20 chars manually - TYPO3 Core - TYPO3 Forge

Actions

Copy link

Bug #16636

closed

INSERT cache_hash ident value needs to be truncated to 20 chars manually

Added by Michiel Roos about 18 years ago. Updated over 17 years ago.

Status:

Closed

Priority:

Should have

Assignee:

Karsten Dambekalns

Category:

Database API (Doctrine DBAL)

Target version:

Start date:

2006-10-10

Due date:

% Done:

Estimated time:

TYPO3 Version:

4.0

PHP Version:

Tags:

Complexity:

Is Regression:

Sprint Focus:

Description

When inserting a cache_hash the field 'ident' is a length of 20. When the string is longer, MySQL will just truncate the value.

Postgres however, will not. It will fail the insert and throw an error.

This is bad. ;-)

This can be fixed by manually truncating the value that goes into 'ident' to 20 chars.

(issue imported from #M4363)

Files

Download all files

class.t3lib_page.php.diff (466 Bytes) class.t3lib_page.php.diff		Administrator Admin, 2006-10-10 16:02
class.t3lib_befunc.php.diff (339 KB) class.t3lib_befunc.php.diff		Administrator Admin, 2006-10-10 16:02

Actions

Copy link

Updated by Martin Kutschker about 18 years ago

No, the solution is wrong. The documentation clearly says that the ident may only be 20 chars long. So it's up to the caller to supply correct values.

I suggest we close the bug (no-fix) and you file a bug with for the code (Core or extension) that produces the error.

Perhaps we could make the field longer to allow for tx_<extkey>_<info>. 20 chars is probably to small for such an ident.

Actions

Copy link