JChem 5.0.0 problem with mysql-connector

Dear Support,





After upgrading to JChem 5.0.0 I still can connect to a database with mysql-connector, but when I try to create a new table with default parameters I get the following error:





'BLOB/TEXT column 'cd_sortable_formula' used in key specification without a key length'





Thanx, for any suggestion!








JChem Manager 5.0.0


JVM: Sun 1.6.0_03


OS: x86 Win XP 5.1


mysql-connector-java-5.1.5-bin.jar

Hi,





We are investigating the problem and plan to fix it for JChem 5.0.1.


We will get back to you soon.


Could you also let us know your MySQL version meanwhile please ?





(e.g. "mysql --version")





Best regards,





Szilard

Szilard wrote:

Could you also let us know your MySQL version meanwhile please?

4.1.21-community

Zsolt,





We have reconstructed the problem successfully.


We will fix this in the next bugfix release, thank you for reporting the problem.





Edvard

JChem 5.0.1 has been released, the structure table upgrade problem has been fixed.


Sorry for this inconvenience.





Edvard