Vistor Message and Pm Problem

[Wizardjv]

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.

[Lynne]

Create a new style with no parent:

• Styles & Templates > Style Manager > Add New Style
• Parent Style: No Parent Style
• Title: Default vBulletin
• Allow User Selection: Yes
• Save

Then browse the site using that totally default vbulletin style - do you still have the same problem?

[Wizardjv]

Yes, I have tested all the styles. They have no edits and with the default style I get the same error. I am down to thinking that that query is the problem. But I am open to any ideas and or opinions? Thank You ahead of time

[Lynne]

Have you tried looking in the actual database? Make sure there is only one entry in userlist that meets the requirements listed.

[Wizardjv]

Well, here is everything that is there in the database..Though, I honestly dont know what I am looking for.

[Lynne]

You need to Browse the table. Or query it for what it is asking. I'm not sure how to tell you what you are looking for cuz I'm just thinking aloud about what I would look for. It seems to think there is more than one entry for the query, so I'd go see if that is actually true.

[Wizardjv]

So do you think emptying that table would fix it?

[Lynne]

I have no idea. If it has an extra line in there that is causing the problem, then you still have the problem of wondering how it got there - was it a modification? Which one?

[mikey1991]

What modifications do you have installed?