SQL error when updating a data value and when double-clicking a data entry field

I recently upgraded to 2.22 build 21814, and getting same error with 2.23 build 21998 (but not in the online demos, so it is probably something with my database)

Log attached.

When double-clicking in a field, I get the pop-up box, but just with an error. This is what is in the log:

Caused by: org.postgresql.util.PSQLException: ERROR: column this_.created does not exist

error2.txt (61.4 KB)

···

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

This seems to be the issue:
Caused by:

org.postgresql.util.PSQLException: ERROR: column “created” of relation “datavalueaudit” does not exist

···

On Tue, Feb 23, 2016 at 11:44 AM, Knut Staring knutst@gmail.com wrote:

I recently upgraded to 2.22 build 21814, and getting same error with 2.23 build 21998 (but not in the online demos, so it is probably something with my database)

Log attached.

When double-clicking in a field, I get the pop-up box, but just with an error. This is what is in the log:

Caused by: org.postgresql.util.PSQLException: ERROR: column this_.created does not exist


Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hi Knut

Please try again with latest version and try again

···

On Tue, Feb 23, 2016 at 5:48 PM, Knut Staring knutst@gmail.com wrote:

This seems to be the issue:
Caused by:

org.postgresql.util.PSQLException: ERROR: column “created” of relation “datavalueaudit” does not exist


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Tue, Feb 23, 2016 at 11:44 AM, Knut Staring knutst@gmail.com wrote:

I recently upgraded to 2.22 build 21814, and getting same error with 2.23 build 21998 (but not in the online demos, so it is probably something with my database)

Log attached.

When double-clicking in a field, I get the pop-up box, but just with an error. This is what is in the log:

Caused by: org.postgresql.util.PSQLException: ERROR: column this_.created does not exist


Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Morten

Thanks Morten, the new update to 2.22 and trunk works well.

Knut

···

On Tue, Feb 23, 2016 at 12:46 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hi Knut

Please try again with latest version and try again

On Tue, Feb 23, 2016 at 5:48 PM, Knut Staring knutst@gmail.com wrote:

This seems to be the issue:
Caused by:

org.postgresql.util.PSQLException: ERROR: column “created” of relation “datavalueaudit” does not exist


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Morten

On Tue, Feb 23, 2016 at 11:44 AM, Knut Staring knutst@gmail.com wrote:

I recently upgraded to 2.22 build 21814, and getting same error with 2.23 build 21998 (but not in the online demos, so it is probably something with my database)

Log attached.

When double-clicking in a field, I get the pop-up box, but just with an error. This is what is in the log:

Caused by: org.postgresql.util.PSQLException: ERROR: column this_.created does not exist


Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org


Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org