Error at the I-MSCP move to a new Server -> 1.2.2

  • Hello


    I tried the server move as described here:
    i-mscp komplett umziehen


    At the auto installation I got the following error :


    [ERROR]


    Package::Webmail::Roundcube::Installer::_updateDatabase: Unable to update roundcube database schema.
    [FATAL]


    iMSCP::Debug::__ANON__: Can't use string ("255") as a HASH ref while "strict refs" in use at /usr/local/src/imscp-1.2.2/engine/PerlLib/Package/Webmail/Roundcube/Installer.pm line 657.


    Old server: wheezy with I-MSCP 1.2.2
    New server: wheezy with I-MSCP 1.2.2


    How can i solve the problem?


    Thanks.

  • You imported the databases correctly and all the other steps worked fine expect the last step (autoinstaller)?


    PS: Are you using some plugins?

  • Hello nino


    Thanks for ur answer.
    Yes i have imported the database correctly, and all autoinstaller steps bevor the Error worked fine.


    I have all plugins deactivated bevor i beginning with the data exports...

  • @ruv6000



    Could you give me an access to your server?

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • @ruv6000


    Problem found.


    Shell-Script
    1. root@s3:/usr/local/src/imscp-1.2.2# php /var/www/imscp/gui/public/tools/webmail/bin/updatedb.sh --version=1.1.1 --dir=/var/www/imscp/gui/public/tools/webmail/SQL --package=roundcube
    2. Updating database schema (2013052500)... ERROR: [1050] Table 'cache_shared' already exists (SQL Query: CREATE TABLE `cache_shared` (
    3. `cache_key` varchar(255) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL,
    4. `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
    5. `data` longtext NOT NULL,
    6. INDEX `created_index` (`created`),
    7. INDEX `cache_key_index` (`cache_key`)
    8. ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */)[FAILED]
    9. Error 500: Error in DDL upgrade 2013052500: [1050] Table 'cache_shared' already exists


    This is due to the fact that a database update is already applied. I'll fix that on your server. Shouldn't occurs normally.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

  • Re;


    Problem fixed.


    Code
    1. Congratulations │
    2. │ │
    3. │ i-MSCP has been successfully installed/updated. │
    4. │ │
    5. │ Please connect to http://admin.sxx3.xxxxx.ch:xxx and login with your │
    6. │ administrator account. │
    7. │ │
    8. │ Thank you for choosing i-MSCP.


    I've also fixed password of debian-sys-maint SQL user which was wrong.


    BTW: I don't know if this is expected but on your system, I see new imscp database and old ispcp database. The database in use right now is the imscp database which doesn't seem to contain any customer related data.


    Please create another thread for any other problem.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206