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

[Vivek Pandey]

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(QueryExecutorI
mpl.java:2161)

        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1890)

        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava: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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20140813/3c0aa9bc/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: server.log
Type: application/octet-stream
Size: 228839 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/aerogear-dev/attachments/20140813/3c0aa9bc/attachment-0001.obj