[RCD] Can not save the "Display Name" and "Email Address" setting

johnw johnw at wonghome.net
Fri Oct 15 19:01:40 CEST 2010


 On Fri, 15 Oct 2010 17:56:12 +0100, Viktor Balogh wrote:
> Hi,
>
>>  but when i run SQL/mysql.upgrade.sql as root,
>>  it show the error like this:
>>
>>  root#: mysql roundcubedb < mysql.upgrade.sql
>>  ERROR 1091 (42000) at line 7: Can't DROP 'idx'; check that 
>> column/key
>>  exists
>>
>>  What shall i do now?
>
> I've ran into the same error just like you. You shouldn't import the
> whole contents of the mysql.update.sql file, but only the sections 
> which
> are relevant to you. See the comment statements in the file:
>
> # grep -e "^--"  mysql.update.sql
> -- RoundCube Webmail update script for MySQL databases
> -- Updates from version 0.1-stable
> -- Updates from version 0.1.1
> -- Updates from version 0.2-alpha
> -- Updates from version 0.2-beta (InnoDB required)
> -- Updates from version 0.3-stable
> -- Updates from version 0.3.1
> -- Updates from version 0.4-beta
> #
>
> Regards,
> Viktor

 Yes, i cut down the upgrade script to only have 0.4-beta to below.
 i can run the mysql.upgrade.sql script now. no any error.

 but i still can not save the "Display Name", and the error message 
 still like before.

_______________________________________________
List info: http://lists.roundcube.net/dev/
BT/aba52c80



More information about the Dev mailing list