Good morning Paul,
I see you have been working actively implementing LedgerCart during the
weekend and Armaghan seems to think that the error messages you were
getting are related to your using Dieters version of SQL-Ledger instead
of Ledger123. This sounds very probable, because I actually based my
LedgerCart step-by-step installation guide on Ledger123, not Dieters
version of SQL-Ledger. Try to install Ledger123 instead and upgrade your
db with sql/Pg-custom_tables.sql as suggested by Armaghan, and see if
this doesn't solve the problem.
Please keep us updated and feel free to edit and adjust my LedgerCart
installation step-by-step instructions if you feel it needs to be
improved.
Regards,
Sebastian
On Sun, 2012-11-11 at 11:01 +0100, Paul Tammes 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
