I would try TRUNCATE usersetting;
and see where this gets you. On Tue, Nov 29, 2011 at 6:27 PM, Ifeanyi Okoye <897...@bugs.launchpad.net> wrote: > Hello Jason, > We thought as much too, it's the effect on DHIS2 that we are not sure how to > handle this as we can't create users or modify the general system settings. > What do you think? > > > Warm Regards, > > Ifeanyi > > > > ________________________________ > From: jason.p.pickering <897...@bugs.launchpad.net> > To: ifeanyiok...@yahoo.com > Sent: Tuesday, November 29, 2011 2:50 PM > Subject: Re: [Bug 897677] [NEW] Some functions not working in DHIS 2 after > database restore > > I do not think this is an issue with DHIS2, but an issue restoring > from Postgres 9.1 to Postgres 8.4. Postgres is normally quite > sensitive about backwards restores, i.e. from 9.1 to 8.4. Going from > 8.4 to 9.1 should not be a problem but the other way around may > present issues, which I think is the problem with one of the error > screen shots you sent. > > > On Tue, Nov 29, 2011 at 3:27 PM, Ifeanyi Okoye > <897...@bugs.launchpad.net> wrote: >> Public bug reported: >> >> I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my >> Windows 7 computer. I used pg_dump to create a database backup in plain >> format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386 >> server. The restore was successful but there were some errors. >> After logging in, we found that there were problems with the following >> functions: >> >> 1. Some of the settings did not import with the database restore >> 2. Opening system general settings throws an exception >> 3. Adding users also throws an exception >> 4. Trying to edit a dataset throws exceptions as well. >> >> I have attached some error logs and screenshots for you to see >> >> ** Affects: dhis2 >> Importance: Undecided >> Status: New >> >> -- >> You received this bug notification because you are a member of DHIS 2 >> India Developers, which is subscribed to DHIS. >> https://bugs.launchpad.net/bugs/897677 >> >> Title: >> Some functions not working in DHIS 2 after database restore >> >> Status in DHIS 2 - District Health Information Software: >> New >> >> Bug description: >> I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my >> Windows 7 computer. I used pg_dump to create a database backup in plain >> format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386 >> server. The restore was successful but there were some errors. >> After logging in, we found that there were problems with the following >> functions: >> >> 1. Some of the settings did not import with the database restore >> 2. Opening system general settings throws an exception >> 3. Adding users also throws an exception >> 4. Trying to edit a dataset throws exceptions as well. >> >> I have attached some error logs and screenshots for you to see >> >> To manage notifications about this bug go to: >> https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions >> > > -- > You received this bug notification because you are subscribed to the bug > report. > https://bugs.launchpad.net/bugs/897677 > > Title: > Some functions not working in DHIS 2 after database restore > > Status in DHIS 2 - District Health Information Software: > New > > Bug description: > I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my > Windows 7 computer. I used pg_dump to create a database backup in plain > format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386 > server. The restore was successful but there were some errors. > After logging in, we found that there were problems with the following > functions: > > 1. Some of the settings did not import with the database restore > 2. Opening system general settings throws an exception > 3. Adding users also throws an exception > 4. Trying to edit a dataset throws exceptions as well. > > I have attached some error logs and screenshots for you to see > > To manage notifications about this bug go to: > https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions > > -- > You received this bug notification because you are a member of DHIS 2 > India Developers, which is subscribed to DHIS. > https://bugs.launchpad.net/bugs/897677 > > Title: > Some functions not working in DHIS 2 after database restore > > Status in DHIS 2 - District Health Information Software: > New > > Bug description: > I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my > Windows 7 computer. I used pg_dump to create a database backup in plain > format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386 > server. The restore was successful but there were some errors. > After logging in, we found that there were problems with the following > functions: > > 1. Some of the settings did not import with the database restore > 2. Opening system general settings throws an exception > 3. Adding users also throws an exception > 4. Trying to edit a dataset throws exceptions as well. > > I have attached some error logs and screenshots for you to see > > To manage notifications about this bug go to: > https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions > -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/897677 Title: Some functions not working in DHIS 2 after database restore Status in DHIS 2 - District Health Information Software: New Bug description: I run a DHIS 2.0 (version 2.5) live instance using PostgreSQL 9.1 on my Windows 7 computer. I used pg_dump to create a database backup in plain format for a restore to PostgreSQL 8.4 running on an Ubuntu 10.04 i386 server. The restore was successful but there were some errors. After logging in, we found that there were problems with the following functions: 1. Some of the settings did not import with the database restore 2. Opening system general settings throws an exception 3. Adding users also throws an exception 4. Trying to edit a dataset throws exceptions as well. I have attached some error logs and screenshots for you to see To manage notifications about this bug go to: https://bugs.launchpad.net/dhis2/+bug/897677/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
