Emsi
-
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
-
-
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}
-
16 hours ago, Ryan H. said:
What version of AT&P are you running?
3.1.7 according to the applications list. I just bought and downloaded it from the marketplace yesterday. IPS version is 4.1.17.1.
-
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?
Advanced Tags & Prefixes - IPS 4.x
in Marketplace
Posted
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.