So when I tried inserting the .sql file into the database it said that I dont have permissions to create events.
Could we get full error message?
CREATE [email protected] EVENT reset_hours ON SCHEDULE EVERY 1 MONTH STARTS '2021-07-01 23:30:00' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE users SET hours_month = '0';
MySQL said: Documentation
#1227 - Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation
Understood. Ill forward this. In the meantime could you let me know where is this being used ? In game hosting ?
Why is it using schedules ? Instead of executing query from the code ?
I dont know the GM has been given by a friend.
For now I recommend using Linux VPS(https://lemehost.com/hosting/34/linux+vps) with mysql(https://lemehost.com/forum/topic/1796/install+mysq...)
Or edit GM and execute that query from GM