With some guidance from ehu` on the IRC channel, I made some progress on the issue described below, but now again find myself stuck here.
After setting the default country, AR and AP accounts, I encountered an Internal Server Error, for which I have posted the logs here: http://pastebin.campaignfoundations.com/2 so I went: chown www-data: /tmp/ledgersmb/ And on page reload, I am advised in the browser: "Error! Internal Database Error: More information has been reported in the error logs." So I linked those error logs here: http://static.campaignfoundations.com/upgrade_logs/ ehu` advised that I "need to change your ledgersmb.conf," explaining "in your ledgersmb.conf, there's a setting pointing to the directory of tablefunc.sql". With a fresh updatedb, `locate tablefunction.sql` turns up nothing. Poking around I'm guessing perhaps the directory I am interested in is this one: /usr/local/ledgersmb_13/sql/upgrade/svn/. But I still do not know what key to set that value to. Grep'ing the code base led me to LedgerSMB::DBObject->exec_method() which appears to call a stored procedure on the database, but that left me still scratching my head about what change I need to make to ledgersmb.conf. But he being from Europe, ehu` was likely fast asleep by the time I sorted that out and got back to him. Any further guidance is appreciated. I'm heading out to dinner and will check in on IRC when I return in an hour or so. Thanks, -- Hugh Esco -------------------- I am working to upgrade a 1.2.0 installation with four active sets of books. I dumped one set of books, restoring them to a new empty db. >From my webserver, after modifying the script to use a -h db.server switch on the psql invocation inside the loop, I ran: `time /bin/bash reload_modules.sh ymd_lsmb_1318 \ > reload_modules.sh.output \ 2> reload_modules.sh.err`, and then used a grep | wc pipe to determine that for the 30 lines in LOADORDER, I now had 19 ROLLBACK's and 4 COMMIT's. Can anyone here please offer guidance on how to proceed to resolve this and complete this migration? I have posted the STDOUT and STDERR here: http://static.campaignfoundations.com/reload_modules.sh.output http://static.campaignfoundations.com/reload_modules.sh.err -- Hugh Esco skype: hresco3_ ; 678-921-8186 x21 http://www.CampaignFoundations.com/ Providing Application Hosting, Telephony, Custom Development and Consulting Services to Green Candidates, Green Parties and the non profits working for a just and sustainable future. if( $insurance->rationing() ) { $people->die(); } if( isa_ok($self,'Troy::Davis') =~ m/^ok/) { $people->are_whole(); } ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users