Jump to content

Extension update notifications


Robin Somes

Recommended Posts

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

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

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

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

 

Image5.jpg

Link to comment
Share on other sites

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

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

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

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

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

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

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

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

 

 

 

Image6.jpg

Link to comment
Share on other sites

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

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

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

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"}

Image3.jpg

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

"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

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

Archived

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

×
×
  • Create New...