zpupster 6 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 Share this post Link to post Share on other sites
speed777 0 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. Share this post Link to post Share on other sites
zpupster 6 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 Share this post Link to post Share on other sites
zpupster 6 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 Share this post Link to post Share on other sites
speed777 0 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 Share this post Link to post Share on other sites