[TYPO3-core] RFC #8542: Cannot create page with Mysl in strict mode (STRICT_TRANS_TABLES)

[Martin Kutschker]

Steffen Kamper schrieb:
> 
> thx for your investigation. Seems that definition of group fields in DB is 
> not common.
> IIRC the fields where converted from Blob to Varchar (NOT NULL) eg usergroup 
> in be_user

You don't understand. The "storage_pid" in "pages" has always been an 
INT column. The point is that TYPO3 relies on implicit types conversions 
from '' to 0 both in PHP and Mysql.

> I think best way is to have a correct field definition and a correct 
> handling in t3lib_TCEmain::checkValue_group_select_processDBdata()

You need only one one them. Either the column is changed into a VARCHAR, 
then there is no need for processing, or the the column stays an INT, 
then we need some kind of processing.

Masi