Unknown column 'ac.weight'
novogreen - December 23, 2008 - 16:06
| Project: | Affiliates |
| Version: | 6.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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.
#1
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.