This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Orthomclinstallschema: DBD::mysql::st execute failed:....

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?

software error
• 3,493 views • link
written by tito3000 • 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.
• 1 views • link
written by tito3000 • tito3000

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.

• 1 views • link
written by Juke34 Juke34

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

• 1 views • link
written by tito3000 • tito3000

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 ?

• 1 views • link
written by Juke34 Juke34

0 answers

No answers yet.

Log in to answer this question.

More posts like this