TYPO3 Core

Which MySQL version?

Hi,
I believe I have read that Rene has fixed this...
Greets, Sebastian

Hi René,
I believe you already fixed this issue some time ago - but I am not sure.
Can you confirm this?
Greets, and thanks,
Sebastian

MySQL 3.23. But it does not matter, seems like these tables were not defined properly and typo3 thinks they should not exist

As I remember this is related to the Install Tool and some Mysql versions (5.x?).
While the static info tables just don't do the COMPARE they are not resposible for the failure. Also there's nothing special in the tables, I think.

Rene, install tools compares database structure to your SQL (you have it in ext_tables.sql). It seems that COMPARE cannot find SQL for those tables and thinks they should be removed.

[(you have it in ext_tables.sql). It seems that COMPARE cannot find SQL for those tables and thinks they should be removed.]

Why is that my fault? I would be happy to fix that, but I can't see where the problem is in static info tables. If someone tells me what's wrong with the SQL I'll fix that. For me it's working with PHP4/5/5.1 and MySql 4/5.
BTW: Do you have installed the latest version?

Well, any tables managed by typo3 should be properly defined in ext_tables.sql and ext_tables.php. Static tables probably have different SQL file name (I am not sure). I am saying that it is a problem with SQL file because I had similar problem in my own extension. It also had static table and typo3 wanted to kill it on COMPARE. I do not remember what exactly I did but it was something with SQL and ext_tables.php

[Static tables probably have different SQL file name (I am not sure).]

No.

Once I had a look into the COMPARE thing and I must say it's ... hard to understand. Two different ways of comparing, different handling of MySQL versions and so on.
I just can't fix that unless someone tell me how, unfortunately!
As I said before, it seems not to work with specific MySQL versions and it works perfect for me and other's.

Rene, I try to will check with latest version today. Let's wait till I verify it. If it does not work, I will try to see why.

Works here, if static_info_tables is installed the table is not suggested for deletion.

@Dmitry Dulepov: under what excat circumstances does this happen?

Latest version is ok. You can close this bug.

Karsten, nothing special. Installed version from TER, went to install tool > database analyzer and selected COMPARE.

Works with latest version of extension