New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

update on debian 2018.08.4-1.90 -> 2018.08.5-1.90: setup.php --update fails #6958

Closed
tobser opened this Issue Nov 6, 2018 · 5 comments

Comments

Projects
None yet
2 participants
@tobser

tobser commented Nov 6, 2018

since this update (from /var/log/apt/history.log):

Start-Date: 2018-10-30  02:26:17
Commandline: apt-get dist-upgrade
Upgrade: tine20-felamimail:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-tasks:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-activesync:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-mailfiler:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-humanresources:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-filemanager:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-sales:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-webstack:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-libraries:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-tinebase:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-inventory:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-crm:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-calendar:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20:amd64 (2018.08.4-1.90, 2018.08.5-1.90), tine20-timetracker:amd64 (2018.08.4-1.90, 2018.08.5-1.90)
End-Date: 2018-10-30  02:26:26

the command
/usr/bin/php /usr/share/tine20/setup.php --config /etc/tine20/config.inc.php --update

fails with the following exceptions

PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'tine20_humanresources_account' already exists in /usr/share/tine20/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
Stack trace:
#0 /usr/share/tine20/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('CREATE TABLE `t...')
#1 /usr/share/tine20/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('CREATE TABLE `t...')
#2 /usr/share/tine20/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(843): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE `t...')
#3 /usr/share/tine20/Setup/SchemaTool.php(144): Doctrine\ORM\Tools\SchemaTool->updateSchema(Array, true)
#4 /usr/share/tine20/Setup/Update/Abstract.php(532): Setup_SchemaTool::updateSchema(Array)
#5 /usr/share/tine20/HumanResources/Setup/Update/Release12.php(15): Setup_Update_Abstract->updateSchema('HumanResources', Array)
#6 /usr/share/tine20/Setup/Controller.php(631): H in /usr/share/tine20/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 49

Fatal error: Uncaught PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'tine20_humanresources_account' already exists in /usr/share/tine20/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
Stack trace:
#0 /usr/share/tine20/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('CREATE TABLE `t...')
#1 /usr/share/tine20/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('CREATE TABLE `t...')
#2 /usr/share/tine20/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(843): Doctrine\DBAL\Connection->executeQuery('CREATE TABLE `t...')
#3 /usr/share/tine20/Setup/SchemaTool.php(144): Doctrine\ORM\Tools\SchemaTool->updateSchema(Array, true)
#4 /usr/share/tine20/Setup/Update/Abstract.php(532): Setup_SchemaTool::updateSchema(Array)
#5 /usr/share/tine20/HumanResources/Setup/Update/Release12.php(15): Setup_Update_Abstract->updateSchema('HumanResources', Array)
#6 /usr/share/tine20/Setup/Controller.php(631): H in /usr/share/tine20/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 49

and tine is stuck in maintenance mode.

packages are installed from
deb https://packages.tine20.org/debian stretch stable

@pschuele

This comment has been minimized.

Member

pschuele commented Nov 7, 2018

hi,

do you use the HumanResources module?
could you switch the tine20-logging to DEBUG and attach the logfile?

@tobser

This comment has been minimized.

tobser commented Nov 7, 2018

Hi,
i do not use the HumanResources module and i think it should have been disabled in the Webinterface (or uninstalled if this is possible form the WebUi but i'm not sure it has been a while ago). Here is the debug log: tine20-update.log

@pschuele

This comment has been minimized.

Member

pschuele commented Nov 8, 2018

ok, somehow tine20 has the opinion that the HR module needs an update... when it tries to create the table(s), it crashes.

please try to uninstall the module (for example via CLI):

php setup.php --config=/path/to/config --uninstall HumanResources

and try again.

if that does not help, you might have to remove the tables (tine20_humanresources_*) manually.

@tobser

This comment has been minimized.

tobser commented Nov 8, 2018

after uninstalling HumanResources I get a new error:
tine20-update2.log

@pschuele

This comment has been minimized.

Member

pschuele commented Nov 9, 2018

the new error is a duplicate of #6949 which is already fixed. closing this issue.

@pschuele pschuele closed this Nov 9, 2018

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment