Bug #16952
closed
Calling "DB Check" -> "Record Statistics" results in many SQL-related errors
Added by Christian Brunner almost 18 years ago.
Updated over 17 years ago.
Description
When I call "DB Check" -> "Record Statistics" I get a lot of errors in t3lib/class.t3lib_db.php in lines around 800.
Reason:
The functions "sql_fetch_assoc()" and "sql_fetch_row()" don't check, whether $res is a valid SQL Resource
I got these warnings on PHP Error Level E_ALL
I attached a diff-file that fixed the problem for me
I think this also affects Version 4.0.4 but i'm not sure
MySQL 5.0.22
(issue imported from #M4939)
I forgot to say that I got this error with 4.1RC1 but I could only select 4.1beta3...
sorry for that
Did you update the database in the Install Tool?
yes
today i
1) changed the sources form 4.0.4 to 4.1RC1
2) made a DB update
3) changed the compatibility mode to 4.1
=> error was still there
btw: the error was already there with 4.0.4 (clean install)
@anyone looking at this bug:
PLEASE DONT USE THE PATCH!!!! (i cant delete it)
the patch just supresses the error but doesn't solve it!
the problem seems to be "deeper" (look at bug 0004951)
[EDIT] it was an mysql bug (i think in 5.0.22) -> update mysql and it works just fine
The error depends on MySQL 5.0.22 which is unable to handle query parts like "... IN (-1,0,123) ..." (negative integer and positive integer in an "IN (...)" statement).
The error was fixed in MySQL 5.0.23/5.0.24, see http://bugs.mysql.com/bug.php?id=19618.
I removed the suggested patch.
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by