I went and looked at the RDAIRPLAY table in the other RD 3.6.5 system (which had been installed using the Paravel script under CentOS 7).

Based on what I found there, I went back to the new system, where the RDAIRPLAY table had no entries.

I executed the following MySQL statement:

INSERT INTO RDAIRPLAY (STATION,INSTANCE) values ("sistrurus",0);

...and now I no longer see the error message when I run rdadmin. rdairplay no longer asks for a password when I try to exit, and values I enter in the rdairplay screen under Manage Hosts now get saved, which they hadn't been.

It sounds like the database restore wasn't perfect. I wonder what other problems there might be that I haven't encountered yet.

This system is going to get tested thoroughly before it gets deployed.

Today's lesson seems to be: don't try to install Rivendell 3.6.5 on a Dell Inspiron 3910. My client gave me three of these things, and it's been tough sledding.


Rob

--
Не думай что всё пропели,
Что бури все отгремели;
Готовься к великой цели,
А слава тебя найдёт.


On Sat, 18 Jun 2022, Rob Landry wrote:


invalid SQL or failed DB connection[Field 'INSTANCE' doesn't have a default value QMYSQL: Unable to execute query]: insert into `RDAIRPLAY` set STATION="sistrurus"

This is on an RD 3.6.5 system compiled from source under Rocky Linux 8, usig a database restored from a backup from another RD 3.6.5 system.


Rob

--
Не думай что всё пропели,
Что бури все отгремели;
Готовься к великой цели,
А слава тебя найдёт.
_______________________________________________
Rivendell-dev mailing list
[email protected]
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev

Reply via email to