I'm guessing that what has happened is that the old MySQL features of LMS have been removed, leaving only support for sqlite.
No, that's not what happened. But there have been a number of plugins (stock, eg. Fulltext search, as well as 3rd party - eg. Erlands, obviously) which registered custom functions to SQLite. These caused some problems interfering with each other, potentially overwriting or un-registering those functions. Back in December I added a well defined way to handle these registrations. Unfortunately this change is not compatible with Erland's way to handle this feature.
This is the change in question: https://github.com/Logitech/slimserver/commit/58b361a26dc5867ca312cf6565dca3392d15dbcf
have several functions that were in MySQL, such as concat, so errors are being generated.
SQLite does have concat, but it's handled differently. We've had some custom code in place to handle this difference for years, but Erland's plugins don't use it. They add their own solution instead.
Erland has said that he's looking at this, so for those of us using newer versions of LMS 7.9 we need to wait a while for the changes to be made to be compatible.
I'm not familiar with Erland's plugins. But if you have access to the underlying SQL code, you might work around this limitation by modifiyng the SQL queries.
See eg. http://stackoverflow.com/questions/6134415/how-to-concatenate-strings-with-padding-in-sqlite for an example how to concatenate in SQLite.
I'm currently on vacation. But I might review this change in a week or two. If I find time.
-- Michael _______________________________________________ plugins mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/plugins
