dhis2-devs team mailing list archive

[Ifeanyi Okoye <897677@xxxxxxxxxxxxxxxxxx>]

Hello. 
This is what we tried and the outcome.

Looking at all the suggestions made, we didn't think that we wanted to do the upgrades just yet till everyone agrees it is the recommended thing to do.
We tried the delete queries as suggested by Lars, but still had the same problem; however, that gave us an idea. We created a .sql backup from pgAdmin but in the objects window, we unchecked the three tables - usersettings, systemsettings, and importobjects before running the backup.
The resultant backup file was restored to a new database without any errors. The data statistics show exactly same number of data elements, data element groups, datasets, org units etc. 
We are not having any exceptions being thrown when trying to add users or change system settings.

However, this we have noticed.
The data entry module appears not to be working with the current system settings. Things like the application title, the style are different on the data entry module than all other modules (and we went through most of them). For instance, we changed the style to green but it remains blue in the data entry module. The application title does not update on the data entry module also. We had to clear the cache and cookies in Firefox 8 and Google Chrome before we got the  application title and style to update.

We are not sure what else might not be working. Data integrity check is
taking forever to run.

Let me know what you think.

Thanks

-- 
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