fettlebox Posted December 10, 2020 Share Posted December 10, 2020 During recent upgrade I was surprised to see the error log was 1.5gb! I may have had the extensions installed for test in the distant past but they are not there now. How do I stop these? Thanks Quote [10-Dec-2020 16:08:10 Europe/London] PHP Notice: Error: Hook 'enhanced_sorting/hooks/controller.admin.php' was not found in /home/ross/public_html/classes/hookloader.class.php on line 298 [10-Dec-2020 16:08:10 Europe/London] PHP Notice: Error: Hook 'enhanced_sorting/hooks/controller.admin.php' was not found in /home/ross/public_html/classes/hookloader.class.php on line 298 [10-Dec-2020 16:08:10 Europe/London] PHP Notice: Error: Hook 'enhanced_sorting/hooks/admin.navigation.php' was not found in /home/ross/public_html/classes/hookloader.class.php on line 298 [10-Dec-2020 16:08:10 Europe/London] PHP Notice: Error: Hook 'SFWS_Deluxe_Related_Products/hooks/admin.navigation.php' was not found in /home/ross/public_html/classes/hookloader.class.php on line 298 Link to comment Share on other sites More sharing options...
havenswift-hosting Posted December 10, 2020 Share Posted December 10, 2020 This happens if you manually delete plugins via FTP or File Manager rather than delete them through your store admin. You can delete them from the CubeCart_hooks table Link to comment Share on other sites More sharing options...
fettlebox Posted December 10, 2020 Author Share Posted December 10, 2020 Thanks! I think I'm looking in the right place - nothing there (I don't remember removing by filemanger or ftp). Just BTREE (Braintree?) Link to comment Share on other sites More sharing options...
bsmither Posted December 10, 2020 Share Posted December 10, 2020 You need to be on the Browse tab. Delete the rows of records that mention the plugins you no longer have installed. Link to comment Share on other sites More sharing options...
fettlebox Posted December 10, 2020 Author Share Posted December 10, 2020 Also empty i'm afraid Link to comment Share on other sites More sharing options...
bsmither Posted December 10, 2020 Share Posted December 10, 2020 Might I dare say that you might be looking at the wrong database? Also, if the errors are being generated while viewing content on the storefront, the queries against this table might be cached, even if the actual table is empty. So, clear the cache. Link to comment Share on other sites More sharing options...
fettlebox Posted December 10, 2020 Author Share Posted December 10, 2020 There's only one cc database. Cache is cleared - if you mean the yellow 'clear cache' tab at top of ACP. Error log is filling up with errors on a loop it seems. Link to comment Share on other sites More sharing options...
bsmither Posted December 10, 2020 Share Posted December 10, 2020 Every time CubeCart starts up (meaning, every page request), the CubeCart_hooks table is queried for a list of plugin hooks (and if the results are in the cache, the cache will supply the list). So, yes, a lot of these error messages. Just to eliminate a weird possibility, look in /includes/global.inc.php for the value to use for $glob['dbprefix']. Is it actually 'cc_cc_cc_'? Link to comment Share on other sites More sharing options...
fettlebox Posted December 10, 2020 Author Share Posted December 10, 2020 No it's 'cc_' I changed it to 'cc_cc_cc_' & it goofed up the page - duplicate header image & categories not found. Put back to 'cc_' for now. Link to comment Share on other sites More sharing options...
bsmither Posted December 11, 2020 Share Posted December 11, 2020 So, the global.inc.php value is 'cc_'. Looking closely at the screen grab posted above ("Also empty I'm afraid."), I see that the query was looking for 'cc_cc_cc_CubeCart_hooks'. Might I dare say that you might be looking at the wrong database? Or at least the wrong table? Link to comment Share on other sites More sharing options...
fettlebox Posted December 11, 2020 Author Share Posted December 11, 2020 I'm looking at the hooks table. The store is in its own cpanel account & there is only one CC database & a empty test database. The name of the db matched the one named in global.inc.php. However I think you may be right. Looking at the filemanager table there are less images listed than expected. Same for inventory, coupons tables plus document content is old versions. History only lists versions 5.0.8 to 5.1.1. Looks to be from 2012!! So where is the current db hiding?? I'll message the support team. Link to comment Share on other sites More sharing options...
bsmither Posted December 11, 2020 Share Posted December 11, 2020 I think you could delete the very long list of error messages posted above. Link to comment Share on other sites More sharing options...
fettlebox Posted December 11, 2020 Author Share Posted December 11, 2020 done - apologies, it was auto hiding in my view. Link to comment Share on other sites More sharing options...
fettlebox Posted December 11, 2020 Author Share Posted December 11, 2020 I was in the right database but didn't spot it was over 5 pages in the phpmyadmin nav-tree! Never seen that drop-down before. The db has grown from c500mb to 1.5gb due to the upgrade (which I had to do in version steps). The db now has three sets of duplicate tables prefixed cc_, cc_cc_ & cc_cc_cc_. 1.2gb of that is in the cc_CubeCart_cookie_consent table - seems strange to have gotten so big so quick. I notice in the database part of the ACP there is a note under the table: Quote cc_cc_CubeCart_cookie_consent.log_hash has duplicate KEY indexes. One of these could be removed. I found the hooks from the error log in the 'cc_CubeCart_hooks & have now deleted them. I double checked - no reference to those hooks in cc_cc or cc_cc_cc_ versions of that table. I'm still getting errors relating to those hooks (as well as others). Am I ok to delete the cc_cc_ & cc_cc_cc_ prefixed tables? Link to comment Share on other sites More sharing options...
bsmither Posted December 11, 2020 Share Posted December 11, 2020 "I'm still getting errors relating to those hooks (as well as others)." Please post just a few of them. It is fine to delete the cc_cc_ and cc_cc_cc_ prefixed tables (unless you want to keep the cc_cc_ as an old backup). Link to comment Share on other sites More sharing options...
fettlebox Posted December 11, 2020 Author Share Posted December 11, 2020 Quote Today, 18:49 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/admin_kutAtd.php?_g=settings&node=errorlog Today, 18:49 File: [controller.admin.pre_session.inc.php] Line: [27] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:48 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:48 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:717 - session_start() [<a href='http://docs.php.net/manual/en/function.session-start.php'>function.session-start.php</a>]: ps_files_cleanup_dir: opendir(/var/cpanel/php/sessions/ea-php72) failed: Permission denied (13) https://fettlebox.co.uk/burner-washers-asbestos-free-large.html?set_currency=TWN Today, 18:48 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:48 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/burner-washers-asbestos-free-large.html Today, 18:43 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:43 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/vintage-used-parts/primus-reserve-cap-with-chain-new-old-stock-not-repro.html Today, 18:43 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:41 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:40 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:38 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:38 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/burner-washers-small-asbestos-free-pack-of-4.html Today, 18:38 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:33 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:33 [<strong>Warning</strong>] /home/ross/public_html/classes/sanitize.class.php:114 - Security Warning: Illegal array key "/photos/kitchen/cabinet-finish--brown/query/ceramic-tile-backsplash-material" was detected and was removed. http://fettlebox.co.uk/images/images/jiaju33.php?/photos/kitchen/cabinet-finish--brown/query/ceramic-tile-backsplash-material Today, 18:33 [<strong>Warning</strong>] /home/ross/public_html/classes/sanitize.class.php:114 - Security Warning: Illegal array key "/photos/kitchen/cabinet-finish--brown/query/ceramic-tile-backsplash-material" was detected and was removed. http://fettlebox.co.uk/images/images/jiaju33.php?/photos/kitchen/cabinet-finish--brown/query/ceramic-tile-backsplash-material Today, 18:33 [<strong>Notice</strong>] /home/ross/public_html/classes/ssl.class.php:39 - Undefined index: _g http://fettlebox.co.uk/images/images/jiaju33.php?/photos/kitchen/cabinet-finish--brown/query/ceramic-tile-backsplash-material Today, 18:33 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:33 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/pressure-lamp-parts.html Today, 18:33 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:28 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:28 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:717 - session_start() [<a href='http://docs.php.net/manual/en/function.session-start.php'>function.session-start.php</a>]: ps_files_cleanup_dir: opendir(/var/cpanel/php/sessions/ea-php72) failed: Permission denied (13) https://www.fettlebox.co.uk/vapalux-bialaddin-washer-kit-w5-type.html?set_currency=CAD Today, 18:28 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 18:28 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://www.fettlebox.co.uk/vapalux-bialaddin-washer-kit-w5-type.html I'm also concerned I may have been hacked although these may be a legacy issues from when the store was hacked a few years ago & a fake unrelated store placed in a subfolder. I may be misremembering that though! Quote [<strong>Warning</strong>] /home/ross/public_html/classes/sanitize.class.php:114 - Security Warning: Illegal array key "/photos/kitchen/cabinet-finish--brown/query/ceramic-tile-backsplash-material" was detected and was removed. http://fettlebox.co.uk/images/images/jiaju33.php?/photos/kitchen/cabinet-finish--brown/query/ceramic-tile-backsplash-material Link to comment Share on other sites More sharing options...
fettlebox Posted December 11, 2020 Author Share Posted December 11, 2020 41 minutes ago, bsmither said: It is fine to delete the cc_cc_ and cc_cc_cc_ prefixed tables Done Link to comment Share on other sites More sharing options...
bsmither Posted December 11, 2020 Share Posted December 11, 2020 You can ignore most Notices. Undefined whatever is just PHP reminding the developers that there is a better way to write programs. This Security Warning for an Illegal Array Key is just a little concerning. Most of the time, it is a cookie that uses punctuation in its name that CubeCart does not like. But the URL posted above is very odd: is there, in fact, an /images/images/ folder? If so, is there a file named jiaju33.php in there? Link to comment Share on other sites More sharing options...
fettlebox Posted December 11, 2020 Author Share Posted December 11, 2020 No that folder doesn't exist. The wording of that array key is nothing to do with my site. Looks like it's kitchen related & if my memory is right it was a kitchen website that got hosted in a sub-folder. That was years back so maybe a legacy error that's been looping in the log since then. Over 800K entries here cc_CubeCart_cookie_consent table Yes - legacy error from hack 4 years ago. Link to comment Share on other sites More sharing options...
bsmither Posted December 11, 2020 Share Posted December 11, 2020 In admin, Maintenance, Rebuild tab, there is a new "Clear Cookie Consent Log" option. Hopefully you can get away with losing all these permissions from the past. Also for CC64+, entries that get logged there are more strictly managed, so table shouldn't grow as fast. Link to comment Share on other sites More sharing options...
fettlebox Posted December 11, 2020 Author Share Posted December 11, 2020 Many thanks. Errors seems to be limited to these on a loop now: Quote Today, 19:37 File: [controller.admin.pre_session.inc.php] Line: [27] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 19:37 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/admin_kutAtd.php?_g=settings&node=errorlogset_cookie() (session.class.php:721) _start() (session.class.php:165) __construct() (session.class.php:184) getInstance() (controller.admin.pre_session.inc.php:33) include() (admin_kutAtd.php:34) Today, 19:37 File: [controller.admin.pre_session.inc.php] Line: [27] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 19:37 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/admin_kutAtd.php?_g=settings&node=errorlog Today, 19:37 File: [controller.admin.pre_session.inc.php] Line: [27] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 19:37 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/admin_kutAtd.php?_g=maintenance Today, 19:37 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 19:37 File: [controller.admin.pre_session.inc.php] Line: [27] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 19:37 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/admin_kutAtd.php?_g=orders Today, 19:36 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 19:36 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/favicon.ico Today, 19:36 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 19:36 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/favicon.ico Today, 19:36 File: [controller.index.inc.php] Line: [28] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Today, 19:36 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:717 - session_start() [<a href='http://docs.php.net/manual/en/function.session-start.php'>function.session-start.php</a>]: ps_files_cleanup_dir: opendir(/var/cpanel/php/sessions/ea-php72) failed: Permission denied (13) https://fettlebox.co.uk/apple-touch-icon.png Today, 19:36 [<strong>Notice</strong>] /home/ross/public_html/classes/session.class.php:608 - Undefined index: samesite https://fettlebox.co.uk/apple-touch-icon.png Link to comment Share on other sites More sharing options...
bsmither Posted December 11, 2020 Share Posted December 11, 2020 You will get a lot of Undefined index and Undefined variable log entries, as long as your site has Debugging mode enabled. The Incorrect Timezone has been discussed here, and requires the server admin to load the database's system table with timezone data. The session_start Permission denied error also needs to be looked at by the server environment tech support. Link to comment Share on other sites More sharing options...
fettlebox Posted December 11, 2020 Author Share Posted December 11, 2020 I will pass that on. Hopefully the database will report as much smaller tomorrow once cpanel refreshes the info. I've had help from various folk on here over the years & a lot from yourself. It's much appreciated. Thankyou. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.