DB update issue

[hooligan]

I updated my version to r31534 from r31508 yesterday...

I got this:

12:29:31 M: 41938944 NOTICE: CApplication::UpdateLibraries - Starting video library startup scan
12:29:31 M: 41828352 NOTICE: Attempting to update the database MyVideos34.db from version 38 to 42
12:29:31 M: 41828352 ERROR: SQLite: SQL error or missing database
Query: CREATE VIEW movieview AS SELECT movie.*, files.strFileName AS strFileName, path.strPath AS strPath, files.playCount AS playCount, files.lastPlayed AS lastPlayed FROM movie JOIN files ON files.idFile=movie.idFile JOIN path ON path.idPath=files.idPath

No problems, I thought. Renamed the DB and restarted. Black screen with no FTP. Restarted again in an alternate dashboard and found the DB was created but was 0 size. Next I renamed my original install, created a new folder and copied the r31534 in fresh, restarted, got a black screen with no FTP and again found the DB recreated with file size of 0. Below is from the log:

13:11:35 M: 46022656 NOTICE: CApplication::UpdateLibraries - Starting video library startup scan
13:11:35 M: 45854720 ERROR: SQLite: SQL error or missing database
Query: DROP VIEW episodeview
13:11:35 M: 45834240 ERROR: CVideoDatabase::CreateTables unable to create tables:0
13:11:35 M: 45993984 ERROR: SQLite: SQL error or missing database
Query: SELECT idVersion FROM version
13:11:35 M: 45993984 FATAL: Unknown exception code (0xe06d7363)
at 0x00321554

Restarted back into the alternate dashboard. I renamed the original install and DB back to original and then copied 3.2 stable over top. Everything worked. I then put the nightly build I had previously used, r31508, over top again and it still worked. I retried r31534 again with the same result and, because it was there while I was poking about, I tried r31539 with the same results as above.

So.. I am sitting at r31508 with no idea whats wrong? Why can't I just delete the DB (and thumbs) and start from scratch again? I know the nightly's can be unstable but I understand and can deal with that and, if that's all it is, great but shouldn't I still be able to have no DB's, have it start, and create fresh files?

Anybody have an suggestions?

Thanx in advance...

[BuZz]

I updated my version to r31534 from r31508 yesterday...

Anybody have an suggestions?

Thanx in advance...

you are running development builds. the most recent containing some changes that haven't been tested completely.

nightly builds should not be run unless you are willing to partake in the dev process. having said that, by running it, you have helped me to know one of the issues with the new sql view cosmetic changes

[hooligan]

Thanx for the help... I know they're "dev" builds. I was mostly wondering why I couldn't start fresh... I was thinking that maybe I'd missed something somewhere/sometime regarding doing a DB refresh or new install... Its been probably 2-3 years since doing that...

Thanx again and I appreciate the work that goes into this...

[BuZz]

i'll fix up the issue you and let you know when it's sorted. thanks.

[BuZz]

r31540 which will be available in the nightly builds shortly (currently building) should fix the issue. Appreciate the heads up, and do continue running the nightlies if you are happy for issues like this to be found/fixed every so often.

[spicemuseum]

r31540 which will be available in the nightly builds shortly (currently building) should fix the issue. Appreciate the heads up, and do continue running the nightlies if you are happy for issues like this to be found/fixed every so often.

Confirm, fixes the problem for me.

[hooligan]

Sorry for the delay. just got back to it... yes it's all fixed...

Thanx