[Andrew] Moderator Panel 2.0.9

[Mr Lucky]

AndrewSimm updated [Andrew] Moderator Panel with a new update entry:

UPDATED: Check for spam cleaner log instead of spam cleaner phrase for when not showing spam cleaned users on banned

Many thanks Andrew - works perfectly in the main banned user list in the side navigation, but the Recently banned users dashboard widget still showing spam cleaned banned users.

 

[AndrewSimm]

Many thanks Andrew - works perfectly in the main banned user list in the side navigation, but the Recently banned users dashboard widget still showing spam cleaned banned users.

I see the issue. it will be fixed in the next release this coming weekend.

 

[Mr Lucky]

Error when changing user note to a newly created category (cat ID =4). NB: only happens with one specific user, is OK when changing other user notes to this category:

F\Db\Exception: MySQL query error [1690]: BIGINT UNSIGNED value is out of range in '`caf_15_2`.`xf_andrew_mp_user_note_category`.`use_count` - 1' src/XF/Db/AbstractStatement.php:230
Generated by: Pete Thomas Aug 14, 2024 at 11:48 AM
Stack trace
                    UPDATE xf_andrew_mp_user_note_category
                    SET use_count = use_count - 1
                    WHERE note_category_id = ?
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1690, '22003')
#1 src/XF/Db/Mysqli/Statement.php(78): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1690, '22003')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/addons/Andrew/ModeratorPanel/Entity/UserNote.php(84): XF\Db\AbstractAdapter->query('
              ...', 3)
#4 src/XF/Mvc/Entity/Entity.php(1282): Andrew\ModeratorPanel\Entity\UserNote->_postSave()
#5 src/addons/Andrew/ModeratorPanel/Pub/Controller/UserNote.php(124): XF\Mvc\Entity\Entity->save()
#6 src/XF/Mvc/Dispatcher.php(352): Andrew\ModeratorPanel\Pub\Controller\UserNote->actionSave(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('Andrew\\Moderato...', 'Save', Object(XF\Mvc\RouteMatch), Object(Andrew\ModeratorPanel\Pub\Controller\UserNote), NULL)
#8 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Andrew\ModeratorPanel\Pub\Controller\UserNote), NULL)
#9 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2485): XF\Mvc\Dispatcher->run()
#11 src/XF.php(524): XF\App->run()
#12 index.php(20): XF::runApp('XF\\Pub\\App')
#13 {main}
Request state
array(4) {
  ["url"] => string(33) "/moderatorpanel/user-notes/2/save"
  ["referrer"] => string(52) "https://cafesaxophone.com/moderatorpanel/user-notes/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(9) {
    ["_xfToken"] => string(8) "********"
    ["_xfInlineEdit"] => string(1) "1"
    ["message_html"] => string(33) "<p>Troll of the highest order</p>"
    ["noteCategory"] => string(1) "4"
    ["noteList"] => string(1) "1"
    ["user_id"] => string(4) "6736"
    ["_xfRequestUri"] => string(27) "/moderatorpanel/user-notes/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

 

[AndrewSimm]

Error when changing user note to a newly created category (cat ID =4). NB: only happens with one specific user, is OK when changing other user notes to this category:

F\Db\Exception: MySQL query error [1690]: BIGINT UNSIGNED value is out of range in '`caf_15_2`.`xf_andrew_mp_user_note_category`.`use_count` - 1' src/XF/Db/AbstractStatement.php:230
Generated by: Pete Thomas Aug 14, 2024 at 11:48 AM
Stack trace
                    UPDATE xf_andrew_mp_user_note_category
                    SET use_count = use_count - 1
                    WHERE note_category_id = ?
------------

#0 src/XF/Db/Mysqli/Statement.php(198): XF\Db\AbstractStatement->getException('MySQL query err...', 1690, '22003')
#1 src/XF/Db/Mysqli/Statement.php(78): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1690, '22003')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/addons/Andrew/ModeratorPanel/Entity/UserNote.php(84): XF\Db\AbstractAdapter->query('
              ...', 3)
#4 src/XF/Mvc/Entity/Entity.php(1282): Andrew\ModeratorPanel\Entity\UserNote->_postSave()
#5 src/addons/Andrew/ModeratorPanel/Pub/Controller/UserNote.php(124): XF\Mvc\Entity\Entity->save()
#6 src/XF/Mvc/Dispatcher.php(352): Andrew\ModeratorPanel\Pub\Controller\UserNote->actionSave(Object(XF\Mvc\ParameterBag))
#7 src/XF/Mvc/Dispatcher.php(258): XF\Mvc\Dispatcher->dispatchClass('Andrew\\Moderato...', 'Save', Object(XF\Mvc\RouteMatch), Object(Andrew\ModeratorPanel\Pub\Controller\UserNote), NULL)
#8 src/XF/Mvc/Dispatcher.php(115): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Andrew\ModeratorPanel\Pub\Controller\UserNote), NULL)
#9 src/XF/Mvc/Dispatcher.php(57): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#10 src/XF/App.php(2485): XF\Mvc\Dispatcher->run()
#11 src/XF.php(524): XF\App->run()
#12 index.php(20): XF::runApp('XF\\Pub\\App')
#13 {main}
Request state
array(4) {
  ["url"] => string(33) "/moderatorpanel/user-notes/2/save"
  ["referrer"] => string(52) "https://cafesaxophone.com/moderatorpanel/user-notes/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(9) {
    ["_xfToken"] => string(8) "********"
    ["_xfInlineEdit"] => string(1) "1"
    ["message_html"] => string(33) "<p>Troll of the highest order</p>"
    ["noteCategory"] => string(1) "4"
    ["noteList"] => string(1) "1"
    ["user_id"] => string(4) "6736"
    ["_xfRequestUri"] => string(27) "/moderatorpanel/user-notes/"
    ["_xfWithData"] => string(1) "1"
    ["_xfResponseType"] => string(4) "json"
  }
}

