kotaco

Getting this error after latest update: SELECT *, item_id FROM `core_solved_index` LEFT JOIN `forums_topics` ON core_solved_index.item_id = forums_topics.tid WHERE core_solved_index.app = 'forums' AND 1=1 GROUP BY `item_id` ORDER BY solved_date DESC LIMIT 0,5 IPS\Db\Exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '***_invision.core_solved_index.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055) #0 /home/**/public_html/system/Db/Select.php(383): IPS\_Db->preparedQuery('/****_invi...', Array, true) #1 /home/**/public_html/system/Db/Select.php(441): IPS\Db\_Select->runQuery() #2 /home/**/public_html/applications/famewall/modules/front/famewall/famewall.php(157): IPS\Db\_Select->rewind() #3 /home/**/public_html/system/Dispatcher/Controller.php(101): IPS\famewall\modules\front\famewall\_famewall->manage() #4 /home/**/public_html/applications/famewall/modules/front/famewall/famewall.php(35): IPS\Dispatcher\_Controller->execute() #5 /home/**/public_html/system/Dispatcher/Dispatcher.php(152): IPS\famewall\modules\front\famewall\_famewall->execute() #6 /home/**/public_html/index.php(13): IPS\_Dispatcher->run() #7 {main}

We utilize a very large gallery and at times there is a need for some mass cleanup. We have noticed the following items could be improved: Currently there is no option to select multiple images to change owner, must be done one by one. You can hide/delete/etc, but not alter ownership. Currently there is no option to move images into another users album if moderator/admin. You can only move them into albums you have created. If an album has ownership changed, there is no option to apply that change to the images inside the album. Therefore the album is under a new owner, but the images remain under the original album owner. This is ok in some cases, but undesirable in others, an option would be helpful here.

Unsure if this is known, but working on a fresh install and I noticed the Guidelines / Privacy Policy / TOS pages all have this issue where the content width is not matching the rest of the site:

Works for me on 4.1.19.1

Does this work with IP.Pages? I use forums for my comments on records in my IP.Pages database and am trying to set a prefix for each topic created when an article is submitted, but no prefix is saved upon submission. However I can manually edit those topics to set a prefix and it works fine. So it seems like something isn't saving in IP.Pages when creating a new record.

Does this include a feature that resets a goal after the end date is reached? For example, we accept donations towards monthly sever fees, is it possible to reset the goal each month automatically?

Saw that and had a doh moment

Can a game server type be added by request? (ARMA 3)

Learned that in order to use the group sync feature without getting your serverquery banned for flooding, add your forum's IP to the TS3 whitelist

Just throwing it out there, but you're using the serverquery admin user name and pass, not the actual admin's user and pass correct?

Bump? Anybody out there?

I've noticed users occasionally have groups removed, not sure if it was due to a TS3 server restart kicking users and they auto reconnected and something got confused. These users lost their primary groups, but the secondary groups remained. I noticed going to the affected users and saving their accounts as if I was editing something in the AdminCP reset it on TS3 and the icons reappeared. This got me wondering if there is a way to manually resync the TS3 UUIDs to their assigned groups, or if this is done automatically at center intervals? (I didn't see a task for it). Or is it only done when a change is made to a user account?

Yes the issue is resolved, thanks for the quick response!

Starting to get pop up reports of these errors which render the site unusable to the affected users. When I disable the TS3 integration the problem resolves. Double checked the groups of the members reporting the issue and they are set appropriately in the AdminCP. They did not have the chance to enter their UUID prior to receiving this error according to them. OutOfRangeException: (0) #0 /home/user/public_html/system/Member/Group.php(104): IPS\Patterns\_ActiveRecord::load(0, NULL, NULL) #1 /home/user/public_html/init.php(434) : eval()'d code(32): IPS\Member\_Group::load(0) #2 /home/user/public_html/init.php(434) : eval()'d code(9): IPS\Dispatcher\ts3integration_hook_ts3_force_uuid->init() #3 /home/user/public_html/system/Dispatcher/Dispatcher.php(86): IPS\Dispatcher\hook342->init() #4 /home/user/public_html/index.php(13): IPS\_Dispatcher::i() #5 {main} #0 /home/user/public_html/init.php(498): IPS\_Log::log('OutOfRangeExcep...', 'uncaught_except...') #1 [internal function]: IPS\IPS::exceptionHandler(Object(OutOfRangeException)) #2 {main} Had to disable application for now

Thank you for this update. A bug was breaking my automated rules and I was starting to panic moments before you posted it and now everything is resolved! And boy, when you said force uses, you really meant it! lol. I signed in as another user to see what the notification would look like and got trapped in there, wouldn't even let me switch back to admin lol.

How would someone be able to see another users UUID through this app since its all based in account settings rather than profile fields which could be accidentally displayed publicly?

Sounds good, one request would be to allow Admin to pick what groups to enforce. For example, I only care to force my clan members to do this, I don't mind if non-clan affiliated members don't

Quick question I've got my TS3 server all set up and the ports open so it now connects properly. Yay. But when I got to edit member groups it only shows limited default group options, but as you can see all the server groups are in place. Is there something I need to do to in order for that to sync up?

Sold. Thank you sir.

Couple of presale questions to clarify. We use two different groups on TS3 to identify our members. Their primary group of course to set their permissions, in addition to a secondary group that is just for the ranks. So Primary Group = Officer, Secondary Group = Captain for example. This matches our forums precisely. Will this integration (I know you said your working on it) when complete, automatically adjust their TS3 groups/ranks when they are adjusted on the forums? I also don't see an issue with the UID storage, profile fields can be set to be visible to the admin and that user only which is plenty secure for me.

Its still working fine for me, but I don't use many of the topic display options and stuff like that. So it may just be a template change in there in the latest update doesn't agree with the code.

Suggestion: All awards are required to to have reason listed upon creation in the AdminCP. When awarding on front end, a reason is not required, so awards can show in profiles with no description as to what they are or why aside from image and title. Can a setting be added to opt that front end awarding does not utilize a reason and instead the reason is always automatically applied from the listing set in the AdminCP? This would help with consistency on a site where many users have the ability to award. We utilize our award system similar to that of steam achievements, so everyone is awarded for the same reason when something is accomplished.

Installed fine, when trying to add feedback a 500 error upon submission. Further, when attempting to paste a link to the topic being referenced in the submission only about 3 characters of the url show. Running 4.1.x (latest version)

To clarify, he hasn't replied in this thread since July. He's still an active user here.

One thing I'm noticing, not sure if it's a bug, but when reorder primary group is enabled and the user is only a member of 1 group, the icon does not display. Works perfectly if they are in more than 1 group though.