Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` ) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND pi.`sequence` = 0 AND wp.`website_id` = 189 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(258) AND air.`attribute_item_id` IN(776,798,752,770) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 4

::DEBUG:: An error has occurred:

Failed to fetch product count including sub_categories.

array (
  'website_id' => 189,
  'message' => 'Failed to fetch product count including sub_categories.',
  'sql' => 'SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id` ) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` )  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND pi.`sequence` = 0 AND wp.`website_id` = 189 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(258) AND air.`attribute_item_id` IN(776,798,752,770) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 4',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.furnitureworldnw.com/leather/leather-chairs/?a_137=776&a_141=798&a_134=752&a_136=770??a_137=776&a_141=798&a_134=752&a_136=770',
  'referer' => NULL,
  'line' => 599,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::product_count',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-20 02:32:14',
)


To disable these messages, edit s98_fw/config.php file.


Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id`) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` ) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND pi.`sequence` = 0 AND wp.`website_id` = 189 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` = 258 AND air.`attribute_item_id` IN(776,798,752,770) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 4

::DEBUG:: An error has occurred:

Failed to fetch product count NOT including sub_categories.

array (
  'website_id' => 189,
  'message' => 'Failed to fetch product count NOT including sub_categories.',
  'sql' => 'SELECT DISTINCT p.`product_id` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id`) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id` )  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND pi.`sequence` = 0 AND wp.`website_id` = 189 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` = 258 AND air.`attribute_item_id` IN(776,798,752,770) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 4',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.furnitureworldnw.com/leather/leather-chairs/?a_137=776&a_141=798&a_134=752&a_136=770??a_137=776&a_141=798&a_134=752&a_136=770',
  'referer' => NULL,
  'line' => 607,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::product_count',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-20 02:32:14',
)


To disable these messages, edit s98_fw/config.php file.


Studio98 Framework database error: [Unknown column 'a.product_id' in 'on clause']
SELECT p.`product_id`, p.`category_id`, p.`name`, p.`slug`, p.`description`, wp.`price`, wp.`sale_price`, wp.`price_note`, wp.`status`, pi.`image`, i.`name` AS industry, IF( wp.`weight` <> 0, wp.`weight`, p.`weight` ) AS `weight` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id`) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id`) INNER JOIN `industries` AS i ON ( i.`industry_id` = p.`industry_id`) LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = 'public' AND wp.`website_id` = 189 AND wp.`blocked` = 0 AND wp.`active` = 1 AND pi.`sequence` = 0 AND p.`category_id` IN(258) AND air.`attribute_item_id` IN(776,798,752,770) GROUP BY p.`product_id` HAVING COUNT(air.`product_id`) = 4 ORDER BY wp.`sequence` LIMIT 0, 9

::DEBUG:: An error has occurred:

Failed to fetch products including sub_categories.

array (
  'website_id' => 189,
  'message' => 'Failed to fetch products including sub_categories.',
  'sql' => 'SELECT p.`product_id`, p.`category_id`, p.`name`, p.`slug`, p.`description`, wp.`price`, wp.`sale_price`, wp.`price_note`, wp.`status`, pi.`image`,  i.`name` AS industry, IF( wp.`weight` <> 0, wp.`weight`, p.`weight` ) AS `weight` FROM `products` AS p LEFT JOIN `website_products` AS wp ON ( wp.`product_id` = p.`product_id`) LEFT JOIN `product_images` AS pi ON ( pi.`product_id` = p.`product_id`) INNER JOIN `industries` AS i ON ( i.`industry_id` = p.`industry_id`)  LEFT JOIN `attribute_item_relations` AS air ON ( a.`product_id` = air.`product_id` ) WHERE p.`publish_visibility` = \'public\' AND wp.`website_id` = 189 AND wp.`blocked` = 0 AND wp.`active` = 1 AND pi.`sequence` = 0 AND p.`category_id` IN(258)  AND air.`attribute_item_id` IN(776,798,752,770) GROUP BY p.`product_id`  HAVING COUNT(air.`product_id`) = 4 ORDER BY wp.`sequence` LIMIT 0, 9',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.furnitureworldnw.com/leather/leather-chairs/?a_137=776&a_141=798&a_134=752&a_136=770??a_137=776&a_141=798&a_134=752&a_136=770',
  'referer' => NULL,
  'line' => 73,
  'file' => '/gsr/platform/core/classes/products.php',
  'dir' => '/gsr/platform/core/classes',
  'function' => '',
  'class' => 'Products',
  'method' => 'Products::get_products',
  'browser_name' => 'unrecognized',
  'browser_version' => 'unknown',
  'browser_platform' => 'unrecognized',
  'browser_user_agent' => 'ccbot/2.0',
  'date_created' => '2013-05-20 02:32:14',
)


To disable these messages, edit s98_fw/config.php file.


Leather Chairs furniture Marysville WA | Furniture World NW
360-653-5312

Home > Products > Leather > Leather Chairs > Type: Reclining (x) > Finish Tone: Medium (x) > Color: Brown (x) > Height: > 40" (x)