Problem with SQL Query
  • Hello,

    I have intalled Campcaster 1.1.1, When I was installing campcaster-station I received this error:

    ...
    ...
    Adding system startup for /etc/init.d/campcaster-scheduler ...
    /etc/rc0.d/K92campcaster-scheduler -> ../init.d/campcaster-scheduler
    /etc/rc1.d/K92campcaster-scheduler -> ../init.d/campcaster-scheduler
    /etc/rc6.d/K92campcaster-scheduler -> ../init.d/campcaster-scheduler
    /etc/rc2.d/S92campcaster-scheduler -> ../init.d/campcaster-scheduler
    /etc/rc3.d/S92campcaster-scheduler -> ../init.d/campcaster-scheduler
    /etc/rc4.d/S92campcaster-scheduler -> ../init.d/campcaster-scheduler
    /etc/rc5.d/S92campcaster-scheduler -> ../init.d/campcaster-scheduler
    Starting campcaster scheduler: using config file '/opt/campcaster/etc/campcaster-scheduler.xml'
    campcaster-scheduler.

    jose@pc-ubuntu:~$ error executing command start
    authentication problem: Login method returned fault response:
    [faultCode:805,faultString:ERROR:xrLocStor: 256 BasicStor: DB Error: unknown error
    SELECT id FROM ls_tree t
    LEFT JOIN ls_struct s ON id=objid
    WHERE name='RootNode' AND parid is null [nativecode=ERROR: no existe la relación «ls_tree»] (/opt/campcaster/var/Campcaster/storageServer/var/BasicStor.php:105)]
    -----

    Now, when I try to enter in ...campcaster/htmlUI/var/html/ui_browser.php, I receive this error:

    Fatal error: BasicStor: DB Error: unknown error SELECT id FROM ls_tree t LEFT JOIN ls_struct s ON id=objid WHERE name='RootNode' AND parid is null [nativecode=ERROR: no existe la relación «ls_tree»] in /opt/campcaster/var/Campcaster/storageServer/var/BasicStor.php on line 105

    ... and Camcaster Studio say: "The authentication server is not available. Would you like to edit the server settings?" and don't run.

    Thanks.