Jump to content

Emsi

Clients
  • Posts

    25
  • Joined

  • Last visited

 Content Type 

Downloads

Release Notes

IPS4 Guides

IPS4 Developer Documentation

Invision Community Blog

Development Blog

Deprecation Tracker

Providers Directory

Forums

Events

Store

Gallery

Posts posted by Emsi

  1. On 12/17/2016 at 10:36 PM, Ryan H. said:

    ... mysql 5.7 (or your configuration thereof) sucks.

    Guess that serves me right for trying to fix an issue I can't actually test.

     

    Defaults have changed to enforce a more strict adherence to the SQL specifications. In any case, we moved to MariaDB and the issues disappeared. You may still want to look into the 5.7 issues though and set up a VM. Because it is the default MySQL server shipped by various large server distributions. Ubuntu LTS being one of them.

  2. Tried new version 3.1.8. Attempt to rebuild the cache leads to this:

    SELECT `tag_aai_lookup`, `tag_meta_app`, `tag_meta_area`, `tag_meta_id`, `tag_id` FROM `core_tags` GROUP BY `tag_meta_id` ORDER BY `tag_id` ASC LIMIT 0,100
    IPS\Db\Exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'support.core_tags.tag_aai_lookup' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055)
    #0 /home/support/public/system/Db/Select.php(346): IPS\_Db->preparedQuery('/*IPS\\advancedt...', Array)
    #1 /home/support/public/system/Db/Select.php(408): IPS\Db\_Select->runQuery()
    #2 /home/support/public/applications/advancedtagsprefixes/modules/admin/manage/tools.php(277): IPS\Db\_Select->rewind()
    #3 [internal function]: IPS\advancedtagsprefixes\modules\admin\manage\_tools->rebuild()
    #4 /home/support/public/system/Dispatcher/Controller.php(85): call_user_func(Array)
    #5 /home/support/public/applications/advancedtagsprefixes/modules/admin/manage/tools.php(26): IPS\Dispatcher\_Controller->execute()
    #6 /home/support/public/system/Dispatcher/Dispatcher.php(129): IPS\advancedtagsprefixes\modules\admin\manage\_tools->execute()
    #7 /home/support/public/3uskbvr1xqi24czhwy51/index.php(13): IPS\_Dispatcher->run()
    #8 {main}

     

  3. Any attempt to resync the cache and get proper badges in the topic list results in this error:

    SELECT DISTINCT `tag_aai_lookup`, `tag_meta_app`, `tag_meta_area`, `tag_meta_id` FROM `core_tags` ORDER BY `tag_id` ASC LIMIT 0,100
    IPS\Db\Exception: Expression #1 of ORDER BY clause is not in SELECT list, references column 'support.core_tags.tag_id' which is not in SELECT list; this is incompatible with DISTINCT (3065)
    #0 /home/support/public/system/Db/Select.php(346): IPS\_Db->preparedQuery('/*IPS\\advancedt...', Array)
    #1 /home/support/public/system/Db/Select.php(408): IPS\Db\_Select->runQuery()
    #2 /home/support/public/applications/advancedtagsprefixes/modules/admin/manage/tools.php(276): IPS\Db\_Select->rewind()
    #3 [internal function]: IPS\advancedtagsprefixes\modules\admin\manage\_tools->rebuild()
    #4 /home/support/public/system/Dispatcher/Controller.php(85): call_user_func(Array)
    #5 /home/support/public/applications/advancedtagsprefixes/modules/admin/manage/tools.php(26): IPS\Dispatcher\_Controller->execute()
    #6 /home/support/public/system/Dispatcher/Dispatcher.php(129): IPS\advancedtagsprefixes\modules\admin\manage\_tools->execute()
    #7 /home/support/public/3uskbvr1xqi24czhwy51/index.php(13): IPS\_Dispatcher->run()
    #8 {main}

    It appears someone reported this exact problem before and it seems to be related to MySQL 5.7 almost a year (!) ago. Is there any way to fix it?

×
×
  • Create New...