Page 1 of 1
database schema has changed [#14157]
Posted: Wed Mar 22, 2017 2:34 pm
by Marquis
I missed a few betas, and installed this latest version (March 21 2017) build 1831
I get an error stating:
There was a problem querying the database:
Error executing SQL statement "DROP TABLE IF EXISTS _TempPlaylistContent_392_Th_2068": database schema has changed (6,6)
I can't seem to get around this and only way is to kill the process.
Is my database corrupt now?
Re: Build 1831 : database schema has changed
Posted: Wed Mar 22, 2017 4:05 pm
by Peke
Hi,
What third party plugin you use?
Re: Build 1831 : database schema has changed
Posted: Wed Mar 22, 2017 5:13 pm
by Guest
I had a script installed : Tagging inconsistencies (4.0.1.128)
That's it
Re: Build 1831 : database schema has changed
Posted: Sat Mar 25, 2017 7:07 pm
by Peke
Hmm, not sure if that plugin directly access DB but to be sure please open support ticket and supply us with compressed MM.DB for analyze?
Re: Build 1831 : database schema has changed
Posted: Tue Mar 28, 2017 11:33 am
by Ludek
These temp tables are native, MMW use them starting from 4.1.15 for the auto-playlists referencing further playlists in order to get around possible complex SQL.
Could you share your DB? The DB schema hasn't changed so I don't see a reason for the error.
But I read somewhere that VACUUM could cause this somehow indirectly.
Did you try Maintain Database > Optimize Database (Quick) ?
Re: database schema has changed [#14157]
Posted: Fri Mar 31, 2017 8:05 pm
by Peke
The bug reported here is fixed in our latest beta release and will be included in our next stable build.
Re: database schema has changed [#14157]
Posted: Sat Apr 01, 2017 7:30 pm
by Guest
I tried the latest version, sadly changes nothing for me.
I posted a reply in the ticket
Re: database schema has changed [#14157]
Posted: Sun Apr 02, 2017 4:10 pm
by Lowlander
The new version was posted after you wrote this post:
http://www.mediamonkey.com/forum/viewto ... 06#p434506