Issue Details#987 Im having some problems with look ups

  • Priority: Normal
  • Number: 987
  • Type: Bug
  • Status: Closed
  • Age: 829 Days

Description

http://imgur.com/a/NmUMn

12.02 00:44:56 [Server] WARN com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mc20189.prism_data.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

12.02 00:44:56 [Server] WARN at sun.reflect.GeneratedConstructorAccessor98.newInstance(Unknown Source) 12.02 00:44:56 [Server] WARN at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 12.02 00:44:56 [Server] WARN at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.Util.getInstance(Util.java:408) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861) 12.02 00:44:56 [Server] WARN at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962) 12.02 00:44:56 [Server] WARN at me.botsko.prism.actionlibs.ActionsQuery.lookup(ActionsQuery.java:113) 12.02 00:44:56 [Server] WARN at me.botsko.prism.wands.InspectorWand$1.run(InspectorWand.java:106) 12.02 00:44:56 [Server] WARN at org.bukkit.craftbukkit.v1_11_R1.scheduler.CraftTask.run(CraftTask.java:71) 12.02 00:44:56 [Server] WARN at org.bukkit.craftbukkit.v1_11_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:52) 12.02 00:44:56 [Server] WARN at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) 12.02 00:44:56 [Server] WARN at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 12.02 00:44:56 [Server] WARN at java.lang.Thread.run(Thread.java:745) 12.02 00:44:56 [Server] INFO [Prism]: Database connection error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mc20189.prism_data.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

History

sebdomsan54 Gravatar

sebdomsan54 February 12, 2017 5:51 AM

Issue reported.

botsko Gravatar

botsko February 12, 2017 3:58 PM

Prism 1 and 2 were not compatible with sql_mode=only_full_group_by. You'll need to change that in your mysql configurations. Prism 3 is compatible with it, but v3 is only available for Sponge.

  • Status → Closed

Update Issue

Add your comments to this issue!

Creating a free account will let you immediately report issues on this project, as well as comment on existing issues, save your filters, and more!!