zpupster Posted March 26, 2011 Share Posted March 26, 2011 hello support, i am in sandbox mode, i am finally got the order to go thru. everything looks fine. except this one link return to my site. it gives this error: 1054 - Unknown column 'Array' in 'where clause' select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id in (Array) and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP] any suggestions?? thanks, craig Quote Link to comment Share on other sites More sharing options...
speed777 Posted March 26, 2011 Share Posted March 26, 2011 hello support, i am in sandbox mode, i am finally got the order to go thru. everything looks fine. except this one link return to my site. it gives this error: 1054 - Unknown column 'Array' in 'where clause' select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id in (Array) and pd.products_id = p.products_id and pd.language_id = '1' [TEP STOP] any suggestions?? thanks, craig The 'p.products_id in (Array)' is not in your database, that's why your getting that error. Quote Link to comment Share on other sites More sharing options...
zpupster Posted March 27, 2011 Author Share Posted March 27, 2011 do you think if i just add it then everything will be all right. actually i do not know how to add it but, i will find out. thanks, craig Quote Link to comment Share on other sites More sharing options...
zpupster Posted April 5, 2011 Author Share Posted April 5, 2011 The 'p.products_id in (Array)' is not in your database, that's why your getting that error. i am confused, from this line in gc_return.php . TABLE_PRODUCTS . " p, " when i go to the products table there is a column labeled and filled products_id if there is more information, you need to help me please let me know. thanks, craig Quote Link to comment Share on other sites More sharing options...
speed777 Posted April 6, 2011 Share Posted April 6, 2011 (edited) The 'p.products_id in (Array)' is not in your database, that's why your getting that error. i am confused, from this line in gc_return.php . TABLE_PRODUCTS . " p, " when i go to the products table there is a column labeled and filled products_id if there is more information, you need to help me please let me know. thanks, craig You must have a shipping and labeling addon installed because there is no 'labeled and filled products_id' in GC that I am aware of. Edited April 6, 2011 by speed777 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.