[TYPO3-dev] STRICT-mode for MySQL and install tool

[Peter Russ]

--- Original Nachricht ---
Absender:   Steffen Kamper
Datum:       27.01.2009 00:04:
> Hi,
> 
> i'm not sure about my results, so  i ask here and descrbe the situation:
> 
> I configured MySQL to work in STRICT-mode
> $TYPO3_CONF_VARS['SYS']['setDBinit'] = 'SET @@global.sql_mode= 
> \'STRICT_ALL_TABLES\';';   
> 
> Then i discovered Problems with new content with templavoila, error 
> message was:
> sorry, you didn't have proper permissions to perform this change.
> 
> Then i created content with classic page module, error message was:
> 2: SQL error: 'Field 'tx_templavoila_flex' doesn't have a default value' 
> (tt_content:NEW497e35b082363)
> 
> looking to ext_tables.sql, field is defined:
> tx_templavoila_flex mediumtext NOT NULL
> 
> After i changed the field in PMA to DEFAULT '' all errors were gone and 
> i could create new content again.
> 
> Now first question: is it the case that all fields need DEFAULT if they 
> are defined with NOT NULL? (even mediumtext,text etc.)
> 
> And now the Bug with installtool. If i change definition to
> tx_templavoila_flex mediumtext DEFAULT '' NOT NULL
> 
> EM (installscript) is never happy and always display:
> ALTER TABLE tt_content CHANGE tx_templavoila_flex tx_templavoila_flex 
> mediumtext default '';
> Current value: mediumtext
> If my first question is true, then we have a bug with the compare.
> (it seems there are more, try to change DEFAULT '' to DEFAULT NULL)
> 

I would say no bug. Just missing understanding: 
http://bugs.mysql.com/bug.php?id=33371

Peter.

-- 
Fiat lux!
Docendo discimus.
http://www.gidf.de

_____________________________
4Many� Services

XING:	https://www.xing.com/go/invita/360052
	http://www.xing.com/go/privatemessage/Peter_Russ