Orthomclinstallschema: DBD::mysql::st execute failed:....

Question

[tito3000]

Hi everyone! orthomclInstallSchema gives me this error:

DBD::mysql::st execute failed: Table 'SimilarSequences' already exists at /usr/local/bin/orthomclSoftware/bin/orthomclInstallSchema line 184, <F> line 14.

Can you Help me, please?

[tito3000]

I solved this problem by removing table on mysql databases. Unfortunately, I found the following error:

DBD::mysql::st execute failed: Table storage engine for 'SimilarSequencess' doesn't have this option at /usr/local/bin/orthomclSoftware/bin/orthomclInstallSchema line 184, <F> line 14.

[Juke34]

You should restart from a clean database. Remove it and re-isntall it. DROP DATABASE orthomclDB CREATE DATABASE orthomclDB orthomclInstallSchema orthomcl.config

Replace orthomclDB by the database name you used.

[tito3000]

Thanks for support, Juke. I I did as you say but i have the same problem. Do you have other suggestions?

[Juke34]

I remember that you have to set up your Mysql installation in a certain way (with a specific option) to be able to use it without error with OrthoMCL. Did you check that ?