[RedTyger]

Originally Posted by milsirhc

I think I found another bug Redtyger!

Not sure if i'm the only one having the problem.. but if you try going to a user profile page and click on his last post, you will encounter a SQL error (randomly). I tried 5 times and it hit me.

The reason why I believe this is the plugin that causing it (i could be wrong) is that I disabled all my plugins and enable them one by one and I got the error when i enabled the ad management plugin.

Hmm. can someone else confirm?

Thanks!

Opps: Edited (Same bug as what Brettmo is having!)

I'm 99% certain now that it's vBSEO that is causing these problems. Not a problem with their software, but I'm guessing that it alters thread and post details enough to cause an error in my modification, which uses the default details.

I don't mind implementing a workaround for vBSEO users if it's not too arduous, but it might be a bit tricky to deal with, since I have no testing copy of vBSEO and I can't look at their code to help with fixes anyway because they encrypt it all.

If either of you is able to get support from vBSEO, you could ask on my behalf and see if they can tell you what the problem is. Just tell them that you're trying to pull details from the database using:

SELECT post.userid, userfield.field7, user.usergroupid
FROM post AS post, userfield AS userfield, user AS user
WHERE threadid = 
AND userfield.userid = post.userid
AND user.userid = post.userid
ORDER BY post.dateline DESC
LIMIT 1;

and as you can see the threadid is not being used, it's blank. It works correctly on a non-vBSEO forum.

Oh and don't forget to post here if you've asked them so they don't get lots of enquiries. I guess if it's not vBSEO that's the problem I'll soon know about it.

Originally Posted by KipLarson

Hey, I don't think you answered my question about premium yearly subscriptions. Is there support for this? i.e. pay to get into the premium usergroup?

Yes, just use the default vBulletin Usergroups and the vB Ad Management Usergroup settings. You can restrict access by Usergroup very easily.