Any potential issues with reinstalling Boonex Spy module?

Our videos are no longer being logged by the Boonex Spy module, so a reinstallation seems necessary to correct this. Can you foresee any potential issues with reinstalling Boonex Spy module? We have a large community that makes major use of the Spy module functions.

when you uninstall, you are going to drop all the records from that table, but shouldnt be a huge deal, because its not as if this is holding an accessible history. plus the table is probably quite large if you have a large sized community.

FYI, backup your database prior to uninstalling

Yes that's the only real stumbling block here as I'm not sure if even reinstalling Spy will restore video entry logging. I have no idea why it stopped recording video posts in Spy.

 sure, thats understood, and the reason i said to backup your database. if you uninstall and reinstall and do not receive the desired results, then you can just restore your database.

 are you able to obtain any information from your error_log on the site or the server as to why this module has quit working?

It records every other activity that it should do, except for video posts. It's really odd and I can't seem to determine what happened - there's nothing related to this in the error_log, unfortunately. There must be some code somewhere that's been altered that disallows videos to be recorded in the Spy table.

Can you confirm this trouble in http://demo.boonex.com ?

No, it's specific to our site.

Maybe you did some changes in Video module or you have some Spy modifications?

LeonidS suggested executing the SQL queries:

SET @iSpyAct = (SELECT `id` FROM `sys_alerts_handlers` WHERE `name`='bx_spy_content_activity' LIMIT 1);

INSERT INTO `sys_alerts` VALUES(NULL, 'bx_videos', 'add', @iSpyAct);

The second one resulted in this error message: #1048 - Column 'handler_id' cannot be null

I think he is correct with this idea though because in our sys_alerts table there is no bx_videos with 'add' (only delete). Any ideas what this 'handler_id' value should be replaced with... then I think it is done!

Hello make sure that your bx_spy_handlers table contain this row:

(some id, 'bx_videos', 'add', 'videos', 'Module', 'get_spy_post');

It does not contain that row. The highest id# is 41, so shall I try to execute this command:

INSERT INTO `bx_spy_handlers` VALUES(42, 'bx_videos', 'add', 'videos', 'Module', 'get_spy_post');

yes don't forget clean all caches

The following three queries were added (and all caches cleaned manually, and database cache cleaned via admin), but still no video activity is being recorded. Can you see a problem with any of the commands?

SET @iSpyAct = (SELECT `id` FROM `sys_alerts_handlers` WHERE `name`='bx_spy_content_activity' LIMIT 1);

INSERT INTO `sys_alerts` VALUES(NULL, 'bx_videos', 'add', 42);

INSERT INTO `bx_spy_handlers` VALUES(42, 'bx_videos', 'add', 'videos', 'Module', 'get_spy_post');

This issue has been successfully resolved by who I would recommend LeonidS wholeheartedly for timely, efficient and accurate troubleshooting.

Make the technical ticket  to support  page

Why? Read the post above :)

 Ah... Sorry!