Re: 1.4.1 cannot access LSMB

Unfortunately I have tracked down the issue and it is a small but significant bug in the db schema. It will be fixed in 1.4.2.

In the mean time, here is a hot fix:

run the following via psql:

BEGIN;

ALTER TABLE BATCH DROP CONSTRAINT "batch_locked_by_fkey";

ALTER TABLE BATCH ADD FOREIGN KEY (locked_by) references session (session_id)

ON DELETE SET NULL;

COMMIT;

On Tue, Sep 23, 2014 at 6:56 AM, Max van Biezen <..hidden..> wrote:

On 23 September 2014 15:46, Chris Travers <..hidden..> wrote:
> As a temporary fix try this in psql:
>
> UPDATE BATCH SET locked_by = NULL;
>
> I am looking further in to why this might happen.

<dbname>=# UPDATE BATCH SET locked_by = NULL;
UPDATE 40

Ok I can use the data. I will do the same again and report back

The only thing that I ignored initially was a that I had to run 1.4.1.
setup.pl twice. Here is what I did:

1. copy DB 1.3.40 to DB-newname
2. logged on to DB-newname with 1.3.40, basic checks ok.
3. log off and the open setup.pl with the DB-newname with 1.4.1
4. convert DB
5. log on to LSMB with 1.4.1 then error: using a 1.4.0 DB where
expecting a 1.4.1
6. again run 1.4.1 setup.pl
7. log on using 1.4.1 all ok and the I took the actions as described
in first mail

So potentially the conversion is not what it should be.

Max

------------------------------------------------------------------------------
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer
http://pubads.g.doubleclick.net/gampad/clk?id=154622311&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