Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Try Vanilla Forums Cloud product

Ready to contribute?

Amazing! Sign our contributors' agreement and then join us on GitHub.

Vanilla 2.3 fully supports PHP 7. Get it now!

Strong issue

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 I'm not a SuperHero; I just like wearing tights... Moderator
    edited February 10

    @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é.

  • Bonsoir

    merci pour votre aide.

    le message detaille:


    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 (
    )

  • 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 Papillon-Sauvage MVP

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

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

  • 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

  • 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 Français / FRENCH - http://forums.kraftgame.eu/ La Rochelle ✭✭

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

  • vrijvlindervrijvlinder Papillon-Sauvage MVP
  • 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 Operations Vanilla Staff

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

    Vanilla Forums Senior Developer [GitHub, Twitter, About.me]

  • x00x00 MVP
    edited February 12

    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.

  • @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

  • you need to ask your host to help you.

    grep is your friend.

  • K17K17 Français / FRENCH - http://forums.kraftgame.eu/ La Rochelle ✭✭

    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.