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

[Michael J Rubinsky]

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.

-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5849 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/horde/attachments/20130923/0282c177/attachment-0001.bin>