I just installed Affiliates module on my drupal 6.x site and while trying to "Admin" it I always get following message. I have not had the time to do much of debugging, but is anyone knows the reason..let me know!!!! Is there some configuration missing?

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 /home/cleantec/public_html/modules/affiliates/affiliates.module on line 937.

Comments

novogreen’s picture

novogreen commented
Status: Active » Closed (fixed)

I saw an old issue where it is stated that the missing column warning would get displayed in DB status report, but for my installation for Drupal 6.6 it doesn't and I don't know why the module shouldn't work like any other module , without having to fiddle with DB. Anyway, adding column to DB solves this problem.