Robin Somes Posted August 24, 2020 Share Posted August 24, 2020 CC6.2.9 / All In One Shipping 1.0.18 / Facebook 1.0.1 / PayPal Commerce Platform 1.3.20 / PayPal standard commerce platform 1.08 (disabled) / ProductAddons 1.0.12 / SagePay 1.0.11 Site: piscesconservation.com/cube Is the extension update notification facility in CC no longer operating? I clearly remember it working, for a while at least, and now it's not, with no conscious input on my part. TIA, Robin Link to comment Share on other sites More sharing options...
Al Brookbanks Posted August 24, 2020 Share Posted August 24, 2020 It's definitely working. Link to comment Share on other sites More sharing options...
Robin Somes Posted August 24, 2020 Author Share Posted August 24, 2020 13 minutes ago, Al Brookbanks said: It's definitely working. Most odd, because it's distinctly not working for me; I have to open the Manage Extensions section of the dashboard, and search for each extension in turn in the marketplace, to find if I have the latest version. Would it be possible for it to become disabled on upgrading to CC 6.2.9, which I did back in May? And if so, how to re-enable it? Link to comment Share on other sites More sharing options...
havenswift-hosting Posted August 24, 2020 Share Posted August 24, 2020 The notifications do still work but you must upgrade the extensions using the thunderbolt key from within CubeCart admin. If you manually upgrade using FTP or a file manager upload then you wont get any notification Ian Link to comment Share on other sites More sharing options...
Robin Somes Posted August 24, 2020 Author Share Posted August 24, 2020 Just now, havenswift-hosting said: The notifications do still work but you must upgrade the extensions using the thunderbolt key from within CubeCart admin. If you manually upgrade using FTP or a file manager upload then you wont get any notification Ian Unfortunately, not the case here; I've always (at least within living memory) upgraded using the thunderbolt key. I *did* get a couple of notifications, and thought "that's useful, cool", but that was at least 4 or 5 months ago. Nothing since. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted August 24, 2020 Share Posted August 24, 2020 Then something in your Hosting environment is blocking the updates - when done that way, it works perfectly. Ian Link to comment Share on other sites More sharing options...
bsmither Posted August 24, 2020 Share Posted August 24, 2020 To double-check, please use an external database utility and look at the table CubeCart_extension_info. Only those modules logged in this table will show only when there are updates available. Link to comment Share on other sites More sharing options...
Robin Somes Posted August 25, 2020 Author Share Posted August 25, 2020 It's taken a while to get back to this, but... I have two databases, titled db{code}_cubecart and db{code}_cubecart_test. _cubecart does not contain a table called CubeCart_extension_info. _cubecart_test does, but that table appears to be empty - see the attached image. I'm not clear how the upgrade notification can have been working X months ago, yet isn't now. The latest upgrade from CC 6.2.5 to 6.2.9 I did myself in May, by backing up, then using the "Upgrade Now" option (or whatever it's called) from the Dashboard, then copying over the few modified components. The previous upgrades, and migration from our former ISP, were done by Al. To the best of my knowledge, I've always installed and updated extensions using the thunderbolt code. My obvious guess is that notifications ceased working after i upgraded to 6.2.9 in May - though I know not how. The question is, where to go from here? Robin Link to comment Share on other sites More sharing options...
bsmither Posted August 25, 2020 Share Posted August 25, 2020 Ok, two databases--- One database does not have CubeCart_extension_info, which means it is still at CC6012 or earlier, or the upgrade scripts were not run having updated CubeCart to a version more current than or at CC610. In the database, there is a CubeCart_history table. The contents of which are revealed in admin, Maintenance, Upgrade tab. Does the history show CubeCart passing through 6.1.0 (if it was initially installed earlier than that)? Link to comment Share on other sites More sharing options...
RobinSomes Posted August 25, 2020 Share Posted August 25, 2020 2 hours ago, bsmither said: Ok, two databases--- One database does not have CubeCart_extension_info, which means it is still at CC6012 or earlier, or the upgrade scripts were not run having updated CubeCart to a version more current than or at CC610. In the database, there is a CubeCart_history table. The contents of which are revealed in admin, Maintenance, Upgrade tab. Does the history show CubeCart passing through 6.1.0 (if it was initially installed earlier than that)? Replying from my home a/c, rather than work, hopefully this is still followable. Here is the full upgrade history from Advanced: Maintenance: Upgrade. The upgrades in April 2018, September 2018 and March 2019 were done by Al; fairly sure I did the rest. While the version installed has gone *past* 6.1.0, it doesn't appear to have gone *through* it. Hope that helps, Robin Upgrade History CubeCart Version Date 6.2.9 Tuesday, 12 May 2020 6.2.8 Tuesday, 12 May 2020 6.2.7 Tuesday, 12 May 2020 6.2.6 Tuesday, 12 May 2020 6.2.5 Friday, 19 July 2019 6.2.4 Monday, 25 March 2019 6.2.3 Monday, 25 March 2019 6.2.2 Monday, 10 September 2018 6.2.1 Monday, 10 September 2018 6.2.0-b1 Monday, 10 September 2018 6.1.15 Tuesday, 24 April 2018 6.1.14 Tuesday, 24 April 2018 6.1.13 Tuesday, 24 April 2018 6.1.11 Tuesday, 24 April 2018 6.1.9 Tuesday, 24 April 2018 6.1.7 Tuesday, 24 April 2018 6.1.6 Tuesday, 24 April 2018 6.1.5 Tuesday, 24 April 2018 6.1.4 Tuesday, 24 April 2018 6.1.2 Tuesday, 24 April 2018 6.1.0 Tuesday, 24 April 2018 6.0.12 Tuesday, 24 April 2018 6.0.11 Tuesday, 24 April 2018 6.0.9 Tuesday, 24 April 2018 6.0.7 Tuesday, 24 April 2018 6.0.6 Wednesday, 24 June 2015 6.0.5 Thursday, 4 June 2015 Link to comment Share on other sites More sharing options...
bsmither Posted August 25, 2020 Share Posted August 25, 2020 The 6.1.0 is 7th from the bottom. CubeCart processed the upgrade step for CC610 on 24 April 2018 from CC607 on its way to CC6115. Please check these other aspects of the CC610 changes to the database (the one missing the CubeCart_extension_info table): CubeCart_inventory has a new column: 'latest' CubeCart_order_history has a new column 'initiator' CubeCart_coupons has a new column 'free_shipping' CubeCart_email_log is a new table CubeCart_extension_info is a new table CubeCart_coupons has a new column 'email_sent' Do any of these new columns/tables exist? Link to comment Share on other sites More sharing options...
RobinSomes Posted August 25, 2020 Share Posted August 25, 2020 5 minutes ago, bsmither said: The 6.1.0 is 7th from the bottom. CubeCart processed the upgrade step for CC610 on 24 April 2018 from CC607 on its way to CC6115. Please check these other aspects of the CC610 changes to the database (the one missing the CubeCart_extension_info table): CubeCart_inventory has a new column: 'latest' CubeCart_order_history has a new column 'initiator' CubeCart_coupons has a new column 'free_shipping' CubeCart_email_log is a new table CubeCart_extension_info is a new table CubeCart_coupons has a new column 'email_sent' Do any of these new columns/tables exist? Sorry, I was mis-reading 6.1.0 for 6.0.10... I can't access phpMyAdmin for my work account from home (well I probably could, but it would probably take me the rest of the evening to track down the correct username/pwd combination), so will have to return to your questions tomorrow morning. Thanks for your help, I appreciate it. Robin Link to comment Share on other sites More sharing options...
RobinSomes Posted August 25, 2020 Share Posted August 25, 2020 Incidentally, I have just checked my own shop site (shop.robinsomes.co.uk). This was a completely fresh installation of CC 6.2.9 in March 2020, with very little customisation. The database has the table Cubecart_extension_info, and that table has 3 rows corresponding to the 3 extensions I have installed (ByWeight, All In One Shipping, and PayPal Commerce). CubeCart_inventory has a new column: 'latest' - CORRECT CubeCart_order_history has a new column 'initiator' - CORRECT CubeCart_coupons has a new column 'free_shipping' - CORRECT CubeCart_email_log is a new table - CORRECT CubeCart_extension_info is a new table - CORRECT CubeCart_coupons has a new column 'email_sent' - CORRECT However, the site still did not notify me that the latest version of PayPal Commerce Platform (1.3.18 to 1.3.20) was available. Robin Link to comment Share on other sites More sharing options...
bsmither Posted August 25, 2020 Share Posted August 25, 2020 The above checks were for the database with the missing table. As for the freshly installed CC629, AIOS and PPC were automatically installed the first time the admin visited the Manage Extensions page in admin, but the data logged in the CubeCart_extension_info table during that auto install was probably corrupted. If so, the first time the Dashboard did a version check, those particular records were deleted. (See: https://github.com/cubecart/v6/issues/2586) For this CC629 store, have you ever actually logged out of admin since Aug 6, 2020? (An odd question, but my development installation hasn't been logged out for a couple of months.) That's when PPC1.3.18 was published. PPC1.3.19 was published Aug 10, immediately followed by PPC1.3.20. The version check happens when an admin first logs in and views the Dashboard. The fact that a version check took place is remembered in session, and will not make another check until a new session is started (admin logs out then logs in). Link to comment Share on other sites More sharing options...
RobinSomes Posted August 25, 2020 Share Posted August 25, 2020 20 minutes ago, bsmither said: The above checks were for the database with the missing table. As for the freshly installed CC629, AIOS and PPC were automatically installed the first time the admin visited the Manage Extensions page in admin, but the data logged in the CubeCart_extension_info table during that auto install was probably corrupted. If so, the first time the Dashboard did a version check, those particular records were deleted. (See: https://github.com/cubecart/v6/issues/2586) For this CC629 store, have you ever actually logged out of admin since Aug 6, 2020? (An odd question, but my development installation hasn't been logged out for a couple of months.) That's when PPC1.3.18 was published. PPC1.3.19 was published Aug 10, immediately followed by PPC1.3.20. The version check happens when an admin first logs in and views the Dashboard. The fact that a version check took place is remembered in session, and will not make another check until a new session is started (admin logs out then logs in). Many thanks for the explanation. Just to confirm, yes, I've logged out of admin probably a dozen times since August 6th; aside from processing sales, I'm not logged in at all as a matter of course. Will check the details on the other site when I return to work tomorrow. Link to comment Share on other sites More sharing options...
Robin Somes Posted August 26, 2020 Author Share Posted August 26, 2020 13 hours ago, bsmither said: The 6.1.0 is 7th from the bottom. CubeCart processed the upgrade step for CC610 on 24 April 2018 from CC607 on its way to CC6115. Please check these other aspects of the CC610 changes to the database (the one missing the CubeCart_extension_info table): CubeCart_inventory has a new column: 'latest' CubeCart_order_history has a new column 'initiator' CubeCart_coupons has a new column 'free_shipping' CubeCart_email_log is a new table CubeCart_extension_info is a new table CubeCart_coupons has a new column 'email_sent' Do any of these new columns/tables exist? To answer your original question. The database without the Cubecart_extension_info table: CubeCart_inventory has a new column: 'latest' - NO CubeCart_order_history has a new column 'initiator' - NO CubeCart_coupons has a new column 'free_shipping' - NO CubeCart_email_log is a new table - NOT PRESENT CubeCart_extension_info is a new table - NOT PRESENT CubeCart_coupons has a new column 'email_sent' - NO I now have a better understanding of what's happened. Digging further into phpMyAdmin, I have 3 Cubecart databases (image attached below). The first in the list, 'cubecart', is the one with the missing table. This was our original shop, set up in June 2015 running CC 6.0.5, and updated to CC 6.0.6 the same month. That ran, more or less smoothly, until April 24th 2018, when our former ISP moved us from their legacy hosting to a new cloud platform. At that point I enlisted Al to migrate the site to the new platform; he installed the then current version 6.1.15 - this is where the other two databases, db{code}_cubecart and db{code}_cubecarttest arrived - and imported all the site contents. The site has therefore been running (albeit with a change in hosting company in September 2018), using db{code}_cubecart, from April 24th 2018 until now. This database does have all the requisite tables. To sum up: cubecart: - ran from June 2015 to 23/04/2018; last installed CC version 6.0.6, has not been in use since 23/04/2018. db{code}_cubecart: set up 24/04/2018 using CC 6.1.15, in use ever since, regularly updated to latest CC version. db{code}_cubecarttest: - set up 24/04/2018 using CC 6.1.15, never used. As with the other site I brought up last night, I never stay logged in to Admin for very long. Any suggestion as to how to proceed from here would be appreciated. As Ian from Havenswift suggested above, perhaps some slight misconfiguration of the hosting environment is causing the notifications not to appear? Robin Link to comment Share on other sites More sharing options...
bsmither Posted August 26, 2020 Share Posted August 26, 2020 So, db{code}_cubecart: set up 24/04/2018 using CC 6.1.15, in use ever since, regularly updated to latest CC version, is complete, but does not present to you a tab showing extensions that do, in fact, have a version available more recent than what is installed? Looking at db{code}_cubecart, what does CubeCart_extension_info contain? A version check uses CubeCart's Request functionality, Unfortunately, this request and response is not logged. Let's change that and then make a test. In the admin script /sources/dashboard.index.inc.php: Near line 112, find: ## Check current version if (!$GLOBALS['session']->has('version_check') && $request = new Request('www.cubecart.com', '/version-check/'.CC_VERSION)) { $request->skiplog(true); Change: $request->skiplog(true); To: $request->skiplog(false); Based on what CubeCart_extension_info has, will determine how we test this. But, logging out (clears the session), then logging in and viewing the Dashboard, will cause a version check request to be made and now get logged. In admin, view the Request Log to see if it got logged at all. Link to comment Share on other sites More sharing options...
Al Brookbanks Posted August 26, 2020 Share Posted August 26, 2020 This year has been rough for us all. I'm out the office until Friday with family in Suffolk, UK, working here and there. I'll have a good look at this on my return. Link to comment Share on other sites More sharing options...
bsmither Posted August 26, 2020 Share Posted August 26, 2020 If it did get logged, this is what you should see if no modules need updating: Today, 12:22 Request Sent (cURL) - https://www.cubecart.com/version-check/6.2.9?version=6.2.9&extensions%5B44%5D=1596699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286 version=6.2.9&extensions%5B44%5D=1596699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286 Response received (200 - OK) {"version":"6.2.9"} I manually changed the modified value in the CubeCart_extension_info table to simulate an older version installed. Then I logged out and back in. Today, 12:48 Request Sent (cURL) - https://www.cubecart.com/version-check/6.2.9?version=6.2.9&extensions%5B44%5D=1096699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286 version=6.2.9&extensions%5B44%5D=1096699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286 Response received (200 - OK) {"version":"6.2.9","updates":{"44":true}} The "44" extension key is the All in One Shipping module. Link to comment Share on other sites More sharing options...
bsmither Posted August 26, 2020 Share Posted August 26, 2020 My tests suggests something is definitely wrong with the version check server at CubeCart HQ. See: https://github.com/cubecart/v6/issues/2588 Link to comment Share on other sites More sharing options...
RobinSomes Posted August 26, 2020 Share Posted August 26, 2020 2 hours ago, Al Brookbanks said: This year has been rough for us all. I'm out the office until Friday with family in Suffolk, UK, working here and there. I'll have a good look at this on my return. Al, it's absolutely no problem to me, in the main I'm just curious as to what might be going on and whether it has any other implications. Whenever you get the chance, no worries. Robin Link to comment Share on other sites More sharing options...
RobinSomes Posted August 26, 2020 Share Posted August 26, 2020 2 hours ago, bsmither said: So, db{code}_cubecart: set up 24/04/2018 using CC 6.1.15, in use ever since, regularly updated to latest CC version, is complete, but does not present to you a tab showing extensions that do, in fact, have a version available more recent than what is installed? Yes, that's correct. 2 hours ago, bsmither said: Looking at db{code}_cubecart, what does CubeCart_extension_info contain? See the image below; 4 plugins - AIOS 1.0.18, SagePay 1.0.11, Facebook 1.0.1 and paypal_commerce 1.3.20 2 hours ago, bsmither said: A version check uses CubeCart's Request functionality, Unfortunately, this request and response is not logged. Let's change that and then make a test. In the admin script /sources/dashboard.index.inc.php: Near line 112, find: ## Check current version if (!$GLOBALS['session']->has('version_check') && $request = new Request('www.cubecart.com', '/version-check/'.CC_VERSION)) { $request->skiplog(true); Change: $request->skiplog(true); To: $request->skiplog(false); OK, done... 2 hours ago, bsmither said: Based on what CubeCart_extension_info has, will determine how we test this. But, logging out (clears the session), then logging in and viewing the Dashboard, will cause a version check request to be made and now get logged. In admin, view the Request Log to see if it got logged at all. Yes, it got logged: Today, 23:23 Request Sent (cURL) - https://www.cubecart.com/version-check/6.2.9?version=6.2.9&extensions[44]=1596699083&extensions[80]=1548263568&extensions[108]=1551776120&extensions[452]=1597078286version=6.2.9&extensions%5B44%5D=1596699083&extensions%5B80%5D=1548263568&extensions%5B108%5D=1551776120&extensions%5B452%5D=1597078286 Response received (200 - OK){"version":"6.2.9"} 2 hours ago, bsmither said: If it did get logged, this is what you should see if no modules need updating: Today, 12:22 Request Sent (cURL) - https://www.cubecart.com/version-check/6.2.9?version=6.2.9&extensions%5B44%5D=1596699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286 version=6.2.9&extensions%5B44%5D=1596699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286 Response received (200 - OK) {"version":"6.2.9"} I manually changed the modified value in the CubeCart_extension_info table to simulate an older version installed. Then I logged out and back in. Today, 12:48 Request Sent (cURL) - https://www.cubecart.com/version-check/6.2.9?version=6.2.9&extensions%5B44%5D=1096699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286 version=6.2.9&extensions%5B44%5D=1096699083&extensions%5B105%5D=1474387528&extensions%5B452%5D=1597078286 Response received (200 - OK) {"version":"6.2.9","updates":{"44":true}} The "44" extension key is the All in One Shipping module. I'm reluctant to revert to older versions of any of my extension (even if such were available), as the site is still live. Can you suggest another extension with older versions available that I could install, to test whether or not it works for me? Many thanks again for your help. Robin Link to comment Share on other sites More sharing options...
bsmither Posted August 26, 2020 Share Posted August 26, 2020 "I'm reluctant to revert to older versions" Sorry, I think you misunderstood. I said: "I manually changed the value in the "modified" column in the CubeCart_extension_info table to simulate an older version installed." Having done this, and having CubeCart make a version check, then I got the Dashboard tab saying that a newer version is available. (The module actual version installed was not disturbed in any way.) From my tests, I will conclude we must wait for CubeCart HQ to fix their server. Link to comment Share on other sites More sharing options...
RobinSomes Posted August 26, 2020 Share Posted August 26, 2020 10 minutes ago, bsmither said: "I'm reluctant to revert to older versions" Sorry, I think you misunderstood. I said: "I manually changed the value in the "modified" column in the CubeCart_extension_info table to simulate an older version installed." Having done this, and having CubeCart make a version check, then I got the Dashboard tab saying that a newer version is available. (The module actual version installed was not disturbed in any way.) From my tests, I will conclude we must wait for CubeCart HQ to fix their server. OK, got that, thanks. As I said to Al elsewhere in this thread, it's causing me no real trouble, so I'm content to sit and wait. Thanks again for your help. Robin Link to comment Share on other sites More sharing options...
Robin Somes Posted September 3, 2020 Author Share Posted September 3, 2020 Happy to report that the Extension Update notification is now working - whatever has been tweaked at CCHQ has taken effect. Thanks again Robin Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.