By Catpriest on

I have only just started to use the ecommerce module and it seems to work, but when I click on 'my files', it yields this error:

user warning: Table 'dreamgate.ec_product_parcel' doesn't exist query: SELECT st.created, st.expires, stp.title, pp.mnid, p.nid FROM ec_transaction AS st, users AS u, ec_product AS p, ec_product_parcel AS pp, ec_transaction_product AS stp WHERE u.uid = st.uid AND st.uid = 1 AND p.nid = stp.nid AND st.txnid = stp.txnid AND pp.nid = p.nid AND st.payment_status = 2 ORDER BY st.txnid DESC in /home/user/dreamgate/www/includes/database.mysql.inc on line 120.

How can I fix this ?

(our database is called 'dreamgate')

⋅ Categories: Drupal 4.7.x

Comments

vm’s picture

vm commented

another table issue. Table 'dreamgate.ec_product_parcel' doesn't exist means the table isnt found in your DB. the sql needs to be rechecked. check your db for the table, make sure it has the prefix attached in the db.

jeffrey.dalton’s picture

jeffrey.dalton commented

Has anyone found a solution to this one. I just did a clean install of Drupal 4.7.4 and the Latest Ecommerce Package with File downloads and everything seems to be working well except the 'My Files' feature which throws the error listed above that the table ec_product_parcel does not exist.

Anyone using Ecommerce that has this working? What is this table supposed to look like?

Regards,
Jeffrey

Jeffrey Dalton
Creative Director & Founding Partner
BKJ Digital
https://bkjdigital.com

plumbley’s picture

plumbley commented

files.module needs to check for parcels (products containg products) that contain file downloads. But currently (file.module,v 1.37.2.7 2006/10/02) it assumes parcel.module is installed (around lines 390-ish) when it ought to check first.

The error is actually harmless - files simply fails to find any produces in any parcels (there aren't any!).

Workaround: install parcel.module, which creates ec_product_parcel, and the error goes away.

Bugfix: protect the code performing "Check 2" by if (module_exist('parcel')) { ... }.

[Update: Patch to file.module 4.7 submitted for review at http://drupal.org/node/98681]

Best wishes,

Mark.
--
www.PostgraduateStudentships.co.uk - where ideas and funding meet