could someone tell me how to fix this error, i get many of these emailed to me:


Database error in vBulletin 3.5.2:

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 : Tuesday, February 21st 2006 @ 09:50:38 PM
Script : http://***/showthread.php?p=6720
Referrer :
IP Address : 65.54.111.69
Username : Unregistered
Classname : vb_database

Doesn't this add one query to EACH post? :confused:

Just thought i would let the developer know that when I applied the plugin and edited the templates that it was calling for the referrals vbphrase when in my 3.5.4 forum the phrase was referrers..

Don't know if it was due some change I did but putting it out there anyway.

I am having this same issue, The cause is from the post being by a guest or user 0. Since I have some USENET posts these have no userid and the plugin crashes the thread.

Any idea if we can get an update that eliminates the referall call on guest posts?

Thanks!

-Jason

i'll update this hack soon

Thanks! It is a great hack!!

Any luck?

Ok, had some other folks here help me on this and here is the patch:

Go into your Admincp, plugins and edit the plugin: Number Of Referrals in postbit-by Developer

Replace this:

With this:

And it will work with USENET and Guest posts!

(Thanks to tnguy3n, Hambil, gio~logist and Zachery!)

Still, a problem with this hack is it runs an addtional query for each post.

It would much better to do an update for each user and log their total user referals. Then log new referals from then on out.

Fixing It now i'll add a plugin in update counters so you have to run something after installing the hack so it counts referrals and then insert it in a field in user's table using datamanger.