[horde] QUERY FAILED: Unknown column 'sync_time' in 'field list'

[Simon B]

On 23 September 2013 17:47, Michael J Rubinsky <mrubinsk at horde.org> wrote:
>
> Quoting Simon B <simon.buongiorno at gmail.com>:
>
>> Hi
>>
>> This morning I tried to change a calendar appointment to all day - but
>> also set the timezone to EST (GMT -5).  After pressing save, the
>> window froze (not the browser) and nothing was clickable.  After
>> restarting the browser I was presented with the login screen, but
>> login fails (it doesn't fail with an error, but login is also not
>> possible - it's just spinning).
>>
>> In the logs find:
>> 2013-09-23T10:34:05+00:00 ERR: HORDE-PROD [horde] Returning HTTP 500
>> while handling FolderSync command. [pid 10258 on line 156 of
>> "/usr/share/horde-prod/rpc.php"]
>> 2013-09-23T10:34:05+00:00 ERR: HORDE-PROD [horde] Error in
>> communicating with ActiveSync server: QUERY FAILED: Unknown column
>> 'sync_time' in 'field list'
>
>
>
> The sync_time column was renamed to sync_mod with one of the last few
> updates. The only way I can see you getting this error is if you ran the
> migration on your database, and then attempted to use an older version of
> the code without reverting the migration. I've grepped the code for
> sync_time and it's not any sql statements in the current code.


Thanks Michael.  I've worked out what I've done wrong :)

Simon