Updating a database

=== HEROKU_POSTGRESQL_WHITE Plan: Standard 2 Status: available ...

Following: HEROKU_POSTGRESQL_LAVENDER (DATABASE_URL) Behind By: 125 commits It is important that no new data is written to your current primary database during the upgrade process, because it will not be transferred to the new database.

updating a database-16updating a database-47updating a database-25updating a database-60

Only works with Standard, Premium, Private, or Shield tier databases.

To accomplish this, place your app into maintenance mode.

If you have scheduler jobs running as well, you should disable them.

2016/12/21 [error] [application] CDb Command failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'Ui28t_element$ 2016/12/21 [error] [application] #0 /var/www/craft/app/framework/db/CDb Command.php(1352): CDb Command-run() #18 /var/www/public_html/index.php(19): require_once('/var/www/craft/...') #19 2016/12/21 [error] [application] Failed to apply migration: m150827_000000_element_index_settings (time: 0.001s) 2016/12/21 [error] [application] Migration failed for Craft. ****************************************************************************************************** 2016/12/21 [info] [application] [Forced] Rolling back any database changes. The fact that is already exists during this update indicates that you've already got some 2.5 database schema changes already in place.

Most likely this occurred from a previous 2.5 update attempt that failed (for whatever reason) and the database wasn't restored from a pre-2.5 update attempt backup before another update was applied.

Leave a Reply