I'm getting the following user warning under my account - History - subscriptions:
user warning: Unknown column 't.uid' in 'where clause' query: SELECT * FROM ec_recurring_expiration e, ec_recurring_schedule r, ec_recurring_product p, ec_transaction t, node_revisions n, ec_transaction_product etp WHERE e.txnid = t.txnid AND n.vid = e.vid AND r.sid = p.sid AND p.vid = e.vid AND p.vid = etp.vid AND e.txnid = etp.txnid AND t.uid = 1 AND e.status = 0 AND rid <= 0 in /home/content/a/d/m/admin3ddigs/html/includes/database.mysql.inc on line 174.
also, I've had these warnings when I try to create coupons under the administer/ecommerce/coupon tab:
user warning: Table 'filmmaker1.ec_coupon' doesn't exist query: SELECT COUNT(c.coupon) FROM ec_coupon c LEFT JOIN ec_transaction_coupon tc ON c.coupon = tc.coupon in /home/content/a/d/m/admin3ddigs/html/includes/database.mysql.inc on line 174.
user warning: Table 'filmmaker1.ec_coupon' doesn't exist query: SELECT c.*, SUM(tc.discount) as coupon_discount FROM ec_coupon c LEFT JOIN ec_transaction_coupon tc ON c.coupon = tc.coupon GROUP BY c.coupon, c.operator, c.operand, c.created, c.created_txnid, c.created_vid ORDER BY created ASC LIMIT 0, 10 in /home/content/a/d/m/admin3ddigs/html/includes/database.mysql.inc on line 174
It looks like tables aren't being set up in the database on installation of the modules. I followed the intallation instruction for the ecommerce package exactly and everything else seems to function fine.
Any help is greatly appreciated. I hope this can be fixed..because the e-commerce module seems to be a great fit for my future website.
Thanks in advance,
Kerry
Comments
Comment #1
sammys commentedThis bug no longer applies as 4.x will not be supported on Drupal 5.x. In addition, ec_recurring is yet to be ported to EC 4.x.