In case you wondered, the three commands that Lars lists below can be entered into pgAdmin. Click on the SQL icon in the menu bar, and you will get a pop up window. Enter the below commands and hit the green arrow to Execute the query.
Knut 2011/11/29 Lars Helge Øverland <larshe...@gmail.com> > Hi like Jason say just remove the content of the tables which have > binary properties: > > delete from usersetting; > delete from systemsetting; > delete from importobject; > > -- > 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 > -- Knut Staring Informatics, U. of Oslo http://hisp.uio.no +4791880522 -- 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
