[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Database upgrade from 1.2.21 to 1.3.29 fails
- Subject: Database upgrade from 1.2.21 to 1.3.29 fails
- From: Nigel Titley <..hidden..>
- Date: Sun, 03 Mar 2013 22:50:05 +0000
I'm making yet another attempt to transfer my production data across to
a test instance of 1.3.29 so that my staff can have a play with the 1.3
system before we try and bring it live.
I copied the production database to a test one and invoked the setup.pl
script.
The setup script ran through without errors apart from a few duplicate
invoices, customers etc and I created a user. The user creation went
through OK and the process finished without errors
I then logged into the new instance of ledgersmb and found that the
database was completely empty, no accounts, no customers, no
transactions. The only thing present was the user I just created.
Obviously something has failed in the process and hasn't given an error
message. Can anyone suggest what I should be looking at to try and pin
down the error?
I'm running Ubuntu 10.10 and Postgres 8.4 (the postgres server is on a
different box)
The error log has multiple instances of
[Sun Mar 03 22:11:28 2013] [error] [client 192.168.1.146] commit
ineffective with AutoCommit enabled at scripts/setup.pl line 617.,
referer: http://woden.titley.com/ledgersmb-1.3/setup.pl
but I suspect this is cosmetic
This is a real killer. I can't even think of moving to 1.3 until I can
get the data across
Nigel