View Single Post
  #122  
Old 10-12-2012, 10:51 AM
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
Senior Member
 
Join Date: Jun 2008
Location: New York
Posts: 10,610
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Hostboard View Post
Fresh install on 4.2.0pl2
Ran the report after configuring it.
Report generated and posted but also got:

Code:
Post Check SQL:
 SELECT mmpost.ipaddress, GROUP_CONCAT(DISTINCT mmpost.userid) AS userid, GROUP_CONCAT(DISTINCT mmpost.postid) AS postid, mmuser.usergroupid          FROM mmpost LEFT JOIN mmuser ON mmuser.userid = mmpost.userid          WHERE mmpost.dateline > 1349176946 AND mmpost.userid > 0  AND mmpost.ipaddress != '127.0.0.1'  AND mmpost.ipaddress != ''             GROUP BY mmpost.ipaddress          HAVING COUNT(DISTINCT mmpost.userid) > 1          ORDER BY COUNT(DISTINCT mmpost.userid) DESC          LIMIT 500

User Check SQL:
 SELECT ipaddress, GROUP_CONCAT(DISTINCT userid) AS userid, usergroupid          FROM mmuser          WHERE joindate > 1347189746 AND userid > 0  AND ipaddress != '127.0.0.1'  AND ipaddress != ''             GROUP BY ipaddress          HAVING COUNT(DISTINCT userid) > 1          ORDER BY COUNT(DISTINCT userid) DESC          LIMIT 500
Where did you "get" that code? If you manually run the report that is completely normal debug info that is output.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01073 seconds
  • Memory Usage 1,767KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete