Just upgraded FreePBX 12 to 13
All is working fine.
Trying to install Dynamic Routes ( 13.0.3 ) module I get this error :
SQLSTATE[42000]: Syntax error or access violation: 1068 Multiple primary key defined
/var/www/html/admin/modules/dynroute/Dynroute.class.php
."TABLE_CATALOG
= ‘def’ AND TABLE_SCHEMA
= DATABASE() AND “
.”TABLE_NAME
= ‘$table’ AND INDEX_NAME
= ‘PRIMARY’ ";
$results = sql($sql, “getAll”,DB_FETCHMODE_ASSOC);
if (empty($results)) {
$sql = “ALTER TABLE $table
ADD PRIMARY KEY (dynroute_id
,selection
);”;
$sth = $this->db->prepare($sql);
$sth->execute();
}
} catch(PDOException $e) {
Any hint please ??