Dump Error

Dump Error

Postby 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

Postby 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.
lordzardeck
 
Posts: 3
Joined: Sat 24 Oct 2009 13:44

Postby Shalex » Mon 26 Oct 2009 16:18

Please explain your functionality request more clearly.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Postby 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.
lordzardeck
 
Posts: 3
Joined: Sat 24 Oct 2009 13:44

Postby Shalex » Tue 27 Oct 2009 12:51

We have answered you by e-mail.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL