Migration from ispcp to i-MSCP - Unknown column admin_sys_name' in field list

Hilwi · Nov 28th 2014

Hi!

I'm trying to upgrade from ispcp 1.0.7 to i-MSCP 1.1.18 on a Debian Squeeze system (courier, apache-fcgid).

The upgrade-script "imscp-migrate-from-ispcp" went fine after deleting some orphaned domain entries from the database. But running imscp-setup -d I ran into several errors which I managed to fix so far.

The first problem was a missing php_ini table that doesn't exist in my ispcp database. I created it using the matching part from https://code.google.com/p/ispc…nk/imscp/schema.sql?r=153. However, this may not have been the best solution but it was the only way to get further - I didn't find any informations in the forum.

But now I get the following error:

Code

Error while performing step:Servers installationError was:\Z1Servers::httpd::apache_fcgid::installer::_addUser: Error while executing query: Unknown column '\''admin_sys_name'\'' in '\''field list'\'' \ZnPlease, post on http://i-mscp.net/forum to get any help.' 21 78[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::getExitCode: External command exited with value 0[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::execute: Executing command: /usr/sbin/postmap hash:/etc/postfix/imscp/domains[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::getExitCode: External command exited with value 0[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::execute: Executing command: /usr/sbin/postmap hash:/etc/postfix/imscp/relay_domains[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::getExitCode: External command exited with value 0[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::execute: Executing command: /usr/sbin/postmap hash:/etc/postfix/imscp/transport[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::getExitCode: External command exited with value 0[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::execute: Executing command: /usr/sbin/postmap hash:/etc/postfix/imscp/sender-access[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::getExitCode: External command exited with value 0[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::execute: Executing command: /usr/sbin/postmap hash:/etc/postfix/imscp/aliases[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::getExitCode: External command exited with value 0[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::execute: Executing command: /usr/sbin/postmap hash:/etc/postfix/imscp/mailboxes[Fri Nov 28 17:43:49 2014] [debug] iMSCP::Execute::getExitCode: External command exited with value 0[Fri Nov 28 17:43:49 2014] [error] iMSCP::Debug::END: Exit code: 1

This column doesn't exist in my ispcp database:

Code

+----------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+----------------+
| admin_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| admin_name | varchar(200) | YES | UNI | NULL | |
| admin_pass | varchar(200) | YES | | NULL | |
| admin_type | varchar(10) | YES | | NULL | |
| domain_created | int(10) unsigned | NO | | 0 | |
| customer_id | varchar(200) | YES | | 0 | |
| created_by | int(10) unsigned | YES | | 0 | |
| fname | varchar(200) | YES | | NULL | |
| lname | varchar(200) | YES | | NULL | |
| gender | varchar(1) | YES | | NULL | |
| firm | varchar(200) | YES | | NULL | |
| zip | varchar(10) | YES | | NULL | |
| city | varchar(200) | YES | | NULL | |
| state | varchar(200) | YES | | NULL | |
| country | varchar(200) | YES | | NULL | |
| email | varchar(200) | YES | | NULL | |
| phone | varchar(200) | YES | | NULL | |
| fax | varchar(200) | YES | | NULL | |
| street1 | varchar(200) | YES | | NULL | |
| street2 | varchar(200) | YES | | NULL | |
| uniqkey | varchar(255) | YES | | NULL | |
| uniqkey_time | timestamp | YES | | NULL | |
+----------------+------------------+------+-----+---------+----------------+

Display More

The DATABASE_REVISION is 45.

I don't think that my current database is broken because ispcp worked fine. What can I do to install i-mscp anyway?

Achim

**Nuxwin** · Nov 28th 2014

Hello ,

If you database revision is still set to 45, this mean that the db update has not been done.

So here, try the following:

Remove the php_ini table which you created manually
Run the /var/www/imscp/engine/setup/updDB.php script manually
If not error is reported, restart the imscp-autoinstall script, else, give us the output

Hilwi · Nov 28th 2014

Thank you for your quick reply! I ran the script and got the following error:

An exception has been thrown in file /var/www/imscp/gui/library/vendor/Zend/Translate/Adapter.php at line 241:

The given Language 'lang_GermanGermany' does not exist

Strange - I didn't see this error message before. Do I need to install something additionally? I even can change the language if I'd know how to do it.

**Nuxwin** · Nov 28th 2014

re;

@Hilwi

Ok, this explain why all users which try to migrate from ispCP cannot. Well, just edit the file manually and comment the following line:

Edit: This will not be sufficient. You must upgrade to last 1.1.x state instead which fix the bug. You can download the archive here: https://github.com/i-MSCP/imscp/archive/1.1.x.zip

To resume:

Download the 1.1.x archive, unzip it and run the imscp-autoinstall script from it. Then, this should be OK.

Hilwi · Nov 28th 2014

Thank you! This version installed fine!

Migration from ispcp to i-MSCP - Unknown column admin_sys_name' in field list

Share

Daily visitors