Dump Error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
lordzardeck
Posts: 3
Joined: Sat 24 Oct 2009 13:44

Dump Error

Post by lordzardeck » Sat 24 Oct 2009 14:27

For some reason I keep getting this error when I try to run the MySQL dump class in dotconnnect:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition' at line 1

I have NO idea why this happens, and I'd be more than glad to give any information needed to solve this problem.

lordzardeck
Posts: 3
Joined: Sat 24 Oct 2009 13:44

Post by lordzardeck » Sun 25 Oct 2009 04:05

Found out the problem. In mysql, you can't use condition as a field without enclosing it with `. I think that if devart wants $150 from me, they should have included this.

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 26 Oct 2009 16:18

Please explain your functionality request more clearly.

lordzardeck
Posts: 3
Joined: Sat 24 Oct 2009 13:44

Post by lordzardeck » Tue 27 Oct 2009 00:16

Well, i figured out what the problem was. I have a table in my database called condition, and it uses a column called condition. I found out that mysql requires ` marks to be placed around these in order for it to work. Your MySQL Dump class does not do this. Will you be able to change your queries in the classes to place ` around them? I will NOT even consider purchasing full license if problems like these can not be resolved.

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 27 Oct 2009 12:51

We have answered you by e-mail.

Post Reply