Jump to content

error logs since latest upgrades


Richard1967

Recommended Posts

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

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

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

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

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

@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

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

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...