Richard1967 Posted November 12, 2020 Share Posted November 12, 2020 Is anyone else getting error logs since latest upgrade? Increases to over 500 in 24 hours Link to comment Share on other sites More sharing options...
bsmither Posted November 12, 2020 Share Posted November 12, 2020 This has been happening since the past four or five versions of CubeCart We advise you to contact your hosting company and ask them to load the database server's system table with timezone information. It's easy to do, and should have been something they should have known to do as a hosting company. Link to comment Share on other sites More sharing options...
Richard1967 Posted November 13, 2020 Author Share Posted November 13, 2020 CPanel interface under Software > MultiPHP INI Editor in Editor Mode for location extremeracing.co.uk You need to add the following line:- date.timezone = "xxxx" where xxxx = the required timezone (i.e. Europe/London) added date.timezone = "Europe/London" but no change? Link to comment Share on other sites More sharing options...
bsmither Posted November 13, 2020 Share Posted November 13, 2020 The error message you see is actually being relayed by PHP coming from the database server. PHP sends the command to the database server: SET @@time_zone = 'UTC' The database server says back to PHP, "Error! I do not know this 'UTC' that you speak of." PHP then triggers an internal error because of this, and CubeCart, listening for PHP errors, then logs that error message in the CubeCart_system_error_log database table. The Cpanel settings change made a change to PHP's settings, not the database server. Correction: at this point, CubeCart is not listening for errors. But database errors will still get logged to the System Error Log. Link to comment Share on other sites More sharing options...
Larry5 Posted November 14, 2020 Share Posted November 14, 2020 I am getting error messages all having to do with SEO and all since upgrading to latest 2 versions. File: [seo.class.php] Line: [726] "INSERT INTO `ccge_CubeCart_seo_urls` (`type`,`item_id`,`path`,`custom`) VALUES ('prod','','-p.html','0');" - Duplicate entry '-p.html' for key 'PRIMARY' it started this past week and I upgraded to 4.0 and I upgraded to the 4.1 yesterday. They don't seem to interfere with processing payments but one sale can generate a string of these errors. Any help would be appreciated. Thanks, Larry Link to comment Share on other sites More sharing options...
Robo Posted November 15, 2020 Share Posted November 15, 2020 same here File: [seo.class.php] Line: [726] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`,`custom`) VALUES ('prod','','-p.html','0');" - Duplicate entry '-p.html' for key 'PRIMARY' Link to comment Share on other sites More sharing options...
bsmither Posted November 15, 2020 Share Posted November 15, 2020 In admin, Error Log, System Error Log tab, are these errors logged in this table? If so, hovering the mouse cursor in the row of the table that has this error will show a "tooltip". You will be able to move the mouse cursor into the tooltip and select the text there. Copy that text and paste it in a reply here. Apparently, this is a known issue. https://github.com/cubecart/v6/issues/2657 Link to comment Share on other sites More sharing options...
Richard1967 Posted November 18, 2020 Author Share Posted November 18, 2020 should the UTC error be showing in cubecart dashboard if not in debug mode? Note: Your store should only log notice and warning errors if it is in debug mode. Link to comment Share on other sites More sharing options...
bsmither Posted November 18, 2020 Share Posted November 18, 2020 If something got logged, it will show in this list. When CubeCart is not in debug mode, then those PHP errors (not the same as database errors) that are more serious than Warnings will get logged to the System Error log. When in debug mode, all PHP errors (not the same as database errors) will get logged to the System Error log. The code that does all the nitty-gritty database work will always log any error reported by the database server when it complains about something. Link to comment Share on other sites More sharing options...
Richard1967 Posted November 18, 2020 Author Share Posted November 18, 2020 solved it, time zone was set to UTC, switched it to below & all good now Timezone Use default server time (Europe/London) Link to comment Share on other sites More sharing options...
bsmither Posted November 20, 2020 Share Posted November 20, 2020 @Larry5 and @Robo -- Regarding the "Duplicate Entry' error message you have had logged in your System Error log... Please let us know if, in the prior 30 orders from when you first noticed these errors, did any order have a Gift Certificate as an item in that order? Link to comment Share on other sites More sharing options...
Richard1967 Posted November 20, 2020 Author Share Posted November 20, 2020 10 minutes ago, bsmither said: @Larry5 and @Robo -- Regarding the "Duplicate Entry' error message you have had logged in your System Error log... Please let us know if, in the prior 30 orders from when you first noticed these errors, did any order have a Gift Certificate as an item in that order? the errors started directly after the latest upgrade 6.4.0 No orders had gift certificates Link to comment Share on other sites More sharing options...
Robo Posted November 20, 2020 Share Posted November 20, 2020 the errors started directly after the latest upgrade 6.4.1 Link to comment Share on other sites More sharing options...
bsmither Posted November 20, 2020 Share Posted November 20, 2020 @Richard1967, your error is not related to that of Robo and Larry5. And @Robo, I am asking a different question. Link to comment Share on other sites More sharing options...
Robo Posted November 20, 2020 Share Posted November 20, 2020 sorry no gift certificates, just orders Link to comment Share on other sites More sharing options...
bsmither Posted November 20, 2020 Share Posted November 20, 2020 Ok. If you have direct access to the database, using a utility such as phpMyAdmin, please look through the table CubeCart_order_inventory and see if any rows have for product_id a value of zero. Link to comment Share on other sites More sharing options...
Richard1967 Posted November 23, 2020 Author Share Posted November 23, 2020 also had the seo error today Today, 09:18 File: [seo.class.php] Line: [726] "INSERT INTO `cc6_CubeCart_seo_urls` (`type`,`item_id`,`path`,`custom`) VALUES ('prod','','-p.html','0');" - Duplicate entry '-p.html' for key 'PRIMARY' Link to comment Share on other sites More sharing options...
Richard1967 Posted November 23, 2020 Author Share Posted November 23, 2020 On 11/20/2020 at 8:32 AM, bsmither said: Ok. If you have direct access to the database, using a utility such as phpMyAdmin, please look through the table CubeCart_order_inventory and see if any rows have for product_id a value of zero. checked there are no product_id with a value of zero Link to comment Share on other sites More sharing options...
bsmither Posted November 23, 2020 Share Posted November 23, 2020 Interesting. Thank you for looking. Link to comment Share on other sites More sharing options...
Robo Posted November 24, 2020 Share Posted November 24, 2020 sorry no time to check for this it is so busy here will try to do asap Link to comment Share on other sites More sharing options...
Richard1967 Posted November 25, 2020 Author Share Posted November 25, 2020 Had this error also Nov 22 2020, 22:40 pm [<strong>Error</strong>] /home/ctncrtns/public_html/classes/user.class.php:313 - Possible Phishing attack - Redirection to 'https://stormtrooperundersuit.com/index.php?_a=confirm' is not allowed. https://stormtrooperundersuit.com/index.php?_a=register Link to comment Share on other sites More sharing options...
Robo Posted November 25, 2020 Share Posted November 25, 2020 a few new ones File: [seo.class.php] Line: [726] "INSERT INTO `CubeCart_seo_urls` (`type`,`item_id`,`path`,`custom`) VALUES ('prod','','-p.html','0');" - Duplicate entry '-p.html' for key 'PRIMARY' Nov 21 2020, 12:28 pmFile: [catalogue.class.php] Line: [1051] "SELECT SQL_CALC_FOUND_ROWS * FROM `CubeCart_inventory` WHERE `product_id` IN (913,996,468,469,470,471,472,473,474,475,992,606,627,686,713,714,760,1009,838,873,875,889,891,965,921,939,940,941,942,943,944,981,983,1015) AND CubeCart_inventory.status = '1' AND `live_from` < UNIX_TIMESTAMP() ORDER BY `name` ASC LIMIT 12 OFFSET 2.6545345345453E+14;" - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '2.6545345345453E+14' at line 1 Link to comment Share on other sites More sharing options...
bsmither Posted November 25, 2020 Share Posted November 25, 2020 The SQL error is very possibly a goofball asking for a page # that is super-long when looking at products in a category or search result. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.