Re: need support for a 1.2 to 1.3 upgrade

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é <..hidden..> 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
..hidden..
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