1

Topic: Roundcube upgrade problem

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 0.9.8
- Deployed with iRedMail Easy or the downloadable installer? No
- Linux/BSD distribution name and version: Ubuntu 18.04 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  LDAP
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? Yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hi

I want to upgrade roundcube. (from 1.3.6 to 1.3.9)
After command bin/installto.sh /opt/www/roundcube....
There is an error at the end

Error 500: Error in DDL upgrade 2016081200: [1091] Can't DROP 'created'; check that column/key exists
Updating database schema (2016081200)... [FAILED]
All done.

Any suggestions ?

Arnis

2

Re: Roundcube upgrade problem

Please go to /opt/www/roundcubemail/SQL/mysql/, import sql file "2016081200.sql" to roundcubemail database manually. Like this:

mysql> USE roundcubemail;
mysql> SOURCE /opt/www/roundcubemail/SQL/mysql/2016081200.sql;

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

3

Re: Roundcube upgrade problem

ZhangHuangbin wrote:

Please go to /opt/www/roundcubemail/SQL/mysql/, import sql file "2016081200.sql" to roundcubemail database manually. Like this:

mysql> USE roundcubemail;
mysql> SOURCE /opt/www/roundcubemail/SQL/mysql/2016081200.sql;


1)
mysql>  USE roundcubemail;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

2)mysql>  SOURCE /opt/www/roundcubemail/SQL/mysql/2016081200.sql;
ERROR 1091 (42000): Can't DROP 'created'; check that column/key exists
mysql>\

Any suggestions ?


Arnis

4

Re: Roundcube upgrade problem

Did you upgrade Roundcube from an old release to 1.3.6 (Not 1.3.9 yet)? If yes, i'm afraid that your SQL database MAYBE not upgraded correctly in previous upgrade (from old release to 1.3.6), you can try to import the SQL file slight earlier than 2016081200.sql under /opt/www/roundcubemail/SQL/mysql/.

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee

5

Re: Roundcube upgrade problem

hello, cant find the upgrade tutarial for roundcube.

6

Re: Roundcube upgrade problem

morethanlazy wrote:

hello, cant find the upgrade tutarial for roundcube.

FYI: https://github.com/roundcube/roundcubemail/wiki/Upgrade

----

Does my reply help a little? How about buying me a cup of coffee ($5) as an encouragement?

buy me a cup of coffee