Problem With The Affiliates Module

[SiCkerOne666]

When I Have It Active It Always Gives Me This Error:
Database error in vBulletin 3.0.1:

Invalid SQL: SELECT sitename,siteurl,affiliate_id,clicks,buttonurl FROM affiliates WHERE active='1' ORDER BY clicks DESC LIMIT 5
mysql error: Unknown column 'clicks' in 'field list'

mysql error number: 1054

Date: Wednesday 15th of September 2004 11:37:56 AM
Script: http://xxxxxxxxxxxxxxxxxxxxx/portal.php
Referer:
Username: xxxxxxxxxxxx
IP Address: xx.xxx.xxx.x
How Do I Fix This Error?
Thank You

[Brian]

Unknown column 'clicks' in 'field list'

That means that the table does not have a 'clicks' column. You'd probably be better off asking for help in the thread for that module though as I've never used it.

[Our Sponsors]

[SiCkerOne666]

Thanks Brian