CREATE TRIGGER lighting_schedule_ins AFTER INSERT ON`lighting_schedule` FOR EACH ROW UPDATE lighting SET NEW.lastupdated=Now() WHERE index=1; ... (one statement, so delims aren't needed), but the logic looks fishy---there's no evident relationship between between the Insert and an``index...
Auto Play isn't working on my player, why?If you have enabled Auto Play in your HTML Player settings then the player will attempt to automatically start your stream when someone visits your web page. However, many browsers now block audio from auto playing on websites so you shouldn't rel...
Re: Why isn't this working? 494 John Frank April 14, 2021 04:06PM Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent...
Re: Why isn't this working? Posted by:Peter Brawley Date: April 14, 2021 09:54AM My mistake, I misread the code. "Timestamp" is a `Lighting Schedule` column? Or are you trying to set `Lighting`.`Last Updated` to the current time? In that case you need Current_Timestamp or Now...