Good morning Sebastian. I actually installed 123-ledger alongside SQL-Ledger this morning, ran the modification of the database with 123ledgers custom-tables, and he presto! IT JUST WORKS!
Armaghan allready mentioned to use 123ledger at the moment. I actually installed 123-ledger alongside SQL-Ledger this morning, ran the modification of the database with 123ledgers custom-tables psql databasename < Pg-custom_tables.sql Indeed: IT JUST WORKS! Looks cool as well. This obviously changes the database, which I do not really want to do. Main concerns: Will it be possible later to undo those changes to the main database? Or even better, can they be prevented? Can I restore a backup made and emailed from within SQL-Ledger to a crisp and shining new stock SQL_Ledger install if the need should arise? Storing those different or new tables in a special ledgercart postgresDB or extra file in the ledgercart directory might be extra coding, but I would very much prefer a solution in that direction. BTW: Marvelous add-on, this will probably replace a lot of joomla, wordpress and other SMB websites once the word gets out via Linux-Format or something like that . If a bookkeeper such as I am can get this working in a weekend, be it with help from some professionals, it can not be too hard. Keep up the good work! Paul 2012/11/12 Sebastian Weitmann <[email protected]> > ** > 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 > [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
