Event-Editor bug on timing end date "no end date"

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
MarkBrock
Posts: 33
Joined: Fri 12 Dec 2008 12:31

Event-Editor bug on timing end date "no end date"

Post by MarkBrock » Fri 12 Dec 2008 12:43

In the new version 3.10.205 there is a bug in the event editor, when selecting "no end date" in the timing tab.
The SQL Statement is displayed and executed as follows:
...
ON SCHEDULE EVERY '1' MONTH
STARTS '2009-01-01 00:00:00'
ENDS CURRENT_TIMESTAMP
ON COMPLETION PRESERVE
DO
...
This cause an error "ENDS is either invalid or before STARTS"
I think the ends clause must be removed in the SQL when selecting no end date.

Alexz
Devart Team
Posts: 165
Joined: Wed 10 Aug 2005 08:30

Post by Alexz » Fri 12 Dec 2008 15:04

We'll work over this problem. The fix will be available in the next build of dbForge for MySQL.

MarkBrock
Posts: 33
Joined: Fri 12 Dec 2008 12:31

Post by MarkBrock » Fri 12 Dec 2008 15:14

thx

Post Reply