Upgrade from .096 - 1.01 database schema error and all mail won't load

[jmeander]

Used ./bin/installto.sh script and got the message below. Roundcube appears to open with no trouble but the mail folders won't fully load. Only the most recent 1-3 emails in any folder display in the pane; the Loading... bar spins endlessly. Upon a new login, the count of messages in the folder decreased by several hundred as well.

Any ideas?

Thanks!

Do you want me to fix your local configuration? (y/N)
y
. backing up the current config file(s)...
. writing /home/mydir/public_html/rcmail/config/config.inc.php...
Done.
Your configuration files are now up-to-date!
WARNING: File type detection doesn't work properly!
Please check the 'mime_magic' config option or the finfo functions of PHP and run this script again.
WARNING: Mimetype to file extension mapping doesn't work properly!
Please check the 'mime_types' config option and run this script again.
Executing database schema update.
Updating database schema (2013042700)... [OK]
Updating database schema (2013052500)... [OK]
ERROR: Error in DDL upgrade 2013061000: [1146] Table 'mydb_rcube.cache_index' doesn't exist
Updating database schema (2013061000)... [FAILED]

[ABerglund]

Looks like a previous upgrade to the DB didn't complete. Backup your database, then try manually applying the following mysql updates in order:

SQL/mysql/2011092800.sql
SQL/mysql/2011111600.sql
SQL/mysql/2011121400.sql
SQL/mysql/2012080700.sql
SQL/mysql/2013011000.sql
SQL/mysql/2013042700.sql
SQL/mysql/2013052500.sql
SQL/mysql/2013061000.sql
SQL/mysql/2014042900.sql

You will see some errors as some of those have already completed at least partially. But if you run through all of those, it should fix your problem.

[jmeander]

Thanks for the response.

SQL done, with the below errors, however the extremely slow/partial loading problem persists, seemingly unchanged.

I'm running my old roundcube and upgraded roundcube side-by-side on the same database and the old version runs normally on the 'upgraded' DB with no issues.

Code Select Expand

SQL/mysql/2011092800.sql
SQL query:
ALTER TABLE  `users` CHANGE  `alias`  `alias` VARCHAR( 128 ) BINARY NOT NULL ;
MySQL said: Documentation
#1054 - Unknown column 'alias' in 'users'

2011121400.sql
ALTER TABLE  `contacts` DROP INDEX  `user_contacts_index` ;
MySQL said: Documentation
#1091 - Can't DROP 'user_contacts_index'; check that column/key exists

SQL/mysql/2012080700.sql
ALTER TABLE  `cache` DROP COLUMN  `cache_id` ;
MySQL said: Documentation
#1091 - Can't DROP 'cache_id'; check that column/key exists

[jmeander]

You know, thanks, but I know better than to keep messing around with this. It's a roundcube install that's been upgraded multiple times - I think it's time to bite the bullet and start fresh. So I'm in the process of doing that.

Is there a clean way to pull over my users' preferences from the v.9x database, once I have v1.01 running well?