1282 SQL Error on Add/Rescan [#6122]

Beta Testing for Windows Products and plugins

Moderator: Gurus

UksusoFF
Posts: 77
Joined: Sat Oct 31, 2009 10:04 am
Location: Russia
Contact:

1282 SQL Error on Add/Rescan [#6122]

Post by UksusoFF »

Hello! Can Anybody help me fix this problem?

Image

Image
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: SQL Error

Post by Owyn »

What were you doing when the error occurred?
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
UksusoFF
Posts: 77
Joined: Sat Oct 31, 2009 10:04 am
Location: Russia
Contact:

Re: SQL Error

Post by UksusoFF »

Owyn wrote:What were you doing when the error occurred?
"add\rescan tracks to the library"

It happens at the same mp3 files which name or tag contains "ъ" and "ь" symbols.

Sorry for my bad English :(.
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: SQL Error

Post by Owyn »

I assume you are running MM.1261.
Could you re-test with the latest beta. There have been some changes to add/rescan since 1261.
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
UksusoFF
Posts: 77
Joined: Sat Oct 31, 2009 10:04 am
Location: Russia
Contact:

Re: SQL Error

Post by UksusoFF »

Owyn wrote:I assume you are running MM.1261.
Could you re-test with the latest beta. There have been some changes to add/rescan since 1261.
Yes, first library update in 1261, but I already try 3.1.2.1282 RC-2...
need clean library Before rescan it?
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: 1282 SQL Error on Add/Rescan

Post by Owyn »

Ok. Moved to beta forum for action.
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
UksusoFF
Posts: 77
Joined: Sat Oct 31, 2009 10:04 am
Location: Russia
Contact:

Re: 1282 SQL Error on Add/Rescan

Post by UksusoFF »

Owyn wrote:Ok. Moved to beta forum for action.
Before i use Windows XP and everything worked in all version up to 1261 include...

Now i use Windows 7 x64.
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: 1282 SQL Error on Add/Rescan

Post by Owyn »

UksusoFF wrote:
Owyn wrote:Ok. Moved to beta forum for action.
Before i use Windows XP and everything worked in all version up to 1261 include...

Now i use Windows 7 x64.
Thanks, that will help to isolate problem.
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
UksusoFF
Posts: 77
Joined: Sat Oct 31, 2009 10:04 am
Location: Russia
Contact:

Re: 1282 SQL Error on Add/Rescan

Post by UksusoFF »

Owyn wrote:Thanks, that will help to isolate problem.
maybe need send mp3 to you?
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: 1282 SQL Error on Add/Rescan

Post by Owyn »

Thanks. If you could upload an mp3 and PM me with a link I will test it on Vista.
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
UksusoFF
Posts: 77
Joined: Sat Oct 31, 2009 10:04 am
Location: Russia
Contact:

Re: 1282 SQL Error on Add/Rescan

Post by UksusoFF »

Owyn wrote:Thanks. If you could upload an mp3 and PM me with a link I will test it on Vista.
Ok. Look at PM =)
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: 1282 SQL Error on Add/Rescan

Post by Owyn »

Error reproduced on Vista.

Code: Select all

00000546	157.36012268	[288] -------------------------------------------------------- 
00000547	157.36012268	[288] New exception: 
00000548	157.36012268	[288] Exception code: 2460516 
00000549	157.36012268	[288] Exception flags: 1677721600 
00000550	157.36012268	[288] Number of parameters: 1360477 
00000551	157.36012268	[288] (no debug info) Find error: E58B0000 
00000552	157.36012268	[288]  
00000553	157.40101624	[288] Forms: Accepted WM_ACTIVATEAPP +
00000554	157.40126038	[288] Winamp sim - ignoring.
00000555	157.40133667	[288] Winamp sim - ignoring.
00000556	180.08779907	[288] Thread has started 2064
00000557	180.08789063	[288] Thread initialized 2064
00000558	180.13731384	[288] Going to make final callback 2064
00000559	199.36677551	[288] Forms: RestoreTopMost: Level: 1
00000560	199.39155579	[288] Winamp simulation window received messsage 28
00000561	199.40257263	[288] Dialog: There was a problem querying the database: 
00000562	199.40257263	[288]  Error executing SQL statement "INSERT INTO Songs (SongPath, Artist, IdAlbum, Album, AlbumArtist, SongTitle, Genre, Year, IDMedia, SongLength, PlaybackPos, TrackNumber, BitRate, FileLength, Seekable, SamplingFrequency, Stereo,  VBR, BPM, Author, Rating, AudioCDTrack, FileModified, MaxSample, NormalizeTrack, NormalizeAlbum, DateAdded, LastTimePlayed, PlayCounter, Custom1, Custom2, Custom3, Custom4, Custom5, SignType, SignPart1, SignPart2, SignPart3, SignPart4, Copyright, Publisher, Encoder, Lyricist, Conductor, InvolvedPeople, OrigTitle, OrigArtist, OrigLyricist, GroupDesc, SubTitle, ISRC, InitialKey, Language, OrigYear, Tempo, Mood, Occasion, Quality, Lyrics, Comment, DiscNumber, PreGap, PostGap, TotalSamples, GaplessBytes, TrackModified ) VALUES ( ?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?,?,?,?,?, ?,?,?,?,?,?) 
00000563	199.40257263	[288] " : SQL logic error or missing database (1, 21) result: 2
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: 1282 SQL Error on Add/Rescan

Post by Owyn »

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
jiri
Posts: 5430
Joined: Tue Aug 14, 2001 7:00 pm
Location: Czech Republic
Contact:

Re: 1282 SQL Error on Add/Rescan [#6122]

Post by jiri »

Could you please send me the link to the mp3 track or post it here?

Thanks,
Jiri
Owyn
Posts: 2018
Joined: Fri Mar 21, 2008 10:55 am
Location: Canada

Re: 1282 SQL Error on Add/Rescan [#6122]

Post by Owyn »

PM with link on the way
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