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)

Originally Posted by Error Message

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]

Originally Posted by Ace Shattock

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