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