← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 897677] [NEW] Some functions not working in DHIS 2 after database restore

 

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 <larshelge@xxxxxxxxx>

> 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


Follow ups

References