Hi,

After much haxory I managed to get campcaster installed on Debian Lenny, however now I have an issue when trying to import MP3s.
Both using copy mode and link mode.

I get the following error when using ./campcaster-import -l $filename
(note this is just an excerpt, there's heaps of this output.)
(also, psql ver is 8.3.6-1)


========================
Campcaster Import Script
========================
Importing: [00001] blah.mp3
array(15) {
[0]=>
array(2) {
["function"]=>
string(25) "camp_import_error_handler"
["args"]=>
array(1) {
[0]=>
object(DB_Error)#9 ( {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(16)
["level"]=>
int(1024)
["code"]=>
int(-1)
["message"]=>
string(23) "DB Error: unknown error"
["userinfo"]=>
string(576) "
SELECT parmd.predns as parns, parmd.predicate as parname,
md.predxml, md.predns as chns, md.predicate as chname
FROM ls_mdata parmd
INNER JOIN ls_mdata md
ON parmd.id=md.subject AND md.subjns='_I'
WHERE md.id=59 [nativecode=ERROR: operator does not exist: integer = character varying
LINE 6: ON parmd.id=md.subject AND md.subjns='_I'
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.]"

["backtrace"]=>
array(13) {
[0]=>
array(7) {
["file"]=>
string(27) "/campcaster/lib/pear/DB.php"
["line"]=>
int(966)
["function"]=>
string(10) "PEAR_Error"
["class"]=>
string(10) "PEAR_Error"
["object"]=>
object(DB_Error)#9 ( {
["error_message_prefix"]=>
string(0) ""
["mode"]=>
int(16)
["level"]=>
int(1024)
["code"]=>
int(-1)
["message"]=>
string(23) "DB Error: unknown error"
["userinfo"]=>
string(576) "
SELECT parmd.predns as parns, parmd.predicate as parname,
md.predxml, md.predns as chns, md.predicate as chname
FROM ls_mdata parmd
INNER JOIN ls_mdata md
ON parmd.id=md.subject AND md.subjns='_I'
WHERE md.id=59 [nativecode=ERROR: operator does not exist: integer = character varying
LINE 6: ON parmd.id=md.subject AND md.subjns='_I'
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.]"




This does insert an entry into the ls_files table in the database, but the file just shows up in the Media Library as "Empty File" with 0.00 playtime.

Interesting enough, if I then click that empty file and click "listen" the resulting .m3u file actually streams the MP3 correctly.