vb.org Archive
Page 3 of 32 12 3 4513 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Moderator Statistics (https://vborg.vbsupport.ru/showthread.php?t=106329)

darksoulz 01-26-2006 03:53 PM
getting a sql error on this. anyone have an idea how to fix?

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:

        SELECT userid, count(*) AS total
        FROM moderatorlog AS moderatorlog
        WHERE dateline >= 1135705843 AND userid IN ()
        GROUP BY userid;

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 ')
        GROUP BY userid' at line 3
Error Number : 1064
Date        : Thursday, January 26th 2006 @ 11:50:43 AM
Script      : http://xxxxxx/board/misc.php?do=moderator_stats
Referrer    :
IP Address  : xxxxx
Username    : xxxxx
Classname    : vB_Database_MySQLi
also getting
Warning: array_unique() [function.array-unique]: The argument should be an array in /misc.php(86) : eval()'d code on line 161

a bunch of
Warning: Invalid argument supplied for foreach() in /misc.php(86) : eval()'d code on line 168

and a
Warning: implode() [function.implode]: Bad arguments. in /misc.php(86) : eval()'d code on line 181

Martin 01-26-2006 04:07 PM
I installed, but it just hangs when I try to access it. How does it retrieve the data? If it's searching for raw info in the database, this may not be suitable for large forums like mine.

This is what I get when I run it:

Server Load Averages 20.74 7.92 5.21 | 737 Users Online

kall 01-26-2006 04:10 PM
Posts in "His" forum?

What about people who have female moderators?

Abe1 01-26-2006 04:12 PM
Quote:
Originally Posted by darksoulz
getting a sql error on this. anyone have an idea how to fix?

Code:
Database error in vBulletin 3.5.3:

Invalid SQL:

        SELECT userid, count(*) AS total
        FROM moderatorlog AS moderatorlog
        WHERE dateline >= 1135705843 AND userid IN ()
        GROUP BY userid;

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 ')
        GROUP BY userid' at line 3
Error Number : 1064
Date        : Thursday, January 26th 2006 @ 11:50:43 AM
Script      : http://xxxxxx/board/misc.php?do=moderator_stats
Referrer    :
IP Address  : xxxxx
Username    : xxxxx
Classname    : vB_Database_MySQLi
also getting
Warning: array_unique() [function.array-unique]: The argument should be an array in /misc.php(86) : eval()'d code on line 161

a bunch of
Warning: Invalid argument supplied for foreach() in /misc.php(86) : eval()'d code on line 168

and a
Warning: implode() [function.implode]: Bad arguments. in /misc.php(86) : eval()'d code on line 181
I see you are using MySQLi, I didn't do any test on it. I will look at the code tonight to see what I can come up with.

Abe1 01-26-2006 04:14 PM
Quote:
Originally Posted by Martin
I installed, but it just hangs when I try to access it. How does it retrieve the data? If it's searching for raw info in the database, this may not be suitable for large forums like mine.

This is what I get when I run it:

Server Load Averages 20.74 7.92 5.21 | 737 Users Online
It only uses about 4 queries besides the standard queries that run on every click. No queries just pull all info. They all have limits as far as I remember.

Abe1 01-26-2006 04:16 PM
Quote:
Originally Posted by kall
Posts in "His" forum?

What about people who have female moderators?
When we talk about God, we refer to 'him' as 'him'. 'Him' is normal for languge when it can be either or. If you dont like it, you can edit the phrase. The hack is fully phrased.

Martin 01-26-2006 04:33 PM
Here are my loads without it running:

2.95 2.55 3.30 | 799 Users Online

I have 94 forums, 44 mods, 4.6mil posts, ~274,000 threads.

I think it's the size of my forum that's causing problems. Pity, because this is a great hack idea.

Abe1 01-26-2006 04:35 PM
Quote:
Originally Posted by Martin
Here are my loads without it running:

2.95 2.55 3.30 | 799 Users Online

I have 94 forums, 44 mods, 4.6mil posts, ~274,000 threads.

I think it's the size of my forum that's causing problems. Pity, because this is a great hack idea.
That's alot of mods. I'll have to look into it.

JsnakeJ 01-26-2006 04:38 PM
/me installs.

Very useful hack.

antialiasis 01-26-2006 04:41 PM
What statistics does this hack show exactly?


All times are GMT. The time now is 06:36 AM.
Page 3 of 32 12 3 4513 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.01432 seconds
  • Memory Usage 1,745KB
  • 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
  • (4)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