After running the upgrade script per the instructions here https://github.com/roundcube/roundcubemail/wiki/Upgrade (https://github.com/roundcube/roundcubemail/wiki/Upgrade), I got this error:
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.
Run the bin/install-jsdeps.sh script, that was the part that was skipped when exec was disabled.
I get this error.
ERROR: Required program 'unzip' not found
However, if I do #which unzipfrom the command line, I get /bin/unzip, so I don't know why the install-jsdeps.sh can't find it.
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: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
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.
# ./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'
https://github.com/roundcube/roundcubemail/issues/6034
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.