Hi;
I was going back trying to see what happened here, and I couldn't find the
previous emails. At any rate I apologize for not following up sooner.
On Thu, Dec 5, 2013 at 7:30 AM, Antoine Beaupré <anar...@anarcat.ath.cx>wrote:
> Hi,
>
> We are looking for assistance for upgrading our rather broken LedgerSMB
> 1.2 install to 1.3. We have been trying to perform this upgrade for more
> than a year now, and at each step we found new corruption in our old
> (old!) database, which was migrated from SQL-Ledger back in the days
> (and before that: migrated from Gnucash!).
>
Looking at the current messages, it looks like there are blank addresses.
That's probably what is holding up the issue.
There are a couple of difficulties we are likely to run into here,
including timezone issues. if you would be available to work with me over
IRC one of these evenings your time, we can probably get this straightened
out.
If evenings wouldn't work (I think I am 12 hours off from you), I would
recommend contacting either Erik Huelsmann or Havard Sorli (both of whom
are core contributors to LedgerSMB), or Freelock Consulting in Seattle (who
also contributes quite a bit). I will however offer technical suggestions
below, and email lists may not be a bad way to go.
>
> Here are the technical details of our current process and problems:
>
> https://wiki.koumbit.net/LedgerSmbUpgrade#A1.2.25_to_1.3.18
The specific error you are getting suggests that there are blank addresses
for customers and vendors which may contain spaces.
What I would suggest doing at this point is running the following two
queries before the upgrade:
UPDATE customer SET address1 = 'DELETEME' where (address1 ~
'[[:alnum:]_]') is not true;
UPDATE vendor SET address1 = 'DELETEME' where (address1 ~ '[[:alnum:]_]')
is not true;
Then after the upgrade:
DELETE FROM location WHERE line_one = 'DELETEME';
>
>
> This was previously discussed on this mailing list, but we failed to
> find a solution:
>
> http://archive.ledgersmb.org/ledger-smb-users/msg06632.html
>
> We have failed to get support from any commercial providers (including
> metatrontech, which has not responded to our emails since june), so we
> are quite worried about the level of support LedgerSMB really has in the
> community. We are willing to finance work on this to get us through this
> delicate upgrade.
>
> We will start considering switching to another application if we cannot
> finish this upgrade, especially considering the trouble we're having
> finding proper support...
>
> Thanks for any feedback you can provide,
>
> A.
>
> --
> Debugging is twice as hard as writing the code in the first place.
> Therefore, if you write the code as cleverly as possible, you are, by
> definition, not smart enough to debug it.
> - Brian W. Kernighan
>
>
> ------------------------------------------------------------------------------
> Sponsored by Intel(R) XDK
> Develop, test and display web and hybrid apps with a single code base.
> Download it for free now!
>
> http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
> _______________________________________________
> Ledger-smb-users mailing list
> Ledger-smb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>
>
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
lock-in.
http://www.efficito.com/learn_more.shtml
------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
