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

Download and get help for different MediaMonkey for Windows 4 Addons.

Moderators: Peke, Gurus

Mizery_Made
Posts: 2283
Joined: Tue Aug 29, 2006 1:09 pm
Location: Kansas City, Missouri, United States

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by 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
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by Bex »

No problem, Thanks!
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by Bex »

Bex wrote: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..
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts
mooks

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by mooks »

I love you guys! thanks for this.
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by Bex »

Thanks! :D
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts
djkor
Posts: 8
Joined: Thu May 24, 2007 5:23 am
Contact:

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by djkor »

epic plug-in, really helped me to move library from remote networked drive to local hdd preserving ratings and playcounts. thanks.
~ megalord twat ~
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by Bex »

Thanks, glad you found it useful!
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by Owyn »

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

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.)
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by nynaevelan »

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

Nyn
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by Owyn »

nynaevelan wrote: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.
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
nynaevelan
Posts: 5559
Joined: Wed Feb 07, 2007 11:07 pm
Location: New Jersey, USA
Contact:

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by nynaevelan »

Owyn wrote:
nynaevelan wrote: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.
:lol: :lol: A tester's job is never finished!!
3.2x - Win7 Ultimate (Zen Touch 2 16 GB/Zen 8GB)
Link to Favorite Scripts/Skins

Join Dropbox, the online site to share your files
Bex
Posts: 6316
Joined: Fri May 21, 2004 5:44 am
Location: Sweden

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by 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.
Advanced Duplicate Find & Fix Find More From Same - Custom Search. | Transfer PlayStat & Copy-Paste Tags/AlbumArt between any tracks.
Tagging Inconsistencies Do you think you have your tags in order? Think again...
Play History & Stats Node Like having your Last-FM account stored locally, but more advanced.
Case & Leading Zero Fixer Works on filenames too!

All My Scripts
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by Owyn »

Thanks. Installed Scriptreloader.
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by 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.
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: SQL-Viewer 2.3 [Script] 2008-05-15 [MM3]

Post by 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
Cogito cogito ergo cogito sum. (Ambrose Bierce)
I drink therefore I am. (Monty Python)
Vista 32bit Home Premium SP2 / MM3.2.1.1297 Gold / Last.Fm 1.0.2.22 / IE8
Dell Inspiron 530 (1.8 Core2 / 2GB)
Skin: Vitreous Blue
Scripts: Add/Remove Playstat|Advanced Duplicate Find & Fix|Album Art Tagger|Backup|Batch Art Finder|Calculate Cover Size|Case&Leading Zero Fixer|DB_Audit|DB_Clean|DB_Schema|Event Logger|Genre Finder|Lyricator|Magic Nodes|MM2VLC|Monkey Rok|MusicIP Tagger|PUID Generator|RegExp Find & Replace|Right Click for Scripts|Scriptreloader|SQL Viewer|Stats(Filtered)|Tagging Inconsistencies
Post Reply