Release Support > Pending Issues

mysql.update.sql error

(1/2) > >>

cbrace:
Hi all,

It appears the database schema of my roundcube installation is out of date, and following the instructions of the installer, I have run the SQL update script in PhpMyAdmin. Alas it returns an error message:

--- Code: ---SQL query:

ALTER TABLE  `messages` DROP INDEX  `idx` ,
DROP INDEX  `uid` ;


MySQL said:

#1091 - Can't DROP 'idx'; check that column/key exists
--- End code ---
Any ideas what is going wrong here?

Thanks

roundcube v0.7.2

--- Code: ---$ mysql --version
mysql  Ver 14.14 Distrib 5.5.22, for FreeBSD8.2 (amd64) using  5.2

--- End code ---

SKaero:
You need to open the mysql update file and run the queries under the version your updating from.

cbrace:
Hmmm... I am not sure what version I am updating from. I know that sounds bizarre, but I update roundcube periodically via the FreeBSD ports system along with everything else on the server, and a few updates passed without my running the installer. I know, my bad.

I tried applying updates from several recent releases using the facility on page three of the installer with no luck :(((

SKaero:
Do you have a backup of the old files? You could check the version number in the index.php.

cbrace:
These are the versions I have installed over time on my FreeBSD server:

--- Code: ----rw-r--r--  1 root  wheel  2254703 Jan 12  2011 /usr/ports/distfiles/roundcubemail-0.5.tar.gz
-rw-r--r--  1 root  wheel  2291117 Aug 13  2011 /usr/ports/distfiles/roundcubemail-0.5.4.tar.gz
-rw-r--r--  1 root  wheel  2681342 Sep 28  2011 /usr/ports/distfiles/roundcubemail-0.6.tar.gz
-rw-r--r--  1 root  wheel  2710511 Jan  8 18:09 /usr/ports/distfiles/roundcubemail-0.7.1.tar.gz
-rw-r--r--  1 root  wheel  2714219 Mar 11 17:39 /usr/ports/distfiles/roundcubemail-0.7.2.tar.gz
-rw-r--r--  1 root  wheel  2707916 Dec 14 14:37 /usr/ports/distfiles/roundcubemail-0.7.tar.gz
--- End code ---
Using the very useful "Version to update from" feature on page 3 of the installer, I have tried updating from every version from v5 upwards. No luck. Everytime I get a mySQL error.

This is what I see when first open page 3 of the installer in the DB section:


--- Quote ---Check DB config

DSN (write):  OK
DB Schema:  NOT OK(Database schema differs)
Missing table 'cache_index'
Missing table 'cache_thread'
Missing table 'cache_messages'
Missing table 'dictionary'
Missing table 'searches'

You should run the update queries to get the schmea fixed.
Version to update from:   
--- End quote ---

Any ideas why these tables are not/have not been created?

Navigation

[0] Message Index

[#] Next page