return to google checkout

[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]

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]

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