[TYPO3] Typo3 sites fails when upgrading mysql from 4 to 5

[Francois Suter]

Hi,

>> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
>> result resource in
>> D:\Domains\initaaq.gl\wwwroot\typo3\t3lib\class.t3lib_db.php on  
>> line 741
>
> We do not officially support mysql 5. Changing from 4 is 5 is a major
> risk without official support. I would not do it even though I think I
> can solve most problems.

Well, I have a site running fine with MySQL 5. When I switched over  
from 4.0.x to 5.0.x, I just dumped the database from the 4.0.x MySQL  
server and reloaded it into the 5.0.x server. I had no problems  
except for some accentuated characters that were mangled, but that  
was probably a question of settings. I did the same recently for  
another database (but it was not TYPO3, it was SugarCRM) and no data  
was damaged.

I have no idea where your problem comes from. This kind of message  
often appears after an TYPO3 update when you haven't run the COMPARE  
utility in the Install tool. Maybe you could try that. Then again,  
maybe the error comes not from the core, but from an extension...

Good luck

François Suter
Directeur technique
-----------------------------------------------------
Cobweb Development Sàrl
www.cobweb.ch
-----------------------------------------------------