[aerogear-dev] SQLGrammerException using unifiedpush-server-1.0.0.Beta1/JBoss 7.1.1/Postgres

[Matthias Wessendorf]

Hi Vivek,

thanks for reporting. I noticed the same bug a few days ago and this has
has been fixed in the upcoming BETA2

https://issues.jboss.org/browse/AGPUSH-879

Greetings,
Matthias


On Wed, Aug 13, 2014 at 2:09 PM, Vivek Pandey <vivek.pandey at pinelabs.com>
wrote:

> Hello Guys,
>
>
>
> I see following error in logs when I try to create a variant
>
>
>
> Caused by: org.postgresql.util.PSQLException: ERROR: column
> "variant1_.type" must appear in the GROUP BY clause or be used in an
> aggregate function
>
>   Position: 8
>
>         at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
>
>         at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
>
>         at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
>
>         at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
>
>
>
>
>
> I am using
>
> JAVA: C:\jdk1.7.0_45
>
> UPS: unifiedpush-server-1.0.0.Beta1
>
> Postgres: 9.3
>
> Postgres driver: postgresql-9.3-1100-jdbc4.jar
>
>
>
> Please find the log files attached
>
>
>
> ------------------------------
> This message may contain privileged and confidential information and is
> solely for the use of intended recipient. The views expressed in this email
> are those of the sender and not of Pine Labs. The recipient should check
> this email and attachments for the presence of viruses / malwares etc. Pine
> Labs accepts no liability for any damage caused by any virus transmitted by
> this email. Pine Labs may monitor and record all emails.
> ------------------------------
>
>
> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>



-- 
Matthias Wessendorf

blog: http://matthiaswessendorf.wordpress.com/
sessions: http://www.slideshare.net/mwessendorf
twitter: http://twitter.com/mwessendorf
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20140813/4767ca9e/attachment.html