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

[Sander van Gelderen]

Hi Steffen,

Problem solved, thank you very much.

best regards,

Sander

Steffen Kamper schreef:
> Hi,
> 
> this was fixed in trunk with #8728
> 
> vg Steffen
> 
> Sander van Gelderen schrieb:
>> 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