[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Problems, still, upgrading from LSMB 1.2.0, guidance sought

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:


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:


ehu` advised that I "need to change your ledgersmb.conf," explaining
"in your ledgersmb.conf, there's a setting pointing to the directory of

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.  

-- Hugh Esco


I am working to upgrade a 1.2.0 installation with four active sets of

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:

Hugh Esco 
skype: hresco3_ ; 678-921-8186 x21 
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(); }