[TYPO3] PHP Warning: mysql_free_result(): supplied argumentisnota valid MySQL resultresourcein/usr/local/typo3/t3lib/class.t3lib_db.php

[Ernesto Baschny [cron IT]]

Dmitry Dulepov [typo3] wrote: on 06.01.2008 18:12:

> Ernesto Baschny [cron IT] wrote:
>> There is no problem with mysql5, just configure it not to use "strict" 
>> mode. The default Windows mysql installation will include a "SQL-MODE" 
>> line with some STRICT instructions. Just uncomment that line, restart 
>> mysql and it should work.
> 
> According to [1] by default mysql comes without any mode, which seems to 
> be equal to 4.x defaults. Here is a quote:
> 
> --------------
> 27.3.7:  What is the default server SQL mode when My SQL 5.0 is installed?
> 
> By default, no special modes are enabled. See Section 5.1.6, “SQL 
> Modes”, for information about all available modes and MySQL's default 
> behavior. --------------
> 
> So it depends either on distribution or om the person, who configured 
> mysql. I checked mine SuSE 10.3 with MySQL 5.0.45. Its "select 
> @@sql_mode" produces empty string for sql_mode.
> 
> [1] 
> http://dev.mysql.com/doc/refman/5.0/en/faqs-sql-modes.html#qandaitem-27-3-7

That might be true for the source code which defaults to "none" if no 
setting is made, but I recall several windows installations from the 
official "setup.exe" from mysql.com which installed a my.ini with the 
strict modes "ON"!

I just installed mysql-essential-5.0.45-win32.msi:

The installation is pretty easy, and after installed it opens the "MySQL 
Server Instance Configuration Wizard". Somewhere in step 5 or 6 there is 
a question about "Enable Strict Mode", which is checked by default. 
Comment is "It is recommended to enable this option". After finished, I get:

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

in my.ini.

Cheers,
Ernesto