[TYPO3] a-b-c 1-2-3 installer / jive with database

[Erik Svendsen]

Hello Dmitry,

>> The setup:
>> MySQL 5.0.22
> This is the reason most likely. Typo3 is not officially compatible
> with mysql5. You may want to search mailing list archives for
> solution.

Suppose this is correct. TYPO3 has problem with certain modes of MySQL 5.x. 
Because of security (not hacking), but internal data integrity the standard 
mode of MySQL 5.x normally are STRICT_TRANS_TABLES, who are more and less 
incompatible with TYPO3. (as far as I understand, but as I'm not a MySQL-guru, 
so I may have misunderstod).

If this are the reason - the solution is to open the Install tool, go to 
All Configuration. Then look for [setDBinit], and copy the following value 
to the taxtarea, SET SESSION sql_mode='MYSQL4';

http://bugs.typo3.org/view.php?id=2059 gives also some information.
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html - gives a more 
comprehensive explanation about the modes.

The strange part, I had problem like this when ugrading MySQL to or installing 
MySQL 5.x on Windows. Haven't had it on my Debian server with MySQL 5, and 
not on my laptop with OpenSuse and MySQL 5

 
WBR,
Erik Svendsen
www.linnearad.no