[Tickets #10346] Syntax error in Horde_ActiveSync_State_History->listDevices()

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/10346
------------------------------------------------------------------------------
  Ticket           | 10346
  Erstellt Von     | botner at univention.de
  Zusammenfassung  | Syntax error in
                   | Horde_ActiveSync_State_History->listDevices()
  Warteschlange    | Horde Framework Packages
  Version          | Git master
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 1. Low
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


botner at univention.de (2011-07-15 12:56) hat geschrieben:

    * logged in as a admin user on the horde webclient
    * clicked on "Administration" -> "ActiveSync Devices"

Then i got the following error message:

A fatal error has occurred
SQLSTATE[42601]: Syntax error: 7 FEHLER: Syntaxfehler bei »device_id«  
LINE 1: SELECT d.device_id device_id, device_type, device_agent,  
dev... ^

1. Horde_ActiveSync_State_History->listDevices()  
/usr/share/horde4/admin/activesync.php:58

Details
The full error message is logged in Horde's log file, and is shown  
below only to administrators. Non-administrative users will not see  
error details.

Horde_ActiveSync_Exception Object
(
     [_previous:private] => Horde_Db_Exception Object
         (
             [_previous:private] =>
             [details] =>
             [message:protected] => SQLSTATE[42601]: Syntax error: 7  
FEHLER:  Syntaxfehler bei »device_id«
LINE 1: SELECT d.device_id device_id, device_type, device_agent, dev...
                            ^
             [string:private] =>
             [code:protected] => 42601
             [file:protected] => /usr/share/php/Horde/Db/Adapter/Base.php
             [line:protected] => 556
             [trace:private] => Array
                 (
                     [0] => Array
                         (
                             [file] =>  
/usr/share/php/Horde/Db/Adapter/Pdo/Base.php
                             [line] => 83
                             [function] => execute
                             [class] => Horde_Db_Adapter_Base
                             [type] => ->
                             [args] => Array
                                 (
                                     [0] => SELECT d.device_id  
device_id, device_type, device_agent, device_policykey,  
device_rwstatus, device_user FROM horde_activesync_device d INNER JOIN  
horde_activesync_device_users u ON d.device_id = u.device_id
                                     [1] => Array
                                         (
                                         )

                                     [2] =>
                                 )

                         )

                     [1] => Array
                         (
                             [file] =>  
/usr/share/php/Horde/ActiveSync/State/History.php
                             [line] => 561
                             [function] => selectAll
                             [class] => Horde_Db_Adapter_Pdo_Base
                             [type] => ->
                             [args] => Array
                                 (
                                     [0] => SELECT d.device_id  
device_id, device_type, device_agent, device_policykey,  
device_rwstatus, device_user FROM horde_activesync_device d INNER JOIN  
horde_activesync_device_users u ON d.device_id = u.device_id
                                     [1] => Array
                                         (
                                         )

                                 )

                         )

                     [2] => Array
                         (
                             [file] => /usr/share/horde4/admin/activesync.php
                             [line] => 58
                             [function] => listDevices
                             [class] => Horde_ActiveSync_State_History
                             [type] => ->
                             [args] => Array
                                 (
                                 )

                         )

                 )

         )

     [details] =>
     [message:protected] => SQLSTATE[42601]: Syntax error: 7 FEHLER:   
Syntaxfehler bei »device_id«
LINE 1: SELECT d.device_id device_id, device_type, device_agent, dev...
                            ^
     [string:private] =>
     [code:protected] => 42601
     [file:protected] => /usr/share/php/Horde/ActiveSync/State/History.php
     [line:protected] => 563
     [trace:private] => Array
         (
             [0] => Array
                 (
                     [file] => /usr/share/horde4/admin/activesync.php
                     [line] => 58
                     [function] => listDevices
                     [class] => Horde_ActiveSync_State_History
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )

         )

)