Problems, still, upgrading from LSMB 1.2.0, guidance sought

[Hugh Esco <..hidden..>]

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(); }