Unregistered/Deleted Members Cause This SQL Error...

[InsaneContender]

I've been having problems with this, but whenever someone posts and then that user gets deleted as well - I get this SQL error on every page that they posted on.

Just the one link is an example of it.

http://www.communityforums.net/forum...ead.php?t=1242

[NTLDR]

The prolem comes from whichever hack adds the following query in showthread.php:

[sql]COUNT(*) AS count FROM user WHERE referrerid =[/sql]

The problem being there is no numer after referrerid = in the query for guests/unregistered users.

[Agent Jones]

Also having the exact same problem... Found out in

/includes/functions_showthread.php

PHP Code:

    //Referral link mod
    if ($vboptions['usereferrer'])
    {
        $refcount = $DB_site->query_first("SELECT
    COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE referrerid =
     $post[userid]");
        $referrals = vb_number_format($refcount['count']);
    }
    //!Referral link mod 


Maybe I added something, but I just commented out (look below) and it now works...

PHP Code:

    //Referral link mod
    /*if ($vboptions['usereferrer'])
    {
        $refcount = $DB_site->query_first("SELECT
    COUNT(*) AS count FROM " . TABLE_PREFIX . "user WHERE referrerid =
     $post[userid]");
        $referrals = vb_number_format($refcount['count']);
    }*/
    //!Referral link mod 


PS: This might cause some malfunction in the mod... I hope not!