Posted by lakbaytaodev on March 12, 2012 at 12:40pm
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.
Comments
can you try reinstalling the
can you try reinstalling the module? or maybe you missed running a db update after installing / updating?
i get that kind of warning usually after a wrong install.
Hmmm..thanks on this one. I
Hmmm..thanks on this one. I will try to update the db and see the result.
Linux Registered User #383849
This is what I got when I try
This is what I got when I try to update the db.
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
Is there something wrong with the module? Or did I miss something during the installation? Please help. Thanks.
Linux Registered User #383849
really looks like the module
really looks like the module was not properly installed. mysql is complaining that some parts of the database are not there / were not created.
only advice i can think of is download and install the modules from scratch.
Yeah..i try to download the
Yeah..i try to download the file again. And now some of the components are showing up after loading the module.
Linux Registered User #383849