Page 1 of 1

Dump Error

Posted: Sat 24 Oct 2009 14:27
by lordzardeck
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.

Posted: Sun 25 Oct 2009 04:05
by lordzardeck
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.

Posted: Mon 26 Oct 2009 16:18
by Shalex
Please explain your functionality request more clearly.

Posted: Tue 27 Oct 2009 00:16
by lordzardeck
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.

Posted: Tue 27 Oct 2009 12:51
by Shalex
We have answered you by e-mail.