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