You are here: Home » Reply

Reply To: Help Pls! Can’t get music added to database

#8446

jw2k_fr
Participant

🙂 No, they’re not truncated that’s just the way the lines are truncated from my terminal session. The files are in folders owned by nobody and nogroup

The files themselves also are owned by nobody and nogroup and I have run chmod -R a+rwx * from the root of my media tree. Still doesn’t want to list the files.

It is possible that I’ve something weird going on with usbmount, but it doesn’t catalogue anything in the other media directory I have which is not on an external USB drive. The log entries from the init of the database have slightly strange wording which might indicate an error (a dollar sign indicates a truncated line from terminal session):

2007-01-17 08:41:45 (00004000): Executing: select value from config where term=$2007-01-17 08:41:45 (00004000): Results: 0
2007-01-17 08:41:45 (00004000): Initializing database
2007-01-17 08:41:45 (00004000): Executing: select count(*) FROM songs
2007-01-17 08:41:45 (00004000): Executing: select value from config where term=$2007-01-17 08:41:45 (00004000): Full reload…
2007-01-17 08:41:45 (00004000): Executing: drop index idx_path
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop index idx_songid
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop index idx_playlistid
2007-01-17 08:41:45 (00004000): Rows: 0
22007-01-17 08:41:45 (00004000): Executing: drop index idx_playlistid
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop table songs
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: delete from playlists where not type$2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop table playlistitems
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: drop table config
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: vacuum
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: create table songs (
id INTEGER PRIMARY KEY NOT NULL,
path VARCHAR(4096) NOT NULL,
fname VARCHAR(255) NOT NULL,
title VARCHAR(1024) DEFAULT NULL,
artist VARCHAR(1024) DEFAULT NULL,
album VARCHAR(1024) DEFAULT NULL,
genre VARCHAR(255) DEFAULT NULL,
album VARCHAR(1024) DEFAULT NULL,
genre VARCHAR(255) DEFAULT NULL,
comment VARCHAR(4096) DEFAULT NULL,
type VARCHAR(255) DEFAULT NULL,
composer VARCHAR(1024) DEFAULT NULL,
orchestra VARCHAR(1024) DEFAULT NULL,
conductor VARCHAR(1024) DEFAULT NULL,
grouping VARCHAR(1024) DEFAULT NULL,
url VARCHAR(1024) DEFAULT NULL,
bitrate INTEGER DEFAULT 0,
samplerate INTEGER DEFAULT 0,
song_length INTEGER DEFAULT 0,
file_size INTEGER DEFAULT 0,
year INTEGER DEFAULT 0,
track INTEGER DEFAULT 0,
total_tracks INTEGER DEFAULT 0,
disc INTEGER DEFAULT 0,
total_discs INTEGER DEFAULT 0,
bpm INTEGER DEFAULT 0,
compilation INTEGER DEFAULT 0,
bpm INTEGER DEFAULT 0,
compilation INTEGER DEFAULT 0,
rating INTEGER DEFAULT 0,
play_count INTEGER DEFAULT 0,
data_kind INTEGER DEFAULT 0,
item_kind INTEGER DEFAULT 0,
description INTEGER DEFAULT 0,
time_added INTEGER DEFAULT 0,
time_modified INTEGER DEFAULT 0,
time_played INTEGER DEFAULT 0,
db_timestamp INTEGER DEFAULT 0,
disabled INTEGER DEFAULT 0,
sample_count INTEGER DEFAULT 0,
force_update INTEGER DEFAULT 0,
codectype VARCHAR(5) DEFAULT NULL,
idx INTEGER NOT NULL,
has_video INTEGER DEFAULT 0,
contentrating INTEGER DEFAULT 0,
bits_per_sample INTEGER DEFAULT 0,
album_artist VARCHAR(1024)
bits_per_sample INTEGER DEFAULT 0,
album_artist VARCHAR(1024)
);
create table playlistitems (
id INTEGER PRIMARY KEY NOT NULL,
playlistid INTEGER NOT NULL,
songid INTEGER NOT NULL
);
create table config (
term VARCHAR(255) NOT NULL,
subterm VARCHAR(255) DEFAULT NULL,
value VARCHAR(1024) NOT NULL
);
insert into config values (‘version’,”,’13’);

2007-01-17 08:41:45 (00004000): Rows: 1
2007-01-17 08:41:45 (00004000): Executing: create table playlists (
id INTEGER PRIMARY KEY NOT NULL,
title VARCHAR(255) NOT NULL,
type INTEGER NOT NULL,
title VARCHAR(255) NOT NULL,
type INTEGER NOT NULL,
items INTEGER NOT NULL,
query VARCHAR(1024),
db_timestamp INTEGER NOT NULL,
path VARCHAR(4096),
idx INTEGER NOT NULL
);
insert into playlists values (1,’Library’,1,0,’1′,0,”,0);

2007-01-17 08:41:45 (00004000): Query: create table playlists (
id INTEGER PRIMARY KEY NOT NULL,
title VARCHAR(255) NOT NULL,
type INTEGER NOT NULL,
items INTEGER NOT NULL,
query VARCHAR(1024),
db_timestamp INTEGER NOT NULL,
path VARCHAR(4096),
idx INTEGER NOT NULL
);
idx INTEGER NOT NULL
);
insert into playlists values (1,’Library’,1,0,’1′,0,”,0);

2007-01-17 08:41:45 (00004000): Error: table playlists already exists
2007-01-17 08:41:45 (00004000): Starting mp3 scan
2007-01-17 08:41:45 (00004000): Starting scan_init
2007-01-17 08:41:45 (00004000): Starting db scan
2007-01-17 08:41:45 (00004000): Executing: pragma synchronous = off
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Executing: begin transaction
2007-01-17 08:41:45 (00004000): Rows: 0
2007-01-17 08:41:45 (00004000): Scanning for MP3s in /mnt/music
2007-01-17 08:41:45 (00004000): Found /mnt/music/AC-DC
2007-01-17 08:41:45 (00004000): Found AC-DC.. recursing
2007-01-17 08:41:45 (00004000): Found /mnt/music/AC-DC/Live
2007-01-17 08:41:45 (00004000): Found Live.. recursing
2007-01-17 08:41:45 (00004000): Found /mnt/music/AC-DC/Live/01. Thunderstruck.f$2007-01-17 08:41:45 (00004000): Found /mnt/music/AC-DC/Live/02. Shoot To Thrill$

And thus continues the scan of flac files found in both media directories (i have flac as a file format to transcode)

Any further ideas?
Thx