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

[Erik Svendsen]

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.

Look in this bug report - http://bugs.typo3.org/view.php?id=2059 - maybe 
you find the answer.

http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html - gives a more 
comprehensive explanation


WBR,
Erik Svendsen
www.linnearad.no