Not a huge deal, thanks anyways.
Digital Point Spy 1.3.0
- Thread starter digitalpoint
- Start date
Not a huge deal, thanks anyways.
S
Syndol
Guest
@digitalpoint I've encounter a small issue with one of my add-ons when attempting to update a moderator log entry.
I ended up having to add an if ($this->isInsert()) condition to your DigitalPointSpy_DataWriter_ModeratorLog save() function as it assumes the new data always includes the content type which is not necessarily the case when updating.
I ended up having to add an if ($this->isInsert()) condition to your DigitalPointSpy_DataWriter_ModeratorLog save() function as it assumes the new data always includes the content type which is not necessarily the case when updating.
digitalpoint
Well-known member
It's been fixed for the next release.
Is this somehow related to it, or requires its own fix?
Code:
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli statement execute error : Data too long for column 'action' at row 1 - library/Zend/Db/Statement/Mysqli.php:214
Generated By: ****, Today at 2:23 AM
Stack Trace
#0 /path/library/Zend/Db/Statement.php(297): Zend_Db_Statement_Mysqli->_execute(Array)
#1 /path/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)
#2 /path/library/Zend/Db/Adapter/Abstract.php(574): Zend_Db_Adapter_Abstract->query('INSERT INTO `dp...', Array)
#3 /path/library/DigitalPointSpy/DataWriter/ModeratorLog.php(18): Zend_Db_Adapter_Abstract->insert('dp_spy', Array)
#4 /path/library/XenForo/ModeratorLogHandler/Thread.php(21): DigitalPointSpy_DataWriter_ModeratorLog->save()
#5 /path/library/XenForo/ModeratorLogHandler/Abstract.php(32): XenForo_ModeratorLogHandler_Thread->_log(Array, Array, 'post_move_targe...', Array, NULL)
#6 /path/library/XenForo/Model/Log.php(202): XenForo_ModeratorLogHandler_Abstract->log(Array, 'post_move_targe...', Array, NULL, NULL)
#7 /path/library/XenForo/Model/Log.php(188): XenForo_Model_Log->logModeratorActionLocal('thread', Array, 'post_move_targe...', Array, NULL, NULL)
#8 /path/library/XenForo/Model/Post.php(1504): XenForo_Model_Log::logModeratorAction('thread', Array, 'post_move_targe...', Array)
#9 /path/library/XenForo/Model/Post.php(1313): XenForo_Model_Post->_moveOrCopyPosts('move', Array, Array, Array, Array)
#10 /path/library/XenForo/Model/InlineMod/Post.php(455): XenForo_Model_Post->movePosts(Array, Array, Array, Array)
#11 /path/library/XenForo/Model/InlineMod/Post.php(353): XenForo_Model_InlineMod_Post->_moveOrCopyPosts('move', Array, Array, Array, Array, NULL)
#12 /path/library/XenForo/ControllerPublic/InlineMod/Post.php(223): XenForo_Model_InlineMod_Post->movePosts(Array, Array, NULL)
#13 /path/library/XenForo/ControllerPublic/InlineMod/Post.php(140): XenForo_ControllerPublic_InlineMod_Post->_moveOrCopyPostsAction('canMovePosts', 'movePosts', 'XenForo_ViewPub...', 'inline_mod_post...')
#14 /path/library/XenForo/FrontController.php(347): XenForo_ControllerPublic_InlineMod_Post->actionMove()
#15 /path/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#16 /path/index.php(13): XenForo_FrontController->run()
#17 {main}
Request State
array(3) {
["url"] => string(39) "http://www.sitename.com/inline-mod/post/move"
["_GET"] => array(0) {
}
["_POST"] => array(7) {
["thread_type"] => string(8) "existing"
["existing_url"] => string(64) "http://www.sitename.com/threads/threadnamerandom-pic-thread-non-animated.35333/"
["save"] => string(10) "Move Posts"
["posts"] => array(1) {
[0] => string(7) "1080919"
}
["_xfConfirm"] => string(1) "1"
["redirect"] => string(74) "http://www.sitename.com/threads/random-animated-gifs.30764/page-36#post-1080919"
["_xfToken"] => string(8) "********"
}
}
motowebmaster
Well-known member
So this addon doesn't work with 1.3 yet?
motowebmaster
Well-known member
It appears that a newer version is coming.
My users appear to using the Spy feature a bit, I'd like to keep it in place and am holding-up on upgrading to 1.3
My users appear to using the Spy feature a bit, I'd like to keep it in place and am holding-up on upgrading to 1.3
digitalpoint
Well-known member
A simple fix is to just make the "action" column a VARCHAR(200).
D.O.A.
Well-known member
@digitalpoint just fyi, I wasn't seeing anything at all shown in the spy area since the 1.3 upgrade, so I changed the action column as noted and it came back on refresh showing one new user, but nothing for all the posts etc taking place following it. No errors logged anywhere either, so I can't be much help there.
motowebmaster
Well-known member
Is this something that would be needed for all 1.3 implementations - or just certain sites?
digitalpoint
Well-known member
Actually, I've been digging on this a bit, and haven't run into *anything* that needed to change for 1.3.
Is anyone running into any issues at all with 1.3?
Is anyone running into any issues at all with 1.3?
Post #164 and #167 on this page, have they been resolved? You mentioned #164 was fixed in "the next release"?
digitalpoint
Well-known member
Never was able to replicate the #167 thing.
I haven't had another occurrence of this error since it happened, so I'll wait and see if it happens again before I implement changing the "action" column to VARCHAR(200) then...
digitalpoint
Well-known member
What is your action column currently set to (length of the VARCHAR)?
Similar threads
- Suggestion
