Roundcube Community Forum

 

updatedb fails on upgrade from 0.8.5 to 1.0.2

Started by stevenospam, November 11, 2014, 04:04:05 PM

Previous topic - Next topic

stevenospam

I'm upgrading Roundcube on my VPS (Debian) and I have root access but I can't run shell scripts. Using the web interface installer/index.php, I get to the point where the upgrade says:
DB Schema:  NOT OK(Database schema differs)

    Missing columns in table 'cache': expires
    Missing table 'cache_shared'
    Missing columns in table 'cache_index': expires
    Missing columns in table 'cache_thread': expires
    Missing columns in table 'cache_messages': expires
    Missing table 'system'
I can't run the updatedb.sh script because the bash shell environment is not really available. When I tried it I got:

root@vps42353:/hosting/services/mounts/1/coolnluc2/home/www/webmail.lucencool.com/roundcubemail-1.0.2/bin# /hosting/services/mounts/1/admin/bin/bash updatedb.sh
updatedb.sh: line 2: ?php: No such file or directory
updatedb.sh: line 3: /aquota.group: No such file or directory
updatedb.sh: line 4: +-----------------------------------------------------------------------+: command not found
updatedb.sh: line 5: syntax error near unexpected token `|'
updatedb.sh: line 5: ` | bin/updatedb.sh                                                       |'

Are there instructions to manually make the MYSQL changes? Any other suggestions?

SKaero

You can manually run the SQL files in the <RC root>/SQL/mysql folder. When upgrading from 0.8.5 run 2013061000.sql and newer.