vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Moderators Functions - FractalizeR: Show items, awaiting moderation in notifications area (https://vborg.vbsupport.ru/showthread.php?t=241301)

RNArmstrong 01-17-2015 11:14 PM

Uploading product-fr_notifymoditems.xml (11.0 KB, 744 downloads) does not work for me to remove the 3 extra Threads, awaiting moderation in the Notifications. Any other suggestions?

kapii 01-25-2015 09:35 PM

Why does this mod show a notification for threads or posts if the moderator can not see a particular forum?

Wedframe 01-30-2015 12:37 AM

Thanks! Great mod! Mark as installed! vB v4.2.2 PL3

@kapii , I think its your case:
https://vborg.vbsupport.ru/showpost....&postcount=118

Wedframe 02-03-2015 04:01 PM

Hello! I found some errore in this mod.
In my case, i was have one moderator which was not moderate at least one forume. This generate a database errore 1064 with your mod enabled.

Code:

SELECT COUNT(*) AS num
              FROM moderation AS moderation
              INNER JOIN post AS post ON (moderation.primaryid = post.postid)
              INNER JOIN thread AS thread ON (post.threadid = thread.threadid)
              WHERE type = 'reply' AND forumid IN (  );

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

I dont know, this errore of mod, or guilty of admin))) but this point exist.....

Delfi_r 02-13-2015 09:29 PM

I've installed on two 4.2.2pl4 forums. One is loaded of plugins, the other is lightweight. On both the installation of the last revision of this useful mod makes the login process impossible with fatal database error.

There are other requirements or known incompatible plugins?

Delfi_r 02-14-2015 01:49 PM

The problem it's not there on the A825F933D42B version

My Hattiesburg 04-25-2015 03:50 PM

For a long time now the notification has shown 1 visitor message and 15 posts need moderation but those items are nowhere to be found. Is there any way to reset those to 0?

MarkFL 04-25-2015 04:09 PM

Quote:

Originally Posted by My Hattiesburg (Post 2544161)
For a long time now the notification has shown 1 visitor message and 15 posts need moderation but those items are nowhere to be found. Is there any way to reset those to 0?

In the AdminCP, go to Maintenance -> Execute SQL Query

and run the manual query:

truncate moderation;

This will clear that table and remove the errant entries. :D

My Hattiesburg 04-25-2015 06:57 PM

Quote:

Originally Posted by MarkFL (Post 2544166)
In the AdminCP, go to Maintenance -> Execute SQL Query

and run the manual query:

truncate moderation;

This will clear that table and remove the errant entries. :D

I've never executed an SQL query before so I was a little hesitant, but that fixed it. Thanks!

My Hattiesburg 04-26-2015 05:33 PM

Quote:

Originally Posted by Wedframe (Post 2535926)
Hello! I found some errore in this mod.
In my case, i was have one moderator which was not moderate at least one forume. This generate a database errore 1064 with your mod enabled.

Code:

SELECT COUNT(*) AS num
              FROM moderation AS moderation
              INNER JOIN post AS post ON (moderation.primaryid = post.postid)
              INNER JOIN thread AS thread ON (post.threadid = thread.threadid)
              WHERE type = 'reply' AND forumid IN (  );

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

I dont know, this errore of mod, or guilty of admin))) but this point exist.....

I had been using the 4.02 version for awhile and never had any problems (except for the count being wrong but thanks to MarkFL for his help in fixing that) so I decided to install the 4.03 version and got the exact same problem. One of our owners got this error and couldn't log in until I disabled it. Going to go back to a previous version to see if it still works.


All times are GMT. The time now is 12:33 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02427 seconds
  • Memory Usage 1,742KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete