URGENT: "Add to Cart" missing from uc_product_table on live store

Posts: 4
Joined: 02/01/2008

Suddenly clients complain that they cannot see the Add to Cart button on product views for http://wildhivefarm.com. I've looked all over forums on Ubercart, and it seems "Add to Cart" is supposed to be a clickable item under UC_Product_Table in Table Display Settings but all I see there are Image, Name, and Price.

I HAVE enabled this under Product Settings (it was already enabled) What's the intermediate step?

Help me, please?

--

--
Bram Moreinis
845-750-6204
Principal, Game Face Web Design
http://www.gamefacewebdesign.com
Director, Hudson Valley Tech Scouts
http://hvscouts.com

"The future is already here - it's just not evenly distributed." - William Gibson

Posts: 5269
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Have you recently updated your Ubercart version?

Also, a little unrelated but do you know if they sell oat or corn flour?

Posts: 4
Joined: 02/01/2008

It so happens I have, Ryan! If you have a moment, would you go to our website, gamefacewebdesign dot com, get my phone number, and perhaps help me get on with my miserable life?

And yes, they sell milled oat and corn flour - they just haven't got that working on the store yet.

--

--
Bram Moreinis
845-750-6204
Principal, Game Face Web Design
http://www.gamefacewebdesign.com
Director, Hudson Valley Tech Scouts
http://hvscouts.com

"The future is already here - it's just not evenly distributed." - William Gibson

Posts: 4
Joined: 02/01/2008

I just checked all the logs, and found one Visitor error that happened twice:

Message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= '1') )' at line 1 query: SELECT count( DISTINCT(node.nid)) FROM node node INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 1 AND na.realm = 'term_access'))) AND ( (node.status = '1') AND (.is_product = '1') ) in /usr/local/www/drupal-5.2/includes/database.mysql.inc on line 172.

On Update.php:

* user warning: Unknown column 'notify' in 'uc_order_statuses' query: ALTER TABLE uc_order_statuses CHANGE notify state VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '' in /usr/local/www/drupal-5.2/includes/database.mysql.inc on line 172.
* user warning: Duplicate column name 'weight' query: ALTER TABLE uc_order_statuses ADD weight MEDIUMINT(9) NOT NULL in /usr/local/www/drupal-5.2/includes/database.mysql.inc on line 172.
* user warning: Duplicate column name 'locked' query: ALTER TABLE uc_order_statuses ADD locked TINYINT NOT NULL DEFAULT '0' in /usr/local/www/drupal-5.2/includes/database.mysql.inc on line 172.

* ALTER TABLE {uc_order_statuses} CHANGE order_status_id order_status_id VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
* ALTER TABLE {uc_order_statuses} CHANGE title title VARCHAR(48) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
* Failed: ALTER TABLE {uc_order_statuses} CHANGE notify state VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
* Failed: ALTER TABLE {uc_order_statuses} ADD weight MEDIUMINT(9) NOT NULL
* Failed: ALTER TABLE {uc_order_statuses} ADD locked TINYINT NOT NULL DEFAULT '0'
* DELETE FROM {uc_order_statuses} WHERE order_status_id LIKE '_'
* INSERT INTO {uc_order_statuses} (order_status_id, title, state, weight, locked) VALUES ('payment_received', 'Payment received', 'payment_received', 10, 1);

--

--
Bram Moreinis
845-750-6204
Principal, Game Face Web Design
http://www.gamefacewebdesign.com
Director, Hudson Valley Tech Scouts
http://hvscouts.com

"The future is already here - it's just not evenly distributed." - William Gibson

Posts: 91
Joined: 08/09/2007
Uber DonorBug Finder

the uc cart module disabled itself on an update because workflow_ng and token were not enabled/missing. Glad we were able to get it figured out.

--

Biodiesel * (ubercart + drupal) = Sundays Energy

Posts: 5269
Joined: 08/07/2007
AdministratorHead Code Monkey - I eat bugs.

Very weird... I don't think core really nailed down issues regarding dependencies in Drupal 5. Hopefully Drupal 6 fixes 'em!