I get this error when clicking on "save settings" in the Configure Referral Statistics on the Admincp


Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE referrals SET resultnumber='10', limit1='', limit2='', limit3='', limit4='1', limit5='1', limit6='1'
mysql error: Unknown column 'resultnumber' in 'field list'

mysql error number: 1054

Date: Thursday 02nd of June 2005 09:33:28 AM
Script: http://www.myfootballforum.com/admin...erralstats.php
Referer: http://www.myfootballforum.com/admin...erralstats.php
Username: boro_boy
IP Address: 62.254.64.19

Did you run the installer?

Yes, it obviously didn't add a table or something.

im gettin this error, how can i fix ?

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT COUNT(referrerid) as getusers FROM user WHERE referrerid > 0 AND usergroupid NOT IN 2
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 '2' at line 1

mysql error number: 1064

Date: Sunday 05th of June 2005 05:33:06 AM
Script: http://talkweed.com/forums/admincp/r...rralstatistics
Referer: http://talkweed.com/forums/admincp/index.php?do=nav
Username: dexstar
IP Address: xx.xx.xx.xx

anyone???

Everything's working well, but is there any way to replace the list of referrals with Homepage URL? I tried $userinfo[homepage] but it's not working.

Can anyone help me out here? Thanks.

Works great for me.. Thx

When I am looking at the Referral statistics page and try to go to my AdminCP from the footer It goes to this
http://www.justsprint.com/forum/refe...ncp/index.php?

It puts the referrals.php in there

Any ideas

Sorry I am new to this

yes, you edited your footer incorrectly, check the instructions again and follow them step by step for editing your footer template.

For some reason it works now...Who knows