Bug #13350

Reduce the likelihood of issues in upgrades from 1.x to 2.6.x

Added by José Raddaoui Marín 4 months ago. Updated 4 months ago.

Status:VerifiedStart date:06/11/2020
Priority:MediumDue date:
Assignee:-% Done:

0%

Category:Migration task
Target version:Release 2.6.0
Google Code Legacy ID: Tested version:2.6
Sponsored:No Requires documentation:

Description

Testing the SQL upgrade from a legacy database (1.1 v.62, first version considered in the upgrade-sql task) to 2.6.x a few issues came out:

- Migration 62:

Fatal error: Uncaught Error: Undefined class constant 'INFORMATION_OBJECT_ID' in /atom/src/lib/task/migrate/arUpgrader110.class.php:572
Stack trace:
#0 /atom/src/lib/task/migrate/arUpgradeSqlTask.class.php(173): arUpgrader110->up(70, Object(qubitConfiguration), Array)
#1 /atom/src/vendor/symfony/lib/task/sfBaseTask.class.php(68): QubitUpgradeSqlTask->execute(Array, Array)
#2 /atom/src/vendor/symfony/lib/task/sfTask.class.php(97): sfBaseTask->doRun(Object(sfCommandManager), NULL)
#3 /atom/src/vendor/symfony/lib/command/sfSymfonyCommandApplication.class.php(76): sfTask->runFromCLI(Object(sfCommandManager), NULL)
#4 /atom/src/vendor/symfony/lib/command/cli.php(20): sfSymfonyCommandApplication->run()
#5 /atom/src/symfony(14): include('/atom/src/vendo...')
#6 {main}
  thrown in /atom/src/lib/task/migrate/arUpgrader110.class.php on line 572

- Migration 82:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'function MODIFY `description_identifier` VARCHAR(1024)' at line 1

- Migration 98:

[wrapped: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'digital_object.OBJECT_ID' in 'field list']

- Migration 121:

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'event_FK_3'; check that column/key exists

Related issues

Related to Access to Memory (AtoM) - Task #10306: Improve foreign key declarations in database schema Verified 09/14/2016
Related to Access to Memory (AtoM) - Feature #13220: Support MySQL 8 Verified 12/05/2019
Related to Access to Memory (AtoM) - Bug #13221: Avoid schema differences between a default install and an... Verified 12/05/2019

History

#1 Updated by José Raddaoui Marín 4 months ago

  • Related to Task #10306: Improve foreign key declarations in database schema added

#2 Updated by José Raddaoui Marín 4 months ago

#3 Updated by José Raddaoui Marín 4 months ago

  • Related to Bug #13221: Avoid schema differences between a default install and an upgraded database added

#4 Updated by José Raddaoui Marín 4 months ago

  • Description updated (diff)

#5 Updated by José Raddaoui Marín 4 months ago

  • Status changed from New to Code Review

#6 Updated by José Raddaoui Marín 4 months ago

  • Status changed from Code Review to Verified
  • Assignee deleted (José Raddaoui Marín)

Found and tested this fixes with a couple of 1.x DBs more.

Also available in: Atom PDF