On Wed, 2017-05-03 at 06:52 -0400, Rob Landry wrote: > What do you mean by 'searching the library'? With what tool (rdairplay? > rdlibrary? mysql?)?
using rdlibrary, and entering 'MUSIC' in the form element labeled 'Filter:' I tried your procedure set out below. No joy. I get the same errors when I try to use rdlibrary. Some additional information, when I try to run the query from a terminal, I see the error message "QSqlQuery::value: not positioned on a valid record" five times, the number of letters in 'MUSIC', as it does a search for each letter entered. JE > > It sounds like you have a database format problem. > > Try this: > > 1) stop the Rivendell daemons; > > 2) drop database Rivendell; > > 3) create database Rivendell; > > 4) use Mysql to restore the Rivendell database from the backup you > made from rivendell-2.2.1; > > 5) run rdadmin > > rdadmin should detect the old format database and automatically update it > for 2.15.3. > > > Rob > > -- > Я там, где ребята толковые, > Я там, где плакаты "Вперёд", > Где песни рабочие новые > Страна трудовая поёт. > > On Tue, 2 May 2017, John Edstrom wrote: > > > I'm (finally) upgrading our old Rivendell to a newer version and am > > having problems with the SQL. > > > > We're going from RD 2.2.1 -> 2.15.3 > > mysql 14.14 dist 5.5.29 -> 14.14 dist 5.5.55... -- John Edstrom <[email protected]> Firebare _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
