roundcube issue

[urgido]

Updating RoundCube webmail.
--2011-01-20 00:28:47-- http://files.directadmin.com/services/all/roundcube/roundcubemail-0.5.tar.gz
Resolving files.directadmin.com... 72.35.85.222
Connecting to files.directadmin.com|72.35.85.222|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2300100 (2.2M) [application/x-gzip]
Saving to: `/usr/local/directadmin/custombuild/roundcubemail-0.5.tar.gz'

100%[================================================================================================>] 2,300,100 804K/s in 2.8s

2011-01-20 00:28:50 (804 KB/s) - `/usr/local/directadmin/custombuild/roundcubemail-0.5.tar.gz' saved [2300100/2300100]

Updating mysql database ...
Editing roundcube configuration...
Roundcube 0.5 has been installed successfully.
WARNING: Database schema needs to be updated!
Open /var/www/html/roundcubemail-0.5/SQL/mysql.update.sql and execute all queries that are superscribed with the currently installed version number

view last three lines on warning message.
How I can fix this?

best regards

 

[zEitEr]

./build clean
./build update
./build roundcube d

 

[urgido]

thanks, now:

host:/usr/local/directadmin/custombuild# ./build roundcube d
cp: `/var/www/html/roundcube/logs' and `/var/www/html/roundcubemail-0.5/logs' are the same file
cp: `/var/www/html/roundcube/temp' and `/var/www/html/roundcubemail-0.5/temp' are the same file
Editing roundcube configuration...
Roundcube 0.5 has been installed successfully.
WARNING: Database schema needs to be updated!
Open /var/www/html/roundcubemail-0.5/SQL/mysql.update.sql and execute all queries that are superscribed with the currently installed version number

host:/usr/local/directadmin/custombuild#

 

[urgido]

anybody?

 

[zEitEr]

Why don't you follow:

Open /var/www/html/roundcubemail-0.5/SQL/mysql.update.sql and execute all queries that are superscribed with the currently installed version number

???

 

[zEitEr]

Run something like:

mysql --database=da_roundcube -u da_roundcube -p < /var/www/html/roundcubemail-0.5/SQL/mysql.update.sql

You can find your password for da_roundcube:

# grep da_roundcube /var/www/html/roundcubemail-0.5/config/db.inc.php

in line

$rcmail_config['db_dsnw'] = 'mysql://da_roundcube:HERE_IS_YOUR_PASSWORD@localhost/da_roundcube';

 

[urgido]

Oh, sorry I forgot write a line.

ERROR 1091 (42000) at line 7: Can't DROP 'idx'; check that column/key exists

 

[zEitEr]

Thus roundcube seems already to be updated. Does any error occur while working with the web-client?

 

[urgido]

I read this post: http://www.directadmin.com/forum/showthread.php?t=29240

I think is a "common error" or similar.
Anyway, do you have any idea about this "safety alert"?

 

[zEitEr]

It's just a warning, if you've got no errors, while working with roundcube, ignore this warning. Other way, you can delete DB da_roundcube and directory roundcube from /var/www/html/. And re-install it again. Note in this case, you'll loose all settings of your customers, stored in DB.