vanilla 2.61 something has gone wrong after i click on any of a discussion.

jeongwee

vanilla 2.61 page shows

Something has gone wrong after i click on any of a discussion.

We've run into a problem and are unable to handle this request right now.
Please check back in a little while.

it was no problem on 2.6

can anyone help with this?

whu606

The first thing to do when you see 'Something has gone wrong' has been posted on this site multiple ties.

Please search this forum using those key words, and follow the advice given.

jeongwee

sry but i didnt find one same as mine
i use debug mode ,it shows

==================================

Fatal Error in PHP.gdn_ErrorHandler();
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated >column 'easyclass101.c.DateInserted' 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: /data/www/default/library/database/class.database.php
417: if (!$message) {
418: $message = $ex->getMessage();
419: }
420:
421: trigger_error($message, E_USER_ERROR);
422: }
423:
424: }
425:
Backtrace:
/data/www/default/library/database/class.database.phpPHP::gdn_ErrorHandler();
[/data/www/default/library/database/class.database.php:421] PHP::trigger_error();
[/data/www/default/library/database/class.sqldriver.php:1707] Gdn_Database->query();
[/data/www/default/library/database/class.sqldriver.php:664] Gdn_SQLDriver->query();
[/data/www/default/plugins/VanillaInThisDiscussion/class.inthisdiscussionmodule.php:46] >Gdn_SQLDriver->get();
[/data/www/default/plugins/VanillaInThisDiscussion/default.php:49] >InThisDiscussionModule->getData();
[/data/www/default/plugins/VanillaInThisDiscussion/default.php:49] >VanillaInThisDiscussionPlugin->discussionController_beforeDiscussionRender_handler();
[/data/www/default/library/Garden/EventManager.php:278] PHP::call_user_func_array();
[/data/www/default/library/core/class.pluginmanager.php:806] Garden\EventManager->>fire();
[/data/www/default/library/core/class.pluginmanager.php:765] Gdn_PluginManager->>callEventHandler();
[/data/www/default/library/core/class.pluggable.php:133] Gdn_PluginManager->>callEventHandlers();
[/data/www/default/applications/vanilla/controllers/class.discussioncontroller.php:267] >Gdn_Pluggable->fireEvent();
[/data/www/default/library/core/class.dispatcher.php:845] DiscussionController->index();
[/data/www/default/library/core/class.dispatcher.php:274] Gdn_Dispatcher->>dispatchController();
[/data/www/default/index.php:29] Gdn_Dispatcher->dispatch();
Variables in local scope:
[sql] 'select u.UserID as UserID, u.Name as Name, u.Photo as Photo, >max(c.DateInserted) as DateLastActive
from GDN_User u
join GDN_Comment c on u.UserID = c.InsertUserID
where c.DiscussionID = :cDiscussionID
group by u.UserID, u.Name, u.Photo
order by c.DateInserted desc
limit 20'
[inputParameters] array (
':cDiscussionID' => 1,
)
[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 ORDER BY clause is not in GROUP BY clause and contains >nonaggregated column \'easyclass101.c.DateInserted\' which is not functionally dependent >on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by'
[ex] array (
)
Need Help?
If you are a user of this website, you can report this message to a website administrator.
If you are an administrator of this website, you can get help at the Vanilla Community >Forums.
Additional information for support personnel:
Application: Vanilla
Application Version: 2.6.1
PHP Version: 7.1.21
Operating System: Linux
Server Software: Apache
Referer: http://144.202.80.138/discussions
User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like >Gecko) Chrome/61.0.3163.100 Safari/537.36
Request Uri: /discussion/1/welcome-to-awesome
Controller: PHP
Method: gdn_ErrorHandler

Shadowdare

Try removing ONLY_FULL_GROUP_BY from your MySQL's sql_mode config setting.

jeongwee

thx both, it works.

https://stackoverflow.com/questions/23921117/disable-only-full-group-by

jeongwee

@Shadowdare @whu606
the bug appear again, i have done nothing but posting some thread...
i have to disable it again.

Shadowdare

I think changing the setting via command line (SET GLOBAL sql_mode=...) is temporary. You probably have to set it in your MySQL config file. On Linux installs, it's usually in /etc/mysql/my.cnf.