Hi Armaghan We ran the Pg-custom_tables.sql on the database after importing the dataset. no errors were reported during that process, but we still have the same error on login into sql-ledger Error!
*SELECT * FROM defaults ERROR: permission denied for relation defaults* If I login using a test database Sql-ledger runs fine. Thanks again Tim Wade Penguin Products Ph: (021) 797-0725 Fax: (021) 762-4644 [image: Picture] On Wed, Oct 10, 2012 at 2:38 AM, Armaghan Saqib <[email protected]> wrote: > On Wed, Oct 10, 2012 at 2:10 PM, Penguin Products < > [email protected]> wrote: > >> Thank you to all who helped, I now have a working version of Ledger123 >> (2.8.33) up and running. >> >> How do I restore the backup from Sql Ledger 2.8.14 onto this current >> version. When I import the penguin.sql file, I get an error on login that's >> a SQL error which means it's looking for something that doesn't exist or >> the sql is different. >> >> to do the import I did: psql [database] < databasename.sql >> so psql penguin < penguin.sql >> if I create the dataset in sql-ledger the import gives errors but still >> completes >> if i create an empty database and import there are no errors on import >> but either way they give the same error on login. >> >> Please run sql/Pg-custom_tables.sql on the database after importing your > dataset. This should fix the problem. > > If not, post the error message. > > Regards > Armaghan > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger > >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
