[Tickets #11877] Re: ActiveSync DB Schema Update Error

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/11877
------------------------------------------------------------------------------
  Ticket             | 11877
  Updated By         | nimm at technikum-wien.at
  Summary            | ActiveSync DB Schema Update Error
  Queue              | Synchronization
  Version            | Git master
  Type               | Bug
  State              | Feedback
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             | Michael Rubinsky
------------------------------------------------------------------------------


nimm at technikum-wien.at (2012-12-13 15:51) wrote:

> I can't reproduce this. The migration works fine here on MySQL. Can  
> you try the following on the MySQL command line and post the results?
>
> DESCRIBE horde_activesync_mailmap;
>

Hi!
following output:
mysql> DESCRIBE horde_activesync_mailmap;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| message_uid   | varchar(255) | NO   | MUL |         |       |
| sync_key      | varchar(255) | NO   |     |         |       |
| sync_devid    | varchar(255) | NO   | MUL |         |       |
| sync_folderid | varchar(255) | NO   | MUL |         |       |
| sync_user     | varchar(255) | YES  |     | NULL    |       |
| sync_read     | tinyint(1)   | YES  |     | NULL    |       |
| sync_deleted  | tinyint(1)   | YES  |     | NULL    |       |
| sync_flagged  | tinyint(1)   | YES  |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)

The problem ist the default ''
when i manually enter
  ALTER TABLE `horde_activesync_mailmap` CHANGE `message_uid`  
`message_uid` int(11);

it works and the new table looks likemysql> DESCRIBE horde_activesync_mailmap;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| message_uid   | int(11)      | YES  | MUL | NULL    |       |
| sync_key      | varchar(255) | NO   |     |         |       |
| sync_devid    | varchar(255) | NO   | MUL |         |       |
| sync_folderid | varchar(255) | NO   | MUL |         |       |
| sync_user     | varchar(255) | YES  |     | NULL    |       |
| sync_read     | tinyint(1)   | YES  |     | NULL    |       |
| sync_deleted  | tinyint(1)   | YES  |     | NULL    |       |
| sync_flagged  | tinyint(1)   | YES  |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
8 rows in set (0.00 sec)


Maybe the problem is a rather old MySQL Version 5.0.45, InnoDB storage  
for this table.