Database events

[Logan]

Can't seem to figure out the issue with my events. Running standalone MySQL database, switched to dedicated server about 2-3 weeks ago. Getting around the time for maintenance and no one can maintain. No cars being deleted, etc, etc.

 

All are enabled, set to every day, used the same ones on my hosted servers from Vert, no issues. 

 

Only thing I can think causing it would be my definer 

 

http://i.imgur.com/ZEAoI6B.png

 

User (PoTW) has all privileges. 

 

Everything else is working fine, no idea on the issue.

 

EDIT: Posted in wrong section, reported to get a mod to move.

[Defent]

Are you sure you have turned events on? 

Click the main database tab and execute these commands to see:

SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;

[jahangir13]

Is the table name object_data? For me (but using thre linux version) it's Object_DATA and table names are case sensitive.

[Logan]

 

Are you sure you have turned events on? 

Click the main database tab and execute these commands to see:

SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;

 

SET GLOBAL event_scheduler = ON;

SET @@global.event_scheduler = ON;

SET GLOBAL event_scheduler = 1;

SET @@global.event_scheduler = 1;

/* Affected rows: 0  Found rows: 0  Warnings: 0  Duration for 4 queries: 0.000 sec. */

 

How would I check if they are on after running? That's all it showed in the log on Heidi

 

Just check in the options on MySQL Workbench, seems event scheduler was turned off. Just turned it on, hopefully this works, thanks!

Is the table name object_data? For me (but using thre linux version) it's Object_DATA and table names are case sensitive.

 

Yep, first thing I checked.