[TYPO3-core] RFC #8697: Warnings when using MySql 4.0

[Stefan Geith]

This is an SVN patch request.


Type: Bugfix


Bugtracker references:
http://bugs.typo3.org/view.php?id=8697


Branches:
4.2, Trunk


Problem:
If MySql < 4.1 is used, your get many warnings for class.t3lib_db.php on line 1047


Additional Information:
MySql before 4.1 does not support query('SHOW CHARACTER SET').
The function admin_get_charsets() was added to t3lib_db with Typo3 4.2.

At least all 1+1 managed servers only support MySql 4.0 (not 4.1 nor 5.0).
The support-center of 1+1 states: no update to 4.1 or 5.0 before end of 2008.

I think Typo3 4.2 and 4.3 should still be able to use MySql 4.0

I am not sure what side-effects we get, if admin_get_charsets returns an empty array. 
Where mights this lead to complications ?


Solution:
Removing this Warning is easy: simply check for resource:
   1047: if ($columns_res) while ($row = mysql_fetch_assoc($columns_res)) {



-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 0008697-mysql40.patch
Url: http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20080613/72e57d7a/attachment.txt