SQL-Viewer 2.4 [Script] 2009-10-25

[Mizery_Made]

Alrighty, Bex. Much appreciation for you taking the time to tackle this issue. Just wanted to make sure MM wouldn't decide to blow up one of these days as a result of these changes.

[Bex]

No problem, Thanks!

[Bex]

Yes, I forgot to add WHERE IDListType=1 in the UPDATE statement. I'll add it later. The all sorted together thing isn't an issue since it doesn't matter what nr the sortorder starts with or if it's in exact sequence or not. It's only the "order" that is important.

I made this a bit smarter by adding WHERE ID IN (SELECT ListID FROM tmpSortClass) instead..

[mooks]

I love you guys! thanks for this.

[Bex]

Thanks!

[djkor]

epic plug-in, really helped me to move library from remote networked drive to local hdd preserving ratings and playcounts. thanks.

[Bex]

Thanks, glad you found it useful!

[Owyn]

I have been getting the following error in recent betas when running the viewer for the second time.


May be related to running other scripts (see signature) in same session.
i.e. Sometimes I can run it again (I think).

Need to exit and restart MM to get it to work.

Edit: Confirmed that I could re-run the viewer multiple times immediately after re-start of MM. Problem may be caused by interaction with other script (ADFF, Backups are at the top of my list for conflicts. More after testing scenarios.)

[nynaevelan]

It's working for me using SQL Viewer, ADFF and Export to iTunes during the same session.

Nyn

[Owyn]

It's working for me using SQL Viewer, ADFF and Export to iTunes during the same session.

Nyn

Yeah. Exact cause of problem is uncertain. I don't always see the error, but, once it occurs it is consistent until MM restarted. I am running Debug View full time at the moment so I may also have info in the log to trace the error. Unfortunately I had just re-started Debug View to reset the log file before I thought of checking it for more info.

Merging this testing with the "sqlite_sequence" problem tests.

Psigh.

[nynaevelan]

It's working for me using SQL Viewer, ADFF and Export to iTunes during the same session.

Nyn

Yeah. Exact cause of problem is uncertain. I don't always see the error, but, once it occurs it is consistent until MM restarted. I am running Debug View full time at the moment so I may also have info in the log to trace the error. Unfortunately I had just re-started Debug View to reset the log file before I thought of checking it for more info.

Merging this testing with the "sqlite_sequence" problem tests.

Psigh.

A tester's job is never finished!!

[Bex]

Yes, I've seen that error as well occasionally but I haven't investigated the reason for it yet. As a simple workaround for now you can install my scriptreloader script and reload SQL-Viewer when it happens.

[Owyn]

Thanks. Installed Scriptreloader.

[Owyn]

Reproduced error.

Ctrl-F9: Viewer dialog working.
Library->Files to Edit->Advanced Duplicate Find & Fix->Custom Duplicate Search(Artist, Title, Track Nodes)
Selected first track node.

Ctrl-F9: Error message.

Ran Scriptreloader->Sqlviewer.vbs.

Ctrl-F9: Still get error message.

[Owyn]

Got this again after running File->Maintain Libary.

Debug log snippet follows:

Code: Select all

00000379	2010.72253418	[3200] 3136 DB exec SQL: CREATE TABLE If NOT EXISTS TmpSqlHist (tmpIDnr INTEGER PRIMARY KEY, tmpRows INTEGER, tmpTime TEXT, tmpHtml TEXT, tmpSql TEXT) 
00000380	2010.72290039	[3200] 3136 DB lock successful.
00000381	2010.72314453	[3200] 3136 DB lock finished, took 3581.
00000382	2010.72314453	[3200] 3136 DB exec SQL: CREATE TABLE If NOT EXISTS TmpSqlSaves (tmpIDnr INTEGER PRIMARY KEY, tmpName TEXT, tmpRows INTEGER, tmpTime TEXT, tmpHtml TEXT, tmpSql TEXT) 
00000383	2010.72338867	[3200] 3136 DB lock successful.
00000384	2010.72338867	[3200] 3136 DB lock finished, took 2746.
00000385	2010.74487305	[3200] 3136 DB open SQL: SELECT SQLITE_VERSION(*) FROM (SELECT 1) 
00000386	2010.74511719	[3200] 3136 DB lock finished, took 4956.
00000387	2010.78173828	[3200] Going to make final callback 6000
00000388	2010.78527832	[3200] Thread has finished 6000
00000389	2010.80725098	[3200] -------------------------------------------------------- 
00000390	2010.80725098	[3200] New exception: 
00000391	2010.80725098	[3200] Exception code: 2460516 
00000392	2010.80725098	[3200] Exception flags: 1677721600 
00000393	2010.80725098	[3200] Number of parameters: 1360477 
00000394	2010.80725098	[3200] (no debug info) Find error: E58B0000 
00000395	2010.80725098	[3200]  
00000396	2010.83654785	[3200] Forms: NormalizeTopMosts: Level: 0
00000397	2010.83666992	[3200] Forms: NormalizeTopMost: Starting
00000398	2018.25622559	[3200] Forms: RestoreTopMost: Level: 1
00000399	2018.25646973	[3200] Forms: RestoreTopMost: Starting
00000400	2018.26660156	[3200] Dialog: Error happened during script execution: 
00000401	2018.26660156	[3200] This key is already associated with an element of this collection result: 1