mysql event not querying but is showing that it was exacuted

I have a mysql event not querying but is showing that it was executed. In my process list its showing that is was running.. Any ideas or suggestions on where to look? The server was recently restarted.

I am running mysql 5.1.69 if that helps any.

 

do this and post the output please:

$result = mysql_query("YOUR QUERY HERE");
echo $result;

PHP:

Please replace the YOUR QUERY HERE with your query.

 

I tried that and when I run it in mysql I keep getting error 1064

 

Could you show me the script / commands you are trying to run?

 

All my old events stopped running for some reason I had all of them setup like >>>>run_now<<< without a database first. They all seemed to run fine for months then just stopped running. Even with restarts. I am not sure what changed exactly. Any one have any idea where the logs are located so I may check. what I don't understand is what was the cause form them to just stop running the one day.

DELIMITER //
CREATE EVENT run_now
ON SCHEDULE EVERY 24 HOUR
STARTS '2013-12-12 21:00:00'
DO
BEGIN
UPDATE sometable
SET number=number +1;
END //
DELIMITER

Code (markup):

I added in the database like this below run_now_two and so far it seems be running so far even with restarts.

DELIMITER //
CREATE EVENT run_now_two
ON SCHEDULE EVERY 24 HOUR
STARTS '2013-12-12 21:00:00'
DO
BEGIN
UPDATE `test`.`sometable`
SET number=number +1;
END //
DELIMITER

Code (markup):