Skip to content

Instantly share code, notes, and snippets.

@jbq
Created February 15, 2017 15:59
Show Gist options
  • Save jbq/8924198da0323136f2681237f66bbf11 to your computer and use it in GitHub Desktop.
Save jbq/8924198da0323136f2681237f66bbf11 to your computer and use it in GitHub Desktop.
Pimcore 3777
└─(2:15:27:%)(master↑4|✚1…)── dsh pimcore_440 sudo -u www-data php /var/www/pimcore/cli/console.php update -u 4.4.3 ──(Wed,Feb15)─┘
You are going to update to build 4044! Continue with this action? (y/n)y
Starting the update process ...
751/751 [============================] 100%
Update stopped by error! Please check your logs
Last return value was: [2017-02-15 16:57:39] core.ERROR: PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'reference' in /var/www/vendor/zendframework/zendframework1/library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /var/www/vendor/zendframework/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /var/www/vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #3 /var/www/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('ALTER TABLE `qu...', Array) #4 [internal function]: Zend_Db_Adapter_Pdo_Abstract->query('ALTER TABLE `qu...') #5 /var/www/pimcore/lib/Pimcore/Db/Wrapper.php(290): call_user_func_array(Array, Array) #6 /var/www/pimcore/lib/Pimcore/Db/Wrapper.php(260): Pimcore\Db\Wrapper->callResourceMethod('query', Array) #7 /var/www/website/var/system/update/3839/scripts/postupdate.php(10): Pimcore\Db\Wrapper->__call('query', Array) #8 /var/www/pimcore/lib/Pimcore/Update.php(329): include('/var/www/websit...') #9 /var/www/pimcore/lib/Pimcore/Console/Command/InternalUpdateProcessorCommand.php(52): Pimcore\Update::executeScript('3839', 'postupdate') #10 /var/www/vendor/symfony/console/Command/Command.php(256): Pimcore\Console\Command\InternalUpdateProcessorCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/vendor/symfony/console/Application.php(831): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/vendor/symfony/console/Application.php(186): Symfony\Component\Console\Application->doRunCommand(Object(Pimcore\Console\Command\InternalUpdateProcessorCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/vendor/symfony/console/Application.php(117): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #14 /var/www/pimcore/cli/console.php(23): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput)) #15 {main} Next Zend_Db_Statement_Exception: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'reference', query was: ALTER TABLE `quantityvalue_units` CHANGE COLUMN `referemce` `reference` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_bin' AFTER `conversionOffset`; in /var/www/vendor/zendframework/zendframework1/library/Zend/Db/Statement/Pdo.php:235 Stack trace: #0 /var/www/vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #2 /var/www/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('ALTER TABLE `qu...', Array) #3 [internal function]: Zend_Db_Adapter_Pdo_Abstract->query('ALTER TABLE `qu...') #4 /var/www/pimcore/lib/Pimcore/Db/Wrapper.php(290): call_user_func_array(Array, Array) #5 /var/www/pimcore/lib/Pimcore/Db/Wrapper.php(260): Pimcore\Db\Wrapper->callResourceMethod('query', Array) #6 /var/www/website/var/system/update/3839/scripts/postupdate.php(10): Pimcore\Db\Wrapper->__call('query', Array) #7 /var/www/pimcore/lib/Pimcore/Update.php(329): include('/var/www/websit...') #8 /var/www/pimcore/lib/Pimcore/Console/Command/InternalUpdateProcessorCommand.php(52): Pimcore\Update::executeScript('3839', 'postupdate') #9 /var/www/vendor/symfony/console/Command/Command.php(256): Pimcore\Console\Command\InternalUpdateProcessorCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #10 /var/www/vendor/symfony/console/Application.php(831): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 /var/www/vendor/symfony/console/Application.php(186): Symfony\Component\Console\Application->doRunCommand(Object(Pimcore\Console\Command\InternalUpdateProcessorCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/vendor/symfony/console/Application.php(117): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/pimcore/cli/console.php(23): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput)) #14 {main} {"origin":"Pimcore\\Db::errorHandler() on line 318","memory":" 8 MB"} []
[2017-02-15 16:57:39] core.ERROR: Array ( [message] => SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'reference', query was: ALTER TABLE `quantityvalue_units` CHANGE COLUMN `referemce` `reference` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_bin' AFTER `conversionOffset`; [method] => query [arguments] => Array ( [0] => ALTER TABLE `quantityvalue_units` CHANGE COLUMN `referemce` `reference` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_bin' AFTER `conversionOffset`; ) ) {"origin":"Pimcore\\Db::errorHandler() on line 322","memory":" 8 MB"} []
{"message":"","success":true}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment