1 Topic by jack (edited by jack 2018-04-11 00:09:28)

  • jack
  • Member
  • Offline
  • Registered: 2015-01-13
  • Posts: 22

Topic: Upgrade from iredmail 0.9.7 to 0.9.8 - Roundcube update fail

======== Required information ====
- iRedMail version (check /etc/iredmail-release): upgrading to 0.9.8
- Linux/BSD distribution name and version: Centos 7
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Upgrading from 0.9.7 to 0.9.8 before upgrading to iRedAdmin-Pro-SQL-2.9.0.  In upgrading RoundCube 1.3.5 from 1.3.0, I received this error at the end of the script:

JavaScript dependencies installation skipped...
Running update script at target...
Executing database schema update.
Updating database schema (2016112200)... [FAILED]
Error 500: Error in DDL upgrade 2016112200: [1060] Duplicate column name 'id'
All done.

Is this OK?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Upgrade from iredmail 0.9.7 to 0.9.8 - Roundcube update fail

Not OK.
Please login to SQL server as root user, then import SQL file "SQL/mysql/2016112200.sql" manually. For example:

# mysql roundcubemail
mysql> SOURCE /var/www/roundcubemail/SQL/mysql/2016112200.sql;

3 Reply by jack

  • jack
  • Member
  • Offline
  • Registered: 2015-01-13
  • Posts: 22

Re: Upgrade from iredmail 0.9.7 to 0.9.8 - Roundcube update fail

ZhangHuangbin wrote:

Not OK.
Please login to SQL server as root user, then import SQL file "SQL/mysql/2016112200.sql" manually. For example:

# mysql roundcubemail
mysql> SOURCE /var/www/roundcubemail/SQL/mysql/2016112200.sql;

Looks like the same error:

MariaDB [roundcubemail]> SOURCE /var/www/roundcubemail-1.3.5/SQL/mysql/2016112200.sql;
ERROR 1060 (42S21) at line 1 in file: '/var/www/roundcubemail-1.3.5/SQL/mysql/2016112200.sql': Duplicate column name 'id'
Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.01 sec)

Query OK, 0 rows affected (0.14 sec)

Query OK, 0 rows affected (0.14 sec)

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,792

Re: Upgrade from iredmail 0.9.7 to 0.9.8 - Roundcube update fail

It's fine now, it skipped the error and applied the rest.

5 Reply by jack

  • jack
  • Member
  • Offline
  • Registered: 2015-01-13
  • Posts: 22

Re: Upgrade from iredmail 0.9.7 to 0.9.8 - Roundcube update fail

ZhangHuangbin wrote:

It's fine now, it skipped the error and applied the rest.

Thanks!!