Error writing file '/tmp/MYpiyl6M' (Errcode: 28 - No space left on device) (3)
SELECT SQL_CALC_FOUND_ROWS (CASE WHEN products.parent_product_id <> 0 THEN products.parent_product_id ELSE products.product_id END) AS product_id, descr1.product as product, companies.company as company_name, companies.ec_rfq_whatsapp_number, companies.ec_rfq_bht, companies.ec_rfq_phone_number, companies.ec_rfq_bhf, GROUP_CONCAT(products.product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_ids, GROUP_CONCAT(products.product_type ORDER BY products.parent_product_id ASC, products.product_id ASC) AS product_types, GROUP_CONCAT(products.parent_product_id ORDER BY products.parent_product_id ASC, products.product_id ASC) AS parent_product_ids, products.product_type, products.parent_product_id, cscart_ec_table_booking_system.booking_type as booking_type FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN cscart_ec_table_booking_system ON cscart_ec_table_booking_system.product_id = products.product_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1 AND cscart_categories.category_id IN (6328, 10398, 10518, 10519, 10520, 10521, 10542, 10543, 10544, 10545, 10629, 10437, 10438, 10439, 10440, 10441, 10442, 10443, 10444, 10446, 10447, 10445, 6340, 6379, 6425, 6544, 6581, 6615, 6664, 6703, 6761, 6795, 6827, 6847, 6967, 7003, 7059, 7090, 7119, 7150, 7182, 7237, 7268, 7287, 7355, 7395, 7470, 7476, 7540, 7541, 7543, 7545, 7548, 7551, 7554, 7558, 7575, 7581, 9033, 9035, 7668, 7678, 7683, 7713, 7717, 7721, 7728, 7735, 7742, 7747, 7768, 7754, 7783, 7798, 7802, 7831, 7917, 7948, 7955, 7965, 8074, 8076, 8099, 8129, 8175, 8178, 8184, 8190, 8198, 8130, 8136, 6471, 6504, 6538, 6563, 6594, 6628, 6663, 6689, 6731, 6851, 6884, 6914, 9037, 9038, 9040, 9041, 9042, 9043, 9044, 9045, 9046, 9047, 9048, 9050, 9051, 9052, 9053, 9054, 9055, 9057, 9058, 9059, 9060, 9061, 9062, 9063, 9064, 9065, 6483, 6500, 6525, 6545, 6560, 6591, 6622, 6665, 6704, 6767, 6798, 6860, 6907, 6960, 6997, 7021, 7075, 7106, 7133, 7174, 7198, 7220, 7276, 7292, 7313, 7335, 7367, 7388, 7455, 7460, 7466, 7474, 7479, 7556, 7562, 7570, 7714, 7720, 7730, 7800, 7816, 7836, 8143, 7850, 6964, 7009, 7060, 7102, 7142, 7187, 7279, 7312, 7358, 7393, 7458, 7467, 7542, 7547, 7552, 7565, 7574, 7586, 7597, 7610, 7619, 7632, 7637, 7646, 7656, 7247, 7264, 7282, 7294, 7310, 7322, 7341, 7360, 7376, 7389, 7399, 7463, 7468, 7473, 7477, 7481, 9066, 9067, 9068, 9069, 9070, 9071, 9072, 9073, 7620, 9078, 9079, 9080, 9081, 7633, 7644, 9082, 9083, 9074, 9075, 9076, 9077, 9031, 10396, 9084, 9085, 9086, 9087, 9088, 9089, 9090, 9091, 9092, 9093, 9094, 9095, 9096, 9097, 9098) AND companies.status IN ('A') AND products.company_id IN (1, 25, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 108, 109, 110, 111, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 148, 150, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 196, 197, 198, 199, 200, 202, 203, 204, 205, 206, 207, 208, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 259, 260, 261, 262, 263, 264, 266, 268, 269, 271, 272, 273, 276, 277, 278, 279, 280, 281, 282, 284, 285, 286, 287, 288, 289, 290, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311, 312, 313, 314, 315, 316, 317, 318, 319, 321, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, 362, 363, 364, 365, 366, 367, 368, 369, 370, 371, 372, 373, 374, 377, 378, 379, 380, 381, 382, 383, 384, 385, 387, 388, 389, 391, 392, 393, 394, 395, 396, 397, 398, 400, 401, 402, 403, 404, 405, 406, 407, 408, 409, 410, 411, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 439, 440, 443, 445, 447, 448, 449, 450, 451, 452, 454, 455, 457, 458, 459, 460, 461, 462, 463, 465, 466, 467, 468, 469, 470, 471, 472, 473, 474, 476, 478, 479, 480, 481, 482, 483, 484, 485, 486, 487, 488, 489, 491, 492, 493, 494, 495, 496, 497, 498, 501, 503, 504, 505, 507, 508, 509, 510, 511, 512, 513, 514, 515, 516, 518, 519, 520, 522, 524, 525, 526, 527, 528, 531, 532, 533, 535, 537, 539, 540, 541, 542, 543, 545, 546, 547, 548, 549, 550, 551, 553, 554, 556, 557, 558, 559, 560, 561, 562, 563, 564, 566, 567, 568, 569, 575, 576, 577, 579, 580, 582, 583, 585, 586, 587, 588, 590, 591, 592, 593, 594, 595, 596, 597, 598, 600, 602, 603, 604, 606, 607, 609, 610, 611, 613, 618, 620, 621, 622, 623, 624, 625, 626, 627, 628, 629, 630, 631, 632, 633, 634, 635, 636, 637, 639, 641, 642, 643, 644, 646, 647, 649, 655, 660, 661, 662, 663, 665, 668, 669, 670, 671, 672, 673, 674, 675, 676, 678, 679, 680, 681, 682, 685, 686, 687, 688, 689, 690, 691, 692, 693, 694, 695, 696, 697, 707, 719, 0) AND products.company_id IN ('671') AND products.status IN ('A') AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN ('A') AND prices.usergroup_id IN (0, 0, 1) GROUP BY product_id ORDER BY popularity.total desc, products.product_id ASC
app/Tygh/Database/Connection.php, line: 1712
| File: | app/Tygh/Database/Connection.php |
| Line: | 1489 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 699 |
| Function: | execQuery |
| File: | app/Tygh/Database/Connection.php |
| Line: | 332 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 35 |
| Function: | getArray |
| File: | app/functions/fn.products.php |
| Line: | 2354 |
| Function: | db_get_array |
| File: | app/functions/fn.products.php |
| Line: | 2437 |
| Function: | {closure} |
| File: | app/addons/et_vivashop_settings/func.php |
| Line: | 474 |
| Function: | fn_get_products |
| File: | app/functions/fn.control.php |
| Line: | 123 |
| Function: | fn_et_vivashop_settings_get_filters_products_count_post |
| File: | app/functions/fn.filters.php |
| Line: | 1450 |
| Function: | fn_set_hook |
| File: | app/Tygh/BlockManager/Block.php |
| Line: | 974 |
| Function: | fn_product_filters_get_filters_products_count |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 810 |
| Function: | getItems |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 666 |
| Function: | getValue |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 493 |
| Function: | renderBlockContent |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 415 |
| Function: | renderBlock |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 373 |
| Function: | renderBlocks |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 230 |
| Function: | renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 200 |
| Function: | renderGrids |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 164 |
| Function: | _renderContainer |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 52 |
| Function: | render |
| File: | var/cache/templates/vivashop/ad7c94170d7ada34d32051ceb16be792b21420fa_2.tygh.et_content.pre.tpl.php |
| Line: | 53 |
| Function: | smarty_function_render_location |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php |
| Line: | 123 |
| Function: | content_67079d99de7f72_14185552 |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php |
| Line: | 114 |
| Function: | getRenderedTemplateCode |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php |
| Line: | 216 |
| Function: | render |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 238 |
| Function: | render |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 116 |
| Function: | _execute |
| File: | app/functions/smarty_plugins/block.hook.php |
| Line: | 129 |
| Function: | fetch |
| File: | var/cache/templates/vivashop/62ef1b660e00ee757ff29c728d8df0587b71adfb_2.tygh.index.tpl.php |
| Line: | 211 |
| Function: | smarty_block_hook |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php |
| Line: | 123 |
| Function: | content_67079d9912a201_44381537 |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php |
| Line: | 114 |
| Function: | getRenderedTemplateCode |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php |
| Line: | 216 |
| Function: | render |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 238 |
| Function: | render |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 116 |
| Function: | _execute |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 81 |
| Function: | fetch |
| File: | app/functions/fn.control.php |
| Line: | 632 |
| Function: | fetch |
| File: | index.php |
| Line: | 19 |
| Function: | fn_dispatch |