There's no instruction in use, the UI contains nothing but two text Boxes with no means or instructions as to generating an affiliate link, and on top of that I recieve this error on the affiliate homepage on a new install of drupal:

user warning: Unknown column 'ac.weight' in 'order clause' query: SELECT aa.*, ac.cat_name FROM affiliates_ads aa INNER JOIN affiliates_cats ac ON ac.cat_id = aa.cat_id WHERE status = 'A' ORDER BY ac.weight ASC, aa.order_by ASC in C:\Documents and Settings\Owner\My Documents\site\modules\affiliates\affiliates.module on line 937.

Comments

drupaloSa’s picture

Title: Is this module even in a usable state? » update function is misnamed
Component: Miscellaneous » Code
Category: support » bug
Priority: Normal » Critical

There is an update in the .install file but the function has been named incorrectly; it should be affiliates_update_6001() instead of affiliates_update_1(). Fixing this and then running the update.php adds a "weight" column to the affliates_cats table and the errors are gone.

kbahey’s picture

Version: 6.x-1.0 » 6.x-1.x-dev
Status: Active » Fixed

Thanks, fixed in dev. New tarball should be available for download in about 9 hours from now.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.