Jump to content

error logs since latest upgrades


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 post
Share on other sites

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 post
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.

Edited by bsmither
Link to post
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 post
Share on other sites

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 post
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

 

Edited by bsmither
Link to post
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.

 

Edited by bsmither
Link to post
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 post
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 post
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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...