object(ArrayObject)#679 (1) {
  ["storage":"ArrayObject":private]=>
  array(3) {
    ["exception"]=>
    object(Zend_Db_Statement_Exception)#677 (7) {
      ["message":protected]=>
      string(3907) "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
                    FROM
                        base_product p
           ' at line 17, query was: 
            SELECT * FROM (
                SELECT baseProductId, stock, categoryname, etilize_name, categoryid, name, mfgpartno, supplierSku, cost, hardSellPrice, isStock, manufacturer, `rank`
                FROM (
                    SELECT
                        p.id AS baseProductId,
                        ds.dealerStock AS stock,
                        bc.name AS categoryname,
                        '' AS etilize_name,
                        bc.id AS categoryid,
                        p.name,
                        p.sku AS mfgpartno,
                        '' AS supplierSku,
                        ds.cost,
                        COALESCE(ds.fixedPrice, 'n/a') AS hardSellPrice,
                        IF(ds.dealerStock >= 1, 'Yes', 'No') AS isStock,
                        m.displayname AS manufacturer,
                        255 AS rank
                    FROM
                        base_product p
                    INNER JOIN
                        dealer_sku ds ON ds.dealerId = ? AND ds.skuId = p.id AND ds.online != 0
                    INNER JOIN
                        manufacturers m ON p.manufacturerId = m.id
                    INNER JOIN
                        base_category bc ON p.categoryid = bc.id
                    INNER JOIN
                        dealer_category dc ON dc.categoryId = bc.id AND dc.dealerId = ?
                    INNER JOIN
                        distribution d ON p.id = d.baseProductId AND d.dealerId = dc.dealerId
                    WHERE
                        p.categoryid = ?
                        AND COALESCE(dc.bucket_override, bc.default_bucket) IN ('sku', 'combined')
                        AND dc.active_category = 1
                        AND d.stockLevel >= 1

                    UNION

                    SELECT
                        p.id AS baseProductId,
                        ds.dealerStock AS stock,
                        bc.name AS categoryname,
                        '' AS etilize_name,
                        bc.id AS categoryid,
                        p.name,
                        p.sku AS mfgpartno,
                        '' AS supplierSku,
                        ds.cost,
                        COALESCE(ds.fixedPrice, 'n/a') AS hardSellPrice,
                        IF(ds.dealerStock >= 1, 'Yes', 'No') AS isStock,
                        m.displayname AS manufacturer,
                        sk.`rank`
                    FROM
                        base_product p
                    INNER JOIN
                        dealer_sku ds ON ds.dealerId = ? AND ds.skuId = p.id AND ds.online != 0
                    INNER JOIN
                        manufacturers m ON p.manufacturerId = m.id
                    INNER JOIN
                        base_category bc ON p.categoryid = bc.id
                    INNER JOIN
                        dealer_category dc ON dc.categoryId = bc.id AND dc.dealerId = ?
                    INNER JOIN
                        distribution d ON p.id = d.baseProductId AND d.dealerId = dc.dealerId
                    INNER JOIN
                        search_keywords sk ON sk.type = 'mpst_sku' AND sk.id = p.id
                    WHERE
                        p.categoryid = ?
                        AND COALESCE(dc.bucket_override, bc.default_bucket) IN ('sku', 'combined')
                        AND dc.active_category = 1
                        AND d.stockLevel >= 1
                ) AS combined
                GROUP BY baseProductId
            ) AS grouped
            ORDER BY `rank`, baseProductId, stock DESC, cost;
            "
      ["string":"Exception":private]=>
      string(0) ""
      ["code":protected]=>
      int(42000)
      ["file":protected]=>
      string(83) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php"
      ["line":protected]=>
      int(235)
      ["trace":"Exception":private]=>
      array(12) {
        [0]=>
        array(5) {
          ["file"]=>
          string(79) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Db/Statement.php"
          ["line"]=>
          int(304)
          ["function"]=>
          string(8) "_execute"
          ["class"]=>
          string(21) "Zend_Db_Statement_Pdo"
          ["type"]=>
          string(2) "->"
        }
        [1]=>
        array(5) {
          ["file"]=>
          string(68) "/var/www/html_production/library/MPSToolbox/Services/MPSTService.php"
          ["line"]=>
          int(4132)
          ["function"]=>
          string(7) "execute"
          ["class"]=>
          string(17) "Zend_Db_Statement"
          ["type"]=>
          string(2) "->"
        }
        [2]=>
        array(5) {
          ["file"]=>
          string(92) "/var/www/html_production/shopify-app/view/product/product-custom-sku-category-single-dev.php"
          ["line"]=>
          int(104)
          ["function"]=>
          string(27) "getCustomProductsByCategory"
          ["class"]=>
          string(31) "MPSToolbox\Services\MPSTService"
          ["type"]=>
          string(2) "->"
        }
        [3]=>
        array(4) {
          ["file"]=>
          string(62) "/var/www/html_production/shopify-app/view/product/category.php"
          ["line"]=>
          int(42)
          ["args"]=>
          array(1) {
            [0]=>
            string(92) "/var/www/html_production/shopify-app/view/product/product-custom-sku-category-single-dev.php"
          }
          ["function"]=>
          string(7) "include"
        }
        [4]=>
        array(4) {
          ["file"]=>
          string(61) "/var/www/html_production/shopify-app/public/shopify/index.php"
          ["line"]=>
          int(307)
          ["args"]=>
          array(1) {
            [0]=>
            string(62) "/var/www/html_production/shopify-app/view/product/category.php"
          }
          ["function"]=>
          string(7) "include"
        }
        [5]=>
        array(4) {
          ["file"]=>
          string(86) "/var/www/html_production/application/modules/default/controllers/ShopifyController.php"
          ["line"]=>
          int(121)
          ["args"]=>
          array(1) {
            [0]=>
            string(61) "/var/www/html_production/shopify-app/public/shopify/index.php"
          }
          ["function"]=>
          string(7) "require"
        }
        [6]=>
        array(5) {
          ["file"]=>
          string(84) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Controller/Action.php"
          ["line"]=>
          int(528)
          ["function"]=>
          string(11) "indexAction"
          ["class"]=>
          string(25) "Default_ShopifyController"
          ["type"]=>
          string(2) "->"
        }
        [7]=>
        array(5) {
          ["file"]=>
          string(97) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php"
          ["line"]=>
          int(308)
          ["function"]=>
          string(8) "dispatch"
          ["class"]=>
          string(22) "Zend_Controller_Action"
          ["type"]=>
          string(2) "->"
        }
        [8]=>
        array(5) {
          ["file"]=>
          string(83) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Controller/Front.php"
          ["line"]=>
          int(954)
          ["function"]=>
          string(8) "dispatch"
          ["class"]=>
          string(35) "Zend_Controller_Dispatcher_Standard"
          ["type"]=>
          string(2) "->"
        }
        [9]=>
        array(5) {
          ["file"]=>
          string(98) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php"
          ["line"]=>
          int(106)
          ["function"]=>
          string(8) "dispatch"
          ["class"]=>
          string(21) "Zend_Controller_Front"
          ["type"]=>
          string(2) "->"
        }
        [10]=>
        array(5) {
          ["file"]=>
          string(78) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Application.php"
          ["line"]=>
          int(400)
          ["function"]=>
          string(3) "run"
          ["class"]=>
          string(36) "Zend_Application_Bootstrap_Bootstrap"
          ["type"]=>
          string(2) "->"
        }
        [11]=>
        array(5) {
          ["file"]=>
          string(41) "/var/www/html_production/public/index.php"
          ["line"]=>
          int(58)
          ["function"]=>
          string(3) "run"
          ["class"]=>
          string(16) "Zend_Application"
          ["type"]=>
          string(2) "->"
        }
      }
      ["previous":"Exception":private]=>
      object(PDOException)#681 (8) {
        ["message":protected]=>
        string(283) "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
                    FROM
                        base_product p
           ' at line 17"
        ["string":"Exception":private]=>
        string(0) ""
        ["code":protected]=>
        string(5) "42000"
        ["file":protected]=>
        string(83) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php"
        ["line":protected]=>
        int(228)
        ["trace":"Exception":private]=>
        array(13) {
          [0]=>
          array(5) {
            ["file"]=>
            string(83) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Db/Statement/Pdo.php"
            ["line"]=>
            int(228)
            ["function"]=>
            string(7) "execute"
            ["class"]=>
            string(12) "PDOStatement"
            ["type"]=>
            string(2) "->"
          }
          [1]=>
          array(5) {
            ["file"]=>
            string(79) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Db/Statement.php"
            ["line"]=>
            int(304)
            ["function"]=>
            string(8) "_execute"
            ["class"]=>
            string(21) "Zend_Db_Statement_Pdo"
            ["type"]=>
            string(2) "->"
          }
          [2]=>
          array(5) {
            ["file"]=>
            string(68) "/var/www/html_production/library/MPSToolbox/Services/MPSTService.php"
            ["line"]=>
            int(4132)
            ["function"]=>
            string(7) "execute"
            ["class"]=>
            string(17) "Zend_Db_Statement"
            ["type"]=>
            string(2) "->"
          }
          [3]=>
          array(5) {
            ["file"]=>
            string(92) "/var/www/html_production/shopify-app/view/product/product-custom-sku-category-single-dev.php"
            ["line"]=>
            int(104)
            ["function"]=>
            string(27) "getCustomProductsByCategory"
            ["class"]=>
            string(31) "MPSToolbox\Services\MPSTService"
            ["type"]=>
            string(2) "->"
          }
          [4]=>
          array(4) {
            ["file"]=>
            string(62) "/var/www/html_production/shopify-app/view/product/category.php"
            ["line"]=>
            int(42)
            ["args"]=>
            array(1) {
              [0]=>
              string(92) "/var/www/html_production/shopify-app/view/product/product-custom-sku-category-single-dev.php"
            }
            ["function"]=>
            string(7) "include"
          }
          [5]=>
          array(4) {
            ["file"]=>
            string(61) "/var/www/html_production/shopify-app/public/shopify/index.php"
            ["line"]=>
            int(307)
            ["args"]=>
            array(1) {
              [0]=>
              string(62) "/var/www/html_production/shopify-app/view/product/category.php"
            }
            ["function"]=>
            string(7) "include"
          }
          [6]=>
          array(4) {
            ["file"]=>
            string(86) "/var/www/html_production/application/modules/default/controllers/ShopifyController.php"
            ["line"]=>
            int(121)
            ["args"]=>
            array(1) {
              [0]=>
              string(61) "/var/www/html_production/shopify-app/public/shopify/index.php"
            }
            ["function"]=>
            string(7) "require"
          }
          [7]=>
          array(5) {
            ["file"]=>
            string(84) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Controller/Action.php"
            ["line"]=>
            int(528)
            ["function"]=>
            string(11) "indexAction"
            ["class"]=>
            string(25) "Default_ShopifyController"
            ["type"]=>
            string(2) "->"
          }
          [8]=>
          array(5) {
            ["file"]=>
            string(97) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Controller/Dispatcher/Standard.php"
            ["line"]=>
            int(308)
            ["function"]=>
            string(8) "dispatch"
            ["class"]=>
            string(22) "Zend_Controller_Action"
            ["type"]=>
            string(2) "->"
          }
          [9]=>
          array(5) {
            ["file"]=>
            string(83) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Controller/Front.php"
            ["line"]=>
            int(954)
            ["function"]=>
            string(8) "dispatch"
            ["class"]=>
            string(35) "Zend_Controller_Dispatcher_Standard"
            ["type"]=>
            string(2) "->"
          }
          [10]=>
          array(5) {
            ["file"]=>
            string(98) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Application/Bootstrap/Bootstrap.php"
            ["line"]=>
            int(106)
            ["function"]=>
            string(8) "dispatch"
            ["class"]=>
            string(21) "Zend_Controller_Front"
            ["type"]=>
            string(2) "->"
          }
          [11]=>
          array(5) {
            ["file"]=>
            string(78) "/var/www/html_production/vendor/shardj/zf1-future/library/Zend/Application.php"
            ["line"]=>
            int(400)
            ["function"]=>
            string(3) "run"
            ["class"]=>
            string(36) "Zend_Application_Bootstrap_Bootstrap"
            ["type"]=>
            string(2) "->"
          }
          [12]=>
          array(5) {
            ["file"]=>
            string(41) "/var/www/html_production/public/index.php"
            ["line"]=>
            int(58)
            ["function"]=>
            string(3) "run"
            ["class"]=>
            string(16) "Zend_Application"
            ["type"]=>
            string(2) "->"
          }
        }
        ["previous":"Exception":private]=>
        NULL
        ["errorInfo"]=>
        array(3) {
          [0]=>
          string(5) "42000"
          [1]=>
          int(1064)
          [2]=>
          string(227) "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank
                    FROM
                        base_product p
           ' at line 17"
        }
      }
    }
    ["type"]=>
    string(15) "EXCEPTION_OTHER"
    ["request"]=>
    object(Zend_Controller_Request_Http)#680 (15) {
      ["_dispatched":protected]=>
      bool(true)
      ["_module":protected]=>
      string(7) "default"
      ["_moduleKey":protected]=>
      string(6) "module"
      ["_controller":protected]=>
      string(7) "shopify"
      ["_controllerKey":protected]=>
      string(10) "controller"
      ["_action":protected]=>
      string(5) "index"
      ["_actionKey":protected]=>
      string(6) "action"
      ["_params":protected]=>
      array(4) {
        ["path"]=>
        string(26) "product/category/POS Rolls"
        ["module"]=>
        string(7) "default"
        ["controller"]=>
        string(7) "shopify"
        ["action"]=>
        string(5) "index"
      }
      ["_paramSources":protected]=>
      array(2) {
        [0]=>
        string(4) "_GET"
        [1]=>
        string(5) "_POST"
      }
      ["_requestUri":protected]=>
      string(238) "/shopify/product/category/POS+Rolls?shop=carlyle-printers-service-and-supplies.myshopify.com&logged_in_customer_id=&path_prefix=%2Ftools%2Fmps×tamp=1794352947&signature=54b6d6f4097e796132b4a5fb69635861472df2726307e40abbd1dffe14b27515"
      ["_baseUrl":protected]=>
      string(0) ""
      ["_basePath":protected]=>
      NULL
      ["_pathInfo":protected]=>
      string(35) "/shopify/product/category/POS+Rolls"
      ["_rawBody":protected]=>
      NULL
      ["_aliases":protected]=>
      array(0) {
      }
    }
  }
}