I'm facing the following problem: some of my scenarios got spoiled, i.e. they are no more working and if I try to edit them via pluto admin site I get a mysql error like this
Fatal error: mysql error: [1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 5] in EXECUTE(" SELECT Device.*, Room.Description AS RoomName, DeviceTemplate.Description AS Template FROM Device INNER JOIN DeviceTemplate ON FK_DeviceTemplate=PK_DeviceTemplate LEFT JOIN Room ON FK_Room=PK_Room WHERE PK_Device = ? ") in /var/www/pluto-admin/include/adodb/adodb-errorhandler.inc.php on line 77
My own scenarios are not a big issue, as I can delete them and recreate (well, not a big issue but quite boring ... :roll:).
Regarding default scenarios I cannot delete them, and for some of them (Play Disk, for instance) I cannot even find a proper way to recreate them.
I guess that each scenario is a record (or query) in mysql, and if a scenario got spoiled this means that the related record (or query) got spoiled as well.
Is there any way to fix those issue in a different way than rebuilding scenarios by hand?
Is there any way to re-trigger the creation of some default scenarios?
More generally, is it possible to have a kind of a backup system for mysql tables, in order to be able to restore the last stable and consistent configuration in case something goes wrong?