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:

18 hours ago, Flow0815 said:

Seems like the actual version is not working with IPB 4.1.19.1 because of application.json not readable or broken. Tested just the github one but i won't buy if not sure if it's working. It seems that it does not. Anybody can confirm? Or is the buyable version fixed?

Greetz

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?

On 9/9/2016 at 0:36 AM, naXe90 said:

ARMA 3 is supported as Armed Assault 3  

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

2 hours ago, PirateCaptain said:

I'm having an annoying problem here, I'm CERTAIN we are entering the correct credentials for the teamspeak server yet ips throws me this

Any ideas what could be cause?

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?

On 6/9/2016 at 10:23 PM, kotaco said:

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?

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?

4 hours ago, Ahmad E. said:

Just updated the APP, should be fixed.

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. 

5 hours ago, almax said:

Maybe not change, but remove.  My only concern is that a user will get a hold of another (potentially higher rank) users UUID and then register the other persons UUID as their own to knock that person out of their actual higher rank.  This would then lead to a situation where I can not ban the user because it would ban the actual legit user, and I can not fix the legit user's rank in TS3 because the integration would just knock him back down.

Also, question as to how the ban works.  Does it just ban the UUID or does it add a ban for the IP as well?  I ask because it is very easy to UUID spoof to avoid bans, not AS easy (but still somewhat easy) to bypass the IP ban.

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? 

On 5/28/2016 at 1:20 PM, Ahmad E. said:

Planning to add it along with the TS viewer in the next update  

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?

Just now, Ahmad E. said:

That functionality has already been added
There is an option to "remove groups" or not to. If you set it to yes, TS users will only be assinged the groups that they have on the forum, so any additional groups they may have will be removed. If set to no, groups will never be removed from TS, so if they had additinal groups they won't be removed only new ones assigned.

It is not stored in profile fields, it's stored in the database and is only shown to the user. But I think @Valthos is referring to situations where a forum does get hacked or something similar.

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)

2 minutes ago, jackflash said:

We haven't heard back from the author since July.  Is someone taking this app over?

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.