Approval Queue Plus 3.5.2

[Sim]

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

Read the rest of this update entry...

 

[Sim]

After updating to the latest version, I get this:

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]

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

 

[Sim]

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]

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]

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]

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]

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]

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]

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]

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]

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]

Thank you Simon!