Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

Hi Lyle, > Ok, I got further, here is a patch for setup.pl: > [ snip ] Thanks for the patch! Not many errors now: > > psql:/tmp/ledgersmb/1.2-1.3-upgrade.sql:358: ERROR: new row for relation > "entity" violates check constraint "entity_name_check" > > DETAIL: Failing row contains (389, ,

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

Hi, Ok, I got further, here is a patch for setup.pl: --- setup_old.pl2014-03-23 19:46:28.0 + +++ setup_new.pl2014-03-23 19:50:47.0 + @@ -650,6 +650,16 @@ } } +# Check to see if there is a heading, otherwise add a default --LH +my (

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

Hi Lyle, On Sun, Mar 23, 2014 at 5:37 PM, Lyle wrote: > My first problem: > > [ snip ] > At first it looked very odd as you can see NULL being passed explicitly > for the heading column. On closer inspection of the table definition in > Pg-database.sql:43 I can see it's a foreign key field.

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

My first problem: On 23/03/2014 16:21, Lyle wrote: psql:/tmp/ledgersmb/1.2-1.3-upgrade_.sql:28: ERROR: null value in column "heading" violates not-null constraint DETAIL: Failing row contains (2, 0010, Freehold Property, A, , null, f, f). CONTEXT: SQL statement "INSERT INTO account (accno, d

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

I'm having another go at it right now. I've worked through the scripts and SQL files to understand the upgrade process. It's a shame the setup.pl file doesn't have as much POD and comments as a lot of the .pm files do. I've been doing most of the upgrade manually so that I can see exactly whe

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

Hi Lyle, > One problem with the upgrade from 1.2 to 1.3 is that the datamodel on 1.3 > has been cleaned up and validation rules are a lot tighter now than they > ever were before -- ie on 1.2. That makes migration hard. We have a number > of checks in place, but probably the checks required for

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

On 17/03/2014 04:58, Chris Travers wrote: Reading the problem this does not look like an extension problem. In general we don't have an easy way to handle pre-9.1 contrib modules and post-9.1 extensions without throwing errors on both sides, so the errors look normal to me. The error seems to

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

On 16/03/2014 22:43, Erik Huelsmann wrote: Hi Lyle, Let me start by saying I'm sorry to hear 1.3 is causing you this much trouble. More comments below. Thanks On Sun, Mar 16, 2014 at 4:06 PM, Lyle > wrote: Hi, Trying to upgrade from 1.2 to 1.3 has

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

I just got back from an unexpected trip and so am catching up. First a few notes. The upgrade works more or less as follows. Understanding this process is the key to understanding when/where restoring from backup is helpful vs rolling back the upgrade (which is generally preferable in a case lik

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

Hi Lyle, Let me start by saying I'm sorry to hear 1.3 is causing you this much trouble. More comments below. On Sun, Mar 16, 2014 at 4:06 PM, Lyle wrote: > Hi, > Trying to upgrade from 1.2 to 1.3 has been quite an experience thus far. > Luckily I backed everything up and have been able to r

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

I've managed to get 1.2 working with PostgreSQL 9.3. I needed to update some of the SQL and there were some minor syntax differences. At least it looks like I'm up and running again and hopefully the upgrade to 1.3 will be easier next time around. I did a fresh CentOS 6.5 VM install. Used the

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

No need to go bleading edge, but it may help to try it on another system rather than mess up a running system Kind regards Benedict White -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the de

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

Hi Benedict, Thanks for the pointer. I've just tried the lastest 1.3 branch from subversion and got the same error when running prepare-company-database.sh I'm also getting an error when running make test: # Failed test at t/04-template-handling.t line 196. # got: 'Error: t/data/04

Re: [Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

It seems there may be some issues with LedgerSMB 1.3.38 which are fixed in the SVN so you could try that. Given how far back your centos machine is, you could perhaps bring up a test machine running a later version and then install from SVN on there and see if you can get that working, followed

[Ledger-smb-devel] 1.2 to 1.3 Upgrade fun

Hi, Trying to upgrade from 1.2 to 1.3 has been quite an experience thus far. Luckily I backed everything up and have been able to revert back to the old version. I followed the upgrade notes: http://sourceforge.net/p/ledger-smb/code/HEAD/tree/branches/1.3/UPGRADE The setup.pl script didn't