SQL Errormessage on upgrade from 1.2.x to 1.5.3

**ciscllc** · Sep 3rd 2018

Hello!

I get this error when updating:

Code

Servers::sqld::mysql::installer::_setupDatbase: [ERROR] Database update 267 failed: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'domain_id'; check that column/key exists

Was: mysql 5.6

Now: MariaDB 10.1

Debian: 9.5

setup.log:

Code

Mon Sep 3 11:25:34 2018] [debug] iMSCP::Execute::execute: /usr/sbin/groupadd -f imscp
[Mon Sep 3 11:25:34 2018] [debug] iMSCP::Execute::execute: /usr/sbin/useradd -c i-MSCP master user -d /var/local/imscp -m -k /etc/skel -g imscp -s /bin/false imscp
[Mon Sep 3 11:25:36 2018] [debug] iMSCP::Execute::execute: /bin/systemctl --system --force --quiet enable imscp_daemon.service
[Mon Sep 3 11:25:37 2018] [debug] iMSCP::Execute::execute: /bin/systemctl --system --force --quiet enable imscp_traffic.service
[Mon Sep 3 11:25:38 2018] [debug] iMSCP::Execute::execute: /bin/systemctl --system --force --quiet enable imscp_mountall.service
[Mon Sep 3 11:25:38 2018] [debug] (eval): SQL server type set to: mariadb
[Mon Sep 3 11:25:38 2018] [debug] (eval): SQL server version set to: 10.1.26
[Mon Sep 3 11:25:38 2018] [debug] iMSCP::Execute::execute: dpkg -l mysql-community* percona-server-* | cut -d' ' -f1 | grep -q 'ii'
[Mon Sep 3 11:25:38 2018] [debug] Servers::sqld::mysql::installer::_updateServerConfig: dpkg-query: no packages found matching mysql-community*
dpkg-query: no packages found matching percona-server-*
[Mon Sep 3 11:25:38 2018] [debug] iMSCP::Execute::execute: php -d date.timezone=UTC /var/www/imscp/engine/setup/updDB.php
[Mon Sep 3 11:28:21 2018] [error] Servers::sqld::mysql::installer::_setupDatbase: [ERROR] Database update 267 failed: SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'domain_id'; check that column/key exists
[Mon Sep 3 11:28:21 2018] [debug] iMSCP::Execute::execute: /usr/bin/dialog --insecure --no-label No --no-shadow --colors --help-label Help --exit-label Abort --yes-label Yes --backtitle 'i-MSCP - internet Multi Server Control Panel (1.5.3)' --title 'i-MSCP Installer Dialog' --cancel-label Back --ok-label Ok --msgbox '\Z1[ERROR]\Zn
Error while performing step:
Executing Servers::sqld preinstall tasks...
Error was:
\Z1Servers::sqld::mysql::installer::_setupDatbase: [ERROR] Database update 267 failed: SQLSTATE[42000]: Syntax error or access violation: 1091 Can'\''t DROP '\''domain_id'\''; check that column/key exists\Zn
Please have a look at http://i-mscp.net/forum if you need help.
' 35 138
[Mon Sep 3 11:32:09 2018] [debug] iMSCP::Execute::execute: /usr/bin/dialog --insecure --no-label No --no-shadow --colors --help-label Help --exit-label Abort --yes-label Yes --backtitle 'i-MSCP - internet Multi Server Control Panel (1.5.3)' --title 'i-MSCP Installer Dialog' --cancel-label Back --ok-label Ok --msgbox '\Z1[ERROR]\Zn
Error while performing step:
Processing servers/packages
Error was:
\Z1Servers::sqld::mysql::installer::_setupDatbase: [ERROR] Database update 267 failed: SQLSTATE[42000]: Syntax error or access violation: 1091 Can'\''t DROP '\''domain_id'\''; check that column/key exists\Zn
Please have a look at http://i-mscp.net/forum if you need help.
' 35 138
[Mon Sep 3 11:32:10 2018] [debug] iMSCP::Execute::execute: /usr/bin/dialog --insecure --no-label No --no-shadow --colors --help-label Help --exit-label Abort --yes-label Yes --backtitle 'i-MSCP - internet Multi Server Control Panel (1.5.3)' --title 'i-MSCP Installer Dialog' --cancel-label Back --ok-label Ok --msgbox '\Z1[ERROR]\Zn
Error while performing step:
Processing setup tasks
Error was:
\Z1Servers::sqld::mysql::installer::_setupDatbase: [ERROR] Database update 267 failed: SQLSTATE[42000]: Syntax error or access violation: 1091 Can'\''t DROP '\''domain_id'\''; check that column/key exists\Zn
Please have a look at http://i-mscp.net/forum if you need help.
' 35 138
[Mon Sep 3 11:32:10 2018] [error] autoinstaller::Functions::install: An error occurred while performing installation steps
[Mon Sep 3 11:32:10 2018] [debug] iMSCP::LockFile::release: Releasing exclusive lock on /var/lock/awstats_updateall.pl.lock
[Mon Sep 3 11:32:11 2018] [debug] iMSCP::LockFile::release: Releasing exclusive lock on /var/lock/imscp.lock
[Mon Sep 3 11:32:11 2018] [debug] iMSCP::LockFile::release: Releasing exclusive lock on /var/lock/imscp-backup-all.lock
[Mon Sep 3 11:32:11 2018] [debug] iMSCP::LockFile::release: Releasing exclusive lock on /var/lock/imscp-disable-accounts.lock
[Mon Sep 3 11:32:11 2018] [debug] iMSCP::LockFile::release: Releasing exclusive lock on /var/lock/imscp-dsk-quota.lock
[Mon Sep 3 11:32:11 2018] [debug] iMSCP::LockFile::release: Releasing exclusive lock on /var/lock/imscp-srv-traff.lock
[Mon Sep 3 11:32:11 2018] [debug] iMSCP::LockFile::release: Releasing exclusive lock on /var/lock/imscp-vrl-traff.lock
[Mon Sep 3 11:32:11 2018] [debug] iMSCP::LockFile::release: Releasing exclusive lock on /var/lock/imscp-backup-imscp.lock

