Opened 4 years ago

Closed 4 years ago

#1486595 closed Bugs (invalid)

address book broken

Reported by: ex_sqm Owned by:
Priority: 5 Milestone: 0.4-beta
Component: Addressbook Version: git-master
Severity: critical Keywords: address book
Cc:

Description

since r325, I cannot use the address book anymore. I get a 500 saying "SERVICE CURRENTLY NOT AVAILABLE!" Apache's error log shows:

File does not exist: /path/to/roundcubemail/skins/default/.css, referer: https://webmail.example.com/?_task=addressbook

Change History (6)

comment:1 Changed 4 years ago by ex_sqm

[a61bbb24] of course, sorry for the typo.

comment:2 Changed 4 years ago by alec

  • Milestone changed from later to 0.4-beta

Did you update your database structure?

comment:3 Changed 4 years ago by ex_sqm

Oh, no. I must have missed that. All I do for the last couple of months is an "svn up" :-)

Where do I find instructions for updating the db?

comment:4 Changed 4 years ago by alec

  • Resolution set to invalid
  • Status changed from new to closed

in UPGRADING file ;)

comment:5 Changed 4 years ago by ex_sqm

  • Resolution invalid deleted
  • Status changed from closed to reopened

Sorr for reopening/bugging you, but:

mysql roundcubemail < SQL/mysql.update.sql

gives me

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

That is in mysql.update.sql:

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

mysql says:

mysql> show keys in messages ;
+----------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table    | Non_unique | Key_name      | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+----------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| messages |          0 | PRIMARY       |            1 | message_id  | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| messages |          0 | uniqueness    |            1 | user_id     | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| messages |          0 | uniqueness    |            2 | cache_key   | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| messages |          0 | uniqueness    |            3 | uid         | A         |           0 |     NULL | NULL   |      | BTREE      |         |
| messages |          1 | created_index |            1 | created     | A         |           0 |     NULL | NULL   |      | BTREE      |         |
+----------+------------+---------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
5 rows in set (0,00 sec)

mysql>

I'm a little bit stuck here :-(

comment:6 Changed 4 years ago by alec

  • Resolution set to invalid
  • Status changed from reopened to closed

Don't execute the whole file. Just read comments inside.

Note: See TracTickets for help on using tickets.