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]
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.
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.
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
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?