Hi,

This is a known issue. Rivendell expects the database to be MyISAM and not InnoDB. From around MySQL 5.5 the default changed from MyISAM to InnoDB. InnoDB is better with not losing data in rare circumstances and is supposedly faster at indexing (or something). The down side is that InnoDB imposes a maximum column limit for updates so you can no longer do stuff like: UPDATE blah SET lots and lots of columns = something.

So the work around is to set the SERVICES table back to MyISAM.

Log into mysql with whatever client you prefer and do the following:

ALTER TABLE `SERVICES` ENGINE=MyISAM;

Your changes will now stick.

Regards,

Wayne



On 2015-08-05 18:02, Aaron Savage wrote:
I am going to expand on this after I have looked at the problem some
more.

I found the reason I cannot schedule certain days is because the grids
are not functioning properly.  When I press "Change All" and pick a
clock it will populate all the fields.   I will then clock close and
go back in and only up to Thursday is filled in.  I then manually add
each hour and close again.  When I go back in the grids are not saved
and only go until Thursday.  So at this point I can schedule Monday
through Wednesday.

Not sure where to go from here.  Any suggestions? 

Xubuntu 14.04 Rivendell 2.10.3

Aloha,
Aaron

On Tue, Aug 4, 2015 at 9:48 PM, Aaron Savage
<[email protected] [1]> wrote:

I have two problems am having with Log manager.

I am running Xubuntu with an Audioscience card and all seems well
except for the log manager.  I am using the built in clocks and
scheduling so there is nothing being imported.  Version 2.10.3

1.  If I am using the default Production service the clocks and
grids work as expected but I am unable to schedule beyond four days.

2.  If I used another service that I created to schedule all it
will put in the log is the legal id.  I have checked the services
list and all the log items are listed under each items.

Other that that all is working well.  Just need to get the
scheduling working.

Aaron



Links:
------
[1] mailto:[email protected]

_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Reply via email to