[horde] Enable ActiveSync doesn't generate table

[Eric]

------ Message d'origine ------
De: "Jan Schneider" <jan at horde.org>
À: horde at lists.horde.org
Envoyé 09/07/2014 12:10:04
Objet: Re: [horde] Enable ActiveSync doesn't generate table
>
>
>Zitat von Eric <eric at fayolle.info>:
>
>>Hello,
>>
>>Hope it'll be the good way to have information.
>>I've try to activate ActiveSync, but when I generate the conf it 
>>doesn't add table to the database.
>
>"Activating", whatever that means, doesn't create tables.
>
>>So I've try to make a horde-db--migrate and I've an error:
>>SQLSTATE[42000]: Syntax error or access violation: 1064
>
>What's the complete error?
>
>>So I've add and configure a database just for ActiveSync and I get the 
>>same problem.
>>
>>Did I do something wrong ?
>>
>>Thanks - Eric
>
>
>
>-- Jan Schneider
>The Horde Project
>http://www.horde.org/
>https://www.facebook.com/hordeproject
>
>-- Horde mailing list
>Frequently Asked Questions: http://horde.org/faq/
>To unsubscribe, mail: horde-unsubscribe at lists.horde.org


Hi Jan,

Thanks for the answer, here's the full message error that I've when I go 
to Administration -> activeSync Devices:
A fatal error has occurredSQLSTATE[42S02]: Base table or view not found: 
1146 Table 'horde.horde_activesync_device' doesn't exist
1. Horde_ActiveSync_State_Sql->listDevices() 
/home/fayolleinfo/sd/webmail/www/admin/activesync.php:74 2. 
Horde_ActiveSync_State_Sql->listDevices() 
/home/fayolleinfo/sd/webmail/www/admin/activesync.php:74 3. 
Horde_Db_Adapter_Pdo_Base->selectAll() 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/ActiveSync/State/Sql.php:738 
4. Horde_Db_Adapter_Pdo_Base->execute() 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/Db/Adapter/Pdo/Base.php:109 
5. Horde_ActiveSync_State_Sql->listDevices() 
/home/fayolleinfo/sd/webmail/www/admin/activesync.php:74 6. 
Horde_Db_Adapter_Pdo_Base->selectAll() 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/ActiveSync/State/Sql.php:738 
7. Horde_Db_Adapter_Pdo_Base->execute() 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/Db/Adapter/Pdo/Base.php:109 
8. PDO->query() 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/Db/Adapter/Pdo/Base.php:201
DetailsThe 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 ( [details] => [logged] => 1 
[_logLevel:protected] => 0 [message:protected] => SQLSTATE[42S02]: Base 
table or view not found: 1146 Table 'horde.horde_activesync_device' 
doesn't exist [string:Exception:private] => [code:protected] => 42 
[file:protected] => 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/ActiveSync/State/Sql.php 
[line:protected] => 740 [trace:Exception:private] => Array ( [0] => 
Array ( [file] => /home/fayolleinfo/sd/webmail/www/admin/activesync.php 
[line] => 74 [function] => listDevices [class] => 
Horde_ActiveSync_State_Sql [type] => -> [args] => Array ( [0] => [1] => 
Array ( [] => ) ) ) ) [previous:Exception:private] => Horde_Db_Exception 
Object ( [details] => [logged] => [_logLevel:protected] => 0 
[message:protected] => SQLSTATE[42S02]: Base table or view not found: 
1146 Table 'horde.horde_activesync_device' doesn't exist 
[string:Exception:private] => [code:protected] => 42 [file:protected] => 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/Db/Adapter/Pdo/Base.php 
[line:protected] => 205 [trace:Exception:private] => Array ( [0] => 
Array ( [file] => 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/Db/Adapter/Pdo/Base.php 
[line] => 109 [function] => execute [class] => Horde_Db_Adapter_Pdo_Base 
[type] => -> [args] => Array ( [0] => SELECT d.device_id AS device_id, 
device_type, device_agent, device_policykey, device_rwstatus, 
device_user, device_properties 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] => 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/ActiveSync/State/Sql.php 
[line] => 738 [function] => selectAll [class] => 
Horde_Db_Adapter_Pdo_Base [type] => -> [args] => Array ( [0] => SELECT 
d.device_id AS device_id, device_type, device_agent, device_policykey, 
device_rwstatus, device_user, device_properties FROM 
horde_activesync_device d INNER JOIN horde_activesync_device_users u ON 
d.device_id = u.device_id [1] => Array ( ) ) ) [2] => Array ( [file] => 
/home/fayolleinfo/sd/webmail/www/admin/activesync.php [line] => 74 
[function] => listDevices [class] => Horde_ActiveSync_State_Sql [type] 
=> -> [args] => Array ( [0] => [1] => Array ( [] => ) ) ) ) 
[previous:Exception:private] => PDOException Object ( 
[message:protected] => SQLSTATE[42S02]: Base table or view not found: 
1146 Table 'horde.horde_activesync_device' doesn't exist 
[string:Exception:private] => [code:protected] => 42S02 [file:protected] 
=> 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/Db/Adapter/Pdo/Base.php 
[line:protected] => 201 [trace:Exception:private] => Array ( [0] => 
Array ( [file] => 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/Db/Adapter/Pdo/Base.php 
[line] => 201 [function] => query [class] => PDO [type] => -> [args] => 
Array ( [0] => SELECT d.device_id AS device_id, device_type, 
device_agent, device_policykey, device_rwstatus, device_user, 
device_properties FROM horde_activesync_device d INNER JOIN 
horde_activesync_device_users u ON d.device_id = u.device_id ) ) [1] => 
Array ( [file] => 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/Db/Adapter/Pdo/Base.php 
[line] => 109 [function] => execute [class] => Horde_Db_Adapter_Pdo_Base 
[type] => -> [args] => Array ( [0] => SELECT d.device_id AS device_id, 
device_type, device_agent, device_policykey, device_rwstatus, 
device_user, device_properties FROM horde_activesync_device d INNER JOIN 
horde_activesync_device_users u ON d.device_id = u.device_id [1] => 
Array ( ) [2] => ) ) [2] => Array ( [file] => 
/home/fayolleinfo/sd/webmail/www/pear/php/Horde/ActiveSync/State/Sql.php 
[line] => 738 [function] => selectAll [class] => 
Horde_Db_Adapter_Pdo_Base [type] => -> [args] => Array ( [0] => SELECT 
d.device_id AS device_id, device_type, device_agent, device_policykey, 
device_rwstatus, device_user, device_properties FROM 
horde_activesync_device d INNER JOIN horde_activesync_device_users u ON 
d.device_id = u.device_id [1] => Array ( ) ) ) [3] => Array ( [file] => 
/home/fayolleinfo/sd/webmail/www/admin/activesync.php [line] => 74 
[function] => listDevices [class] => Horde_ActiveSync_State_Sql [type] 
=> -> [args] => Array ( [0] => [1] => Array ( [] => ) ) ) ) 
[previous:Exception:private] => [errorInfo] => Array ( [0] => 42S02 [1] 
=> 1146 [2] => Table 'horde.horde_activesync_device' doesn't exist

>Thanks - Eric