[SOLVED] Upgrading from 1.3.0 to 1.3.3, database schema fails, email gone

[jeremyjvogel]

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

Code Select Expand

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.

[SKaero]

Run the bin/install-jsdeps.sh script, that was the part that was skipped when exec was disabled.

[jeremyjvogel]

I get this error.

Code Select Expand

ERROR: Required program 'unzip' not found
However, if I do

Code Select Expand

#which unzipfrom the command line, I get /bin/unzip, so I don't know why the install-jsdeps.sh can't find it. 

[jeremyjvogel]

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 Expand

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


[jeremyjvogel]

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 Expand

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


[alec]

https://github.com/roundcube/roundcubemail/issues/6034

[jeremyjvogel]

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.