4 replies to this topic

[zpupster]

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

[speed777]

zpupster, on 26 March 2011, 10:49, said:

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.

[zpupster]

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

[zpupster]

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

[speed777]

zpupster, on 05 April 2011, 14:33, said:

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 by speed777, 06 April 2011, 18:11.