Hi Paul,
> 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! Fantastic work. Congratulations :) > This obviously changes the database, which I do not really want to do. All it does is to add more tables to the existing database in order to store some extra information. It does not change the structure or content of the already existing tables. This extra information is for example vital to get transparency and follow up on all warehouse transactions. > Main concerns: > > Will it be possible later to undo those changes to the main database? > Or even better, can they be prevented? Yes, you can delete the extra tables again whenever you want. > > 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? If you create a database dump using the PostgreSQL command "pg_dump" or "pg_dumpall", you can restore it again into any version of SQL-Ledger with the command "psql -f" without any problem. If you create a backup using the SQL-Ledger -> System -> Backup -> Send by E-mail or Save to File function you run into a problem. Tekki analyzed and spoke about this problem during our last yearly SQL-Ledger conference. @Tekki - can you please post a link to your presentation? I couldn't find it myself. Regards, Sebastian > > 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 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
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
