On Mar 17, 2018, at 18:57, Cowboy <[email protected]> wrote:
> I believe you're the second person to have found the same bug.
> If you delete the clock BEFORE removing the event from the grid, you can't.
>
> Scheduled to be fixed in the next release.
Fixed in git ‘v2.19’.
In the meantime: to recover from the problem:
1) BACKUP THE DATABASE. (*Don’t* skip this step! We’re going to be modifying DB
tables by hand!)
2) Calculate the number of the button on the Grid. Start with ‘0’ in the upper
left-hand corner and count going left-to-right until you get to the button with
the problem. So, for example, the button for 02-03 on Tuesday would be button
26.
3) Get the name of the Service to which the grid belongs (you can see it on the
titlebar of the Edit Grid dialog). For example, a service called “Production”.
4) Use the MySQL monitor to connect to the database. Enter on a command line:
mysql -A -u rduser -p Rivendell
You’ll be prompted for the MySQL password. Enter it (default ‘letmein’).
5) Enter the following SQL command:
insert into SERVICE_CLOCKS set
SERVICE_NAME=“<service-name>”,HOUR=<hour-number>;
and then press ENTER. Replace <service-name> with the name of the service from
step 3), and <hour-number> from number of the button from step 2). Otherwise,
everything should just be copied exactly as shown, including punctuation. For
our example values, it would be:
insert into SERVICE_CLOCKS set SERVICE_NAME=“Production”,HOUR=26;
6) Exit the MySQL monitor by entering ‘Exit;’, then press ENTER.
You’re done.
Cheers!
|----------------------------------------------------------------------|
| Frederick F. Gleason, Jr. | Chief Developer |
| | Paravel Systems |
|----------------------------------------------------------------------|
| A room without books is like a body without a soul. |
| -- Cicero |
|----------------------------------------------------------------------|
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
