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` = 432 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(220) AND air.`attribute_item_id` IN(108,76,99,86) 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' => 432,
  '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` = 432 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(220) AND air.`attribute_item_id` IN(108,76,99,86) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 4',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.brooks-furniture.com/living-room/love-seats/?a_15=108&a_22=76&a_25=99&a_24=86??a_15=108&a_22=76&a_25=99&a_24=86',
  '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-18 22:58:21',
)


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` = 432 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` = 220 AND air.`attribute_item_id` IN(108,76,99,86) 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' => 432,
  '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` = 432 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` = 220 AND air.`attribute_item_id` IN(108,76,99,86) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 4',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.brooks-furniture.com/living-room/love-seats/?a_15=108&a_22=76&a_25=99&a_24=86??a_15=108&a_22=76&a_25=99&a_24=86',
  '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-18 22:58:21',
)


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` = 432 AND wp.`blocked` = 0 AND wp.`active` = 1 AND pi.`sequence` = 0 AND p.`category_id` IN(220) AND air.`attribute_item_id` IN(108,76,99,86) 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' => 432,
  '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` = 432 AND wp.`blocked` = 0 AND wp.`active` = 1 AND pi.`sequence` = 0 AND p.`category_id` IN(220)  AND air.`attribute_item_id` IN(108,76,99,86) 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.brooks-furniture.com/living-room/love-seats/?a_15=108&a_22=76&a_25=99&a_24=86??a_15=108&a_22=76&a_25=99&a_24=86',
  '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-18 22:58:21',
)


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


Love Seats furniture Albany GA | Brooks Furniture
229-888-3933

Home > Products > Living Room > Love Seats > Type: Stationary (x) > Finish Tone: Dark (x) > Width: > 54" (x) > Depth: 36" - 40" (x)