I upgraded from who-knows-what version (used it once) to the current one, got a couple failures, and now I cannot add discounts, plus now I get the following persistent DB error on my front page:

user warning: Unknown column 'start_time' in 'where clause' query: SELECT * FROM uc_discounts WHERE start_time <= 1277735725 AND end_time >= 1277735725 AND is_active = 1 ORDER BY weight in /home/content/i/s/s/issiaip/html/aip/store/sites/all/modules/ubercart/uc_discounts/uc_discounts.module on line 830.

Here are the errors I get on trying to add a discount: 

    * user warning: Unknown column 'max_discounts' in 'field list' query: INSERT INTO uc_discounts (name, description, max_discounts, do_end_processing, is_exclusive, weight, start_time, end_time, is_active) VALUES ('PAGE 40%', 'PAGE 40% discount', 0, 0, 0, 0, 1277704800, 2145941999, 1) in /home/content/i/s/s/issiaip/html/aip/store/sites/all/modules/ubercart/uc_discounts/uc_discounts_admin.inc on line 331.
    * user warning: Unknown column 'id' in 'where clause' query: SELECT * FROM uc_discounts WHERE id=42944 in /home/content/i/s/s/issiaip/html/aip/store/sites/all/modules/ubercart/uc_discounts/uc_discounts.module on line 746.

I think I may have to edit the DB manually, uninstall or abandon this, something...

Comments

scott m. sanders’s picture

scott m. sanders commented

Uninstalling and reinstalling this module seems to have fixed it (who knew).

ultra23sg’s picture

ultra23sg commented

I am getting the same error, I have tried uninstalling and reinstalling this module, still the below error message is displaying on the front page.

user warning: Unknown column 'start_time' in 'where clause' query: SELECT * FROM uc_discounts WHERE start_time <= 1279730094 AND end_time >= 1279730094 AND is_active = 1 ORDER BY weight in /home/ns3ossbit/ns3ossbit.co.cc/bp/modules/uc_discounts/uc_discounts.module on line 830.

uc_discounts version: uc_discounts 6.x-1.x-dev
Drupal Version: 6.17