Hi Paul, You can upgrade to Ledger123 for the time being to correct the missing relations errors. There are only few changes in the Dieter's sql-ledger which are required for LedgerCart (which I shall document soon so that you don't need to upgrade to Ledger123 to run LedgerCart)
To upgrade your db to Ledger123, run sql/Pg-custom_tables.sql in Ledger123 code base. There is Ledger123 sample database in sql folder which can be used to setup the LedgerCart with test data. Let me know if you still find issues. On Sun, Nov 11, 2012 at 3:01 PM, Paul Tammes <[email protected]> wrote: > Step by step works, but > > It seems either > > I type wrong things in config.pl (quite probable) or > > some tables are missing (have to be added to the SQL-Ledger database). > > PS: I run stock sql 3.03 downloaded and installed from DIeters site. > That is the only part where I did not follow the step by step.. > > Here is a more extended log from a newly installed debian 6 machine: > > [Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of > uninitialized value $form{"page"} in string eq at > /usr/local/sql-ledger/ledgercart/index.pl line 59. > [Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of > uninitialized value $form{"page"} in string eq at > /usr/local/sql-ledger/ledgercart/index.pl line 59. > [Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of > uninitialized value $form{"page"} in string eq at > /usr/local/sql-ledger/ledgercart/index.pl line 59. > [Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of > uninitialized value $form{"page"} in string eq at > /usr/local/sql-ledger/ledgercart/index.pl line 59. > [Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Use of > uninitialized value $form{"page"} in string eq at > /usr/local/sql-ledger/ledgercart/index.pl line 59. > [Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Can't call > method "ck_session" on an undefined value at > /usr/local/sql-ledger/ledgercart/index.pl line 79. > [Sun Nov 11 10:45:04 2012] [error] [client 127.0.0.1] Premature end of > script headers: index.pl > [Sun Nov 11 10:53:28 2012] [notice] caught SIGTERM, shutting down > [Sun Nov 11 10:53:29 2012] [notice] Apache/2.2.16 (Debian) > PHP/5.3.3-7+squeeze14 with Suhosin-Patch mod_perl/2.0.4 Perl/v5.10.1 > configured -- resuming normal operations > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] "my" variable > $stmt masks earlier declaration in same scope at > /usr/local/sql-ledger/ledgercart/index.pl line 203. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] "my" variable > $bind masks earlier declaration in same scope at > /usr/local/sql-ledger/ledgercart/index.pl line 203. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] "my" variable > $stmt masks earlier declaration in same scope at > /usr/local/sql-ledger/ledgercart/index.pl line 206. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] "my" variable > $bind masks earlier declaration in same scope at > /usr/local/sql-ledger/ledgercart/index.pl line 206. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Name > "main::allowedpages" used only once: possible typo at > /usr/local/sql-ledger/ledgercart/index.pl line 59. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] DBD::Pg::st > execute failed: ERROR: relation "customerlogin" does not exist > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] LINE 1: SELECT > id, login FROM customerlogin > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] > ^ at User/Simple.pm line 212. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Table > customerlogin does not exist or has wrong structure at > /usr/local/sql-ledger/ledgercart/index.pl line 40. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] DBD::Pg::st > execute failed: ERROR: relation "customerlogin" does not exist > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] LINE 2: > session_exp FROM customerlogin > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] > ^ at User/Simple/Admin.pm line 313. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Table > customerlogin does not exist or has wrong structure at > /usr/local/sql-ledger/ledgercart/index.pl line 41. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Use > User::Simple::Admin->create_db_structure first. at > /usr/local/sql-ledger/ledgercart/index.pl line 41. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Use of > uninitialized value $form{"action"} in substr at > /usr/local/sql-ledger/ledgercart/index.pl line 51. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Use of > uninitialized value $form{"page"} in string eq at > /usr/local/sql-ledger/ledgercart/index.pl line 59. > [Sun Nov 11 10:53:33 2012] [error] [client 127.0.0.1] Use of > uninitialized value $form{"page"} in string eq at > /usr/local/sql-ledger/ledgercart/index.pl line 59. > > > Same errors come up on my VPS, which is Ubuntu but also runnig fine. > Upside: SQL-ledger on bith systems work, and I now know that if needed > I can build a machine from scratch and have a restored SQL up and > runnig inside of 4 hours. > Nice to know.. > > > > > 2012/11/10, Paul Tammes <[email protected]>: >> Thanks a whole lot, with your guide I managed to get my own VPS at least >> partly running. >> The other way round I just proved that I can break a running SQL-Ledger >> system any day by installing the File::Basename from 5.17 beta development >> version. >> Luckily, that is not needed at all it seems, at least your notes did not >> mention it and I get it to kind of run. >> That is a lot more than I managed alone.. >> >> However, i get an error screen and >> >> Use of uninitialized value $form{"page"} in string eq at >> /usr/local/sql-ledger/ledgercart/index.pl line 59 >> >> in the apache logfiles when trying to hit >> >> http://localhost/ledgercart/ >> >> Any hints? >> >> /ledgercart is aliased just like /sql-ledger, and that one works .. >> >> Thanks, >> >> Paul >> >> 2012/11/10 Sebastian Weitmann <[email protected]> >> >>> ** >>> Hi Paul, >>> >>> I successfully installed LegerCart on Debian Squeeze (6.0) and wrote a >>> small step by step guide here: >>> >>> >>> http://www.sql-ledger-network.com/wiki/doku.php/ledgercart_step_by_step_installation/debian >>> >>> You will also need to install SQL-Ledger and can find the step by step >>> guide for this here: >>> >>> >>> http://www.sql-ledger-network.com/wiki/doku.php/step_by_step_installation/debian >>> >>> Good luck and feel free to contact me if you get stuck and need someone >>> to >>> talk to ;) >>> >>> Regards, >>> Sebastian >>> >>> >>> >>> >>> >>> >>> On Sat, 2012-11-10 at 07:25 +0100, Paul Tammes wrote: >>> >>> I am not a developer, but if you are on ubuntu 10, Perl 5.17 is not >>> the standard there. >>> And one of the modules you listed required 5.17. >>> File::Basename was the one iirc. >>> >>> For people in the know an upgrade inside any distro of perl to a >>> beta-version may be a piece of cake. >>> My guess is that I was able to break things doing just that. >>> >>> Will use this weekend to test on a stand-alone spare machine, will >>> post any results later. >>> I hope to be able to run and install myself, mainly a question of hurt >>> pride. >>> When I run a system and software I want to be able to tweak it myself. >>> I am not a great fan of remote sysops, I rather figure it out myself. >>> May take (much) longer though. >>> But if all else fails I might mail you with a remote login all the >>> same, thanks for the offer. >>> >>> Just thought I'd mention my problems to prevent other >>> non-prefessionals from breaking their running SQL-installs. >>> Might be awkward if you want to send invoices or process sales orders.. >>> >>> Cheers, >>> >>> Paul >>> > Not sure what could be wrong. LedgerCart works fine on Ubuntu 10.04 >>> > and I have not tried on Ubuntu 12.04. If you still can't do it, I can >>> > login to your server and set it up for you and see what went wrong. >>> > >>> > I am hoping to get a virtual appliance out with everything configured. >>> > This will be announced via SLNA Platform/forum here >>> > http://www.sql-ledger-network.com/forum/ >>> > >>> > Regards >>> > _______________________________________________ >>> > SQL-Ledger mailing list >>> > [email protected] >>> > http://lists.ledger123.com/mailman/listinfo/sql-ledger >>> _______________________________________________ >>> SQL-Ledger mailing >>> [email protected]http://lists.ledger123.com/mailman/listinfo/sql-ledger >>> >>> >>> _______________________________________________ >>> SQL-Ledger mailing list >>> [email protected] >>> http://lists.ledger123.com/mailman/listinfo/sql-ledger >>> >>> >> > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
