#0 Zend_Db_Statement_Mysqli->_execute(Array ()) called at [/var/www/domains/bs-media.ru/lib/Zend/Db/Statement.php:320] #1 Zend_Db_Statement->execute(Array ()) called at [/var/www/domains/bs-media.ru/lib/Zend/Db/Adapter/Abstract.php:468] #2 Zend_Db_Adapter_Abstract->query(SELECT `i`.`item_id`, `i`.`name`, `i`.`typename`, `i`.`price`, `i`.`currency_id`, `b`.`name` AS `brand_name`, `b`.`display_prices` AS `brand_dp`, ABS(i.item_id - 1579) AS `item_id_abs` FROM `item` AS `i` INNER JOIN `cat_item` AS `ci1` ON ci1.item_id = i.item_id INNER JOIN `catalogue` AS `c0` ON c0.catalogue_id = ci1.catalogue_id INNER JOIN `links` AS `l` ON ci1.catalogue_id = l.id and l.parent_id=254 and l.type=2 LEFT JOIN `brand` AS `b` ON b.brand_id = i.brand_id WHERE (i.realstatus = 1) AND (i.catalogue_id = 215 and i.item_id <> 1579) GROUP BY `i`.`item_id` ORDER BY `item_id_abs` ASC LIMIT 2, Array ()) called at [/var/www/domains/bs-media.ru/lib/Zend/Db/Adapter/Abstract.php:706] #3 Zend_Db_Adapter_Abstract->fetchAll(Zend_Db_Select Object ([*_bind] => Array (),[*_adapter] => Zend_Db_Adapter_Mysqli Object ([*_numericDataTypes] => Array ([0] => 0,[1] => 1,[2] => 2,[INT] => 0,[INTEGER] => 0,[MEDIUMINT] => 0,[SMALLINT] => 0,[TINYINT] => 0,[BIGINT] => 1,[SERIAL] => 1,[DEC] => 2,[DECIMAL] => 2,[DOUBLE] => 2,[DOUBLE PRECISION] => 2,[FIXED] => 2,[FLOAT] => 2),[*_stmt] => Zend_Db_Statement_Mysqli Object ([*_keys] => ,[*_values] => ,[*_meta] => ,[*_stmt] => mysqli_stmt Object ([affected_rows] => ,[insert_id] => ,[num_rows] => ,[param_count] => ,[field_count] => ,[errno] => ,[error] => ,[error_list] => ,[sqlstate] => ,[id] => ),[*_adapter] => Zend_Db_Adapter_Mysqli Object ( *RECURSION*,[*_fetchMode] => 2,[*_attribute] => Array (),[*_bindColumn] => Array (),[*_bindParam] => Array (),[*_sqlSplit] => Array ([0] => SELECT `i`.`item_id`, `i`.`name`, `i`.`typename`, `i`.`price`, `i`.`currency_id`, `b`.`name` AS `brand_name`, `b`.`display_prices` AS `brand_dp`, ABS(i.item_id - 1579) AS `item_id_abs` FROM `item` AS `i` INNER JOIN `cat_item` AS `ci1` ON ci1.item_id = i.item_id INNER JOIN `catalogue` AS `c0` ON c0.catalogue_id = ci1.catalogue_id INNER JOIN `links` AS `l` ON ci1.catalogue_id = l.id and l.parent_id=254 and l.type=2 LEFT JOIN `brand` AS `b` ON b.brand_id = i.brand_id WHERE (i.realstatus = 1) AND (i.catalogue_id = 215 and i.item_id <> 1579) GROUP BY `i`.`item_id` ORDER BY `item_id_abs` ASC LIMIT 2),[*_sqlParam] => Array ([0] => SELECT `i`.`item_id`, `i`.`name`, `i`.`typename`, `i`.`price`, `i`.`currency_id`, `b`.`name` AS `brand_name`, `b`.`display_prices` AS `brand_dp`, ABS(i.item_id - 1579) AS `item_id_abs` FROM `item` AS `i` INNER JOIN `cat_item` AS `ci1` ON ci1.item_id = i.item_id INNER JOIN `catalogue` AS `c0` ON c0.catalogue_id = ci1.catalogue_id INNER JOIN `links` AS `l` ON ci1.catalogue_id = l.id and l.parent_id=254 and l.type=2 LEFT JOIN `brand` AS `b` ON b.brand_id = i.brand_id WHERE (i.realstatus = 1) AND (i.catalogue_id = 215 and i.item_id <> 1579) GROUP BY `i`.`item_id` ORDER BY `item_id_abs` ASC LIMIT 2),[*_queryId] => 37),[*_defaultStmtClass] => Zend_Db_Statement_Mysqli,[*_config] => Array ([host] => localhost,[username] => bs,[password] => aBrING7tOc-E,[dbname] => u260954,[charset] => ,[persistent] => ,[options] => Array ([caseFolding] => 0,[autoQuoteIdentifiers] => 1),[driver_options] => Array ()),[*_fetchMode] => 2,[*_profiler] => Zend_Db_Profiler Object ([*_queryProfiles] => Array ([0] => Zend_Db_Profiler_Query Object ([*_query] => SET NAMES 'utf8',[*_queryType] => 2,[*_startedMicrotime] => 1686096934.2167,[*_endedMicrotime] => 1686096934.2168,[*_boundParams] => Array ()),[1] => Zend_Db_Profiler_Query Object ([*_query] => SET CHARACTER SET 'utf8',[*_queryType] => 2,[*_startedMicrotime] => 1686096934.217,[*_endedMicrotime] => 1686096934.217,[*_boundParams] => Array ()),[2] => Zend_Db_Profiler_Query Object ([*_query] => SET SESSION collation_connection = 'utf8_general_ci',[*_queryType] => 2,[*_startedMicrotime] => 1686096934.2172,[*_endedMicrotime] => 1686096934.2173,[*_boundParams] => Array ()),[3] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id, modelname FROM cmf_script WHERE url = ? limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2337,[*_endedMicrotime] => 1686096934.2339,[*_boundParams] => Array ([1] => bs-media.ru)),[4] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id, name FROM cmf_script WHERE article=?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2341,[*_endedMicrotime] => 1686096934.2342,[*_boundParams] => Array ([1] => Item)),[5] => Zend_Db_Profiler_Query Object ([*_query] => SELECT parent_id, name, url FROM cmf_script WHERE cmf_script_id = ?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2344,[*_endedMicrotime] => 1686096934.2346,[*_boundParams] => Array ([1] => 229)),[6] => Zend_Db_Profiler_Query Object ([*_query] => SELECT parent_id, name, url FROM cmf_script WHERE cmf_script_id = ?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2348,[*_endedMicrotime] => 1686096934.2349,[*_boundParams] => Array ([1] => 228)),[7] => Zend_Db_Profiler_Query Object ([*_query] => SELECT parent_id, name, url FROM cmf_script WHERE cmf_script_id = ?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2351,[*_endedMicrotime] => 1686096934.2352,[*_boundParams] => Array ([1] => 225)),[8] => Zend_Db_Profiler_Query Object ([*_query] => SELECT parent_id, name, url FROM cmf_script WHERE cmf_script_id = ?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2354,[*_endedMicrotime] => 1686096934.2355,[*_boundParams] => Array ([1] => 13)),[9] => Zend_Db_Profiler_Query Object ([*_query] => SELECT parent_id, name, url FROM cmf_script WHERE cmf_script_id = ?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2357,[*_endedMicrotime] => 1686096934.2359,[*_boundParams] => Array ([1] => 1)),[10] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id FROM cmf_script WHERE url = ? limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2362,[*_endedMicrotime] => 1686096934.2363,[*_boundParams] => Array ([1] => bs-media.ru)),[11] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id FROM cmf_script WHERE article=? and cmf_script_id=?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2365,[*_endedMicrotime] => 1686096934.2366,[*_boundParams] => Array ([1] => front,[2] => 254)),[12] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id FROM cmf_script WHERE url = ? limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2368,[*_endedMicrotime] => 1686096934.2369,[*_boundParams] => Array ([1] => bs-media.ru)),[13] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id FROM cmf_script WHERE url = ? limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2372,[*_endedMicrotime] => 1686096934.2373,[*_boundParams] => Array ([1] => bs-media.ru)),[14] => Zend_Db_Profiler_Query Object ([*_query] => SELECT i.catalogue_id FROM item i INNER JOIN links l ON (l.id = i.catalogue_id and l.parent_id=254 and l.type=2) WHERE i.item_id = ?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2375,[*_endedMicrotime] => 1686096934.2379,[*_boundParams] => Array ([1] => 1579)),[15] => Zend_Db_Profiler_Query Object ([*_query] => SELECT `i`.`item_id`, `i`.`name`, `ils2`.`flag` AS `have_attributes`, `i`.`title`, `i`.`typename`, `i`.`price`, `i`.`complex_price`, `i`.`models_in_description`, `i`.`currency_id`, `i`.`article`, `i`.`description`, `i`.`catalogue_id`, `b`.`name` AS `brand_name`, `b`.`display_prices` AS `brand_dp`, `b`.`brand_id`, `x`.`xml`, `c`.`realcatname` FROM `item` AS `i` INNER JOIN `cat_item` AS `ci1` ON ci1.item_id = i.item_id INNER JOIN `catalogue` AS `c0` ON c0.catalogue_id = ci1.catalogue_id INNER JOIN `links` AS `l` ON ci1.catalogue_id = l.id and l.parent_id=254 and l.type=2 LEFT JOIN `brand` AS `b` ON b.brand_id = i.brand_id LEFT JOIN `item_link` AS `ils2` ON ils2.item_id = i.item_id and ils2.item_link_type_id=7 INNER JOIN `links` AS `l3` ON ils2.linked_item_id = l3.id and l3.parent_id=254 and l3.type=2 LEFT JOIN `xmls` AS `x` ON x.xmls_id = i.item_id and x.type = 3 INNER JOIN `catalogue` AS `c` ON c.catalogue_id = i.catalogue_id WHERE (i.realstatus = 1) AND (i.item_id = 1579) GROUP BY `i`.`item_id`,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2385,[*_endedMicrotime] => 1686096934.2398,[*_boundParams] => Array ()),[16] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id FROM cmf_script WHERE url = ? limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2401,[*_endedMicrotime] => 1686096934.2402,[*_boundParams] => Array ([1] => bs-media.ru)),[17] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id FROM cmf_script WHERE url = ? limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2423,[*_endedMicrotime] => 1686096934.2424,[*_boundParams] => Array ([1] => bs-media.ru)),[18] => Zend_Db_Profiler_Query Object ([*_query] => SELECT `item_image`.`item_image_id`, `item_image`.`image` FROM `item_image` WHERE (image <> "") AND (image is not NULL) AND (item_id = 1579) ORDER BY `ordering` ASC,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2427,[*_endedMicrotime] => 1686096934.2449,[*_boundParams] => Array ()),[19] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format where sysname = ?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2452,[*_endedMicrotime] => 1686096934.2453,[*_boundParams] => Array ([1] => item_card)),[20] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format_image where `table`=? and `field`=? and row_id=? and image_format_id=?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2455,[*_endedMicrotime] => 1686096934.2456,[*_boundParams] => Array ([1] => item_image,[2] => image_card,[3] => 1600,[4] => 3)),[21] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format where sysname = ?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2459,[*_endedMicrotime] => 1686096934.246,[*_boundParams] => Array ([1] => item_card_preview)),[22] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format_image where `table`=? and `field`=? and row_id=? and image_format_id=?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2462,[*_endedMicrotime] => 1686096934.2467,[*_boundParams] => Array ([1] => item_image,[2] => image_card_preview,[3] => 1600,[4] => 6)),[23] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format_image where `table`=? and `field`=? and row_id=? and image_format_id=?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2469,[*_endedMicrotime] => 1686096934.2472,[*_boundParams] => Array ([1] => item_image,[2] => image_card,[3] => 2330,[4] => 3)),[24] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format_image where `table`=? and `field`=? and row_id=? and image_format_id=?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2474,[*_endedMicrotime] => 1686096934.2477,[*_boundParams] => Array ([1] => item_image,[2] => image_card_preview,[3] => 2330,[4] => 6)),[25] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id FROM cmf_script WHERE url = ? limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2479,[*_endedMicrotime] => 1686096934.248,[*_boundParams] => Array ([1] => bs-media.ru)),[26] => Zend_Db_Profiler_Query Object ([*_query] => SELECT `item_prices`.`item_price_id`, `item_prices`.`price`, `item_prices`.`file_types_id` FROM `item_prices` WHERE (price <> "") AND (price is not NULL) AND (item_id = 1579) ORDER BY `ordering` ASC,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2483,[*_endedMicrotime] => 1686096934.2485,[*_boundParams] => Array ()),[27] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id FROM cmf_script WHERE url = ? limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2488,[*_endedMicrotime] => 1686096934.2489,[*_boundParams] => Array ([1] => bs-media.ru)),[28] => Zend_Db_Profiler_Query Object ([*_query] => SELECT `file_types`.* FROM `file_types`,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2492,[*_endedMicrotime] => 1686096934.2493,[*_boundParams] => Array ()),[29] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format where sysname = ?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2496,[*_endedMicrotime] => 1686096934.2497,[*_boundParams] => Array ([1] => icon_file_types)),[30] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format_image where `table`=? and `field`=? and row_id=? and image_format_id=?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2499,[*_endedMicrotime] => 1686096934.25,[*_boundParams] => Array ([1] => file_types,[2] => image,[3] => 1,[4] => 13)),[31] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format_image where `table`=? and `field`=? and row_id=? and image_format_id=?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2502,[*_endedMicrotime] => 1686096934.2503,[*_boundParams] => Array ([1] => file_types,[2] => image,[3] => 6,[4] => 13)),[32] => Zend_Db_Profiler_Query Object ([*_query] => select * from image_format_image where `table`=? and `field`=? and row_id=? and image_format_id=?,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2505,[*_endedMicrotime] => 1686096934.2506,[*_boundParams] => Array ([1] => file_types,[2] => image,[3] => 7,[4] => 13)),[33] => Zend_Db_Profiler_Query Object ([*_query] => SELECT cmf_script_id FROM cmf_script WHERE url = ? limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2511,[*_endedMicrotime] => 1686096934.2512,[*_boundParams] => Array ([1] => bs-media.ru)),[34] => Zend_Db_Profiler_Query Object ([*_query] => SELECT `item_xmls`.`item_xml_id`, `item_xmls`.`name`, `item_xmls`.`url`, `item_xmls`.`xml` FROM `item_xmls` WHERE (status) AND (item_id = 1579) ORDER BY `ordering` ASC,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2515,[*_endedMicrotime] => 1686096934.2517,[*_boundParams] => Array ()),[35] => Zend_Db_Profiler_Query Object ([*_query] => SELECT `i`.`item_id`, `i`.`name`, `i`.`typename`, `i`.`price`, `i`.`currency_id`, `b`.`name` AS `brand_name`, `b`.`display_prices` AS `brand_dp` FROM `item` AS `i` INNER JOIN `cat_item` AS `ci1` ON ci1.item_id = i.item_id INNER JOIN `catalogue` AS `c0` ON c0.catalogue_id = ci1.catalogue_id INNER JOIN `links` AS `l` ON ci1.catalogue_id = l.id and l.parent_id=254 and l.type=2 LEFT JOIN `brand` AS `b` ON b.brand_id = i.brand_id INNER JOIN `item_link` AS `il` ON il.item_link_type_id = 1 and il.linked_item_id = i.item_id and il.item_id = 1579 WHERE (i.realstatus = 1) GROUP BY `i`.`item_id` ORDER BY RAND() LIMIT 2,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2523,[*_endedMicrotime] => 1686096934.2528,[*_boundParams] => Array ()),[36] => Zend_Db_Profiler_Query Object ([*_query] => SELECT catalogue_id FROM item WHERE item_id = 1579 limit 1,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.253,[*_endedMicrotime] => 1686096934.2531,[*_boundParams] => Array ()),[37] => Zend_Db_Profiler_Query Object ([*_query] => SELECT `i`.`item_id`, `i`.`name`, `i`.`typename`, `i`.`price`, `i`.`currency_id`, `b`.`name` AS `brand_name`, `b`.`display_prices` AS `brand_dp`, ABS(i.item_id - 1579) AS `item_id_abs` FROM `item` AS `i` INNER JOIN `cat_item` AS `ci1` ON ci1.item_id = i.item_id INNER JOIN `catalogue` AS `c0` ON c0.catalogue_id = ci1.catalogue_id INNER JOIN `links` AS `l` ON ci1.catalogue_id = l.id and l.parent_id=254 and l.type=2 LEFT JOIN `brand` AS `b` ON b.brand_id = i.brand_id WHERE (i.realstatus = 1) AND (i.catalogue_id = 215 and i.item_id <> 1579) GROUP BY `i`.`item_id` ORDER BY `item_id_abs` ASC LIMIT 2,[*_queryType] => 32,[*_startedMicrotime] => 1686096934.2535,[*_endedMicrotime] => ,[*_boundParams] => Array ())),[*_enabled] => 1,[*_filterElapsedSecs] => ,[*_filterTypes] => ),[*_defaultProfilerClass] => Zend_Db_Profiler,[*_connection] => mysqli Object ([affected_rows] => ,[client_info] => ,[client_version] => ,[connect_errno] => ,[connect_error] => ,[errno] => ,[error] => ,[error_list] => ,[field_count] => ,[host_info] => ,[info] => ,[insert_id] => ,[server_info] => ,[server_version] => ,[stat] => ,[sqlstate] => ,[protocol_version] => ,[thread_id] => ,[warning_count] => ),[*_caseFolding] => 0,[*_autoQuoteIdentifiers] => 1,[*_allowSerialization] => 1,[*_autoReconnectOnUnserialize] => ),[*_parts] => Array ([distinct] => ,[columns] => Array ([0] => Array ([0] => i,[1] => item_id,[2] => ),[1] => Array ([0] => i,[1] => name,[2] => ),[2] => Array ([0] => i,[1] => typename,[2] => ),[3] => Array ([0] => i,[1] => price,[2] => ),[4] => Array ([0] => i,[1] => currency_id,[2] => ),[5] => Array ([0] => b,[1] => name,[2] => brand_name),[6] => Array ([0] => b,[1] => display_prices,[2] => brand_dp),[7] => Array ([0] => i,[1] => Zend_Db_Expr Object ([*_expression] => ABS(i.item_id - 1579)),[2] => item_id_abs)),[union] => Array (),[from] => Array ([i] => Array ([joinType] => from,[schema] => ,[tableName] => item,[joinCondition] => ),[ci1] => Array ([joinType] => inner join,[schema] => ,[tableName] => cat_item,[joinCondition] => ci1.item_id = i.item_id),[c0] => Array ([joinType] => inner join,[schema] => ,[tableName] => catalogue,[joinCondition] => c0.catalogue_id = ci1.catalogue_id),[l] => Array ([joinType] => inner join,[schema] => ,[tableName] => links,[joinCondition] => ci1.catalogue_id = l.id and l.parent_id=254 and l.type=2),[b] => Array ([joinType] => left join,[schema] => ,[tableName] => brand,[joinCondition] => b.brand_id = i.brand_id)),[where] => Array ([0] => (i.realstatus = 1),[1] => AND (i.catalogue_id = 215 and i.item_id <> 1579)),[group] => Array ([0] => i.item_id),[having] => Array (),[order] => Array ([0] => Array ([0] => item_id_abs,[1] => ASC)),[limitcount] => 2,[limitoffset] => 0,[forupdate] => ),[*_tableCols] => Array ())) called at [/var/www/domains/bs-media.ru/models/Item.php:711] #4 Item->getRelatedItems(1579, Array ([limit] => 2)) called at [/var/www/domains/bs-media.ru/controllers/ItemController.php:56] #5 ItemController->indexAction() called at [/var/www/domains/bs-media.ru/lib/Abstract_Controller.php:112] #6 Abstract_Controller->dispatch(Array ()) called at [/var/www/domains/bs-media.ru/rewrite.php:137]
Message: Mysqli statement execute error : BIGINT UNSIGNED value is out of range in '(`u260954`.`i`.`item_id` - 1579)'
Code: 1690
File: /var/www/domains/bs-media.ru/lib/Zend/Db/Statement/Mysqli.php
Line: 218
Trace: