Silent Upgrade to v11 reached Step "post", but DB changes are incomplete

I am testing the upgrade to v11 on my Development environment

I used Silent Upgrader (as I always have) to go from 10.0.4 to 11.0.0 (Sugar Pro, On Site)

While the upgrader failed only at Step "post", which I understand to be the QRR stage of the upgrade, the DB changes for the addition of sync_key fields appear to be incomplete and now I get a 500 error because the queries are trying to use a field that is not there.

For example, when I try to log in, I get the following 500 error:

An exception occurred while executing 'SELECT oauth_consumer.id, oauth_consumer.name, oauth_consumer.date_entered, oauth_consumer.date_modified, oauth_consumer.modified_user_id, oauth_consumer.created_by, oauth_consumer.description, oauth_consumer.deleted, oauth_consumer.c_key, oauth_consumer.c_secret, oauth_consumer.oauth_type, oauth_consumer.client_type, oauth_consumer.sync_key, oauth_consumer.assigned_user_id FROM oauth_consumer WHERE ((oauth_consumer.c_key = ?) AND (oauth_consumer.oauth_type = ?)) AND (oauth_consumer.deleted = ?) LIMIT 1' with params ["sugar", "oauth2", 0]: Unknown column 'oauth_consumer.sync_key' in 'field list'

Of course I can track down each of these errors and add the sync_key/indexes to my DB manually, but there has to be a better way...
and if the DB updates are incomplete why would the "Continue" option when re-running the Silent Upgrader not catch that?

FrancescaS

Parents Reply Children
  • Yeah, I tried that. Looks like I'm getting some logs crossed... it's reporting a Database Failure that I'll have to look into.

    There are logs in the sugarcrm/logs directory and logs in the sugarcrm/. directory.

    I'll have to figure out why that is!

    I found the failure on Revenue Line Items, which we don't even have access to given that we're on Professional...

    ALTER TABLE revenue_line_items   modify COLUMN name varchar(255)  NULL ,  add COLUMN lock_duration bool  DEFAULT 0 NULL ,  add COLUMN subtotal decimal(26,6)  NULL ,  add COLUMN discount_amount_signed decimal(26,6)  DEFAULT 0 NULL ,  add COLUMN sync_key varchar(100)  NULL ,  add COLUMN renewal bool  DEFAULT 0 NULL : MySQL error 1292: Incorrect date value: '0000-00-00' for column 'date_closed' at row 328

  • It looks like I have zero dates from 2009-2015, probably before the NO_ZERO_IN_DATE,NO_ZERO_DATE were added to mysql.