Error deploying debug engine

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
mammut_02
Posts: 2
Joined: Mon 04 Feb 2008 23:15

Error deploying debug engine

Post by mammut_02 » Mon 04 Feb 2008 23:20

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

Elias
Devart Team
Posts: 73
Joined: Tue 29 May 2007 14:02

Re: Error deploying debug engine

Post by Elias » Tue 05 Feb 2008 08:57

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.

mammut_02
Posts: 2
Joined: Mon 04 Feb 2008 23:15

Post by mammut_02 » Tue 05 Feb 2008 16:07

It's ok now. I retried today and it worked ??? Alleluia xp reboot
FYI my version of MyDeveloper Studio is 2.10.78.

Percy
Posts: 1
Joined: Wed 06 Feb 2008 08:51

Same Problem

Post by Percy » Wed 06 Feb 2008 08:53

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.

Elias
Devart Team
Posts: 73
Joined: Tue 29 May 2007 14:02

Post by Elias » Wed 06 Feb 2008 13:49

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.

Post Reply