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.

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

jeongweejeongwee Vanilla version 2.6 ✭✭
edited August 2018 in Vanilla 2.0 - 2.8

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?

Comments

  • whu606whu606 I'm not a SuperHero; I just like wearing tights... MVP

    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.

  • jeongweejeongwee Vanilla version 2.6 ✭✭
    edited August 2018

    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

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

    Add Pages to Vanilla with the Basic Pages app

  • jeongweejeongwee Vanilla version 2.6 ✭✭
    edited August 2018
  • jeongweejeongwee Vanilla version 2.6 ✭✭
    edited August 2018

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

  • ShadowdareShadowdare r_j MVP
    edited August 2018

    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.

    Add Pages to Vanilla with the Basic Pages app

Sign In or Register to comment.