IRC.Esper.net - Minecraft IRC Logging service - Channel #prism

If you want your channel logged here, contact KHobbits on #lain @ Esper.
Other channels Current Log Tail Older Stats

[00:00:57]
[00:00:57] #prism - Sun Jan 22 00:00:57 2017
[00:00:57] ---
[00:01:14] * Topic is ':Prism v3 for Sponge http://bit.ly/1QFIvi2 | Site/Docs: http://discover-prism.com | Dev Builds: http://dhmc.us:8080/job/Prism/ | Prism v2: BukkitDev: http://bit.ly/11aF9MU'
[00:01:14] * Set by viveleroi!~botskonet@69.162.95.26 on Wed Feb 03 04:53:17
[03:51:29] * xCykrix (~xCykrix@2601:243:c600:cd74:2122:2815:e926:b42b) has joined #Prism
[03:54:36] <xCykrix> Could somebody possibly help me with a Prism issue? MySQL is giving (paste after) and I have no idea what is causing it; i've tried google and none of the solutions are helping
[03:54:50] <xCykrix> [21:53:43 INFO]: [Prism]: Database connection error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'prism.prism_data.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[03:54:50] <xCykrix> [21:53:43 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'prism.prism_data.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
[04:09:21] <@viveleroi> prism for bukkit didn't work with sql_mode=only_full_group_by
[04:10:08] <@viveleroi> you can relax mysql's settings if you have access
[04:13:19] <xCykrix> I tried modifying it that way vivelroi; I had too had V to the /etc/mysql/my.cnf
[04:13:20] <xCykrix> [mysqld]  
[04:13:20] <xCykrix> sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
[04:13:57] <xCykrix> An update to MySQL apperently broke the old way of "group"
[04:14:26] <xCykrix> I had to add* not had lmao