Announce: New versions of erlands plugins

[erland]

This is a bit over my head Erland but I ran a Free Form Query and get this result, does that tell us anything?

Yes, it says that you have two libraries with id 5 and 6, would be interesting to see if the ids changes if you run it again after you upgrade LMS or does something that trigger the playlist library parameter to be reset.

[PasTim]

Yes, it says that you have two libraries with id 5 and 6, would be interesting to see if the ids changes if you run it again after you upgrade LMS or does something that trigger the playlist library parameter to be reset.

I have, on very rare occasions (I think only when completely resetting LMS), seen the id numbers increase, and rather than rescanning I have changed the ids back to where they were (1 and 2 on my system).

[SlimChances]

I have, on very rare occasions (I think only when completely resetting LMS), seen the id numbers increase, and rather than rescanning I have changed the ids back to where they were (1 and 2 on my system).

Thanks, changing those ids might be easier for me, do I find them somewhere in prefs folder. I looked at server.prefs and multilibrary.prefs but not sure where to make any changes if that is possible


EDIT: In multilibrary.prefs I see references to activelibraryno: 1 and 2, 3,4,5

[SpiderJon]

In my server log, I routinely get the following entries relating to CustomScan:

[21-03-03 14:47:46.8312] Plugins::CustomScan::Scanner::initDatabase (114) CustomScan: Creating database tables
[21-03-03 14:47:46.8336] Plugins::CustomScan::Scanner::initDatabase (119) CustomScan: Upgrading database adding table column valuesort, please wait...
[21-03-03 14:47:46.8342] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn't open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuesort.sql : No such file or directory
[21-03-03 14:47:46.8347] Plugins::CustomScan::Scanner::initDatabase (125) CustomScan: Upgrading database adding table column extravalue, please wait...
[21-03-03 14:47:46.8352] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn't open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_extravalue.sql : No such file or directory
[21-03-03 14:47:46.8357] Plugins::CustomScan::Scanner::initDatabase (131) CustomScan: Upgrading database adding table column valuetype, please wait...
[21-03-03 14:47:46.8361] Plugins::CustomScan::Scanner::executeSQLFile (522) Couldn't open: /var/lib/squeezeboxserver/cache/InstalledPlugins/Plugins/CustomScan/SQL/SQLite/dbupgrade_valuetype.sql : No such file or directory

Two questions:

1. Are they something I should worry/do something about?

2. If they are, what should I do? :-)

[PasTim]

Thanks, changing those ids might be easier for me, do I find them somewhere in prefs folder. I looked at server.prefs and multilibrary.prefs but not sure where to make any changes if that is possible


EDIT: In multilibrary.prefs I see references to activelibraryno: 1 and 2, 3,4,5

I'm afraid not. To change the ids you have to change data in the database, not in the prefs. If you are not familiar with SQL that might take a bit of learning to do. I shut LMS down and use an SQLite tool to change the values in table multilibrary_libraries, but there are several possible pitfalls in that approach, not least other related tables. Erland might have some ideas.

[SlimChances]

I'm afraid not. To change the ids you have to change data in the database, not in the prefs. If you are not familiar with SQL that might take a bit of learning to do. I shut LMS down and use an SQLite tool to change the values in table multilibrary_libraries, but there are several possible pitfalls in that approach, not least other related tables. Erland might have some ideas.

Hmm...It is getting a bit past my skill set so I will just reset the library values as I have in the past

[PasTim]

Hmm...It is getting a bit past my skill set so I will just reset the library values as I have in the past

It is still a mystery why this happens for you. When you do LMS updates do you just install the deb, and do nothing else (not even a rescan)? That's what I've done for years, and hardly ever had a problem.

[SlimChances]

It is still a mystery why this happens for you. When you do LMS updates do you just install the deb, and do nothing else (not even a rescan)? That's what I've done for years, and hardly ever had a problem.

I download the LMS. I stop the server. And then install through gdebi the amd64.deb version. Then restart server. Everything is in order after the upgrade except the multilibrary designations which are often although not always blank on the settings pages. I reset those through SQL Playlist if need be.

EDIT: I just upgraded to the latest LMS 8.2 to see what would happen. All settings including multilibrary settings were retained so there is no way to show the problem occurring right now

[PasTim]

I download the LMS. I stop the server. And then install through gdebi the amd64.deb version. Then restart server. Everything is in order after the upgrade except the multilibrary designations which are often although not always blank on the settings pages. I reset those through SQL Playlist if need be.

EDIT: I just upgraded to the latest LMS 8.2 to see what would happen. All settings including multilibrary settings were retained so there is no way to show the problem occurring right now

I hope the trend continues!

[SlimChances]

Indeed