Event scheduler

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Event scheduler

Postby mldz » 08. January 2009 11:42

Hi,

I recently upgraded to the latest package of xampp.
When I try to make an event, I get the error message: "cannot proceed because system tables used by event scheduler were found damaged at server start"
I tried to repair the table, but I didn't have the right to do so, although I was logged in as root.
I've google for this problem and it seems that others have also experienced this problem, but I was not able to found a solution.
Does anyone have an idea on how the fix this problem?
Kind regards,

Matthijs


------
OK, just minutes after this posting, I found the solution on http://dev.mysql.com/doc/refman/5.1/en/ ... erver.html

1) Upgrade MySql using:

upgrade_mysql --user=root --password=xxx --verbose

and then

2)restart MySql service

I did it and it works. At least i was able to send: set global event_scheduler = on;
and show processlist had a user event_scheduler.
So it seems to be working.
mldz
 
Posts: 12
Joined: 11. December 2007 09:01

Re: Event scheduler

Postby Sharley » 08. January 2009 11:53

mldz wrote:I recently upgraded to the latest package of xampp.

Did you upgrade (not recommended) or did you do a fresh 1.7.0 install?

If you upgraded did you follow the instructions for upgrading in .\xampp\make-upgrade.txt?

After upgrading or doing a fresh install did you run .\xampp\mysql\bin\mysql_upgrade.exe?
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: Event scheduler

Postby mldz » 08. January 2009 12:18

Hi,

yes, i did what I had to do according to the make_upgrade.txt file. But I didn't use mysql_upgrade. After that, it was ok.
regards,

Matthijs
mldz
 
Posts: 12
Joined: 11. December 2007 09:01

Re: Event scheduler

Postby mldz » 08. January 2009 12:40

Got it working. the database needed to be specified in the create event.

---
hi,

there still is a problem.
I just created a test event:

create event myFirstevent
on schedule every 5 second
start timestamp '2009-01-08 12:25:00'
do insert into `test` (`id`,`datetimeID`) values (null,now());

Mysql gave the following error:
Error Code: 1044
Acces denied for user 'root'@'%' to database 'myDB'

Any suggestions?
Kind regards,

Matthijs
mldz
 
Posts: 12
Joined: 11. December 2007 09:01


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 56 guests