Fehler / Fragen Linvdr TT vdr-1.4.5-1 XXV Version: 0.90(1050M)

  • Hallo,


    erstmal vielen dank für das neue XXV läuft supper ....


    Habe jetzt doch noch 2 Fehler entdeckt ....


    Status und Share haben Syntax Fehler ist das nur bei mir so ..


    Habe 2 Fragen Musik / Perl


    1. Frage ... kann man das Musik Modul auch ohne muggle nutzen ...
    Läuft ja leider nicht mehr ... seit libvdr-muggle.so.1.3.24 hier gibt es glaub ich keine Lösung in nächster Zeit ( oder ToxicTonic??)


    Was muss man denn ändern ...


    32 (501) [12:29:07] DBI: DBI->connect(database=GiantDisc;host=localhost;port=3306) failed: Access denied for user 'xxv'@'localhost' to database 'GiantDisc' at /opt/XXV/bin/../lib/XXV/MODULES/MUSIC.pm line 1056
    33 (501) [12:29:07] MUSIC: Access denied for user 'xxv'@'localhost' to database 'GiantDisc'
    34 (250) [12:29:07] MUSIC: No GiantDisc data base. Use standard music data base!
    35 (250) [12:29:20] : Load Module XXV::MODULES::MUSIC = 0.92



    MUSIC: DBD::mysql::st execute failed: Unknown table 'album' in where clause at /opt/XXV/bin/../lib/Tools.pm line 222, <; DATA> line 572.
    MUSIC: Unknown table 'album' in where clause -
    SELECT
    ID as Sv,
    ARTIST as Kuenstler,
    ALBUM as Album,
    TITLE as Titel,
    TRACKNUM as Tracknr,
    YEAR as Jahr,
    IF(SECS >= 3600,SEC_TO_TIME(SECS),DATE_FORMAT(FROM_UNIXTIME(SECS), '0:')) as Dauer,
    GENRE as __GENRE,
    COMMENT as __COMMENT
    FROM
    MUSIC
    WHERE
    ( album.title LIKE '%ÿþA%' )
    AND 0 = 1
    MUSIC: DBD::mysql::db selectall_arrayref failed: Unknown table 'album' in where clause at /opt/XXV/bin/../lib/XXV/MODULES/MUSIC.pm line 637, <; DATA> line 572.


    config :


    [MUSIC]
    Interface=0.0.0.0
    active=y
    clients=5
    coverimages=/pub/mp3/cover
    muggle=DBI:mysql:database=GiantDisc;host=localhost;port=3306
    mugglei=/usr/bin/mugglei
    path=/pub/mp3
    port=7100
    proxy=





    2. Frage das install.sh -p meldet folgende Fehler ...
    Checking for Perl module XML::Stream... MISSING
    Do you want to install XML::Stream? (y)es/(f)orced/(N)ever : f
    Going to read /root/.cpan/sources/authors/01mailrc.txt.gz
    CPAN: Compress::Zlib loaded ok
    Going to read /root/.cpan/sources/modules/02packages.details.txt.gz
    Database was generated on Thu, 15 Feb 2007 06:09:32 GMT
    CPAN: HTTP:: Date loaded ok


    There's a new CPAN.pm version (v1.8802) available!
    [Current version is v1.87]
    You might want to try
    install CPAN
    reload cpan
    without quitting the current session. It should be a seamless upgrade
    while we are running...


    Going to read /root/.cpan/sources/modules/03modlist.data.gz
    XML:: Stream is up to date (1.22).



    1 (250) [21:30:56] :
    ----------------------------
    ---- XXVD System started ---
    ----------------------------
    2 (250) [21:30:56] : Verbose Level is set to 3
    3 (250) [21:30:56] : Use configuration file "/opt/XXV/etc/xxvd.cfg"
    4 (250) [21:30:56] : Schnelle Template Unterstützung ist aktiv!
    5 (250) [21:30:57] main: Successfully connect to database: DBI:mysql:database=xxv;host=localhost;port=3306
    6 (250) [21:30:58] : Load Module XXV::MODULES::WAPD = 0.45
    7 (250) [21:30:58] : Load Module XXV::MODULES::VTX = 0.81
    8 (250) [21:30:58] : Load Module XXV::MODULES::USER = 0.81
    9 (250) [21:30:58] : Load Module XXV::MODULES::TIMERS = 0.92
    10 (250) [21:30:58] : Load Module XXV::MODULES::TELNET = 0.01
    11 (250) [21:30:58] : Load Module XXV::MODULES::SVDRP = 0.91
    12 (250) [21:30:58] : Load Module XXV::MODULES::STREAM = 0.92
    13 (250) [21:30:58] : Load Module XXV::MODULES::STATUS = 0.45
    14 (550) [21:31:03] Expat:
    syntax error at line 1, column 0, byte 0 at /usr/local/lib/perl/5.6.1/XML/Parser.pm line 187
    15 (550) [21:31:03] Parser:
    syntax error at line 1, column 0, byte 0 at /usr/local/lib/perl/5.6.1/XML/Parser.pm line 187
    16 (501) [21:31:03] SHARE: Transport Error: 500 Can't connect to xpix.dyndns.org:81 (connect: timeout)
    17 (501) [21:31:03] SHARE: Can't get user key
    18 (501) [21:31:03] SHARE: Use of uninitialized value in string ne at /opt/XXV/bin/../lib/XXV/MODULES/SHARE.pm line 202.
    19 (501) [21:31:03] SHARE: Response contain wrong answer
    20 (501) [21:31:03] SHARE: Use of uninitialized value in string eq at /opt/XXV/bin/../lib/XXV/MODULES/SHARE.pm line 205.
    21 (250) [21:31:03] main: SOAP Server http://xpix.dyndns.org:81/XXV/Server can not connected!
    22 (250) [21:31:03] main: Deactivate the Share Modul!
    23 (250) [21:31:03] : Load Module XXV::MODULES::SHARE = 0.03
    24 (250) [21:31:03] : Load Module XXV::MODULES::ROBOT = 0.01
    25 (250) [21:31:03] main: Load NEWS Module XXV: UTPUT::NEWS::VDR = 0.01
    26 (250) [21:31:03] main: Load NEWS Module XXV: UTPUT::NEWS::RSS = 0.01
    27 (250) [21:31:04] main: Load NEWS Module XXV: UTPUT::NEWS::MAIL = 0.01
    28 (250) [21:31:04] main: Load NEWS Module XXV: UTPUT::NEWS::JABBER = 0.01
    29 (250) [21:31:04] : Load Module XXV::MODULES::REPORT = 0.01
    30 (250) [21:31:04] : Load Module XXV::MODULES::REMOTE = 0.01
    31 (250) [21:31:04] : Load Module XXV::MODULES::RECORDS = 0.91
    32 (501) [21:31:04] DBI: DBI->connect(database=GiantDisc;host=localhost;port=3306) failed: Access denied for user 'xxv'@'localhost' to database 'GiantDisc' at /opt/XXV/bin/../lib/XXV/MODULES/MUSIC.pm line 1056
    33 (501) [21:31:04] MUSIC: Access denied for user 'xxv'@'localhost' to database 'GiantDisc'
    34 (250) [21:31:04] MUSIC: No GiantDisc data base. Use standard music data base!
    35 (250) [21:31:17] : Load Module XXV::MODULES::MUSIC = 0.92
    36 (250) [21:31:17] : Load Module XXV::MODULES::MEDIALIB = 0.02
    37 (250) [21:31:17] : Load Module XXV::MODULES::LOGREAD = 0.01
    38 (250) [21:31:17] main: Install the SOAP server at http://linvdr:8082/
    39 (250) [21:31:17] : Load Module XXV::MODULES::INTERFACE = 0.01
    40 (250) [21:31:17] : Load Module XXV::MODULES::HTTPD = 0.92
    41 (250) [21:31:17] : Load Module XXV::MODULES::GRAB = 0.01
    42 (250) [21:31:17] : Load Module XXV::MODULES::EVENTS = 0.92
    43 (250) [21:31:17] : Load Module XXV::MODULES::EPG = 0.91
    44 (250) [21:31:17] : Load Module XXV::MODULES::CONFIG = 0.01
    45 (250) [21:31:17] : Load Module XXV::MODULES::CHRONICLE = 0.91
    46 (250) [21:31:17] : Load Module XXV::MODULES::CHANNELS = 0.91
    47 (250) [21:31:17] : Load Module XXV::MODULES::AUTOTIMER = 0.91
    48 (250) [21:31:17] main: CHANNELS: Read and register Channels ...
    49 (250) [21:31:18] main: EPG: Start read epg data and repair ...
    50 (202) [21:31:18] EPG: EVT:270 Call command "LSTE" on svdrp
    51 (250) [21:31:21] main: The read on epg data start now!
    52 (250) [21:31:50] EPG: Finish .. 16 events created, 283 events replaced, 0 events deleted
    53 (250) [21:31:57] main: EVENTS: Look for Evententrys in modules ...
    54 (250) [21:31:57] main: TIMERS: Store timers in database ...
    55 (202) [21:31:57] TIMERS: EVT:270 Call command "lstt" on svdrp
    56 (250) [21:31:57] main: NEWS::VDR: Start initiate the News vdr module ...
    57 (250) [21:31:57] main: NEWS::RSS: Start initiate the RSS Feed ...
    58 (250) [21:31:57] main: Send restart Message to News channel ...
    59 (202) [21:31:57] VDR: EVT:270 Call command "MESG Neustart des xxv-System um: 21:30:56 15.02.2007!" on svdrp
    60 (250) [21:31:57] main: REMOTE: Parse Commandfile ...
    61 (250) [21:31:57] main: RECORDS: Store records in database ...
    62 (202) [21:31:57] RECORDS: EVT:270 Call command "lstr" on svdrp
    63 (202) [21:31:57] RECORDS: EVT:270 Call command "stat disk" on svdrp
    64 (501) [21:31:59] RECORDS: Can't assign recording with title: 'Deluxe~Al Jarreau \- Mornin' \(1983\)'
    65 (501) [21:31:59] RECORDS: Can not find recording for Id 34!
    66 (501) [21:31:59] RECORDS: Can't assign recording with title: '%Verrückt.Schön'
    67 (501) [21:31:59] RECORDS: Can not find recording for Id 46!
    68 (501) [21:32:00] RECORDS: Can't assign recording with title: 'Bibliothek der Sachgeschichten~2006\-11\-26'
    69 (501) [21:32:00] RECORDS: Can not find recording for Id 69!
    70 (501) [21:32:00] RECORDS: Can't assign recording with title: 'Bibliothek der Sachgeschichten~Sprengung \(3.6\)'
    71 (501) [21:32:00] RECORDS: Can not find recording for Id 75!
    72 (501) [21:32:00] RECORDS: Can't assign recording with title: 'Bibliothek der Sachgeschichten~Abschied von der Hülle \(4.6\)'
    73 (501) [21:32:00] RECORDS: Can not find recording for Id 79!
    74 (501) [21:32:00] RECORDS: Can't assign recording with title: 'Bibliothek der Sachgeschichten~Solarenergie \(2.6\)'
    75 (501) [21:32:00] RECORDS: Can not find recording for Id 81!
    76 (501) [21:32:00] RECORDS: Can't assign recording with title: 'Bibliothek der Sachgeschichten~2006\-11\-29'
    77 (501) [21:32:00] RECORDS: Can not find recording for Id 82!
    78 (501) [21:32:00] RECORDS: I can't read file '/video0/Bibliothek_der_Sachgeschichten/S_-_Sprengung/2007-02-03.06.10.99.9
    9.rec/marks.vdr'
    79 (501) [21:32:00] RECORDS: Can't assign recording with title: 'Bibliothek der Sachgeschichten~S \(7\) \- Sprengung \(1.5\)'
    80 (501) [21:32:00] RECORDS: Can not find recording for Id 88!
    81 (501) [21:32:00] RECORDS: Couldn't read : '/video0/Bibliothek_der_Sachgeschichten/2006-12-10/2006-12-10.10.20.99.99.r
    ec/index.vdr'
    82 (501) [21:32:00] RECORDS: Couldn't read : '/video0/Bibliothek_der_Sachgeschichten/2006-12-13/2006-12-13.13.50.99.99.r
    ec/index.vdr'
    83 (501) [21:32:00] RECORDS: Can't assign recording with title: 'Herbie Fully Loaded \- Ein toller Käfer startet durch \(Herbie: Fully Loaded\)'
    84 (501) [21:32:00] RECORDS: Can not find recording for Id 96!
    85 (250) [21:32:00] main: CHRONICLE: Store recordings at chronicle ...
    86 (250) [21:32:01] : Dokumentation wurde in '/opt/XXV/doc' generiert
    87 (202) [21:32:01] VDR: EVT:270 Call command "MESG PANIK! Nur noch 0 0,000000reier Platz auf Gerät /dev/hdb1" on svdrp
    88 (202) [21:32:19] AUTOTIMER: EVT:270 Call command "lstt" on svdrp
    89 (202) [21:32:19] AUTOTIMER: EVT:270 Reread 10 timers and written to DB!
    90 (501) [21:33:31] TIMERS: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION


    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Nam at /opt/XXV/bin/../lib/Tools.pm line 222, <DATA> line 286.
    91 (501) [21:33:31] TIMERS: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION


    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Nam -
    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Name as Kanal,
    c.Pos as __Pos,
    t.Day as Tag,
    t.Start as Start,
    t.Stop as Stopp,
    t.File as Titel,
    t.Priority as Prioritaet,
    UNIX_TIMESTAMP(t.NextStartTime) as __Day,
    t.Collision as __Collision,
    t.eventid as __eventid,
    t.AutotimerId as __AutotimerId,
    UNIX_TIMESTAMP(t.NextStopTime) - UNIX_TIMESTAMP(t.NextStartTime) as __Duration,
    e.description as __description
    FROM
    TIMERS as t,
    CHANNELS as c,
    EPG as e
    WHERE
    t.ChannelID = c.Id
    and (t.eventid = e.eventid)



    UNION


    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Name as Kanal,
    c.Pos as __Pos,
    t.Day as Tag,
    t.Start as Start,
    t.Stop as Stopp,
    t.File as Titel,
    t.Priority as Prioritaet,
    UNIX_TIMESTAMP(t.NextStartTime) as __Day,
    t.Collision as __Collision,
    t.eventid as __eventid,
    t.AutotimerId as __AutotimerId,
    UNIX_TIMESTAMP(t.NextStopTime) - UNIX_TIMESTAMP(t.NextStartTime) as __Duration,
    "" as __description
    FROM
    TIMERS as t,
    CHANNELS as c
    WHERE
    t.ChannelID = c.Id
    and (t.eventid = 0)



    AND 0 = 1
    92 (501) [21:33:31] TIMERS: DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION


    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Nam at /opt/XXV/bin/../lib/XXV/MODULES/TIMERS.pm line 1037, <DATA> line 286.
    93 (202) [21:33:57] TIMERS: EVT:270 Call command "lstt" on svdrp
    94 (501) [21:33:58] TIMERS: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION


    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Nam at /opt/XXV/bin/../lib/Tools.pm line 222, <DATA> line 572.
    95 (501) [21:33:58] TIMERS: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION


    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Nam -
    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Name as Kanal,
    c.Pos as __Pos,
    t.Day as Tag,
    t.Start as Start,
    t.Stop as Stopp,
    t.File as Titel,
    t.Priority as Prioritaet,
    UNIX_TIMESTAMP(t.NextStartTime) as __Day,
    t.Collision as __Collision,
    t.eventid as __eventid,
    t.AutotimerId as __AutotimerId,
    UNIX_TIMESTAMP(t.NextStopTime) - UNIX_TIMESTAMP(t.NextStartTime) as __Duration,
    e.description as __description
    FROM
    TIMERS as t,
    CHANNELS as c,
    EPG as e
    WHERE
    t.ChannelID = c.Id
    and (t.eventid = e.eventid)



    UNION


    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Name as Kanal,
    c.Pos as __Pos,
    t.Day as Tag,
    t.Start as Start,
    t.Stop as Stopp,
    t.File as Titel,
    t.Priority as Prioritaet,
    UNIX_TIMESTAMP(t.NextStartTime) as __Day,
    t.Collision as __Collision,
    t.eventid as __eventid,
    t.AutotimerId as __AutotimerId,
    UNIX_TIMESTAMP(t.NextStopTime) - UNIX_TIMESTAMP(t.NextStartTime) as __Duration,
    "" as __description
    FROM
    TIMERS as t,
    CHANNELS as c
    WHERE
    t.ChannelID = c.Id
    and (t.eventid = 0)



    AND 0 = 1
    96 (501) [21:33:58] TIMERS: DBD::mysql::db selectall_arrayref failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNION


    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Nam at /opt/XXV/bin/../lib/XXV/MODULES/TIMERS.pm line 1037, <DATA> line 572.



    Hat hier jemand eine Lösung ....


    Gruss Miroe4you

  • Hallo,


    mysql --version
    mysql Ver 11.16 Distrib 3.23.49, for pc-linux-gnu (x86_64)



    habe heute erst per svn upgedatet ...


    cd /opt
    svn co http://sonne.bandt.net/repos/XXV
    svn co http://sonne.bandt.net/repos/XXV-Skins



    svn co http://sonne.bandt.net/repos/XXV
    U XXV/contrib/import-data.sql
    U XXV/contrib/update-xxv
    U XXV/contrib/export-data.sql
    U XXV/contrib/upgrade-xxv-db.sql
    U XXV/doc/CHANGELOG.txt
    U XXV/lib/XXV/MODULES/MEDIALIB.pm
    U XXV/lib/XXV/MODULES/USER.pm
    U XXV/lib/XXV/MODULES/MUSIC.pm
    Checked out revision 1051.
    svn co http://sonne.bandt.net/repos/XXV-Skins
    Checked out revision 1051.


    update-xxv
    ----------


    Info: Checking Server
    Info: Checking Database
    Info: Retrieving current version
    Info: current database version: 24
    Info: new database version: 25
    Info: Starting update...
    Info: Saving Data
    Info: Updating Database
    Info: Restoring Data
    Info: Updateing Version
    Info: Update successful


    habe auch die Datenbank neu angelegt ..


    mysql


    drop database xxv;
    create database xxv;
    grant all privileges on xxv.* to xxv@localhost IDENTIFIED BY 'xxv';
    flush privileges;


    hat aber hinsichtlich der Musik Kekse nichts gebracht ..


    Die Datenbank hat allerdings auch einige richtige Einträge ..
    Meine Musikdatenbank besteht aus ca . 1600 Titeln ..


    Meine Musik Sammlung sieht jetzt so aus ..


    Album: ÿþD [Auswählen album]
    Künstler: ÿþS, Jahr: , Genre: ÿþP, Kommentar:
    Sv Kuenstler Album Titel Tracknr Jahr Dauer
    ÿþS ÿþD ÿþC ÿþ6



    ein mysql select * from MUSIC;


    |15184|/pub/mp3/All Artists/Zager & Evans/Mix/Zager & Evans - Mix - In the Year 2525.mp3|ÿþZ|ÿþM|ÿþI| | |0|ÿþD|121|44.1|198|


    zeigt mir das ..


    Werden die Daten aus dem Tag gelesen .. und welche Tag Version ..


    Der SQL Syntax Fehler in der Timer Seite ist auch in der neuen Version noch nicht behoben ..


    Das Share Problem : ( oder hat sich hier etwas geändert )


    Expat:syntax error at line 1, column 0, byte 0 at /usr/local/lib/perl/5.6.1/XML/Parser.pm line 187
    Parser:syntax error at line 1, column 0, byte 0 at /usr/local/lib/perl/5.6.1/XML/Parser.pm line 187
    SHARE: Transport Error: 500 Can't connect to xpix.dyndns.org:81 (connect: timeout)
    SHARE: Can't get user key
    SHARE: Use of uninitialized value in string ne at /opt/XXV/bin/../lib/XXV/MODULES/SHARE.pm line 202.
    SHARE: Response contain wrong answer
    SHARE: Use of uninitialized value in string eq at /opt/XXV/bin/../lib/XXV/MODULES/SHARE.pm line 205.
    main: SOAP Server http://xpix.dyndns.org:81/XXV/Server can not connected!
    main: Deactivate the Share Modul!



    Kannst Du mir auch noch in der cpan Sache helfen .. ist Stream Packet jetzt so o.k. oder nicht ..*??


    perl -MCPAN -e 'install 'XML::Stream
    Going to read /root/.cpan/sources/authors/01mailrc.txt.gz
    CPAN: Compress::Zlib loaded ok
    Going to read /root/.cpan/sources/modules/02packages.details.txt.gz
    Database was generated on Thu, 15 Feb 2007 06:09:32 GMT
    CPAN: HTTP:: Date loaded ok
    Going to read /root/.cpan/sources/modules/03modlist.data.gz
    XML:: Stream is up to date (1.22).

  • Hallo,


    ich denke nicht das es an der mysql Version liegt denn bis gestern lief ja die Version 0.84 noch einwandfrei ...


    Oder hat sich mit der allerneusten das jetzt alles geändert ...


    Das Share ging bis gestern auch noch ...


    Ich denke das Timer Problem ist ein Sytax Fehler ...


    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Nam -
    SELECT
    t.Id as Sv,
    t.Status as Status,
    c.Name as Kanal,


    kann das nicht sein das hier irgenwas fehlt oder gar doppelt ist ..??


    Und die Musik Daten werden ja zum Teil auch richtig gelesen ...


    Kann das an den Dateinamen liegen .. sind ja relativ lange und mit Leerzeichen ...??


    Gruss
    Miroe4you

  • Hallo ,


    das kann ja sein ...


    aber bis gestern lief die
    XXV System -- Version: 0.80(889M) -- created by xpix and hulk 2004 - 2005


    und da gingen die Timer noch ..


    ich betreibe hier ein LINVDR ist nicht die neueste Distri und ein ubgrade auf mysql neuere Version warscheinlich nicht möglich ...


    Oder geht das dann mache ich das natürlich sofort ..

  • Hallo,


    habe jetzt mal die


    /opt/XXV/lib/XXV/MODULES/TIMERS.pm


    aus der Version
    XXV System -- Version: 0.80(889M) -- created by xpix and hulk 2004 - 2005


    genommen jetzt funktionieren die Timer ...


    Bei den Musik Daten ist das glaube ich kein mysql Fehler ...


    Die Titel sind ja alle da ...


    und können auch abgespielt werden .. da der Pfad ja stimmt ...


    also das Modul file::find schreibt richtig .. und findet alle mp3 Daten ..
    sub init legt auch sauber die Datenbank an .. alles soweit o.k


    und jetzt kommt MP3::Icecast und liest die files aus der DB ist das so richtig ...


    Das ist der einzige Fehler .. alles andere läuft supper durch ..


    Das kann eigentlich nichts mit der Version von mysql zutun haben .. weil einige Titel richtig geschrieben werden ...


    mysql> select * from MUSIC where ALBUM = 'Gaudi' ;
    | Id | FILE | ARTIST | ALBUM | TITLE | COMMENT | TRACKNUM | YEAR | GENRE | BITRATE | FREQUENCY | SECS |
    | 12881 | /pub/mp3/All Artists/The Alan Parsons Project/Gaudi/The Alan Parsons Project - Gaudi - Closer to Heaven.mp3 | The Alan Parsons Project | Gaudi | Closer To Heaven | | 3 | 1987 | Rock | 192 | 48 | 353 |
    | 12882 | /pub/mp3/All Artists/The Alan Parsons Project/Gaudi/The Alan Parsons Project - Gaudi - Inside Looking Out.mp3 | The Alan Parsons Project | Gaudi | Inside Looking Out | | 6 | 1987 | Rock | 192 | 48 | 382 |
    | 12883 | /pub/mp3/All Artists/The Alan Parsons Project/Gaudi/The Alan Parsons Project - Gaudi - La Sagrada Familia.mp3 | The Alan Parsons Project | Gaudi | La Sagrada Familia | | 1 | 1987 | Rock | 192 | 48 | 529 |
    | 12884 | /pub/mp3/All Artists/The Alan Parsons Project/Gaudi/The Alan Parsons Project - Gaudi - Money Talks.mp3 | The Alan Parsons Project | Gaudi | Money Talks | | 5 | 1987 | Rock | 192 | 48 | 266 |
    | 12885 | /pub/mp3/All Artists/The Alan Parsons Project/Gaudi/The Alan Parsons Project - Gaudi - Paseo De Gracia (Instrumental).mp3 | The Alan Parsons Project | Gaudi | Paseo De Gracia (Instrumental) | | 7 | 1987 | Rock | 192 | 48 | 217 |
    | 12886 | /pub/mp3/All Artists/The Alan Parsons Project/Gaudi/The Alan Parsons Project - Gaudi - Standing on Higher Ground.mp3 | The Alan Parsons Project | Gaudi | Standing On Higher Ground | | 4 | 1987 | Rock | 192 | 48 | 303 |
    | 12887 | /pub/mp3/All Artists/The Alan Parsons Project/Gaudi/The Alan Parsons Project - Gaudi - Too Late.mp3 | The Alan Parsons Project | Gaudi | Too Late | | 2 | 1987 | Rock | 192 | 48 | 270 |


    und es sind auch ca 50 Titel richtig .. habe jetzt auch nochmal die Tags geprüft sehe aber hier keine Unterschiede alles in IDTag ist o.k.


    Noch eine Idee ...

  • Hallo,


    also das Problem mit der Musik habe ich nun auch nach langer Recherche gefixt ..


    Ist also doch ein Perl Problem ...
    von
    use MP3::Info;
    use_mp3_utf8([STATUS])


    kann scheinbar nur ID3v1 und ID3v2 tags tags lesen und das nur in utf8 Format ...


    Habe nun ein paar mp3 Dateien geeändert und in utf8 und die werden richtig erkannt ..


    timer ist auch was faul denn er geht ja mit der alten Version ..


    Hat also nichts mit der mysql Version zu tun ...

  • Quote

    Original von miroe4you
    Hat also nichts mit der mysql Version zu tun ...


    Wie heiss es so schön,


    Wir behalten uns Änderungen vor, die dem technischen Fortschritt dienen. :mua
    Und ein SQL-Abfrage mit UNION wird erst in mysql-4.0 unterstützt.


    Die einzige Chance, weiterhin ein altes Woddy System zu verwenden sind
    a.) bei der alten Version von TIMER.pm zu bleiben.
    b.) mysql-4 oder sogar einfach ein aktuelles mysql5.0 zuverwenden.
    c.) ohne die Ausgabe der Beschreibung der Sendung bei "tlist" zuleben und dazu das UNION des SQL Statement zu entfernen.




    BTW: Von Meinerseite aus wird die Zeichenkodierung UTF-8 erst unterstützt wenn dies auch nativ vom VDR verwendet wird.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!