Blog Documentation Book a Demo
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.

Strong issue

harry_callahanharry_callahan New
in Vanilla 2.0 - 2.8

hi,

first i m sorry for my bad english i m french.

yesterday i have run vanila forum ( http://www.altis-background.fr/ ) and start create all category i need. all over is ok.

but today, is notpossible to create discution, i dont going to dashboard setting or other, all the time i have picture someting has gone wrong. But on http://www.altis-background.fr/, i see discution, i can enter only if i choose modify.

can you help me?

Comments

  • whu606whu606 MVP
    edited February 2017

    @harry_callahan

    Bienvenue dans la communauté.

    Vous pouvez écrire en français si c'est plus facile pour vous.

    Quand tu vois

    Something has gone wrong

    Set $Configuration['Debug'] = TRUE;

    in your conf/config.php to reveal full error messages

    pour voir un message détaillé.

    Dites-nous ce que dit le message détaillé.

  • harry_callahanharry_callahan New

    Bonsoir

    merci pour votre aide.

    le message detaille:

    [spoiler]
    Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'db336455_altisbackground.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: /flex/storage/altis-background.fr/site/www/library/database/class.database.php

    422: if (!$message) {

    423: $message = $ex->getMessage();

    424: }

    425:

    426: trigger_error($message, E_USER_ERROR);

    427: }

    428:

    429: }

    430:

    Backtrace:

    /flex/storage/altis-background.fr/site/www/library/database/class.database.phpPHP::Gdn_ErrorHandler();

    [/flex/storage/altis-background.fr/site/www/library/database/class.database.php:426] PHP::trigger_error();

    [/flex/storage/altis-background.fr/site/www/library/database/class.sqldriver.php:1663] Gdn_Database->query();

    [/flex/storage/altis-background.fr/site/www/library/database/class.sqldriver.php:614] Gdn_SQLDriver->query();

    [/flex/storage/altis-background.fr/site/www/plugins/VanillaInThisDiscussion/class.inthisdiscussionmodule.php:46] Gdn_SQLDriver->get();

    [/flex/storage/altis-background.fr/site/www/plugins/VanillaInThisDiscussion/default.php:61] InThisDiscussionModule->getData();

    [/flex/storage/altis-background.fr/site/www/library/core/class.pluginmanager.php:873] VanillaInThisDiscussionPlugin->discussionController_beforeDiscussionRender_handler();

    [/flex/storage/altis-background.fr/site/www/library/core/class.pluginmanager.php:781] Gdn_PluginManager->callEventHandler();

    [/flex/storage/altis-background.fr/site/www/library/core/class.pluggable.php:133] Gdn_PluginManager->callEventHandlers();

    [/flex/storage/altis-background.fr/site/www/applications/vanilla/controllers/class.discussioncontroller.php:270] Gdn_Pluggable->fireEvent();

    [/flex/storage/altis-background.fr/site/www/library/core/class.dispatcher.php:326] DiscussionController->index();

    [/flex/storage/altis-background.fr/site/www/index.php:44] 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
    order by c.DateInserted desc
    limit 20'

    [InputParameters] array (
    ':cDiscussionID' => 3,
    )

    [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 \'db336455_altisbackground.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 (
    )

    [/spoiler]

  • harry_callahanharry_callahan New

    si besoin :

    Additional information for support personnel:

    Application: Vanilla
