SEQanswers

SEQanswers (http://seqanswers.com/forums/index.php)
-   Bioinformatics (http://seqanswers.com/forums/forumdisplay.php?f=18)
-   -   DBD::mysql::st execute failed (http://seqanswers.com/forums/showthread.php?t=31238)

kai3192 06-19-2013 11:43 AM

DBD::mysql::st execute failed
 
I am using orthomcl... and currently encountering a error at step 9 (orthomclLoadBlast)... the error says 'DBD::mysql::st execute failed: The used command is not allowed with this MySQL version at orthomclLoadBlast line 39, <F> line 14.'

The orthomcl manual suggests to reinstall Mysql as it was configured without the load local infile tag.... I did that well a several times but when i reinstall the server does not start... i m using ubuntu 12.04... and only when i install the mysql package that comes with ubuntu i m able to start the server but it is by default not configured with Load Local infile option... what should I do ???

I also tried using the mysql import command to directly import the files into the table but then i get an error saying 'mysqlimport: Error: 13, File '/var/lib/mysql/SimilarSequences.txt' not found (Errcode: 13), when using table: SimilarSequences'.... although when the file is persent at its printed path

Can anybody please help me... ??????

Shishir 06-24-2013 01:26 AM

Hi, I am facing the same error and still not able to solve it. Have you already fixed this error? :confused:


All times are GMT -8. The time now is 07:53 AM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2020, vBulletin Solutions, Inc.