On 09/29/09 22:03, Chris Travers wrote: >On Tue, Sep 29, 2009 at 9:55 PM, Joseph <[email protected]> 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.sql >> > >Yes. 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 ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
