Author Topic: [SOLVED] Upgrading from 1.3.0 to 1.3.3, database schema fails, email gone  (Read 5615 times)

Offline jeremyjvogel

  • Newbie
  • *
  • Posts: 5
After running the upgrade script per the instructions here https://github.com/roundcube/roundcubemail/wiki/Upgrade, I got this error:

Code: [Select]
done.
Installing JavaScript dependencies...PHP exec() function is required. Check disable_functions in php.ini
done.
Running update script at target...
Executing database schema update.
Error 500: Error in DDL upgrade 2016112200: [1060] Duplicate column name 'id'
Updating database schema (2016112200)... [FAILED]
All done.

So I removed exec from the php.ini file, restarted httpd and reran the upgrade script upgrade.sh.  Same error.  Now, Roundcube doesn't work.  I can login, but I can't see any email.  The folders are there, but no emails.  Clicking on the "about" link doesn't do anything either.  I can compose an email, but can't send it, but the email server is working fine with IMAP email clients.
« Last Edit: November 15, 2017, 12:21:15 PM by jeremyjvogel »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
Re: Upgrading from 1.3.0 to 1.3.3, database schema fails, email gone
« Reply #1 on: November 15, 2017, 11:10:13 AM »
Run the bin/install-jsdeps.sh script, that was the part that was skipped when exec was disabled.

Offline jeremyjvogel

  • Newbie
  • *
  • Posts: 5
Re: Upgrading from 1.3.0 to 1.3.3, database schema fails, email gone
« Reply #2 on: November 15, 2017, 11:14:02 AM »
I get this error.
Code: [Select]
ERROR: Required program 'unzip' not foundHowever, if I do
Code: [Select]
#which unzipfrom the command line, I get /bin/unzip, so I don't know why the install-jsdeps.sh can't find it. 

Offline jeremyjvogel

  • Newbie
  • *
  • Posts: 5
Re: Upgrading from 1.3.0 to 1.3.3, database schema fails, email gone
« Reply #3 on: November 15, 2017, 11:27:25 AM »
I also found the following exec functions disabled in php.ini. 
ftp_exec
curl_exec
pcntl_exec
shell_exec
curl_multi_exec

I removed them and now I get:
Code: [Select]
Installing jQuery...
Fetching https://code.jquery.com/jquery-3.2.1.min.js
curl: no URL specified!
curl: try 'curl --help' or 'curl --manual' for more information
ERROR: Failed to download source file from https://code.jquery.com/jquery-3.2.1.min.js

Offline jeremyjvogel

  • Newbie
  • *
  • Posts: 5
Re: Upgrading from 1.3.0 to 1.3.3, database schema fails, email gone
« Reply #4 on: November 15, 2017, 11:38:10 AM »
install-jsdeps.sh worked after I commented out the entire disable_functions section of php.ini.  Next I tried update.sh again and get the same error. 

Code: [Select]
# ./update.sh
What version are you upgrading from? Type '?' if you don't know.
1.3.0
Executing database schema update.
Updating database schema (2016112200)... [FAILED]
Error 500: Error in DDL upgrade 2016112200: [1060] Duplicate column name 'id'

Offline alec

  • Hero Member
  • *****
  • Posts: 1,363

Offline jeremyjvogel

  • Newbie
  • *
  • Posts: 5
Re: Upgrading from 1.3.0 to 1.3.3, database schema fails, email gone
« Reply #6 on: November 15, 2017, 12:12:11 PM »
Updating dependencies fixed the email not showing up issue.  Alec's link also fixed the issue with the database schema. 

Thank you very much for your help SKaero and Alec. 
« Last Edit: November 15, 2017, 12:21:44 PM by jeremyjvogel »