Dump Error

lordzardeck · 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 · 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 · Post by **Shalex** » Mon 26 Oct 2009 16:18

Please explain your functionality request more clearly.

lordzardeck · 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 · Post by **Shalex** » Tue 27 Oct 2009 12:51

We have answered you by e-mail.