vb.org Archive
Page 12 of 15 « First 21011 12 1314 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Miscellaneous Hacks - e-steki User ModLog v1.1.3 - An alternative to moderation AutoPM (https://vborg.vbsupport.ru/showthread.php?t=154982)

Boothby 02-25-2008 08:49 PM
maxXximum from vBGo reported this SQL-error-message.
Code:
Database error in vBulletin 3.7.0 Beta 5:

Invalid SQL:

SELECT
modtable.usergroupid as modgroup,
modtable.username as moderator,
editlog.postid as postid,
editlog.reason as reason,
editlog.dateline as dateline,
editlog.userid as modid,
post.threadid as threadid,
forum.forumid as forumid,
thread.title as threadtitle,
forum.title as forumtitle,
post.title as action
FROM vb7editlog as editlog
LEFT JOIN vb7post as post ON (post.postid = editlog.postid)
LEFT JOIN vb7thread AS thread ON (thread.threadid = post.threadid)
LEFT JOIN vb7user AS modtable ON (modtable.userid = editlog.userid)
LEFT JOIN vb7forum AS forum ON (forum.forumid = thread.forumid)
WHERE
post.userid = 3 AND post.userid != editlog.userid AND 1203889380-editlog.dateline <86400 AND modtable.usergroupid IN ()
ORDER BY editlog.dateline DESC
LIMIT 10;

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 ')
ORDER BY editlog.dateline DESC
LIMIT 10' at line 19
Error Number : 1064
I think that happens when $vbulletin->options['eum_groups'] is empty.

CNBAforo 02-26-2008 10:38 PM
In the case of deleted messages/threads, the reason and the deleted content, could be shown in some way to the user, for him to associate the infraction with the content.

Spinball 04-24-2008 08:17 AM
I know this mod is flagged as unsupported, but I want to report an issue with it which I hope Michelle will look in to.
We have a large forum and are experiencing serious SQL slow downs with this query:
Quote:
# Query_time: 11 Lock_time: 0 Rows_sent: 10 Rows_examined: 23956866
SELECT
modtable.username as moderator,
modtable.usergroupid as modgroup,
modlog.userid as modid,
modlog.action as action,
modlog.type as type,
modlog.dateline as dateline,
modlog.threadid as threadid,
modlog.postid as postid,
forum.forumid as forumid,
thread.title as threadtitle,
forum.title as forumtitle,
deletionlog.reason as delreason
FROM moderatorlog AS modlog
LEFT JOIN user AS modtable ON (modtable.userid = modlog.userid)
LEFT JOIN thread AS thread ON (thread.threadid = modlog.threadid)
LEFT JOIN post AS post ON (post.postid = modlog.postid)
LEFT JOIN forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = IF(deletionlog.type = 'post', modlog.postid, modlog.threadid))
WHERE
IF(modlog.postid,post.userid=28735,thread.postuser id=28735) AND modlog.type !=20 AND modtable.userid != 28735 AND modlog.type NOT IN (11,12) AN$
ORDER BY dateline DESC
LIMIT 10;
23 million rows examined!!! This mod is grinding our forum to a halt.
Is there an alternative, more efficient way of doing this? I have had to disable the mod until a fix is found, and I would suggest that anyone with a big forum check their SQL performance when using this.

Lea Verou 04-24-2008 08:50 AM
Unless somebody else thinks of a way to fix this, personally I am unable to think of a most efficient query.
Sorry. :/

Spinball 04-24-2008 09:26 AM
Quote:
Originally Posted by Michelle (Post 1497984)
Unless somebody else thinks of a way to fix this, personally I am unable to think of a most efficient query.
Sorry. :/
Thanks for the quick reply. Might splitting it into separate queries not be easier on the database?
[Edit : I have added an index on moderatorlog.userid and have re-enabled to see whether that has any effect. It should do, I'm guessing and hoping.]
[Edit 2: Nope, still having problems - disabling.]

J98680Bxxxxx 04-24-2008 09:48 AM
Installed (also marked) on vB 3.7 CR2, works fine. :up: Thanks Michelle.

Spinball 04-24-2008 10:13 AM
Michelle, does this mod only report on certain types of moderator actions?
I ask because it is, by the looks of it, reporting checked posts from this mod:
https://vborg.vbsupport.ru/showthread.php?t=173609

Konstantinos 05-16-2008 01:01 PM
it doesnt work for posts moved to another thread

Lea Verou 05-16-2008 01:17 PM
Quote:
Originally Posted by Konstantinos (Post 1521571)
it doesnt work for posts moved to another thread
It does, but it incorrectly notifies the thread author instead of the post authors.
Its a known bug that I will fix sometime, but I don't know when...

shadowevil 05-16-2008 03:16 PM
Does this hack work with vB 3.7 GOLD ??


All times are GMT. The time now is 07:33 AM.
Page 12 of 15 « First 21011 12 1314 Last »
Show 40 post(s) from this thread on one page

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.01337 seconds
  • Memory Usage 1,746KB
  • 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
  • (1)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