DBD::mysql::st execute failed

kai3192 · 06-19-2013, 12:43 PM

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, 02:26 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Download UCSC table with mySql workbench	desmo	Bioinformatics	4	05-31-2012 08:28 AM
1K Genomes mysql	ashkot	Bioinformatics	0	04-20-2012 12:48 PM
Execute Tophat Via Java	Stiff0810	Bioinformatics	6	07-18-2011 01:53 AM
dbSNP build 133 & mysql	rworthi	Bioinformatics	0	06-30-2011 04:05 PM
another tophat "could not execute prep_reads" error	James	Bioinformatics	7	11-17-2010 05:49 AM

06-19-2013, 12:43 PM	#1
kai3192 Junior Member Location: India Join Date: Jun 2013 Posts: 8	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... ??????

06-24-2013, 02:26 AM	#2
Shishir Member Location: Germany Join Date: Nov 2012 Posts: 22	Hi, I am facing the same error and still not able to solve it. Have you already fixed this error?