Display More

the database is imscp and the table domain shows the following:

Code

+-------------------------------+---------------------+------+-----+--------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------------------+---------------------+------+-----+--------------+----------------+
| domain_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| domain_name | varchar(200) | YES | UNI | NULL | |
| domain_admin_id | int(10) unsigned | NO | MUL | 0 | |
| domain_created | int(10) unsigned | NO | | 0 | |
| domain_expires | int(10) unsigned | NO | | 0 | |
| domain_last_modified | int(10) unsigned | NO | | 0 | |
| domain_mailacc_limit | int(11) | YES | | NULL | |
| domain_ftpacc_limit | int(11) | YES | | NULL | |
| domain_traffic_limit | bigint(20) | YES | | NULL | |
| domain_sqld_limit | int(11) | YES | | NULL | |
| domain_sqlu_limit | int(11) | YES | | NULL | |
| domain_status | varchar(255) | YES | | NULL | |
| domain_alias_limit | int(11) | YES | | NULL | |
| domain_subd_limit | int(11) | YES | | NULL | |
| domain_ip_id | int(10) unsigned | YES | | NULL | |
| domain_disk_limit | bigint(20) unsigned | YES | | NULL | |
| domain_disk_usage | bigint(20) unsigned | YES | | NULL | |
| domain_disk_file | bigint(20) unsigned | YES | | NULL | |
| domain_disk_mail | bigint(20) unsigned | YES | | NULL | |
| domain_disk_sql | bigint(20) unsigned | YES | | NULL | |
| domain_php | varchar(15) | YES | | NULL | |
| domain_cgi | varchar(15) | YES | | NULL | |
| allowbackup | varchar(12) | NO | | dmn|sql|mail | |
| domain_dns | varchar(15) | NO | | no | |
| domain_software_allowed | varchar(15) | NO | | no | |
| phpini_perm_system | varchar(20) | NO | | no | |
| phpini_perm_allow_url_fopen | varchar(20) | NO | | no | |
| phpini_perm_display_errors | varchar(20) | NO | | no | |
| phpini_perm_disable_functions | varchar(20) | NO | | no | |
| phpini_perm_mail_function | varchar(20) | NO | | yes | |
| domain_external_mail | varchar(15) | NO | | no | |
| external_mail | varchar(15) | NO | | off | |
| web_folder_protection | varchar(5) | NO | | yes | |
| mail_quota | bigint(20) unsigned | NO | | NULL | |
| document_root | varchar(255) | NO | | /htdocs | |
| url_forward | varchar(255) | NO | | no | |
| type_forward | varchar(5) | YES | | NULL | |
| host_forward | varchar(3) | YES | | Off | |
+-------------------------------+---------------------+------+-----+--------------+----------------+

Display More

Thanks a lot in advance!

**Nuxwin** · Sep 3rd 2018

Good evening,

This has nothing to do with the imscp.domain table but with the imscp.php_ini table

https://github.com/i-MSCP/imsc…Update/Database.php#L2029

If you don't figure out alone, please give us access to the server.

SQL Errormessage on upgrade from 1.2.x to 1.5.3

Share

Daily visitors