1 Topic by platpirs

  • platpirs
  • Member
  • Offline
  • Registered: 2015-02-10
  • Posts: 59

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

----

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: 31,088

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;

3 Reply by platpirs

  • platpirs
  • Member
  • Offline
  • Registered: 2015-02-10
  • Posts: 59

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 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

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/.

5 Reply by morethanlazy

  • morethanlazy
  • Member
  • Offline
  • Registered: 2019-01-20
  • Posts: 38

Re: Roundcube upgrade problem

hello, cant find the upgrade tutarial for roundcube.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Roundcube upgrade problem

morethanlazy wrote:

hello, cant find the upgrade tutarial for roundcube.

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

7 Reply by morethanlazy

  • morethanlazy
  • Member
  • Offline
  • Registered: 2019-01-20
  • Posts: 38

Re: Roundcube upgrade problem

This tutorial doesn’t work, can you please check it

8 Reply by morethanlazy

  • morethanlazy
  • Member
  • Offline
  • Registered: 2019-01-20
  • Posts: 38

Re: Roundcube upgrade problem

I think I make some mistakes

cd <the-unpacked-roundcube-directory>

Cd roundcubemail-1.3.9

root@mail:~/roundcubemail-1.3.9#

After this step

bin/installto.sh <your-existing-roundcube-directory>

bin/installto.sh Roundcube-1.3.8

And I get error

Error 500: Invalid target: not a directory
Usage: installto.sh <TARGET>

I can’t locate the directory and cnt find where it is. About usage install.sh no clue










Error 500: Invalid target: not a directory
Usage: installto.sh <TARGET>

9 Reply by morethanlazy (edited by morethanlazy 2019-05-29 19:01:03)

  • morethanlazy
  • Member
  • Offline
  • Registered: 2019-01-20
  • Posts: 38

Re: Roundcube upgrade problem

I searched Roundcube folders and found

find / -type d -name 'roundcube'


/opt/www/roundcubemail-1.3.8/vendor/roundcube

Is this right path ?

If it is right

root@mail:~/roundcubemail-1.3.9#

bin/installto.sh <your-existing-roundcube-directory>

bin/installto.sh  /opt/www/roundcubemail-1.3.8/vendor/roundcube

Or

bin/installto.sh  /opt/www/roundcubemail-1.3.8

10 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Roundcube upgrade problem

Run: bin/installto.sh  /opt/www/roundcubemail

11 Reply by morethanlazy

  • morethanlazy
  • Member
  • Offline
  • Registered: 2019-01-20
  • Posts: 38

Re: Roundcube upgrade problem

JavaScript dependencies installation skipped...
Running update script at target...
Executing database schema update.
This instance of Roundcube is up-to-date.
Have fun!
All done.

Thank you Zhang