Page 1 of 1

Error deploying debug engine

Posted: Mon 04 Feb 2008 23:20
by mammut_02
I have this error when i try to deploy the debug engine

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 ';

CREATE FUNCTION check_breakpoint()
RETURNS int(11)
READS SQL DATA
' at line 6

I have version 5.0.45

Thanks for your help

Re: Error deploying debug engine

Posted: Tue 05 Feb 2008 08:57
by Elias
Please specify the version of MyDeveloper you use. We have tested the debug engine deployment on MySql 5.0.45 in the latest builds of MyDeveloper successfully.

Posted: Tue 05 Feb 2008 16:07
by mammut_02
It's ok now. I retried today and it worked ??? Alleluia xp reboot
FYI my version of MyDeveloper Studio is 2.10.78.

Same Problem

Posted: Wed 06 Feb 2008 08:53
by Percy
MySQL 5.0.45
MyDeveloper 2.10.78

Restarting MyDev fixed it. Maybe a DELIMITER-type issue? Since the beginning of the syntax error was with the semi-colon.

Update: I remember at some point I tried to re-deploy the debug script. It said something about an up-to-date version already being deployed and whether I wanted to overwrite it or not. I decided to (no particular reason, but I did anyway) and that's when it happened the first time.

Posted: Wed 06 Feb 2008 13:49
by Elias
mammut_02, we're glad that you succeed to redeploy debug engine! We'll continue discovering the problem.

Percy, thanks for reply, actually MyDeveloper 2.x script parser doesn't support DELIMITER in the debug engine script is divided by semicolon. We are still discovering the problem, BTW, DELIMITER and SOURCE commands will be supported in future version.