Dear Tim Do you still have your old server running? If you do, do you have pgadmin III installed?
If yes to the above, I can give you instructions to do the data transfer in a different way, that works for us. I even have a version of 123 (2.8.33) running on a laptop. Please advise. Regards Jean-Pierre *Please note my new e-mail address** : **[email protected]* _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Jean-Pierre Guillou CEO *DCDM Management Services Ltd* Tel PABX : (230) 202 3000 Tel Direct : (230) 202 3057 Fax : (230) 208 0086 Web :www.dcdm-ms.com Business Registration Number : C07051938 ******************************************************************** Privileged/Confidential Information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivering the message to the intended recipient), you should not read it, nor copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply E-mail. Opinions, conclusions and other information in this message that do not relate to the official business of any member firm of the DCDM Organisation shall be understood as neither given nor endorsed by the firm. Please consider the environment before printing this e-mail! Want a signature like mine? <http://r1.wisestamp.com/r/landing?promo=21&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_21> CLICK HERE.<http://r1.wisestamp.com/r/landing?promo=21&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_21> On 10 October 2012 19:33, Penguin Products <[email protected]>wrote: > 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 > >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
