Jump to content

darlingss

Members
  • Posts

    5
  • Joined

  • Last visited

darlingss's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. I need to make this... but the option run event is block because im not super user ver evento activo show variables like '%event%'; activar eventos set GLOBAL event_scheduler=ON; EVENTO CREATE EVENT act_reservacion ON hotelescuela EVERY 1 DAY STARTS ‘2016-07-11 12:00:00’ + interval 1 day DO UPDATE habitaciones INNER JOIN DETALLES ON habitaciones.id = detalles.idhabitacion INNER JOIN RESERVACIONES ON reservaciones.id = detalles.idreservacion SET habitacione.status = 0 WHERE reservaciones.fechaPart = now();
  2. Thank you so much!! and sorry i cant connect to my another external datababase and i use your database but i need to RUN EVENTS, HOW? can i run events?
  3. Are correct, I use port 3306 and the IP/nameHost external database, but not fucntion INTERNARL SERVER ERROR 500
  4. Help me please!! I have a database in another host in where i am SUPER USER, i dont use heliohost database because i cant execute EVENTS MYSQL and then i decided use my database in another host where i can EXECUTE EVENTS THE QUESTION!! When i am trying connect to my external database I JUST GET INTERNAR SERVER ERROR 500, the dates of conecction are correct i dont undertand that message !! Please help me
×
×
  • Create New...