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.

Update for critical security issue in PHPMailer included in release Vanilla 2.3.1
Please upgrade to 2.3 here. The 2.2 and earlier branches are no longer being updated.

Fatal Error in PHP.trigger_error();

edited July 18 in Vanilla 2.0 - 2.2

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ufk-web.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: /var/www/ufkclan.com/public_html/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:

/var/www/ufkclan.com/public_html/library/database/class.database.phpPHP::Gdn_ErrorHandler();

[/var/www/ufkclan.com/public_html/library/database/class.database.php:412] PHP::trigger_error();

[/var/www/ufkclan.com/public_html/library/database/class.sqldriver.php:1663] Gdn_Database->query();

[/var/www/ufkclan.com/public_html/library/database/class.sqldriver.php:614] Gdn_SQLDriver->query();

[/var/www/ufkclan.com/public_html/plugins/Flagging/class.flagging.plugin.php:34] Gdn_SQLDriver->get();

[/var/www/ufkclan.com/public_html/library/core/class.pluginmanager.php:873] FlaggingPlugin->base_getAppSettingsMenuItems_handler();

[/var/www/ufkclan.com/public_html/library/core/class.pluginmanager.php:786] Gdn_PluginManager->callEventHandler();

[/var/www/ufkclan.com/public_html/library/core/class.pluggable.php:133] Gdn_PluginManager->callEventHandlers();

[/var/www/ufkclan.com/public_html/applications/dashboard/modules/class.sidemenumodule.php:268] Gdn_Pluggable->fireEvent();

[/var/www/ufkclan.com/public_html/library/core/class.module.php:240] SideMenuModule->toString();

[/var/www/ufkclan.com/public_html/library/core/class.controller.php:1364] Gdn_Module->render();

[/var/www/ufkclan.com/public_html/applications/dashboard/views/admin.master.php:34] Gdn_Controller->renderAsset();

[/var/www/ufkclan.com/public_html/library/core/class.controller.php:1853] PHP::include();

[/var/www/ufkclan.com/public_html/library/core/class.controller.php:1314] Gdn_Controller->renderMaster();

[/var/www/ufkclan.com/public_html/library/core/class.pluggable.php:199] Gdn_Controller->xRender();

[/var/www/ufkclan.com/public_html/applications/dashboard/controllers/class.settingscontroller.php:936] Gdn_Pluggable->__call();

[/var/www/ufkclan.com/public_html/library/core/class.dispatcher.php:326] SettingsController->xIndex();

[/var/www/ufkclan.com/public_html/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 \'ufk-web.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 (
)

Comments

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator

    I guess you have to disable the "ONLY_FULL_GROUP_BY" sql mode.
    Run this SQL, if you do not know how to do it: SET sql_mode = '';

  • artur66artur66 New
    edited August 1

    Same problem here SQL query didn't change anything
    The error occurred on or near: /home/ppunka77/public_html/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:

    /home/ppunka77/public_html/library/database/class.database.phpPHP::Gdn_ErrorHandler();

    [/home/ppunka77/public_html/library/database/class.database.php:412] PHP::trigger_error();

    [/home/ppunka77/public_html/library/database/class.sqldriver.php:1663] Gdn_Database->query();

    [/home/ppunka77/public_html/library/database/class.sqldriver.php:614] Gdn_SQLDriver->query();

    [/home/ppunka77/public_html/applications/gallery/modules/class.tagcloudmodule.php:26] Gdn_SQLDriver->get();

    [/home/ppunka77/public_html/applications/gallery/modules/class.tagcloudmodule.php:32] TagCloudModule->getData();

    [/home/ppunka77/public_html/library/core/class.module.php:213] TagCloudModule->toString();

    [/home/ppunka77/public_html/library/core/class.modulecollection.php:45] Gdn_Module->render();

    [/home/ppunka77/public_html/library/core/class.modulecollection.php:69] Gdn_ModuleCollection->render();

    [/home/ppunka77/public_html/library/vendors/SmartyPlugins/function.asset.php:46] Gdn_ModuleCollection->toString();

    [/home/ppunka77/public_html/cache/Smarty/compile/vanilla^%%12^126^1262EA03%%default.master.tpl.php:57] PHP::smarty_function_asset();

    [/home/ppunka77/public_html/library/vendors/Smarty-2.6.25/libs/Smarty.class.php:1276] PHP::include();

    [/home/ppunka77/public_html/library/vendors/Smarty-2.6.25/libs/Smarty.class.php:1126] Smarty->fetch();

    [/home/ppunka77/public_html/library/core/class.smarty.php:144] Smarty->display();

    [/home/ppunka77/public_html/library/core/class.controller.php:1895] Gdn_Smarty->render();

    [/home/ppunka77/public_html/library/core/class.controller.php:1320] Gdn_Controller->renderMaster();

    [/home/ppunka77/public_html/library/core/class.pluggable.php:199] Gdn_Controller->xRender();

    [/home/ppunka77/public_html/applications/gallery/controllers/class.gallerycontroller.php:44] Gdn_Pluggable->__call();

    [/home/ppunka77/public_html/applications/gallery/controllers/class.gallerycontroller.php:44] GalleryController->render();

    [/home/ppunka77/public_html/applications/gallery/controllers/class.gallerycontroller.php:44] GalleryController->tagged();

    [/home/ppunka77/public_html/library/core/class.dispatcher.php:329] PHP::call_user_func_array();

    [/home/ppunka77/public_html/index.php:45] Gdn_Dispatcher->dispatch();

    Variables in local scope:

    [Sql] 'select v.*
    from GDN_TagStats v
    order by Galleries desc
    limit 10'

    [InputParameters] array (
    )

    [Options] array (
    'Type' => 'select',
    'Slave' => NULL,
    'ReturnType' => 'DataSet',
    )

    [ReturnType] 'DataSet'

    [tries] 2

    [try] 0

    [PDO] array (
    )

    [PDOStatement] false

    [state] 'HY000'

    [code] 1615

    [message] 'Prepared statement needs to be re-prepared'

    [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.2.1
    PHP Version: 5.5.38
    Operating System: Linux
    Server Software: Apache
    
  • vrijvlindervrijvlinder Papillon-Sauvage MVP

    Seems you deleted some files that are necessary...

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator

    No, your problem is totally different to the original question.

    You are using an application called "gallery" which provides a module called "tagcloudmodule" and the database query which causes the problem is

    select v.*
    from GDN_TagStats v
    order by Galleries desc
    limit 10
    

    It's hard to tell what's happening. And I don't understand "SQL query didn't change anything"

    vrijvlinder
Sign In or Register to comment.