Everything posted by Nathan Explosion
-
Converting from VB5?
-
Converting from VB5?
-
4.7.16 - pruneipaddresses task errors due to duplicate PRIMARY keys
Confirmed as resolving the issue.
-
Deleting IP Addresses does not work
But they may not, if the task is erroring out...
-
Is it possible to only have one theme for users to choose from?
Where's that? Happy to be blind on this one. Anyway...simply change the "Available for..." field so that it's only available to those you want to see it:
-
4.7.16 - pruneipaddresses task errors due to duplicate PRIMARY keys
Here are your reproduction steps... Login to a site Logout Change your IP address Login to the site again, ensuring same browser and account Set the "Remove IP addresses after" setting to whatever you want (I believe the minimum is 1 day) Wait that amount of time, then run the task. To reproduce it quicker, you're going to need to manipulate database records to change the last_seen value to meet the criteria. Potential fix: modify that primary key to include the last_seen value.
-
4.7.16 - pruneipaddresses task errors due to duplicate PRIMARY keys
-
4.7.16 - pruneipaddresses task errors due to duplicate PRIMARY keys
Reporting it as it just occurred on my live site... UPDATE `core_members_known_ip_addresses` `core_members_known_ip_addresses` SET `ip_address`='' WHERE ip_address != '' AND last_seen <1709136738 IPS\Db\Exception: Duplicate entry '0138fdaa72c8135e62b3487f5be7b11d-2970-' for key 'PRIMARY' (1062) #0 /home/fbaeefdf/live.ynwa.tv/system/Db/Db.php(1159): IPS\_Db->preparedQuery() #1 /home/fbaeefdf/live.ynwa.tv/applications/core/extensions/core/IpAddresses/Logins.php(33): IPS\_Db->update() #2 /home/fbaeefdf/live.ynwa.tv/system/Member/Member.php(6504): IPS\core\extensions\core\IpAddresses\_Logins->pruneIpAddresses() #3 /home/fbaeefdf/live.ynwa.tv/applications/core/tasks/pruneipaddresses.php(43): IPS\_Member::pruneAllLoggedIpAddresses() #4 /home/fbaeefdf/live.ynwa.tv/system/Task/Task.php(281): IPS\core\tasks\_pruneipaddresses->execute() #5 /home/fbaeefdf/live.ynwa.tv/applications/core/modules/admin/settings/advanced.php(751): IPS\_Task->run() #6 /home/fbaeefdf/live.ynwa.tv/system/Dispatcher/Controller.php(107): IPS\core\modules\admin\settings\_advanced->runTask() #7 /home/fbaeefdf/live.ynwa.tv/applications/core/modules/admin/settings/advanced.php(38): IPS\Dispatcher\_Controller->execute() #8 /home/fbaeefdf/live.ynwa.tv/system/Dispatcher/Dispatcher.php(153): IPS\core\modules\admin\settings\_advanced->execute() #9 /home/fbaeefdf/live.ynwa.tv/admin/index.php(13): IPS\_Dispatcher->run() #10 {main} I believe this is a knock-on effect of it NOT having been pruning the IP addresses correctly previously - the issue you'll have is that there could be multiple entries for a specific device_key and member_id, but with different IP addresses. Now that task has been fixed to do the pruning, when it tries to remove the IP address on those multiple entries, the PRIMARY key for each row will end up being the same as the key is made up of device_key, member_id, IP address (which is now blank) Sample content attached:core_members_known_ip_addresses.sql When the query in the task runs against that data, the error occurs: UPDATE `core_members_known_ip_addresses` `core_members_known_ip_addresses` SET `ip_address`='' WHERE ip_address != '' AND last_seen <1709135288
-
Combined Fluid View bug 4.7.16
- 4.7.16 - Combined Fluid View Shows Topics From All Forums (incl Clubs)
- Do you know about this virus?
If you are using Windows Defender then report it as a false positive back to Microsoft: https://www.microsoft.com/en-us/wdsi/filesubmission/- [Bug - 4.7.16 Beta 1] Combined Fluid View shows topics from the whole community
I'll be disabling that functionality until this is resolved then...just been alerted to a data leak (title of a private topic being visible) which is going to cause a few problems now that it's been seen. Test of a topic in a private forum, viewable by a normal member...- Costs for a second license
You pay for a new license, and then the renewals.- Setting up advertisements?
- Deleted content : number of days to delete for good ?
Go into the ACP and type delete into the search bar and click on the Permanently delete content result.- Program or application used for screenshots
Windows Snipping Tool Lightshot- Sudden influx of posts from Guest users, even though posting for guests is disabled?
It's designed to allow them...they can "Post before registering" as your members group has permissions to do so... If someone in your members group can post in a location where guests cannot, then guests will be able to post.- Sudden influx of posts from Guest users, even though posting for guests is disabled?
Turn off "Post before registering"- Sudden influx of posts from Guest users, even though posting for guests is disabled?
@LiamH - just checked your site as a guest; there are several forums open to allow guests to post new topics. I suggest you look at the permissions that the Guest group has for forums: You also have "Post before registering" enabled:- Errors when validating member accounts
Apply the patch...- Admin validation required but not set
OK. But it's likely to be that has happened All registrations go through the spam prevention settings, and depending on your configuration then an admin may need to validate the account.- Admin validation required but not set
Probably because your spam prevention settings dictate that a certain level requires admin involvement...- Pages unavailable?
Nathan Explosion replied to Tactus beheerder's post in a topic in Classic self-hosted technical helpDid you download and install it?- Mention Tags Cannot Be Removed on Mobile
GBoard is the default keyboard of the Google Android OS (it's on Pixel devices, it's on most OnePlus devices, plus others that don't massively deviate from the stock OS) 'Samsung Keyboard' is the native keyboard on the Samsung version of the Google Android OS, but can be overridden by the manual installation of GBoard from Google Play, just like SwiftKey is available for all Android devices.- Contact Us Form?
- 4.7.16 - Combined Fluid View Shows Topics From All Forums (incl Clubs)