I'm narrowing down the database restore problem a little bit at a time. When I have the search filter set to 'all' in RDLibrary it shows me up to cart 130073. In the RDAirPlay search under filter 'all' it shows up to cart 130083. If I change the search filter to a specific group, it shows me all carts in the group including the ones it won't show in 'all'.
When I re-do backup of this database in 2.8.1 the other carts and cuts are in there so I haven't lost anything. I've just got to figure out what tables or what not are wrong. I'm not sure how to fix the service field not coming up in RDReports though. I just got up so I'll go download some sql GUI's soon and see what I can do. Is there a list of what tables should or should not exist in RD 2.8.1? Or will I have to go back wipe the database and setup a new 2.8.1 and compare that way? ----- Original Message ----- From: Mike Carroll To: User discussion about the Rivendell Radio Automation System Sent: Saturday, April 05, 2014 9:23 AM Subject: Re: [RDD] Appliance not set correctly I use the MySQL Workbench for ad-hoc queries, etc., albeit in a Windows machine. The workbench also allows you to manage MySQL servers (and the Windows version will optionally install a server for you, which is nice if you want to experiment.) On Fri, Apr 4, 2014 at 1:35 PM, Cowboy <[email protected]> wrote: On Friday 04 April 2014 09:19:05 am Gavin Stephens wrote: > > Any recommendations for an sql gui editor? I use three. Webmin is about the easiest for doing a dump/restore. SIDU is a close second, allowing edits to individual entries, or running an SQL query from within. PhpMyAdmin is the third. Only because it can do things like import a spreadsheet, but that's buggy. Can't always count on it. Supposedly, OpenOffice has something, but I haven't looked at that yet. For a generic, all around SQL GUI I'd lean toward SIDU. He's also very responsive as far as support, but he is in China, or some such. -- Cowboy http://cowboy.cwf1.com "Has anyone had problems with the computer accounts?" "Yes, I don't have one." "Okay, you can send mail to one of the tutors ..." -- E. D'Azevedo, Computer Science 372 _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev -- druidlabs.wordpress.com flickr.com/photos/druidlabs/sets ------------------------------------------------------------------------------ _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
