Jump to content

ledsales

Member
  • Posts

    9
  • Joined

  • Last visited

Profile Information

  • Gender
    Male
  • Location
    Tasmania

ledsales's Achievements

Rookie

Rookie (2/14)

  • Week One Done Rare
  • Dedicated Rare
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Well, they removed the increased limit and it all still works, but we decided to migrate it to a better account anyway. As luck would have it, they are discontinuing the cheaper service and shifting everyone to their main service in the next few weeks anyway, so we don't have to actually do anything...
  2. Thanks again, version is 6.4.4 I reckon it's the size of images that is the issue, I didn't realise that admin listings show a thumbnail of each product image which is actually the full sized image scaled for display, so it's opening 20 images, some at up to several MB each once decompressed. So if the problem comes back again when they reduce the temporary higher memory limit I will start reducing image sizes, or get my partner to. I don't think there are any corrupt files etc in the shop, it all operates normally, it was just bombing when it tried to display the products page in admin, and the only thing different about that is the images. I don't have time to look at code etc at the moment, am on my regular job so that wouldn't happen until the weekend.
  3. Sorry, I removed all the sql query info as there were no errors, it all looked normal, I can turn it back on and post it if you think it's worthwhile. Debug Output This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging". PHP: [Notice] /home/ribbonca/public_html/classes/ssl.class.php:39 - Undefined index: _g GET: 'Before Sanitise:' => 'After Sanitise:' => MySQLi Queries (5): 1. Hack: 1626695412.93550 --- Duration: 298 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS * FROM `ccCubeCart_sessions` WHERE ccCubeCart_sessions.session_id = '8a13809d9cc9d55b1bf5a924b2a435e6' LIMIT 1; 2. Hack: 1626695412.94330 --- Duration: 298 µs [CACHE READ] --- Key: sql.29136a2fd82e79bdc69cf14bfd234a44 SELECT * FROM `ccCubeCart_hooks` WHERE ccCubeCart_hooks.enabled = '1' ORDER BY priority ASC ; 3. Hack: 1626695412.94350 --- Duration: 298 µs [CACHE READ] --- Key: sql.301e5d710559e66eed39a32b08f958c9 SELECT * FROM `ccCubeCart_code_snippet` WHERE ccCubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; 4. Hack: 1626695412.94460 --- Duration: 866 µs [ERROR - NOT CACHED] INSERT INTO `ccCubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[<strong>Notice</strong>] /home/ribbonca/public_html/classes/ssl.class.php:39 - Undefined index: _g','http://ribboncafe.com.au/favicon.ico','mutingErrorHandler() (ssl.class.php:39)\n__construct() (ssl.class.php:54)\ngetInstance() (controller.index.inc.php:60)\ninclude() (index.php:21)\n','1626695412'); 5. Hack: 1626695412.94510 --- Duration: 363 µs [NOT CACHED] DELETE FROM `ccCubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; Memory: Peak Usage / Max (%): 4.09MB / 256M (1.6%) Cache (File): Enabled Cache Used: 389.93kB of 1.97MB (19.30%) [Clear Cache] Page Load Time: 0.041549205780029 seconds Debug Output This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging". PHP: No Errors or Warnings GET: 'Before Sanitise:' => '_g' => products 'node' => index 'After Sanitise:' => '_g' => products 'node' => index 'sort' => 'updated' => DESC MySQLi Queries (165): 1. Hack: 1626695414.38550 --- Duration: 300 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS * FROM `ccCubeCart_sessions` WHERE ccCubeCart_sessions.session_id = '8a13809d9cc9d55b1bf5a924b2a435e6' LIMIT 1; 2. Hack: 1626695414.38570 --- Duration: 108 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 3. Hack: 1626695414.40940 --- Duration: 267 µs [NOT CACHED] SELECT * FROM `ccCubeCart_lang_strings` WHERE ccCubeCart_lang_strings.language = 'en-GB' ; 4. Hack: 1626695414.41160 --- Duration: 393 µs [NOT CACHED] SELECT * FROM `ccCubeCart_hooks` WHERE ccCubeCart_hooks.enabled = '1' ORDER BY priority ASC ; 5. Hack: 1626695414.41260 --- Duration: 232 µs [NOT CACHED] SELECT * FROM `ccCubeCart_code_snippet` WHERE ccCubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; 6. Hack: 1626695414.41720 --- Duration: 243 µs [NOT CACHED] SELECT `name` FROM `ccCubeCart_geo_country` WHERE ccCubeCart_geo_country.numcode = '036' ; 7. Hack: 1626695414.41950 --- Duration: 449 µs [NOT CACHED] SELECT C.cat_id, C.cat_name, C.cat_parent_id, S.path FROM `ccCubeCart_category` as C LEFT JOIN `ccCubeCart_seo_urls` as S ON S.item_id=C.cat_id WHERE S.type='cat' AND S.redirect='0' ORDER BY C.cat_id DESC 8. Hack: 1626695414.42030 --- Duration: 141 µs [NOT CACHED] SELECT `cat_id`, `cat_name` FROM `ccCubeCart_category_language` WHERE ccCubeCart_category_language.language = 'en-GB' ; 9. Hack: 1626695414.42560 --- Duration: 165 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MIN(`live_from`) AS `next_time` FROM `ccCubeCart_inventory` WHERE `live_from` > UNIX_TIMESTAMP() LIMIT 1; 10. Hack: 1626695414.42570 --- Duration: 90 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 11. Hack: 1626695414.42790 --- Duration: 173 µs [NOT CACHED] SELECT * FROM `ccCubeCart_permissions` WHERE ccCubeCart_permissions.admin_id = '2' ; 12. Hack: 1626695414.46470 --- Duration: 404 µs [NOT CACHED] SELECT `cat_parent_id`, `cat_id`, `cat_name` FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '0' ORDER BY priority, cat_name ASC ; 13. Hack: 1626695414.46490 --- Duration: 179 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '24'; 14. Hack: 1626695414.46510 --- Duration: 144 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '4'; 15. Hack: 1626695414.46530 --- Duration: 212 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '7'; 16. Hack: 1626695414.46550 --- Duration: 152 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '22'; 17. Hack: 1626695414.46570 --- Duration: 132 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '23'; 18. Hack: 1626695414.46600 --- Duration: 307 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '5'; 19. Hack: 1626695414.46620 --- Duration: 183 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '3'; 20. Hack: 1626695414.46640 --- Duration: 199 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '2'; 21. Hack: 1626695414.46660 --- Duration: 146 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '19'; 22. Hack: 1626695414.46680 --- Duration: 194 µs [NOT CACHED] SELECT COUNT(cat_id) AS Count FROM `ccCubeCart_category` WHERE ccCubeCart_category.cat_parent_id = '25'; 23. Hack: 1626695414.50110 --- Duration: 1335 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS * FROM `ccCubeCart_inventory` ORDER BY `updated` DESC LIMIT 20 OFFSET 0; 24. Hack: 1626695414.50130 --- Duration: 120 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 25. Hack: 1626695415.02580 --- Duration: 869 µs [NOT CACHED] SELECT DISTINCT UPPER(LEFT(`name`, 1)) AS `char` FROM `ccCubeCart_inventory` 26. Hack: 1626695415.02700 --- Duration: 281 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '194' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 27. Hack: 1626695415.02720 --- Duration: 99 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 28. Hack: 1626695415.02820 --- Duration: 418 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '194' ; 29. Hack: 1626695415.02910 --- Duration: 314 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '194' AND ccCubeCart_image_index.main_img = '1' ; 30. Hack: 1626695415.03010 --- Duration: 305 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '168' ; 31. Hack: 1626695415.03090 --- Duration: 184 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '168' ; 32. Hack: 1626695415.06070 --- Duration: 139 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '194' ; 33. Hack: 1626695415.06160 --- Duration: 797 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '209' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 34. Hack: 1626695415.06170 --- Duration: 106 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 35. Hack: 1626695415.06210 --- Duration: 260 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '209' ; 36. Hack: 1626695415.06230 --- Duration: 180 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '209' AND ccCubeCart_image_index.main_img = '1' ; 37. Hack: 1626695415.06270 --- Duration: 395 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ; 38. Hack: 1626695415.06310 --- Duration: 171 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ; 39. Hack: 1626695415.06350 --- Duration: 231 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '209' ; 40. Hack: 1626695415.06380 --- Duration: 213 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '175' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 41. Hack: 1626695415.06390 --- Duration: 104 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 42. Hack: 1626695415.06420 --- Duration: 175 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '175' ; 43. Hack: 1626695415.06440 --- Duration: 150 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '175' AND ccCubeCart_image_index.main_img = '1' ; 44. Hack: 1626695415.06450 --- Duration: 152 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ; 45. Hack: 1626695415.06480 --- Duration: 176 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ; 46. Hack: 1626695415.06500 --- Duration: 103 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '175' ; 47. Hack: 1626695415.06530 --- Duration: 171 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '193' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 48. Hack: 1626695415.06540 --- Duration: 93 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 49. Hack: 1626695415.06570 --- Duration: 175 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '193' ; 50. Hack: 1626695415.06590 --- Duration: 156 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '193' AND ccCubeCart_image_index.main_img = '1' ; 51. Hack: 1626695415.06600 --- Duration: 146 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ; 52. Hack: 1626695415.06630 --- Duration: 141 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '167' ; 53. Hack: 1626695415.06650 --- Duration: 118 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '193' ; 54. Hack: 1626695415.06680 --- Duration: 251 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '221' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 55. Hack: 1626695415.06690 --- Duration: 88 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 56. Hack: 1626695415.06710 --- Duration: 170 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '221' ; 57. Hack: 1626695415.06730 --- Duration: 162 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '221' AND ccCubeCart_image_index.main_img = '1' ; 58. Hack: 1626695415.06750 --- Duration: 151 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '166' ; 59. Hack: 1626695415.06780 --- Duration: 148 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '166' ; 60. Hack: 1626695415.06800 --- Duration: 115 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '221' ; 61. Hack: 1626695415.06820 --- Duration: 166 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '220' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 62. Hack: 1626695415.06830 --- Duration: 78 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 63. Hack: 1626695415.06850 --- Duration: 153 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '220' ; 64. Hack: 1626695415.06870 --- Duration: 161 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '220' AND ccCubeCart_image_index.main_img = '1' ; 65. Hack: 1626695415.06890 --- Duration: 150 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '165' ; 66. Hack: 1626695415.06920 --- Duration: 154 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '165' ; 67. Hack: 1626695415.06940 --- Duration: 112 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '220' ; 68. Hack: 1626695415.06960 --- Duration: 170 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '219' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 69. Hack: 1626695415.06970 --- Duration: 104 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 70. Hack: 1626695415.06990 --- Duration: 174 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '219' ; 71. Hack: 1626695415.07020 --- Duration: 238 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '219' AND ccCubeCart_image_index.main_img = '1' ; 72. Hack: 1626695415.07040 --- Duration: 166 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '127' ; 73. Hack: 1626695415.07070 --- Duration: 155 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '127' ; 74. Hack: 1626695415.07090 --- Duration: 125 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '219' ; 75. Hack: 1626695415.07120 --- Duration: 302 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '146' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 76. Hack: 1626695415.07140 --- Duration: 113 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 77. Hack: 1626695415.07170 --- Duration: 217 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '146' ; 78. Hack: 1626695415.07190 --- Duration: 161 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '146' AND ccCubeCart_image_index.main_img = '1' ; 79. Hack: 1626695415.07210 --- Duration: 144 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '128' ; 80. Hack: 1626695415.07240 --- Duration: 157 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '128' ; 81. Hack: 1626695415.07260 --- Duration: 100 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '146' ; 82. Hack: 1626695415.07280 --- Duration: 177 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '70' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 83. Hack: 1626695415.07290 --- Duration: 87 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 84. Hack: 1626695415.07320 --- Duration: 211 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '70' ; 85. Hack: 1626695415.07340 --- Duration: 166 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '70' AND ccCubeCart_image_index.main_img = '1' ; 86. Hack: 1626695415.07370 --- Duration: 242 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '62' ; 87. Hack: 1626695415.07400 --- Duration: 154 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '62' ; 88. Hack: 1626695415.07420 --- Duration: 101 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '70' ; 89. Hack: 1626695415.07440 --- Duration: 202 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '157' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 90. Hack: 1626695415.07450 --- Duration: 83 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 91. Hack: 1626695415.07480 --- Duration: 166 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '157' ; 92. Hack: 1626695415.07500 --- Duration: 163 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '157' AND ccCubeCart_image_index.main_img = '1' ; 93. Hack: 1626695415.07520 --- Duration: 161 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '130' ; 94. Hack: 1626695415.07540 --- Duration: 148 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '130' ; 95. Hack: 1626695415.07560 --- Duration: 108 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '157' ; 96. Hack: 1626695415.07580 --- Duration: 175 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '202' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 97. Hack: 1626695415.07590 --- Duration: 87 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 98. Hack: 1626695415.07630 --- Duration: 200 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '202' ; 99. Hack: 1626695415.07650 --- Duration: 161 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '202' AND ccCubeCart_image_index.main_img = '1' ; 100. Hack: 1626695415.07670 --- Duration: 156 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ; 101. Hack: 1626695415.07700 --- Duration: 200 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ; 102. Hack: 1626695415.07730 --- Duration: 125 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '202' ; 103. Hack: 1626695415.07750 --- Duration: 188 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '179' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 104. Hack: 1626695415.07760 --- Duration: 82 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 105. Hack: 1626695415.07780 --- Duration: 183 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '179' ; 106. Hack: 1626695415.07820 --- Duration: 281 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '179' AND ccCubeCart_image_index.main_img = '1' ; 107. Hack: 1626695415.07850 --- Duration: 269 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '101' ; 108. Hack: 1626695415.07880 --- Duration: 162 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '101' ; 109. Hack: 1626695415.07900 --- Duration: 114 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '179' ; 110. Hack: 1626695415.07940 --- Duration: 421 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '163' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 111. Hack: 1626695415.07970 --- Duration: 197 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 112. Hack: 1626695415.08000 --- Duration: 197 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '163' ; 113. Hack: 1626695415.08020 --- Duration: 183 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '163' AND ccCubeCart_image_index.main_img = '1' ; 114. Hack: 1626695415.08040 --- Duration: 180 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ; 115. Hack: 1626695415.08070 --- Duration: 181 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ; 116. Hack: 1626695415.08100 --- Duration: 127 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '163' ; 117. Hack: 1626695415.08130 --- Duration: 297 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '107' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 118. Hack: 1626695415.08150 --- Duration: 100 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 119. Hack: 1626695415.08180 --- Duration: 170 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '107' ; 120. Hack: 1626695415.08200 --- Duration: 161 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '107' AND ccCubeCart_image_index.main_img = '1' ; 121. Hack: 1626695415.08210 --- Duration: 157 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '130' ; 122. Hack: 1626695415.08240 --- Duration: 177 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '130' ; 123. Hack: 1626695415.08260 --- Duration: 112 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '107' ; 124. Hack: 1626695415.08290 --- Duration: 198 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '162' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 125. Hack: 1626695415.08300 --- Duration: 86 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 126. Hack: 1626695415.08330 --- Duration: 231 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '162' ; 127. Hack: 1626695415.08350 --- Duration: 203 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '162' AND ccCubeCart_image_index.main_img = '1' ; 128. Hack: 1626695415.08380 --- Duration: 189 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '135' ; 129. Hack: 1626695415.08410 --- Duration: 174 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '135' ; 130. Hack: 1626695415.08430 --- Duration: 101 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '162' ; 131. Hack: 1626695415.08450 --- Duration: 171 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '203' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 132. Hack: 1626695415.08460 --- Duration: 88 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 133. Hack: 1626695415.08490 --- Duration: 157 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '203' ; 134. Hack: 1626695415.08510 --- Duration: 167 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '203' AND ccCubeCart_image_index.main_img = '1' ; 135. Hack: 1626695415.08520 --- Duration: 142 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ; 136. Hack: 1626695415.08550 --- Duration: 142 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '136' ; 137. Hack: 1626695415.08570 --- Duration: 129 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '203' ; 138. Hack: 1626695415.08590 --- Duration: 201 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '213' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 139. Hack: 1626695415.08600 --- Duration: 82 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 140. Hack: 1626695415.08630 --- Duration: 159 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '213' ; 141. Hack: 1626695415.08650 --- Duration: 154 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '213' AND ccCubeCart_image_index.main_img = '1' ; 142. Hack: 1626695415.08660 --- Duration: 147 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '154' ; 143. Hack: 1626695415.08690 --- Duration: 141 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '154' ; 144. Hack: 1626695415.08710 --- Duration: 116 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '213' ; 145. Hack: 1626695415.08750 --- Duration: 291 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '8' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 146. Hack: 1626695415.08760 --- Duration: 80 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 147. Hack: 1626695415.08790 --- Duration: 304 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '8' ; 148. Hack: 1626695415.08820 --- Duration: 202 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '8' AND ccCubeCart_image_index.main_img = '1' ; 149. Hack: 1626695415.08840 --- Duration: 141 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '160' ; 150. Hack: 1626695415.08860 --- Duration: 163 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '160' ; 151. Hack: 1626695415.08890 --- Duration: 133 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '8' ; 152. Hack: 1626695415.08920 --- Duration: 258 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '218' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 153. Hack: 1626695415.08930 --- Duration: 101 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 154. Hack: 1626695415.08960 --- Duration: 209 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '218' ; 155. Hack: 1626695415.08990 --- Duration: 207 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '218' AND ccCubeCart_image_index.main_img = '1' ; 156. Hack: 1626695415.09010 --- Duration: 161 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '79' ; 157. Hack: 1626695415.09030 --- Duration: 141 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '79' ; 158. Hack: 1626695415.09050 --- Duration: 110 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '218' ; 159. Hack: 1626695415.09070 --- Duration: 188 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS MAX(stock_level) AS max_stock, MIN(stock_level) AS min_stock FROM `ccCubeCart_option_matrix` WHERE ccCubeCart_option_matrix.product_id = '217' AND ccCubeCart_option_matrix.use_stock = '1' AND ccCubeCart_option_matrix.status = '1' LIMIT 1; 160. Hack: 1626695415.09080 --- Duration: 83 µs [NOT CACHED] SELECT FOUND_ROWS() as Count; 161. Hack: 1626695415.09110 --- Duration: 165 µs [NOT CACHED] SELECT `cat_id` FROM `ccCubeCart_category_index` WHERE ccCubeCart_category_index.primary = '1' AND ccCubeCart_category_index.product_id = '217' ; 162. Hack: 1626695415.09130 --- Duration: 145 µs [NOT CACHED] SELECT file_id FROM `ccCubeCart_image_index` WHERE ccCubeCart_image_index.product_id = '217' AND ccCubeCart_image_index.main_img = '1' ; 163. Hack: 1626695415.09150 --- Duration: 177 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '79' ; 164. Hack: 1626695415.09170 --- Duration: 141 µs [NOT CACHED] SELECT * FROM `ccCubeCart_filemanager` WHERE ccCubeCart_filemanager.file_id = '79' ; 165. Hack: 1626695415.09190 --- Duration: 100 µs [NOT CACHED] SELECT `language`, `translation_id` FROM `ccCubeCart_inventory_language` WHERE ccCubeCart_inventory_language.product_id = '217' ; Memory: Peak Usage / Max (%): 8.15MB / 256M (3.18%) Cache (File): Always Disabled in ACP or Setup Cache Used: 0B of 1.97MB (0.00%) Page Load Time: 1.0260000228882 seconds
  4. Ok, thanks, relevant debug output is below, seems we are nowhere near the limit. Debug Output This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging". PHP: [Notice] /home/ribbonca/public_html/classes/ssl.class.php:39 - Undefined index: _g GET: 'Before Sanitise:' => 'After Sanitise:' => MySQLi Queries (5): 1. Hack: 1626654766.98900 --- Duration: 308 µs [NOT CACHED] SELECT SQL_CALC_FOUND_ROWS * FROM `ccCubeCart_sessions` WHERE ccCubeCart_sessions.session_id = 'ff52f147baee495b75647ad7092113f2' LIMIT 1; 2. Hack: 1626654766.99690 --- Duration: 308 µs [CACHE READ] --- Key: sql.29136a2fd82e79bdc69cf14bfd234a44 SELECT * FROM `ccCubeCart_hooks` WHERE ccCubeCart_hooks.enabled = '1' ORDER BY priority ASC ; 3. Hack: 1626654766.99710 --- Duration: 308 µs [CACHE READ] --- Key: sql.301e5d710559e66eed39a32b08f958c9 SELECT * FROM `ccCubeCart_code_snippet` WHERE ccCubeCart_code_snippet.enabled = '1' ORDER BY `priority` ASC ; 4. Hack: 1626654766.99800 --- Duration: 663 µs [ERROR - NOT CACHED] INSERT INTO `ccCubeCart_system_error_log` (`message`,`url`,`backtrace`,`time`) VALUES ('[<strong>Notice</strong>] /home/ribbonca/public_html/classes/ssl.class.php:39 - Undefined index: _g','http://ribboncafe.com.au/favicon.ico','mutingErrorHandler() (ssl.class.php:39)\n__construct() (ssl.class.php:54)\ngetInstance() (controller.index.inc.php:60)\ninclude() (index.php:21)\n','1626654766'); 5. Hack: 1626654766.99830 --- Duration: 191 µs [NOT CACHED] DELETE FROM `ccCubeCart_system_error_log` WHERE time < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 30 DAY)) ; Memory: Peak Usage / Max (%): 4.07MB / 256M (1.59%) Cache (File): Enabled Cache Used: 384.92kB of 1.75MB (21.53%) [Clear Cache] Page Load Time: 0.030229806900024 seconds Debug Output This can be disabled via "Store Settings" » "Advanced" (Tab) » "Enable Debugging". PHP: No Errors or Warnings GET: 'Before Sanitise:' => '_g' => products 'node' => index 'After Sanitise:' => '_g' => products 'node' => index 'sort' => 'updated' => DESC Memory: Peak Usage / Max (%): 6.34MB / 256M (2.48%) Cache (File): Always Disabled in ACP or Setup Cache Used: 0B of 1.75MB (0.00%) Page Load Time: 0.19681596755981 seconds One thing the web host mentioned was that they had seen this issue on other cube cart stores, so it might be something in the way cube cart interacts with their particular setup?
  5. Ok, seems it took a while to filter through, is working now, apparently we have 48 hours to get it sorted...
  6. Web host said they have temporarily doubled the available memory for this account, but it made no difference. They didn't explain why it was hitting a limit at just 11MB, just said "upgrade to a better account". Last time we had similar issues we got them, to do a restore from an earlier backup, which fixed it, so will have to resort to that I guess.
  7. Hi, no, current version is 7.2.34. I use Notepad++ as a text editor on windows, notepad++ was indeed set to CR+LF, can toggle it to LF only, so not a worry, just got to sort out this weird memory issue. The web host confirmed that it is reaching the resource limit for php memory, but that doesn't explain why it's generating errors with an allowed memory size of just 11MB. I will have to hassle them tomorrow or monday.
  8. Thanks for that, memory_limit says 2G in both local and master columns, so that doesn't look to be the issue. That's interesting about the image size, the largest image in any of the image subfolders is 349226 bytes, so just under the limit. But, I have no idea what level of compression she has used on them so they could in fact expand to be very large, but, there is no image larger than 62k uploaded in the last month, so not sure that's it as this only started a few days ago. As for the gdclass file, screengrab attached.
  9. My partner's site started giving a 500 error after she signed in a couple of days ago. It logs in fine, but then tries to bring up the default page (ribboncafe.com.au/rcadmin.php?_g=products&node=index) and she gets a 500 error. If you change the URL to ribboncafe.com.au/rcadmin.php then the admin page displays and everything works, except when you click the Products link, you get the 500 error again. Checking the error log shows this: "PHP Fatal error: Allowed memory size of 11534336 bytes exhausted (tried to allocate 8192 bytes) in /home/ribbonca/public_html/classes/gd.class.php on line 113" which is also confirmed by her web host. My question is, given 1MB/s is a common I/O limit on shared servers, what would be causing this and why did it just start happening after no changes to the site or hosting? Note that line 113 in gd.class.php appears to be just a comment line? There seems to be no way to increase any limits in her hosting, is it a case of CC just being too greedy? She has another site on the same hosting platform (different account though) in Zen Cart that has many more products and it has no issues.
×
×
  • Create New...