Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

Flagging plugin fatal error.

raykairaykai New
edited May 2016 in Vanilla 2.0 - 2.8

if you tern the plugin on in vanilla v2.2.1 & MySQL 5.7.12 it crashes the forum dashboard.

Fatal Error in PHP.trigger_error();

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'aquaexotik0forum_vanilla.fl.ForeignID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

The error occurred on or near:
/library/database/class.database.php

408: // If we get here then the pdo statement prepared properly. 409: break; 410: 411: } catch (Gdn_UserException $uex) { 412: trigger_error($uex->getMessage(), E_USER_ERROR); 413: } catch (Exception $ex) { 414: list($state, $code, $message) = $PDO->errorInfo(); 415: 416: // If the error code is consistent with a disconnect, attempt to retry

Backtrace:

/library/database/class.database.phpPHP::Gdn_ErrorHandler(); [/library/database/class.database.php:412] PHP::trigger_error(); [/library/database/class.sqldriver.php:1663] Gdn_Database->query(); [/library/database/class.sqldriver.php:614] Gdn_SQLDriver->query(); [/plugins/Flagging/class.flagging.plugin.php:34] Gdn_SQLDriver->get(); [/library/core/class.pluginmanager.php:867] FlaggingPlugin->base_getAppSettingsMenuItems_handler(); [/library/core/class.pluginmanager.php:780] Gdn_PluginManager->callEventHandler(); [/library/core/class.pluggable.php:133] Gdn_PluginManager->callEventHandlers(); [/applications/dashboard/modules/class.sidemenumodule.php:268] Gdn_Pluggable->fireEvent(); [/library/core/class.module.php:213] SideMenuModule->toString(); [/library/core/class.controller.php:1350] Gdn_Module->render(); [/applications/dashboard/views/admin.master.php:34] Gdn_Controller->renderAsset(); [/library/core/class.controller.php:1891] PHP::include(); [/library/core/class.controller.php:1318] Gdn_Controller->renderMaster(); [/library/core/class.pluggable.php:199] Gdn_Controller->xRender(); [/applications/dashboard/controllers/class.settingscontroller.php:719] Gdn_Pluggable->__call(); [/applications/dashboard/controllers/class.settingscontroller.php:719] SettingsController->render(); [/applications/dashboard/controllers/class.settingscontroller.php:719] SettingsController->plugins(); [/library/core/class.dispatcher.php:329] PHP::call_user_func_array(); [/index.php:44] Gdn_Dispatcher->dispatch();

Variables in local scope:

[Sql] 'select DISTINCT(fl.ForeignID) asNumFlaggedItemsfrom GDN_Flag fl group by ForeignURL' [InputParameters] array ( ) [Options] array ( 'Type' => 'select', 'Slave' => NULL, 'ReturnType' => 'DataSet', ) [ReturnType] 'DataSet' [tries] 2 [try] 0 [PDO] array ( ) [PDOStatement] false [state] '42000' [code] 1055 [message] 'Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column \'aquaexotik0forum_vanilla.fl.ForeignID\' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by' [uex] array ( )

Tagged:

Comments

Sign In or Register to comment.