By Sophia on

I am creating a download store, and tested this with my own account. I manually changed the transaction to completed, but on "My Files" I am getting the following error:

* user warning: Unknown column 'st.expires' in 'field list' query: SELECT st.created, st.expires, stp.title, pf.size, pf.fpath FROM ec_transaction AS st, users AS u, ec_product AS p, ec_product_file AS pf, 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 pf.nid = p.nid AND st.payment_status = 2 ORDER BY st.txnid DESC in /home/sophiabu/public_html/jan/includes/database.mysql.inc on line 172.
* user warning: Table 'sophiabu_jan.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/sophiabu/public_html/jan/includes/database.mysql.inc on line 172.

Any ideas?

⋅ Categories: Drupal 5.x

Comments

Sophia’s picture

Sophia commented

I just reinstalled the whole site (was rather empty anyway) and tried again, now I found out that even without products yet I am still getting this error message under "My Files". What am I missing? Thanks!