View Single Post
  #1  
Old 04-25-2009, 03:54 AM
Wizardjv Wizardjv is offline
 
Join Date: Feb 2006
Posts: 111
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Vistor Message and Pm Problem

For some reason, when you have the plugin hook system turned on, you cant post a vistor message. You get the following error.

The following errors occurred with your submission

1. No User specified. If you followed a valid link, please notify the administrator

Also, when the plugin system is enabled, the pm doesnt autofill the username. I figured both of these problems were somewhat related. So I turned on debug mode and I found that when the plugin system is enable, there is 11 queries, but when disabled there is 12 queries. And when you disable the plugin system everything works fine. Also, there are no mods installed at all. This is a basic vbulletin installation.

I managed to isolate the query that is being left out when the plugin system is on.

SQL Query

SELECT usertextfield.*, user.*, userlist.type
FROM user AS user
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
LEFT JOIN userlist AS userlist ON(user.userid = userlist.userid AND userlist.relationid = 2 AND userlist.type = 'buddy')
WHERE user.userid IN(21)

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE user const PRIMARY PRIMARY 4 const 1
1 SIMPLE usertextfield const PRIMARY PRIMARY 4 const 1
1 SIMPLE userlist const PRIMARY,relationid,userid PRIMARY 9 const,const,const 0 unique row not found

Time Before: 0.14148 seconds
Time After: 0.14214 seconds
Time Taken: 0.00065 seconds

Memory Before: 6,240.766 KB
Memory After: 6,240.574 KB
Memory Used: -0.191 KB

Anyone have any ideas on what may be wrong and how to fix it? I know its something to do with this query and it says unique row not found. I would appreciate any help I can get.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01196 seconds
  • Memory Usage 1,762KB
  • 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)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