ran the last module update and now i cant view pjsip trunks
the gui shows this error
PDOException (42S22)
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘key’ in ‘where clause’
/var/www/html/admin/modules/core/Core.class.php
if (isset($confdetail)) {
$confdetail .= $result['keyword'] .'='. $result['data'] . "\n";
} else {
$confdetail = $result['keyword'] .'='. $result['data'] . "\n";
}
}
}
return isset($confdetail)?$confdetail:null;
}
public function getTrunkRegisterStringByID($trunkid) {
$tech = $this->getTrunkTech($trunkid);
if (!$this->trunkHasRegistrations($tech)){
return '';
}
// TODO: These should be deferred to their respective driver
if('pjsip' == $tech){
$sql = "SELECT `data` FROM pjsip WHERE `id` = :trunkid and `key` = 'registration'";
$sth = $this->database->prepare($sql);
$sth->execute(array(':trunkid' => $trunkid));
this was updated
This is an automatic notification from your FreePBX server.
Module(s) requiring upgrades: blacklist, bulkhandler, calendar,
callrecording, cel, contactmanager, core, digium_phones, framework,
infoservices, ivr, languages, motif, paging, queues, sipsettings, soundlang,
superfecta, ucp
Upgrading module ‘framework’ from 14.0.3.2 to 14.0.3.4
Module framework successfully downloaded in 4 seconds
Upgrading module ‘core’ from 14.0.12 to 14.0.18.16
Module core successfully downloaded in 6 seconds
Upgrading module ‘sipsettings’ from 14.0.27.1 to 14.0.27.2
Module sipsettings successfully downloaded in 0 seconds
Upgrading module ‘blacklist’ from 13.0.14.8 to 14.0.1
Module blacklist successfully downloaded in 1 seconds
Upgrading module ‘bulkhandler’ from 13.0.14.4 to 13.0.14.6
Module bulkhandler successfully downloaded in 0 seconds
Upgrading module ‘calendar’ from 14.0.2.4 to 14.0.2.5
Module calendar successfully downloaded in 1 seconds
Upgrading module ‘callrecording’ from 13.0.11.5 to 14.0.1
Module callrecording successfully downloaded in 1 seconds
Upgrading module ‘cel’ from 14.0.2.4 to 14.0.2.6
Module cel successfully downloaded in 0 seconds
Upgrading module ‘contactmanager’ from 14.0.3.5 to 14.0.4.5
Module contactmanager successfully downloaded in 2 seconds
Upgrading module ‘digium_phones’ from 13.0.7.3 to 13.0.7.4
Module digium_phones successfully downloaded in 1 seconds
Upgrading module ‘infoservices’ from 13.0.1.2 to 13.0.1.3
Module infoservices successfully downloaded in 1 seconds
Upgrading module ‘ivr’ from 13.0.27.7 to 14.0.1
Module ivr successfully downloaded in 1 seconds
Upgrading module ‘languages’ from 13.0.6 to 14.0.1.2
Module languages successfully downloaded in 0 seconds
Upgrading module ‘motif’ from 13.0.3.2 to 13.0.4
Module motif successfully downloaded in 0 seconds
Upgrading module ‘paging’ from 14.0.3 to 14.0.4
Module paging successfully downloaded in 0 seconds
Upgrading module ‘queues’ from 14.0.2.15 to 14.0.2.16
Module queues successfully downloaded in 1 seconds
Upgrading module ‘soundlang’ from 14.0.4.3 to 14.0.4.5
Module soundlang successfully downloaded in 1 seconds
Upgrading module ‘superfecta’ from 14.0.6 to 14.0.7
Module superfecta successfully downloaded in 1 seconds
Upgrading module ‘ucp’ from 14.0.2.3 to 14.0.2.6
Module ucp successfully downloaded in 2 seconds
All upgrades completed successfully!