View Issue Details

IDProjectCategoryView StatusLast Update
0003551Composrcore_upgraderpublic2018-03-09 02:52
ReporterAdam EdingtonAssigned ToChris Graham 
SeverityFeature-request 
Status closedResolutionno change required 
Product Version 
Fixed in Version 
Summary0003551: Upgrade to 10.1 Beta 7
DescriptionUpgrade was suggested in admin zone, so I upgraded. Getting the error.

Unfortunately a query has failed [SELECT COUNT(*) FROM cms_ecom_invoices WHERE (i_member_id=2) LIMIT 1] [Table 'kal_tlr.cms_ecom_invoices' doesn't exist] (version: 10.1 beta7, PHP version: 7.1.13, URL: /dev/tlr/adminzone/index.php?page=start)
TagsNo tags attached.
Time estimation (hours)
Sponsorship open

Activities

Chris Graham

2018-03-08 03:14

administrator   ~0005562

First, big apologies that it asked you to upgrade to a beta! Especially a beta of a line that we've discontinued (we're going straight to v11).

This is now fixed, and I've added more automated testing to the versioning system.

As for this specific error, it looks like files for the ecommerce addon came back, which you'd uninstalled. So files, but no DB tables. I would guess this was caused by manually extracting the upgrade, or it already having a rogue addon_registry hook for that addon and it restoring the rest of the files. We're aiming to make this a problem of the past with v11 as it happens to too many people.

Chris Graham

2018-03-09 00:18

administrator   ~0005564

Or, the database upgrade step wasn't completed, as we renamed the invoices table to ecom_invoices.

Adam Edington

2018-03-09 02:51

administrator   ~0005565

Probably the latter as I haven't uninstalled any addons. How to fix?

Chris Graham

2018-03-09 02:52

administrator   ~0005566

You can go back into the upgrade and run the database upgrade step.

Issue History

Date Modified Username Field Change
2018-03-05 10:39 Adam Edington New Issue
2018-03-08 03:14 Chris Graham Note Added: 0005562
2018-03-08 03:14 Chris Graham Status non-assigned => closed
2018-03-08 03:14 Chris Graham Assigned To => Chris Graham
2018-03-08 03:14 Chris Graham Resolution open => no change required
2018-03-09 00:18 Chris Graham Note Added: 0005564
2018-03-09 02:51 Adam Edington Note Added: 0005565
2018-03-09 02:52 Chris Graham Note Added: 0005566