[TYPO3] PHP Warning: mysql_free_result(): suppliedargumentisnota valid MySQLresultresourcein/usr/local/typo3/t3lib/class.t3lib_db.php

[erasmo at erasmix.net]

Hi,

I just ran select @@sql_mode and got back an empty string.


Thx,

Erasmo.

Dmitry Dulepov [typo3] wrote ..
> 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"
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english