Re: [ls-support] Problem with SQL Query
  • Hi Josmagar,

    Your database got corrupted somehow. Try removing Campcaster
    completely: make sure there is nothing left in the /opt/campcaster
    directory, and drop the database[1]. Then reinstall Campcaster.

    You can help us find out what is wrong if you tell us more: your system
    version (dapper, edgy, ...), Campcaster version (1.1.1-1, 1.1.1-2, ...),
    whether you had an earlier installation, etc. Anything that could
    possibly be useful. If you have saved the complete output of the
    install script, that would be good to see, too.

    Ferenc

    [1] This is easiest to do with the http://www.pgadmin.org/ program; the
    ubuntu package is called pgadmin3.


    phorum@code.campware.org wrote:
    > Author: josmagar
    > Link: http://code.campware.org/phorum/read.php?20,5085,5085#msg-5085
    > --------------------------------------------------------------------------------
    >
    > 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:
    > (/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 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.
    _______________________________________________
    ls-support mailing list
    ls-support@lists.campware.org
    http://lists.campware.org/mailman/listinfo/ls-support