#26 Loading folder-organized multi-disc directories fails

open
nobody
Database (3)
5
2012-10-17
2005-08-05
No

When scanning library, discs in a series and or set
labeled as:

Album Series - Disc. 1
Album Series - Disc. 2
Album Series - Disc. 3

fails to load more than one of these directories,
appears that either the dash or the period is causing
issues, not sure so thought I'd post my output:


Preparing to scan MP3 locations: Network Music Share
....................................................................................................................................................................
Scanning 808 directories in the library
........................................................................................................................................................................................................
........................................................................................................................................................................................................
........................................................................................................................................................................................................
........................................................................................................................................................................................................
......................
Invalid SQL: INSERT INTO mp3data
(artist,title,genre,album,comment,year,sec,layer,samplerate,channel,bitrate,track,mpeg,size,lastmod,filename,tag,verified,loc_id,added,available,owner)
VALUES ('Dwight Yoakam','Hey Little
Girl','Country','Reprise Please Baby: The Warner Bros.
Years Disc 2',' 00001D2A 00001D2A
0001154E',2002,200.41145833333,'Layer
III',44100,'Stereo',192,5,'MPEG
1',4812192,1091923538,'/library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/05
Hey Little Girl.mp3',1,1,3,1123213399,1,'james')
Class: rimpsDB
MySQL Error:Duplicate entry '/library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Gir...' for key 2 (1062)
PHP_SELF=/rimps/rescan.php
REMOTE_ADDR=127.0.0.1
HTTP_USER_AGENT=Mozilla/5.0 (X11; U; Linux i686; en-US;
rv:1.7.8) Gecko/20050513 Fedora/1.0.4-1.3.1 Firefox/1.0.4

Database error: Invalid SQL: INSERT INTO mp3data
(artist,title,genre,album,comment,year,sec,layer,samplerate,channel,bitrate,track,mpeg,size,lastmod,filename,tag,verified,loc_id,added,available,owner)
VALUES ('Dwight Yoakam','Hey Little
Girl','Country','Reprise Please Baby: The Warner Bros.
Years Disc 2',' 00001D2A 00001D2A
0001154E',2002,200.41145833333,'Layer
III',44100,'Stereo',192,5,'MPEG
1',4812192,1091923538,'/library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/05
Hey Little Girl.mp3',1,1,3,1123213399,1,'james')

MySQL Error: 1062 (Duplicate entry
'/library/music/Dwight Yoakam/Reprise Please Baby- The
Warner Bros. Years Disc 2/05 Hey Little Girl. Years
Disc 2/19 Train in Vain. Years Disc 2/05 Hey Little
Gir...' for key 2)


Note: These albums were loaded by another application
that used this directory structure which is still in
use on another workstation. I only recently started
looking at RIMPS, liking it so far, keep up the great
work. Doubtful that I could fix this error, I thought
it best to report it here. The data in the database
looks like it's reading the periods as a seperation in
directories, when deleting the orphaned node after
moving the file, here is the data it said it deleted:


Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/05
Hey Little Girl
Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/02
Carmelita (2).m
Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/03
Suspicious Mind
Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/18
Baby Don't Go.m
Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/15
Sorry You Asked
Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/20
Rapid City, Sou
Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/02
Carmelita.mp3
Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/04
Doin' What I Di
Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/07
A Thousand Mile
Deleted from database: /library/music/Dwight
Yoakam/Reprise Please Baby- The Warner Bros. Years Disc
2/05 Hey Little Girl. Years Disc 2/19 Train in Vain.
Years Disc 2/05 Hey Little Girl. Years Disc 2/05 Hey
Little Girl. Years Disc 2/02 Carmelita. Years Disc 2/01
Fast as You.mp3


Anyway, no biggie, I moved and renamed the files and
disabled the automatic rename on the other application
so it's a workaround for now, but thought I would pass
it along.

Discussion


Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks