[TYPO3] Typo3 sites fails when upgrading mysql from 4 to 5

[Peter Russ]

Erik Svendsen schrieb:
> Hello Brian,
> 
> 
>> I have tried the compare trick and it wants to alter and create a lot
>> of tables. Then I press "Write to database" but it just loads for a
>> few seconds and then it suggest the same thing, like nothing actually
>> happened.
> 
> Your MySQL installation is probably running in STRICT_TRANS_TABLES, and 
> then TYPO3 has problems writing to the tables. Try set MySQL mode to 
> MYSQL4. You can do it in the installation tool.

Check for [SYS][DBinit] at install tool 5
and copy to the textarea:
SET SESSION sql_mode='MYSQL4';

Regs. Peter

-- 
Fiat lux!
Docendo discimus.
_____________________________
4Many® Services
openBC: http://www.openbc.com/go/invuid/Peter_Russ