On 09/29/09 22:03, Chris Travers wrote:
On Tue, Sep 29, 2009 at 9:55 PM, Joseph <..hidden..> wrote:Thanks for the input. So to be clear, I create an empty database load my sql-ledger data into it and start the upgrades, from my version forward, isn't it? These numbers are a bit confusing :-) My current version SQL-Ledger is 2.6.27 but when I save a backup it saves file as 2.6.12; so I should start loading the changes from 2.6.12 ? psql -U user my database < Pg-upgrade-2.6.12-2.6.17.sqlYes. I believe that was the last SQL-Ledger 2.6 version with db changes. Best Wshes, Chris Travers
What is the correct way of upgrading? I loaded my current SQL-Ledger-2.6.27 into the empty database and I started from: Pg-upgrade-1.2.6-1.2.7.sql but got error on second entry: psql -U postgres sysconcept_smb < Pg-upgrade-1.2.6-1.2.7.sql ALTER TABLE first one went OK, but the next one below I got errors: psql -U postgres sysconcept_smb < Pg-upgrade-1.2.7-1.4.0.sql CREATE TABLE ERROR: column "vendor" does not exist DROP TABLE ALTER TABLE CREATE TABLE ERROR: column "customer" does not exist DROP TABLE ALTER TABLE CREATE TABLE ERROR: column "addr1" does not exist DROP TABLE ALTER TABLE ERROR: relation "customertax" already exists CREATE TABLE ERROR: column "inventory_accno" does not exist DROP TABLE ALTER TABLE UPDATE 0 ERROR: relation "partstax" already exists ERROR: relation "tax" already exists CREATE TABLE ERROR: column "addr1" does not exist DROP TABLE ALTER TABLE ERROR: relation "vendortax" already exists ALTER TABLE NOTICE: CREATE TABLE / UNIQUE will create implicit index "chart_accno_key1" for table "chart" CREATE TABLE ERROR: column "accno" is of type integer but expression is of type text HINT: You will need to rewrite or cast the expression. DROP TABLE If I try to start upgrading from Pg-upgrade-2.6.12-2.6.17.sql psql -U postgres sysconcept_smb < Pg-upgrade-2.6.12-2.6.17.sql CREATE SEQUENCE NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "session_pkey" for table "session" CREATE TABLE ALTER TABLE ALTER TABLE UPDATE 38839 ALTER TABLE ALTER TABLE ERROR: column "version" of relation "defaults" does not exist One error popped up and eventually it will not let me log-in, error log from Apache below:[Wed Sep 30 09:22:49 2009] [error] [client 127.0.0.1] Can't call method "dberror" without a package or object reference at LedgerSMB/Form.pm line 3039., referer: http://localhost/ledgersmb/admin.pl?action=edit&login=joseph&path=bin/mozilla [Wed Sep 30 09:22:49 2009] [error] [client 127.0.0.1] Compilation failed in require at /usr/local/ledgersmb/admin.pl line 91., referer: http://localhost/ledgersmb/admin.pl?action=edit&login=joseph&path=bin/mozilla [Wed Sep 30 09:22:49 2009] [error] [client 127.0.0.1] Premature end of script headers: admin.pl, referer: http://localhost/ledgersmb/admin.pl?action=edit&login=joseph&path=bin/mozilla
So where do I start :-/ -- Joseph