DataBase Errors in random threads - Showthread is the problem - How to resolve?

[system0]

im having a very similar error to [Database Errors problem[/url]

however my error seems to be in showthread and not in forumdisplay (which is where the error is in the thread above)

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT COUNT(*) AS count FROM user WHERE referrerid =;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Date : Thursday, April 27th 2006 @ 07:50:55 PM
Script : http://www.websiteexample.com/showthread.php?t=603
Referrer :
IP Address : xx.xx.xx.xx
Username : Unregistered
Classname : vb_database

most of the changes on my site have been plugins and not extensions (eg file edits) though i reuploaded showthread anyways - with no luck

i had the daniiweb mod rewrite on 3.0 last year and some characters like ' or : caused some problems. However, none of these seem to cause any problems with the vbseo script so im stumped what it could be

No doubt, a few other people have had this problem so any help on the matter would be greatly appreciated

thank you

[Ace Shattock]

Hmm, doesn't immediately grab me as being vBSEO related...do you have Ebux/vBBux installed?

Doesn't it have a setting that involves rewarding the user who referred someone, when that someone makes a post?

That would have to call on the referrer field.

Also, do you maybe have a post in that thread that belongs to a user that has been tachied? Or a guest post?

[Ace Shattock]

P.S: How are we supposed to check the URL when you change the domain name?

*edit to ad* And.. extensions don't require file edits either.

[system0]

i can provide the exact domain name privately if via pm if you wish

its definately related to vbseo...the error started occuring shortly after installtion

i dont have any vbulletin point system or money system installed. I have never allowed guests to post in the forum so it cant be that

[Ace Shattock]

Does it occur if you turn off the Plugin system?

[Michael]

Have you installed any plugins or modifications which make any changes to the ./showthread.php functionality? Also have you made any code modifications too to any vBulletin files?

[Ace Shattock]

Do you have Referrals In Postbit - vBulletin.org Forum installed?

Or anything else that shows referrer details in postbit?

[system0]

Do you have Referrals In Postbit - vBulletin.org Forum installed?

Or anything else that shows referrer details in postbit?

yes i have that installed

i didnt realise that would effect it

is there a way round this...eg keeping the hack and getting rid of the errors

its no big deal if the only solution is uninstalling this hack

[Ace Shattock]

It might be an idea to post in the hack thread.. I saw other people with the same issue there.

[system0]

ive just removed it
as was originally suggested, it was happening in posts with guests posting on it (i wasnt aware if had it)

many thanks for the support

[Ace Shattock]

No problemo Kevin, I am very happy I could help.

[rob]

kewl