dhis2-devs team mailing list archive

[Bob Jolliffe <bobjolliffe@xxxxxxxxx>]

I suspect they are working on ubuntu server from the commandline.
Even so the commands can be easily typed from the psql prompt after
connecting to the database.

On 29 November 2011 20:05, Knut Staring <knutst@xxxxxxxxx> wrote:
> 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
> 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