On Wed, Apr 1, 2015 at 7:02 PM, Dan Gruner <d...@loudaudio.co.uk> wrote:
> I have several Rivendell systems here, including networked systems and > stand-alone versions. All are running pretty much identical hardware and > Debian Wheezy OS with Rivendell version 2.10.3 > > I've just discovered that one of the stand-alone systems (used as a > backup/silence detector machine) refuses to update grid entries past > Thursday 12:00. From digging around, I understand this is a problem to do > with MySQL 5.5 (something to do with limit of row size capacity in newer > MySQL)? What is strange is it is only this system - all the others are > fine. > > I've tried updating things and creating a new Service etc. How can I get > this problem sorted and why has it happened this time? > I can't answer for sure, but you may find that: ALTER TABLE `SERVICES` ENGINE=MyISAM; if you change the SERVICES table to use MyISAM then things will work ok. Make your backup before trying this. IIRC, I have been told on the lists that this should not be necessary any longer, but it sometimes happens to me and this fixes things up for me. > > Many thanks, > > -- > Dan Gruner > Director > > Loud Audio > > Tel office: 01963 406102 > 24hr mobile: 07590 044386 > > <http://www.loudaudio.co.uk> all the best, drew -- http://nakedghosts.blogspot.com/
_______________________________________________ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev