Approval Queue Plus 3.6.4

Sim · May 12, 2024

Sim updated Approval Queue Plus with a new update entry:

3.5.1 bugfix for faulty upgrade

Fixes a critical upgrade bug (doesn't apply to new installs), where certain columns didn't get created

Sim · May 12, 2024

After updating to the latest version, I get this:

Code:

Server error log
XF\Db\Exception: MySQL statement prepare error [1054]: Unknown column 'iso_code' in 'field list' src/XF/Db/AbstractStatement.php:230
Generated by: Unknown account 12. May 2024 at 07:35
Stack trace
INSERT  INTO `xf_aqp_user_data` (`user_id`, `user_agent`, `iso_code`, `cf_location`) VALUES (?, ?, ?, ?)
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL statement...', 1054, '42S22')
#1 src/XF/Db/Mysqli/Statement.php(40): XF\Db\Mysqli\Statement->getException('MySQL statement...', 1054, '42S22')
#2 src/XF/Db/Mysqli/Statement.php(56): XF\Db\Mysqli\Statement->prepare()
#3 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#4 src/XF/Db/AbstractAdapter.php(219): XF\Db\AbstractAdapter->query('INSERT  INTO `x...', Array)
#5 src/XF/Mvc/Entity/Entity.php(1526): XF\Db\AbstractAdapter->insert('xf_aqp_user_dat...', Array, false)
#6 src/XF/Mvc/Entity/Entity.php(1258): XF\Mvc\Entity\Entity->_saveToSource()
#7 src/addons/Hampel/ApprovalQueuePlus/XF/Service/User/Registration.php(30): XF\Mvc\Entity\Entity->save()
#8 src/XF/Service/ValidateAndSavableTrait.php(42): Hampel\ApprovalQueuePlus\XF\Service\User\Registration->_save()
#9 src/XF/Pub/Controller/Register.php(429): XF\Service\User\Registration->save()
#10 src/addons/OzzModz/Spaminator/XF/Pub/Controller/Register.php(134): XF\Pub\Controller\Register->actionRegister()
#11 src/addons/OzzModz/SpamEmailAddress/XF/Pub/Controller/Register.php(28): OzzModz\Spaminator\XF\Pub\Controller\Register->actionRegister()
#12 src/XF/Mvc/Dispatcher.php(352): OzzModz\SpamEmailAddress\XF\Pub\Controller\Register->actionRegister(Object(XF\Mvc\ParameterBag))
#13 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('XF:Register', 'Register', Object(XF\Mvc\RouteMatch), Object(OzzModz\SpamEmailAddress\XF\Pub\Controller\Register), NULL)
#14 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(OzzModz\SpamEmailAddress\XF\Pub\Controller\Register), NULL)
#15 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#16 src/XF/App.php(2487): XF\Mvc\Dispatcher->run()
#17 src/XF.php(524): XF\App->run()
#18 index.php(20): XF::runApp('XF\\Pub\\App')
#19 {main}

Oh boy, sorry about that!

Install/upgrade testing is always tricky - can't easily test every combination and that's were bugs slip in!

Please install 3.5.1 - this should fix the missing tables.

BassMan · May 12, 2024

No problem at all. Thank you for the quick fix.

Sim · Oct 16, 2024

Sim updated Approval Queue Plus with a new update entry:

3.5.2 bugfix - missing admin permissions

Minor bugfix to explicitly enforce admin permissions on admincp tools

Read the rest of this update entry...

ekool · Jan 20, 2025

I don't know if I saw something for this modification or for something else, but emails aren't showing up when a user goes into the approval queue. I'm looking at all the permissions and I can't find a way to show the email address in the tool. It only shows

[email protected]

What is the fix for this?

Sim · Jan 20, 2025

ekool said:
I don't know if I saw something for this modification or for something else, but emails aren't showing up when a user goes into the approval queue. I'm looking at all the permissions and I can't find a way to show the email address in the tool. It only shows

[email protected]

What is the fix for this?

I don't know where that comes from? It doesn't come from my addon.

You should be able to see the email address in the approval queue if you're a moderator with "Approve / reject users" (to see the queue) and "Bypass user privacy" permissions. If you don't have this permission, you simply won't see the email address.

There's nothing in my addon which changes the email display to say "[email protected]"

Dragonfruit · Jan 20, 2025

I was just googling around on this, and I came across another Xenforo forum with a thread that had posts with “email protected”, clicking on it brought me to a page that it’s protected by cloud flare. So, maybe it’s caused by that?

ekool · Jan 20, 2025

Dragonfruit said:
I was just googling around on this, and I came across another Xenforo forum with a thread that had posts with “email protected”, clicking on it brought me to a page that it’s protected by cloud flare. So, maybe it’s caused by that?

Ahhh yes, there is a Cloudflare option per domain.

Email Address Obfuscation · Cloudflare Web Application Firewall (WAF) docs

By enabling Cloudflare Email Address Obfuscation, email addresses on your web page will be hidden from bots, while keeping them visible to humans. In fact, there are no visible changes to your website for visitors.

developers.cloudflare.com

Thank you for that, good call!

chrisf · Feb 22, 2025

Our forum requires members to use their real name and submit their birthdate (which we do not show on the forums) for verification. I was wondering if there was a way to have approval queue plus show the birth day and age in the approval form so we do not have to click into the user account to see what they submitted. Thanks for the great add-on.

Seeker-Smith · Feb 23, 2025

chrisf said:
Our forum requires members to use their real name and submit their birthdate (which we do not show on the forums) for verification. I was wondering if there was a way to have approval queue plus show the birth day and age in the approval form so we do not have to click into the user account to see what they submitted. Thanks for the great add-on.

It would be handy to spot obvious fakes.

Sim · Feb 23, 2025

chrisf said:
Our forum requires members to use their real name and submit their birthdate (which we do not show on the forums) for verification. I was wondering if there was a way to have approval queue plus show the birth day and age in the approval form so we do not have to click into the user account to see what they submitted. Thanks for the great add-on.

Yes, that's a good idea - won't be difficult to add.

Not sure when I'll get to it - really busy at the moment, but I'll put it on the to-do list.

Seeker-Smith · Feb 23, 2025

Sim said:
Yes, that's a good idea - won't be difficult to add.

Not sure when I'll get to it - really busy at the moment, but I'll put it on the to-do list.

Many thanks!

chrisf · Feb 23, 2025

Thank you Simon!

Sim · Oct 6, 2026

Sim updated Approval Queue Plus with a new update entry:

v3.6.2 bugfixes and improvements

3.6.2 (2026-10-04)

fixed: registration failed for any client that sent no User-Agent header — browsers always send one, so ordinary sign-ups were unaffected, but a scripted or API registration was refused

fixed: clearing the Delete User Agent data after box no longer deletes every approved user's recorded data on the next scheduled clean up

3.6.1 (2026-09-22)

the Cloudflare location in the...

Read the rest of this update entry...

Sim · Oct 10, 2026

Sim updated Approval Queue Plus with a new update entry:

v3.6.3 - extra validation

3.6.3 (2026-10-10)

now requires PHP 7.4 or later — above the PHP 7.0 that XenForo 2.2 itself requires, and needed by the new command line checks below. XenForo 2.3 already requires PHP 7.2, so this affects only a XenForo 2.2 forum still running PHP 7.3 or older

new: two command line checks. approval-queue-plus:config prints what the Approval Queue is set up to show and what has been recorded; approval-queue-plus:validate...

Read the rest of this update entry...

Sim · Oct 12, 2026

Sim updated Approval Queue Plus with a new update entry:

v3.6.4 - bugfixes

3.6.4 (2026-10-12)

fixed: the scheduled clean up could exhaust PHP's memory and delete nothing, on a forum holding a large backlog of recorded registration data. It now deletes in batches, and asks the database only for the user ids it needs rather than loading whole rows, so how much one run can get through no longer depends on how much has accumulated

a backlog builds up on any forum that has the clean up switched off, or that has had Delete User Agent...

Read the rest of this update entry...

Approval Queue Plus 3.6.4

Sim

Well-known member

Sim

Well-known member

BassMan

Well-known member

Sim

Well-known member

ekool

Well-known member

Sim

Well-known member

Dragonfruit

Well-known member

ekool

Well-known member

Email Address Obfuscation · Cloudflare Web Application Firewall (WAF) docs

chrisf

Member

Seeker-Smith

Well-known member

Sim

Well-known member

Seeker-Smith

Well-known member

chrisf

Member

Sim

Well-known member

3.6.2 (2026-10-04)

3.6.1 (2026-09-22)

Sim

Well-known member

3.6.3 (2026-10-10)

Sim

Well-known member

3.6.4 (2026-10-12)

Similar threads

We value your privacy

Approval Queue Plus 3.6.4

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Member

Well-known member

Well-known member

Well-known member

Member

Well-known member

3.6.2 (2026-10-04)​

3.6.1 (2026-09-22)​

Well-known member

3.6.3 (2026-10-10)​

Well-known member

3.6.4 (2026-10-12)​

Similar threads

We value your privacy

3.6.2 (2026-10-04)

3.6.1 (2026-09-22)

3.6.3 (2026-10-10)

3.6.4 (2026-10-12)