[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
1.0.0 -> 1.1.1d upgrade issues
- Subject: 1.0.0 -> 1.1.1d upgrade issues
- From: Michael Schultheiss <..hidden..>
- Date: Sun, 22 Oct 2006 22:22:38 -0400
I used SQL-Ledger for several years and when Ledger SMB 1.0.0 came out,
I upgraded to Ledger SMB with very few issues. I've been using 1.0.0
for a while and decided to upgrade to 1.1.1d the other day. I used
setup.pl from the 1.1.1d tarball and I assumed it upgraded everything
without issue since there were no errors. When I tried to login, I kept
getting denied access. I figured out that my user wasn't listed in
users/members. After correcting that, I was able to login and now I
Upgrading to Version 1.1.1c ...
ALTER TABLE acc_trans ADD FOREIGN KEY (chart_id) REFERENCES chart (id)
ERROR: insert or update on table "acc_trans" violates foreign key
DETAIL: Key (chart_id)=(10030) is not present in table "chart".
Fortunately, I made a backup of my database before upgrading to 1.1.1d.
I suppose I can re-enter everything into a blank database but I'd prefer
upgrading my current data to 1.1.1d.