CiviCRM Core issues
https://lab.civicrm.org/dev/core/-/issues
2019-07-10T16:02:55Z
https://lab.civicrm.org/dev/core/-/issues/931
Civi 5.13.0 fails to upgrade on multilingual sites
2019-07-10T16:02:55Z
JonGold
Civi 5.13.0 fails to upgrade on multilingual sites
The backtrace is below. It seems like we can't add a column to a multilingual table if the table wasn't multilingual prior to upgrade.
```
May 02 11:21:35 [info] $Fatal Error Details = Array
(
[callback] => Array
(
...
The backtrace is below. It seems like we can't add a column to a multilingual table if the table wasn't multilingual prior to upgrade.
```
May 02 11:21:35 [info] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title' [nativecode=1146 ** Table 'nasco_dev_civi.civicrm_payment_processor_en_US' doesn't exist]
[type] => DB_Error
[user_info] => SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title' [nativecode=1146 ** Table 'nasco_dev_civi.civicrm_payment_processor_en_US' doesn't exist]
[to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title' [nativecode=1146 ** Table 'nasco_dev_civi.civicrm_payment_processor_en_US' doesn't exist]"]
)
May 02 11:21:35 [info] $backTrace = #0 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/CRM/Core/Error.php(236): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/PEAR.php(921): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: no such table", -18, 16, (Array:2), "SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title' [nativecode=11...")
#3 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/PEAR.php(575): DB_Error->__construct(-18, 16, (Array:2), "SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title' [nativecode=11...")
#4 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -18, 16, (Array:2), "SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title' [nativecode=11...", "DB_Error", TRUE)
#5 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-18, NULL, NULL, "SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title' [nativecode=11...", "1146 ** Table 'nasco_dev_civi.civicrm_payment_processor_en_US' doesn't exist")
#7 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title'")
#9 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title'")
#10 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title'")
#11 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query("SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title'")
#12 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/CRM/Core/DAO.php(1414): CRM_Core_DAO->query("SHOW COLUMNS FROM civicrm_payment_processor_en_US LIKE 'title'", TRUE)
#13 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/CRM/Core/BAO/SchemaHandler.php(632): CRM_Core_DAO::executeQuery("SHOW COLUMNS FROM civicrm_payment_processor LIKE '%1'", (Array:1), TRUE, NULL, FALSE, TRUE)
#14 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/CRM/Upgrade/Incremental/Base.php(159): CRM_Core_BAO_SchemaHandler::checkIfFieldExists("civicrm_payment_processor", "title")
#15 /home/jon/local/nasco/htdocs/sites/all/modules/civicrm/CRM/Queue/Task.php(88): CRM_Upgrade_Incremental_Base::addColumn(Object(CRM_Queue_TaskContext), "civicrm_payment_processor", "title", "text COMMENT 'Payment Processor Descriptive Name.'", TRUE, "5.13.alpha1")
#16 /usr/local/bin/cvsrc/src/Util/ConsoleQueueRunner.php(76): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#17 /usr/local/bin/cvsrc/src/Command/UpgradeDbCommand.php(133): Civi\Cv\Util\ConsoleQueueRunner->runAll()
#18 /usr/local/bin/cvsrc/vendor/symfony/console/Command/Command.php(257): Civi\Cv\Command\UpgradeDbCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#19 /usr/local/bin/cvsrc/vendor/symfony/console/Application.php(850): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#20 /usr/local/bin/cvsrc/vendor/symfony/console/Application.php(193): Symfony\Component\Console\Application->doRunCommand(Object(Civi\Cv\Command\UpgradeDbCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#21 /usr/local/bin/cvsrc/src/Application.php(48): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#22 /usr/local/bin/cvsrc/vendor/symfony/console/Application.php(124): Civi\Cv\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#23 /usr/local/bin/cvsrc/src/Application.php(17): Symfony\Component\Console\Application->run()
#24 /usr/local/bin/cvsrc/bin/cv(27): Civi\Cv\Application::main("/usr/local/bin/cvsrc/bin")
#25 {main}
```
5.13.1