On Wed, May 12, 2010 at 11:08 PM, Viet Nguyen <[email protected]>wrote:
> > > On Wed, May 12, 2010 at 10:45 PM, Quang Nguyen > <[email protected]>wrote: > >> org.postgresql.util.PSQLException: ERROR: column this_.mandatory does not >> exist >> >> > > You can fix this by adding column "mandatory" to table "patientattribute" > , and give a default value for all rows of that column. > > There should be more problems with your db. > > I can't not give a sql patch because I don't know which version your db is > ... > > Is it a production db or just a testing db ? > > If it just for testing, then you can just delete the tables and let the > application auto create it at start up. > > If its production, then you can send me your db, I will try to update it > without losing data... > I'm testing it with real data, Viet. I can do your suggestion. However, what I'm thinking now is a few lines of code to correct the database structure before system starts. I guess we already have a place to put this code. Need to check it out. Quang > > > -- > Viet Nguyen > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
