2 replies [Last post]
lakbaytaodev's picture
Offline
Joined: 03/21/2009
Juice: 57
Was this information Helpful?

Greetings!

I am trying to figure out discounts on Ubercart using the module uc_discounts_alt. However, every time I load the module then try to go to Store Administration and click on Discounts this error always shows up.

user warning: Unknown column 'insert_timestamp' in 'order clause' query: SELECT * FROM uc_discounts ORDER BY insert_timestamp DESC LIMIT 0, 50 in /home6/lakbayta/public_html/bukidnon/sites/all/modules/uc_discounts_alt-6.x-2.4/uc_discounts_alt/uc_discounts/uc_discounts.admin.inc on line 29.

What did I miss? Please advice. A million thanks in advance.

Linux Registered User #383849

lakbaytaodev's picture
Offline
Joined: 03/21/2009
Juice: 57
Re: Problem on using uc_discount_alt

By the way, I also try to run update.php hoping to fix the error but this is what I got after the update.

user warning: Unknown column 'qualifying_amount' in 'uc_discounts' query: ALTER TABLE uc_discounts ADD has_qualifying_amount_max tinyint NOT NULL default 0 AFTER qualifying_amount in /home6/lakbayta/public_html/bukidnon/sites/all/modules/uc_discounts_alt-6.x-2.4/uc_discounts_alt/uc_discounts/uc_discounts.install on line 522.
user warning: Unknown column 'has_qualifying_amount_max' in 'uc_discounts' query: ALTER TABLE uc_discounts ADD qualifying_amount_max float NOT NULL default 0 AFTER has_qualifying_amount_max in /home6/lakbayta/public_html/bukidnon/sites/all/modules/uc_discounts_alt-6.x-2.4/uc_discounts_alt/uc_discounts/uc_discounts.install on line 523.
user warning: Unknown column 'has_role_filter' in 'uc_discounts' query: ALTER TABLE uc_discounts MODIFY has_role_filter tinyint NOT NULL in /home6/lakbayta/public_html/bukidnon/sites/all/modules/uc_discounts_alt-6.x-2.4/uc_discounts_alt/uc_discounts/uc_discounts.install on line 526.
user warning: Unknown column 'max_uses_per_user' in 'uc_discounts' query: ALTER TABLE uc_discounts ADD max_uses_per_code int NOT NULL default 0 AFTER max_uses_per_user in /home6/lakbayta/public_html/bukidnon/sites/all/modules/uc_discounts_alt-6.x-2.4/uc_discounts_alt/uc_discounts/uc_discounts.install on line 549.

and:

The following queries were executed
uc_discounts module
Update #2
Failed: ALTER TABLE {uc_discounts} ADD has_qualifying_amount_max tinyint NOT NULL default 0 AFTER qualifying_amount
Failed: ALTER TABLE {uc_discounts} ADD qualifying_amount_max float NOT NULL default 0 AFTER has_qualifying_amount_max
Failed: ALTER TABLE {uc_discounts} MODIFY has_role_filter tinyint NOT NULL
Update #3
Failed: ALTER TABLE {uc_discounts} ADD max_uses_per_code int NOT NULL default 0 AFTER max_uses_per_user

Did I miss something during the installation? Please help. Thanks.

Linux Registered User #383849

lakbaytaodev's picture
Offline
Joined: 03/21/2009
Juice: 57
Re: Re: Problem on using uc_discount_alt

By the way, I already resolved this issue by deleting all the files and deleting up the database and start all over again. I think its much faster to start all over again since I was just starting up the website. Now its working great! Thanks.

Linux Registered User #383849