Can you walk me through how you created this error. I am having a hard time replicating.

 

[Mr Lucky]

Can you walk me through how you created this error. I am having a hard time replicating.

It affects only one member (so far). If I edit her user notes (e.g. edit text, or change category) I get the error when trying to save. It is odd of course because I was able to create the user note in the first place. It doesn't happen on other users created be fire or after this one. She was a particularly egregious troll so maybe it's a curse.

 

[AndrewSimm]

It affects only one member (so far). If I edit her user notes (e.g. edit text, or change category) I get the error when trying to save. It is odd of course because I was able to create the user note in the first place. It doesn't happen on other users created be fire or after this one. She was a particularly egregious troll so maybe it's a curse.

What appears to be the issue is the note count for that category is going negative. When you check note categories in the admin panel do you see a number greater than 0 beside any category used?

 

[Mr Lucky]

When you check note categories in the admin panel do you see a number greater than 0 beside any category used?

Thing is the error happens even without changing category, any kind of edit to the user note and then try to save causes at the error.

 

[AndrewSimm]

View attachment 309139

Thing is the error happens even without changing category, any kind of edit to the user note and then try to save causes at the error.

It's because user note categories are checked on the save of an user note. Do your counts align with actual?

 

[Mr Lucky]

It's because user note categories are checked on the save of an user note. Do your counts align with actual?

You mean two the counts in ACP align with actual categories in the mod panel. No they don't

 

[Mr Lucky]

I have now deleted all categories, started again and seems to be OK. Counts show as expected and no issues with editing so far.

 

[AndrewSimm]

FYI - I am testing 4 fixes on my large site and should have the updated version released soon.

 

[AndrewSimm]

AndrewSimm updated [Andrew] Moderator Panel with a new update entry:

Version 2.0.8

FIXED: Updated recently banned users on dashboard with some show spam user logic as banned user list
FIXED: Update andrew_reg_country to allow null on entity to prevent error with NF Tickets
FIXED: Refactored how user note category counts are updated to prevent rare scenario of having a negative number
FIXED: Missing code in search users by IP address

Read the rest of this update entry...

 

[cloudpro]

Hi

Thanks for your great addon.

https://xxxxxx/moderatorpanel/moderator-log/

You cannot click and know what you did and to whom

 

[cloudpro]

This is in the mod panel. Any click goes to a home page and not the user or anything else.

 

[AndrewSimm]

This is in the mod panel. Any click goes to a home page and not the user or anything else.

I don't understand what you are saying. Can you clarify?

 

[cloudpro]

Does the mod panel enable to be able to click on the logs ?

Ill ask my coder to clarify.

 

[AndrewSimm]

Does the mod panel enable to be able to click on the logs ?

Ill ask my coder to clarify.View attachment 309563

Yes, I am able to click on the log entries. They should take you to the entry.

 

[cloudpro]

OK cool. Thank you for a great addon....it is awesome.

It must be our own addons. Ill ask @xfcoder for clarification.

 

[gigipmc]

Solved, the reputation add-on is not creating a content_url entry in the moderator log hence the redirect to the home page. We'll patch that add-on to create them.

 

[cloudpro]

Solved, the reputation add-on is not creating a content_url entry in the moderator log hence the redirect to the home page. We'll patch that add-on to create them.

Thank you and thank you again for you free add on.