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` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(257) AND air.`attribute_item_id` IN(764,772) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2

::DEBUG:: An error has occurred:

Failed to fetch product count including sub_categories.

array (
  'website_id' => 293,
  '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` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` IN(257) AND air.`attribute_item_id` IN(764,772) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/leather/leather-love-seats/?a_135=764&a_137=772??a_135=764&a_137=772',
  '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 15:28:46',
)


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` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` = 257 AND air.`attribute_item_id` IN(764,772) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2

::DEBUG:: An error has occurred:

Failed to fetch product count NOT including sub_categories.

array (
  'website_id' => 293,
  '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` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND p.`category_id` = 257 AND air.`attribute_item_id` IN(764,772) GROUP BY air.`product_id` HAVING COUNT(air.`product_id`) = 2',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/leather/leather-love-seats/?a_135=764&a_137=772??a_135=764&a_137=772',
  '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 15:28:46',
)


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` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND pi.`sequence` = 0 AND p.`category_id` IN(257) AND air.`attribute_item_id` IN(764,772) GROUP BY p.`product_id` HAVING COUNT(air.`product_id`) = 2 ORDER BY wp.`sequence` LIMIT 0, 9

::DEBUG:: An error has occurred:

Failed to fetch products including sub_categories.

array (
  'website_id' => 293,
  '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` = 293 AND wp.`blocked` = 0 AND wp.`active` = 1 AND pi.`sequence` = 0 AND p.`category_id` IN(257)  AND air.`attribute_item_id` IN(764,772) GROUP BY p.`product_id`  HAVING COUNT(air.`product_id`) = 2 ORDER BY wp.`sequence` LIMIT 0, 9',
  'sql_error' => 'Unknown column \'a.product_id\' in \'on clause\'',
  'page' => 'http://www.pricebustersmd.com/leather/leather-love-seats/?a_135=764&a_137=772??a_135=764&a_137=772',
  '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 15:28:46',
)


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


Leather Love Seats furniture Baltimore MD | Price Busters Furniture

Home > Products > Leather > Leather Love Seats > Style: Contemporary (x) > Color: Blue (x)