It seems exporting data to Google Base should be very straightforward but for some reason I am getting an error when I try to export.
[quote]Exporting data
[COLOR=#000000][FONT=Courier]Database error:[/FONT][/COLOR] Unknown column ‘product_prices.price’ in ‘field list’ B[/B]
[COLOR=#000000][FONT=Courier]Invalid query:[/FONT][/COLOR] SELECT products.product_id, products.product_id as “id”, product_prices.price as “price”, product_descriptions.product as “title”, product_descriptions.full_description as “description”, images_links.image_id as “image_link” FROM cscart_products as products WHERE products.status IN (‘A’) LIMIT 0, 30
[COLOR=#000000][FONT=Courier]Backtrace:[/FONT][/COLOR] File:/home/fastdeca/public_html/shop/core/fn.database.phpLine:310Function:db_errorFile:/home/fastdeca/public_html/shop/core/fn.database.phpLine:37Function:db_queryFile:/home/fastdeca/public_html/shop/controllers/admin/exim.phpLine:700Function:db_get_arrayFile:/home/fastdeca/public_html/shop/controllers/admin/exim.phpLine:94Function:fn_exportFile:/home/fastdeca/public_html/shop/core/fn.control.phpLine:521Function:includeFile:/home/fastdeca/public_html/shop/core/fn.control.phpLine:384Function:fn_run_controllerFile:/home/fastdeca/public_html/shop/admin.phpLine:27Function:fn_dispatch[/quote]
Any ideas to what could be causing this?