Error Update Roundcube Plugins

  • Code
    1. Plugin-Installation fehlgeschlagen: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'instance'


    System Ubuntu 16.04 and Debian 8

    Edited once, last by lugau45 ().

  • @lugau45


    From which RoundcubePlugin plugin version you try to update? Provide us wih all info, else your thread will be deleted. Also, use bbcode!

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

  • @lugau45


    Please, give me the result of the following SQL query:



    SQL
    1. # mysql
    2. > use imscp;
    3. > select plugin_info from plugin where plugin_name = 'RoundcubePlugins';

    EDIT


    I've just done a fresh installation of the RoundcubePlugins plugin v1.2.6 and then, updated to version 2.0.0. There was an error due to the the pear-pear.php.net/Net_LDAP2 2.2.0 required ext-ldap while running composer bug which has been fixed in the 2.0.1 version. Thus, I've updated to the 2.0.1 version and there was no errors.


    So again, give us the result of the SQL query above and provide us your i-MSCP version.

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

  • Code
    1. mysql> mysql> select plugin_info from plugin where plugin_name = 'RoundcubePlugins';ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql> select plugin_info from plugin where plugin_name = 'RoundcubePlugins'' at line 1

    Imscp Version:


    Code
    1. i-MSCP 1.4.3Build: 20170417

    PhpMyadmin Plugininfo:


    Code
    1. {"author":["Laurent Declercq","Rene Schuster","Sascha Bay"],"email":"[email protected]","version":"2.0.1","require_api":"1.0.6","date":"2017-05-03","build":"2017050301","name":"RoundcubePlugins","desc":"Provides many plugins for the Roundcube Webmail.","url":"http:\/\/wiki.i-mscp.net\/doku.php?id=plugins:roundcubeplugins","__nversion__":"2.0.1","__installable__":true,"__uninstallable__":true,"__need_change__":false,"db_schema_version":"011"}



    Bildschirmfoto vom 2017-05-05 15-57-34.png

  • @lugau45


    Well, the db schema doesn't matches with your plugin version. You have surely done something wrong in the past, such installing a plugin by yourself, I don't know...


    Please, make a dump of your RoundCube database (schema only) through phpmyadmin and send me the file. I need to check which database migrations were already done done.

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

  • @lugau45


    I've check your dump. All migrations are already done... Therefore, connect to PhpMyAdmin and edit the plugin_info field of the plugin table for the RoundcubePlugins plugin. You must change "db_schema_version":"011" by "db_schema_version":"014". You should change only the number. Be aware that if you do something wrong while editing, the JSON format will be broken.


    Once done, you should be able to give a new try though the plugin management interface.

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