vb.org Archive - Moderators Functions - FractalizeR: Show items, awaiting moderation in notifications area

Page 14 of 16

Show 40 post(s) from this thread on one page

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)

Venlaw

05-24-2015 11:12 AM

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.....

Same issue here. Finally got around to shutting off my site and finding this plugin was the cause of my login issues.

Wedframe

06-07-2015 06:28 PM

Venlaw, My Hattiesburg

Quote:

In my case, i was have one moderator which was not moderate at least one forum.

Exactly this moderator could not login to forum, because of receiving the DB-error.
So,.. for me, the solution of the problem was - to assign him to moderate any forum section. After this problem has been resolved.

Wedframe

06-08-2015 06:02 AM

1 Attachment(s)

I create new version of plugin. This version based on product-fr_notifymoditems-4_0_3_by_AUGI.xml with added blog entries in moderation queue.

Gizmo99

08-29-2015 07:01 PM

product-fr_notifymoditems (A825F933D42B).xml

Works on 4.2.3 :)

GIz

Stratis

09-16-2015 03:12 PM

Avatar is ok in thread moderate, but not shown up in post moderate.
Is this issue only to me? if its not, did any one fixed this issue?

Thanks

djbaxter

12-22-2015 08:59 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.....

Quote:

Originally Posted by My Hattiesburg (Post 2544244)

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.

Quote:

Originally Posted by Venlaw (Post 2546329)

Same issue here. Finally got around to shutting off my site and finding this plugin was the cause of my login issues.

Had the same problem on one vBulletin 4.2.3 forum and none of the available versions worked. Uninstalled the product and the login issue disappeared.

Then discovered on another 4.2.3 forum, the product wasn't causing login errors but it simply wasn't working any more.

On a third 4.2.3 forum, the plugin is still working without the login error or any other errors.

The SQL error is because of this part of the query:

Code:

WHERE type = 'reply' AND forumid IN ( );

No forum ID is specified, hence the SQL error.

I have no idea why it works on some forums and not others... I don't have the time to try to track down what causes this behavior.

The best solution currently is simply to uninstall the product.

hazem_aliraqi

12-29-2015 05:14 PM

Quote:

Originally Posted by djbaxter (Post 2561001)

Code:

WHERE type = 'reply' AND forumid IN ( );

i have the same problem with admin login

taravasya

02-15-2016 10:23 AM

djbaxter, hazem_aliraqi
Hi! Please read previous messages very carefully! This errore appears when try to login moderator what do not assign at least one forum to moderate it.

Quote:

Originally Posted by Wedframe (Post 2547327)

Venlaw, My Hattiesburg

Exactly this moderator could not login to forum, because of receiving the DB-error.
So,.. for me, the solution of the problem was - to assign him to moderate any forum section. After this problem has been resolved.

taravasya

02-22-2016 08:30 AM

Well.. I try to fix the root of the problem. As I understand, DB error occurs only with product by_AUGI.
So... if you have installed product by_AUGI, then in module
"Showing notifications"
found string:

PHP Code:


		
			
$m_forums = "AND forumid IN ( ". implode(',', modForums( $vbulletin)) ." )";

and replace it with:

PHP Code:


		
			
$m_forums = "AND forumid IN ( '". implode(',', modForums( $vbulletin)) ."' )";

BTW! Idea AUGI was in to regulate notifications to moderators according to theirs permissions. But... this is just dont work. Notification appears no matter whether the right to moderate in this section of the forum or not. As a result, if moderator with limited privileges receives a notification about moderation items in forum the moderator of which he is does not, when viewing the moderation queue it gets an error...

taravasya

07-12-2016 04:16 AM

UPDATE! !Previous post not enough correct!
for correct processing of rights of moderation with this hack, we need to this piece of code:

PHP Code:


		
			
    //visitormessage, groupmessage, picturecomment 
    if(count(array_intersect($fr_itemsToTrack, array('visitormessage', 'groupmessage', 'picturecomment')))>0) { 
        $query = "SELECT COUNT(type) AS total, type 
                  FROM ". TABLE_PREFIX ."moderation 
                  GROUP BY type"; 
        $fr_result = $vbulletin->db->query_read($query); 
        while($fr_entry = $vbulletin->db->fetch_array($fr_result)) { 
            $fr_modItems[$fr_entry['type']] ['total'] = $fr_entry['total']; 
        } 
    }

rearrange upward, so that it would-be over

PHP Code:


		
			
    //reply - post 
    if(in_array('reply', $fr_itemsToTrack)) { 
        $query = "SELECT COUNT(*) AS num 
                  FROM " . TABLE_PREFIX . "moderation AS moderation 
                  INNER JOIN " . TABLE_PREFIX . "post AS post ON (moderation.primaryid = post.postid) 
                  INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid) 
                  WHERE type = 'reply' ". $m_forums; 
        $fr_result = $vbulletin->db->query_first($query); 
        $fr_modItems['reply'] ['total'] = $fr_result['num']; 
    }

================================================== =========================================
================================================== =========================================

Anf another suggest is for that would not appear a database error when entering/leaving forum by moderator/super-moderator/administrator without any forum moderated, string:

PHP Code:


		
			
if(!isSuperMod($vbulletin)){

must be replaced with:

PHP Code:


		
			
if(!isSuperMod($vbulletin) AND can_moderate()){

================================================== =========================================

Both issues from same module:
Showing notifications

All times are GMT. The time now is 11:05 AM.

Page 14 of 16

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01369 seconds Memory Usage 1,778KB 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 (4)bbcode_code_printable (6)bbcode_php_printable (7)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
Messages: