Getting error on front end. Cannot add a product to the cart. Error is:
Database error: Unknown column ‘cscart_products.shipping_params’ in ‘field list’ (1054)
Then we get the query error as an invalid query and a set of backtrace items.
This cart went live a month ago. Any one know where to start troubleshooting?
Looks like you have an addon or something extra that is using a table name as part of a field list. What is the table name listed in the backtrace. The full sql would be helpful.
Appreciate the response and hope this helps in diagnosis.
Database error: Unknown column 'cscart_products.shipping_params' in 'field list' (1054)
Invalid query: SELECT cscart_products.product_id, cscart_products.company_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = 'M', CONCAT(cscart_products_categories.category_id, 'M'), cscart_products_categories.category_id)) as category_ids, cscart_products.product_code, cscart_products.weight, cscart_products.tracking, cscart_product_descriptions.product, cscart_product_descriptions.short_description, cscart_products.is_edp, cscart_products.edp_shipping, cscart_products.shipping_freight, cscart_products.free_shipping, cscart_products.zero_price_action, cscart_products.tax_ids, cscart_products.qty_step, cscart_products.list_qty_count, cscart_products.max_qty, cscart_products.min_qty, cscart_products.amount as in_stock, cscart_products.shipping_params FROM cscart_products LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id AND cscart_product_descriptions.lang_code = 'EN' INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (cscart_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A', 'H') WHERE cscart_products.product_id = 29779 GROUP BY cscart_products.product_id
Backtrace:
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.database.php
Line: 310
Function: db_error
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.database.php
Line: 102
Function: db_query
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.cart.php
Line: 39
Function: db_get_row
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.cart.php
Line: 1548
Function: fn_get_cart_product_data
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.cart.php
Line: 832
Function: fn_calculate_cart_content
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.init.php
Line: 672
Function: fn_extract_cart_content
File: C:\Inetpub\vhosts\domainname.com\httpdocs\init.php
Line: 176
Function: fn_init_user
File: C:\Inetpub\vhosts\domainname.com\httpdocs\index.php
Line: 24
Function: require
[quote name='tbirnseth' timestamp='1308348419' post='115194']
Looks like you have an addon or something extra that is using a table name as part of a field list. What is the table name listed in the backtrace. The full sql would be helpful.
[/quote]
Hello Tjordan,
[quote name='tjordan' timestamp='1308574463' post='115330']
Appreciate the response and hope this helps in diagnosis.
Database error: Unknown column 'cscart_products.shipping_params' in 'field list' (1054)
Invalid query: SELECT cscart_products.product_id, cscart_products.company_id, GROUP_CONCAT(IF(cscart_products_categories.link_type = 'M', CONCAT(cscart_products_categories.category_id, 'M'), cscart_products_categories.category_id)) as category_ids, cscart_products.product_code, cscart_products.weight, cscart_products.tracking, cscart_product_descriptions.product, cscart_product_descriptions.short_description, cscart_products.is_edp, cscart_products.edp_shipping, cscart_products.shipping_freight, cscart_products.free_shipping, cscart_products.zero_price_action, cscart_products.tax_ids, cscart_products.qty_step, cscart_products.list_qty_count, cscart_products.max_qty, cscart_products.min_qty, cscart_products.amount as in_stock, cscart_products.shipping_params FROM cscart_products LEFT JOIN cscart_product_descriptions ON cscart_product_descriptions.product_id = cscart_products.product_id AND cscart_product_descriptions.lang_code = 'EN' INNER JOIN cscart_products_categories ON cscart_products_categories.product_id = cscart_products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (cscart_products.usergroup_ids = '' OR FIND_IN_SET(0, cscart_products.usergroup_ids) OR FIND_IN_SET(1, cscart_products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_products.status IN ('A', 'H') WHERE cscart_products.product_id = 29779 GROUP BY cscart_products.product_id
Backtrace:
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.database.php
Line: 310
Function: db_error
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.database.php
Line: 102
Function: db_query
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.cart.php
Line: 39
Function: db_get_row
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.cart.php
Line: 1548
Function: fn_get_cart_product_data
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.cart.php
Line: 832
Function: fn_calculate_cart_content
File: C:\Inetpub\vhosts\domainname.com\httpdocs\core\fn.init.php
Line: 672
Function: fn_extract_cart_content
File: C:\Inetpub\vhosts\domainname.com\httpdocs\init.php
Line: 176
Function: fn_init_user
File: C:\Inetpub\vhosts\domainname.com\httpdocs\index.php
Line: 24
Function: require
[/quote]
We are sorry to hear that you experience such a problem.
The problem requires the investigation on your server. Please contact us via Customer Help Desk and provide us with a temporary access to your server.
—
Anastasiya Kozlova
CS-Cart Support team