Unknown MySQL datatype (221)

ShaiLeTroll · Post by **ShaiLeTroll** » Thu 11 Feb 2010 15:50

I change MyDAC 3.55 to 5.90 on Delphi 7 (no Patch)
I Use MySQL 4.1.9-max (Easy PHP 1.8 )

Classic RunTime

Unknown MySQL datatype (221) (D:\Projects\Delphi\Dac\MySql\Source\MyClasses.pas, ligne 1300)"

RunTime With Stop on Delphi Exception (French Delphi)

---------------------------
Notification d'une exception du débogueur
---------------------------
Le projet NeoScope2.exe a provoqué une classe d'exception EAssertionFailed avec le message 'Unknown MySQL datatype (208) (D:\Projects\Delphi\Dac\MySql\Source\MyClasses.pas, ligne 1300)'. Processus stoppé. Utilisez Pas-à-pas ou Exécuter pour continuer.
---------------------------
OK Aide
---------------------------

Why have EAssertionFailed ?
I uncheck the case "Assertions" in Delphi Projects Options on Application Projet and on Internal DPK include a herited object from MyTable

Normally I check the case "Assertions"

Either checked or unchecked, this does not work, I have Assertions in my project

Sometimes, from time to time (au petit bonheur la chance), I Repair and Optimize Table It Works but on Some tables, it's not work, I must drop and refill table !

I Observe différence with EasyPHP LocalHost and EasyPHP on Server (I have a Old Server with Old Files)
A Différent Protocol ?

If i try only REPAIR TABLE or only OPTIMIZE TABLE on PHP MyAdmin has not really effect on TMyTable.Open

but if i run CHECK TABLE, ANALYZE TABLE, REPAIR TABLE, OPTIMIZE TABLE once per table on my Program with TMyScript, after this 4 opérations the TMyTable.Open its Work !

these 4 operations are slow to execute, do not worry, this will be done only once in the transitional version of our software
Hopefully it is not necessary to renew the operation

Accept English ou French Response

Dimon · Post by **Dimon** » Mon 15 Feb 2010 08:09

I can not reproduce the problem.
It seems that this problem is connected with MySQL server, but not with MyDAC.
Please, try to compose a small sample to demonstrate the problem and send it to dmitryg*devart*com, including the script for creating database objects.

ShaiLeTroll · Post by **ShaiLeTroll** » Mon 15 Feb 2010 14:07

I can not reproduce the problem too !
This Morning, I have not reproduce this anomaly !
Yet I have nothing changed on the server that is running since 1 January 2010
Incomprehensible!

Maybe the network problems that we had internally in society have affected my testing client \ server between MySQL 4.1.19 and MyDAC 5.90.0.54 01-Dec-09

I had the impression that the data were shifted as if he missed the start of the frame

Dimon · Post by **Dimon** » Mon 15 Feb 2010 15:00

Probably, this problem was connected with MySQL server or network problems, but not with MyDAC.
If any other questions come up, please contact me.