dhis2-devs team mailing list archive

["jason.p.pickering" <914980@xxxxxxxxxxxxxxxxxx>]

Adding this

    executeSql( "ALTER TABLE chart ADD COLUMN targetline  boolean NOT
NULL DEFAULT false");
    executeSql( "ALTER TABLE chart ADD COLUMN hidesubtitle  boolean
NOT NULL DEFAULT false");

to TableAlteror.java seems to be a quick fix (or executing the
statements directly on the database).

On Wed, Jan 11, 2012 at 9:37 PM, jason.p.pickering
<914980@xxxxxxxxxxxxxxxxxx> wrote:
> Public bug reported:
>
> While attempting to save a chart to the favorites I see this..
>
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column this_.targetline does not exist
>  Position: 410
>        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
>        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
>        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
>        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
>        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
>        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
>        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
>        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
>        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
>        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
>        at org.hibernate.loader.Loader.doList(Loader.java:2533)
>        ... 111 more
>
>
> The UI freezes.
>
> Same problem happens when accessing the dashboard, except the same error
> is thrown to the UI.
>
> Version:
> 2.6
> Build revision:
> 5646
>
> ** Affects: dhis2
>     Importance: Undecided
>         Status: New
>
> --
> 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/914980
>
> Title:
>  data-visualizer-favorites-throws-sql-error
>
> Status in DHIS 2 - District Health Information Software:
>  New
>
> Bug description:
>  While attempting to save a chart to the favorites I see this..
>
>
>  Caused by: org.postgresql.util.PSQLException: ERROR: column this_.targetline does not exist
>    Position: 410
>          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
>          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
>          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
>          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
>          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
>          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
>          at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
>          at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
>          at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
>          at org.hibernate.loader.Loader.doQuery(Loader.java:802)
>          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
>          at org.hibernate.loader.Loader.doList(Loader.java:2533)
>          ... 111 more
>
>
>  The UI freezes.
>
>  Same problem happens when accessing the dashboard, except the same
>  error is thrown to the UI.
>
>  Version:
>  2.6
>  Build revision:
>  5646
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/dhis2/+bug/914980/+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/914980

Title:
  data-visualizer-favorites-throws-sql-error

Status in DHIS 2 - District Health Information Software:
  New

Bug description:
  While attempting to save a chart to the favorites I see this..


  Caused by: org.postgresql.util.PSQLException: ERROR: column this_.targetline does not exist
    Position: 410
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
          at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
          at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
          at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
          at org.hibernate.loader.Loader.doQuery(Loader.java:802)
          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
          at org.hibernate.loader.Loader.doList(Loader.java:2533)
          ... 111 more

  
  The UI freezes. 

  Same problem happens when accessing the dashboard, except the same
  error is thrown to the UI.

  Version:
  2.6
  Build revision:
  5646

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/914980/+subscriptions