[TYPO3-english] Install tool --> Compare --> MySQL warnings

Sander van Gelderen sander at meyson.nl
Fri Oct 16 10:47:18 CEST 2009


Hello List,

I have a TYPO3 4.2.9 site running on Windows.
MySQL version 5.1.30

When I use the Install tool --> Compare function, I get following 
warnings at the top of the screen:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL 
result resource in D:\wamp\www\intranet3\t3lib\class.t3lib_db.php on 
line 1012

Warning: mysql_free_result(): supplied argument is not a valid MySQL 
result resource in D:\wamp\www\intranet3\t3lib\class.t3lib_db.php on 
line 836


Also I get the message 'Table and field definitions should be 
updated',followed by a long list of sql statements, here is one example:
ALTER TABLE sys_filemounts ADD uid int(11) unsigned NOT NULL auto_increment;

But using phpmyadmin, I see that the tables in the database already have 
the right structure, ie the uid field in the table sys_filemounts is 
exactly the way it should be and the sql statement would not change it 
at all.

Please can anyone give me advice how to solve this?

tia

Sander van Gelderen


More information about the TYPO3-english mailing list