Application Version: 2.3
PHP Version: 7.1.0
Operating System: Linux
Server Software: Apache/2.4.10 (Ubuntu)
Referer: http://www.altis-background.fr/
User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:51.0) Gecko/20100101 Firefox/51.0
Request Uri: /discussion/3/altis-background-mission-publique-by-sfp-maj-du-10-02-2017
Controller: PHP
Method: trigger_error
  • vrijvlindervrijvlinder MVP

    Try running utility/structure to fix the missing column... run it a couple times...

    http://www.altis-background.fr/utility/structure

    ❌ ✊ ♥. ¸. ••. ¸♥¸. ••. ¸♥ ✊ ❌

  • harry_callahanharry_callahan New

    I have try tu launch your link but i have this message:

    Fatal Error in PHP.trigger_error();

    Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db336455_altisbackground.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: /flex/storage/altis-background.fr/site/www/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:
    /flex/storage/altis-background.fr/site/www/library/database/class.database.phpPHP::Gdn_ErrorHandler();
    [/flex/storage/altis-background.fr/site/www/library/database/class.database.php:412] PHP::trigger_error();
    [/flex/storage/altis-background.fr/site/www/library/database/class.sqldriver.php:1663] Gdn_Database->query();
    [/flex/storage/altis-background.fr/site/www/library/database/class.sqldriver.php:614] Gdn_SQLDriver->query();
    [/flex/storage/altis-background.fr/site/www/plugins/Flagging/class.flagging.plugin.php:34] Gdn_SQLDriver->get();
    [/flex/storage/altis-background.fr/site/www/library/core/class.pluginmanager.php:873] FlaggingPlugin->base_getAppSettingsMenuItems_handler();
    [/flex/storage/altis-background.fr/site/www/library/core/class.pluginmanager.php:786] Gdn_PluginManager->callEventHandler();
    [/flex/storage/altis-background.fr/site/www/library/core/class.pluggable.php:133] Gdn_PluginManager->callEventHandlers();
    [/flex/storage/altis-background.fr/site/www/applications/dashboard/modules/class.sidemenumodule.php:268] Gdn_Pluggable->fireEvent();
    [/flex/storage/altis-background.fr/site/www/library/core/class.module.php:240] SideMenuModule->toString();
    [/flex/storage/altis-background.fr/site/www/library/core/class.controller.php:1364] Gdn_Module->render();
    [/flex/storage/altis-background.fr/site/www/applications/dashboard/views/admin.master.php:34] Gdn_Controller->renderAsset();
    [/flex/storage/altis-background.fr/site/www/library/core/class.controller.php:1853] PHP::include();
    [/flex/storage/altis-background.fr/site/www/library/core/class.controller.php:1314] Gdn_Controller->renderMaster();
    [/flex/storage/altis-background.fr/site/www/library/core/class.pluggable.php:199] Gdn_Controller->xRender();
    [/flex/storage/altis-background.fr/site/www/applications/dashboard/controllers/class.utilitycontroller.php:184] Gdn_Pluggable->__call();
    [/flex/storage/altis-background.fr/site/www/library/core/class.dispatcher.php:326] UtilityController->structure();
    [/flex/storage/altis-background.fr/site/www/index.php:44] Gdn_Dispatcher->dispatch();
    Variables in local scope:
    [Sql] 'select DISTINCT(fl.ForeignID) as NumFlaggedItems
    from 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 \'db336455_altisbackground.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 (
    )
    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.3
    PHP Version: 7.1.0
    Operating System: Linux
    Server Software: Apache/2.4.10 (Ubuntu)
    User Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 10_1_1 like Mac OS X) AppleWebKit/602.2.14 (KHTML, like Gecko) Version/10.0 Mobile/14B150 Safari/602.1
    Request Uri: /utility/structure
    Controller: PHP
    Method: trigger_error

  • harry_callahanharry_callahan New

    I have try tu launch your link but i have this message:

    Fatal Error in PHP.trigger_error();

    Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db336455_altisbackground.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: /flex/storage/altis-background.fr/site/www/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:
    /flex/storage/altis-background.fr/site/www/library/database/class.database.phpPHP::Gdn_ErrorHandler();
    [/flex/storage/altis-background.fr/site/www/library/database/class.database.php:412] PHP::trigger_error();
    [/flex/storage/altis-background.fr/site/www/library/database/class.sqldriver.php:1663] Gdn_Database->query();
    [/flex/storage/altis-background.fr/site/www/library/database/class.sqldriver.php:614] Gdn_SQLDriver->query();
    [/flex/storage/altis-background.fr/site/www/plugins/Flagging/class.flagging.plugin.php:34] Gdn_SQLDriver->get();
    [/flex/storage/altis-background.fr/site/www/library/core/class.pluginmanager.php:873] FlaggingPlugin->base_getAppSettingsMenuItems_handler();
    [/flex/storage/altis-background.fr/site/www/library/core/class.pluginmanager.php:786] Gdn_PluginManager->callEventHandler();
    [/flex/storage/altis-background.fr/site/www/library/core/class.pluggable.php:133] Gdn_PluginManager->callEventHandlers();
    [/flex/storage/altis-background.fr/site/www/applications/dashboard/modules/class.sidemenumodule.php:268] Gdn_Pluggable->fireEvent();
    [/flex/storage/altis-background.fr/site/www/library/core/class.module.php:240] SideMenuModule->toString();
    [/flex/storage/altis-background.fr/site/www/library/core/class.controller.php:1364] Gdn_Module->render();
    [/flex/storage/altis-background.fr/site/www/applications/dashboard/views/admin.master.php:34] Gdn_Controller->renderAsset();
    [/flex/storage/altis-background.fr/site/www/library/core/class.controller.php:1853] PHP::include();
    [/flex/storage/altis-background.fr/site/www/library/core/class.controller.php:1314] Gdn_Controller->renderMaster();
    [/flex/storage/altis-background.fr/site/www/library/core/class.pluggable.php:199] Gdn_Controller->xRender();
    [/flex/storage/altis-background.fr/site/www/applications/dashboard/controllers/class.utilitycontroller.php:184] Gdn_Pluggable->__call();
    [/flex/storage/altis-background.fr/site/www/library/core/class.dispatcher.php:326] UtilityController->structure();
    [/flex/storage/altis-background.fr/site/www/index.php:44] Gdn_Dispatcher->dispatch();
    Variables in local scope:
    [Sql] 'select DISTINCT(fl.ForeignID) as NumFlaggedItems
    from 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 \'db336455_altisbackground.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 (
    )
    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.3
    PHP Version: 7.1.0
    Operating System: Linux
    Server Software: Apache/2.4.10 (Ubuntu)
    User Agent: Mozilla/5.0 (iPhone; CPU iPhone OS 10_1_1 like Mac OS X) AppleWebKit/602.2.14 (KHTML, like Gecko) Version/10.0 Mobile/14B150 Safari/602.1
    Request Uri: /utility/structure
    Controller: PHP
    Method: trigger_error

  • K17K17 ✭✭✭

    Bonjour :)
    Peux-tu me détailler ton problème en français ?

  • vrijvlindervrijvlinder MVP

    It would seem that the mysql settings are wrong. Try to disable the flagging plugin.

    https://open.vanillaforums.com/discussion/32119/flagging-plugin-fatal-error

    ❌ ✊ ♥. ¸. ••. ¸♥¸. ••. ¸♥ ✊ ❌

  • harry_callahanharry_callahan New

    Après avoir ajouté toutes mes catégories, j ai publie un message mais lorsque j ai voulu valider erreur. Par contre en retournant à l index la publication c s'était bien faite. En voulant ouvrir la publi=erreur. La seule chose que je peux faire est modifie la publication.... je peux plus aller sur le menu admin je suis bloque.

    Je vais regarder la solution de l autre personne.

  • TimTim Vanilla Staff

    I'm willing to bet that he is not using MySQL at all.

    Vanilla Forums COO [GitHub, Twitter, About.me]

  • x00x00 MVP
    edited February 2017

    run SET global sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); in mysql and SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); for good measure.

    grep is your friend.

  • harry_callahanharry_callahan New

    @x00 said:
    run SET global sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); in mysql and SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); for good measure.

    I' mot permission for that. is db on online.net.

    Erreur

    Requête SQL : Documentation

    @sql_mode,'ONLY_FULL_GROUP_BY',''))

    MySQL a répondu: Documentation

    1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

  • x00x00 MVP

    you need to ask your host to help you.

    grep is your friend.

  • K17K17 ✭✭✭

    Je ne vois plus aucun problème aujourd'hui à ce niveau là @harry_callahan.
    Par contre, vu que ton forum est français, il faut que tu installes ce plugin: https://open.vanillaforums.com/addon/termsoflink-plugin
    qui ajoute un lien vers les conditions d'utilisation en bas de chaque page (remercions la CNIL).

Sign In or Register to comment.