A bug has been discovered which caused the "Interest" cron job to log transaction entries for for all members even if the interest feature was disabled. Depending on the size of your forum, this could cause your xf_dbtech_shop_transactionlog table to grow out of control.
I have patched every available download starting with v6.0.0 onwards, so even if your license has expired you should still be able to download the fix.
The only file changed is
After uploading the fix, you may wish to clean out your database, especially if you plan to upgrade to XF2 and the upcoming v6.1, which will make significant alterations to the transaction log table.
In order to clean up your database, please execute this query:
Very large forums may wish to run this query via the command line, as it is not guaranteed to work via web interfaces like phpMyAdmin.SQL:
DELETE FROM xf_dbtech_shop_transactionlog WHERE action = 'interest' AND info LIKE '%s:6:"amount";d:0;}';
After running this query, you may also wish to optimise the table by executing this query:
This will help speed things up, especially if a large amount of data was deleted.SQL:
OPTIMIZE TABLE xf_dbtech_shop_transactionlog;
Sorry about this
What is happening?
On the 11th of July 2018, XenForo published their Resource Guidelines aimed at ensuring performance & stability of XenForo modifications. At the moment, this product does not meet these standards, due to the fact that this product has been engineered to allow the core code to run on both XenForo 1 and XenForo 2.
As a result, I am beginning work on re-engineering this product to become a "native" XenForo 2 modification. At this point in time, there are no plans to re-engineer the XenForo 1 version, as the guidelines appear to target XF2 specifically.
What does this mean for the XF1 version?
Given that I will no longer be able to produce new features for XF1 and XF2 simultaneously without also doubling the work, the version numbers for the XF1 and XF2 versions may diverge going forward. The primary focus of development will be the XenForo 2 version of this product. Support for the XF1 version is NOT ending, and you will continue to be able to download the XF1 version alongside the XF2 version free of charge. Whether I will bump the XF1 version's version number to be in line with XF2 is undecided at this time.
What does this mean for the XF2 version?
First of all, I want to be clear that you will NOT have to uninstall the existing XF2 version in order to continue using this product going forward. I will be releasing beta versions of the re-engineered XF2 version as I finish working on them. I will need your help testing the various features and combinations of features in order to ensure the Gold version is as stable as possible.
When will this update be released?
Unfortunately it is not possible for me to give an ETA on when these updates will be completed, as it depends on the complexity of each individual modification.
Will this be a paid upgrade?
If you have an active license at the time of release, you will be able to download the new version free of charge.
I would also like to ask for your patience while I work on this update. My ability to fix bugs in the existing released version may be diminished, depending on the complexity of the issue.
This release fixes a few lingering issues from the 6.0.3 update.
Complete Change Log
Fix: [XF1] Fixed an issue where the item info template was missing
Fix: [XF2] Fixed an issue where the lottery draw cron job was missing
This release fixes a few lingering issues from the 6.0.2 update.
Special thanks to Siropu for helping me fix the incompatibility between our two mods
Complete Change Log
Fix: Phrase fixes in the front-end for certain items
Fix: Fixed an issue where Post Style would not apply to posts if Siropu's Ads Manager was installed.
This release fixes a few lingering issues from the 6.0.1 update.
Complete Change Log
Fix: Single use flag for the Post Style item would disable the Configure link
Fix: Phrase fixes in the AdminCP for certain items
Fix: Fixed an issue where certain URL parameters would not work correctly if content titles were disabled
Feature: Conversations notifying users that they have received a gift will now include a link to the Active/Hidden settings panel
Change: The "No Configuration" checkbox will no longer be displayed when gifting an item if reconfigure is turned off in the item settings.
Change: Improved the display for messages along with gifted items