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

[Dmitry Dulepov [typo3]]

Hi!

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

-- 
Dmitry Dulepov
TYPO3 core team
Web: http://typo3bloke.net/
Skype: callto:liels_bugs
"Nothing is impossible. There are only limits to our knowledge"