Array ( [0] => Array ( [0] => 22018 [SQLSTATE] => 22018 [1] => 245 [code] => 245 [2] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'Split A/C' to data type int. [message] => [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'Split A/C' to data type int. ) )
SELECT COUNT(DISTINCT p.product_id) AS total From oc_product p Inner join oc_product_description pd On p.product_id = pd.product_id Where pd.language_id = 2 And p.status = 1 And p.date_available < = GETDATE() And p.product_id in ( Select product_id from oc_product_to_store where store_id = 0 ) And p.model <> 'DISCOUNT' And (p.sizecode = '' OR p.sizecode is NULL OR left(p.sizecode,4) = 'Size') And p.product_id in ( Select product_id from oc_product_to_category where category_id = 2001 )
C:\inetpub\wwwroot\goodprice\catalog\model\catalog\product.phpNotice: Undefined index: message in C:\inetpub\wwwroot\goodprice\system\library\db\mssql.php on line 534
Fatal error: Uncaught Exception: Error: <br />SELECT COUNT(DISTINCT p.product_id) AS total From oc_product p Inner join oc_product_description pd On p.product_id = pd.product_id Where pd.language_id = 2 And p.status = 1 And p.date_available < = GETDATE() And p.product_id in ( Select product_id from oc_product_to_store where store_id = 0 ) And p.model <> 'DISCOUNT' And (p.sizecode = '' OR p.sizecode is NULL OR left(p.sizecode,4) = 'Size') And p.product_id in ( Select product_id from oc_product_to_category where category_id = 2001 ) in C:\inetpub\wwwroot\goodprice\system\library\db\mssql.php:534 Stack trace: #0 C:\inetpub\wwwroot\goodprice\system\library\db.php(16): DB\MSSQL->query('SELECT COUNT(DI...', Array) #1 C:\inetpub\wwwroot\goodprice\catalog\model\catalog\product.php(1046): DB->query('\r\n\t\t\tSELECT COU...') #2 C:\inetpub\wwwroot\goodprice\system\engine\loader.php(178): ModelCatalogProduct->getTotalProducts(Array) #3 C:\inetpub\wwwroot\goodprice\system\engine\proxy.php(25): Loader->{closure}(Array, Array) #4 in C:\inetpub\wwwroot\goodprice\system\library\db\mssql.php on line 534