Help with apply_patches

› VitalPBX Community Support › General Discussion › Help with apply_patches

  • Post
    • March 18, 2020 at 3:11 pm
    Gary
    Participant

    I am trying to update a old Ombutel (180 phones & stable) to Vitalpbx, it’s on proxmox so I created a backup and then a new vm so current system is safe, when I apply_patches I get the following error but I don’t see a file name to insert manually ?

    [root@ombutel ~]# /usr/share/ombutel/scripts/apply_patches
    Executing 20180412.1.queue_agents_context.php…
    PHP Fatal error: Uncaught exception ‘Exception’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘tenant_id’ in ‘where claus e’ With Query: select `6bc3d6ed7a4295a522270cc381297148`.`extension_id` as `extension_id`,`6bc3d6ed7a4295a522270cc381297148`.`extension` as `exte nsion`,`6bc3d6ed7a4295a522270cc381297148`.`name` as `name`,`6bc3d6ed7a4295a522270cc381297148`.`language` as `language`,`6bc3d6ed7a4295a522270cc38 1297148`.`email` as `email`,`6bc3d6ed7a4295a522270cc381297148`.`class_of_service_id` as `class_of_service_id`,`6bc3d6ed7a4295a522270cc381297148`. `dial_profile_id` as `dial_profile_id`,`6bc3d6ed7a4295a522270cc381297148`.`call_limit` as `call_limit`,`6bc3d6ed7a4295a522270cc381297148`.`intern al_cid` as `internal_cid`,`6bc3d6ed7a4295a522270cc381297148`.`external_cid` as `external_cid`,`6bc3d6ed7a4295a522270cc381297148`.`ringtime` as `r ingtime`,`6bc3d6ed7a4295a522270cc381297148`.`nospy` as `nospy`,`6bc3d6ed7a4295a522270cc381297148`.`enabled_pa` as `enabled_pa`,`6bc3d6ed7a4295a52 2270cc381297148`.`answermod in /usr/share/ombutel/www/includes/db.php on line 0
    [root@ombutel ~]#

    0
Viewing 5 replies - 1 through 5 (of 5 total)
  • Replies
    • March 18, 2020 at 3:38 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    What I recommend you is to upgrade gradually, I mean, update to a specific version of VitalPBX, then, to another, and another, until the latest.

    0
    • March 18, 2020 at 3:46 pm
    Gary
    Participant
    Up
    0
    Down

    How would I do that, i am using

    ./ombutel-to-vpbx.sh

    0
    • March 18, 2020 at 4:30 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    We just update the migration script to update to a specific version, and, then, make an update to the latest version.

    Please, try it, and let me know if you were able to perform the upgrade.

    0
    • March 18, 2020 at 6:09 pm
    Gary
    Participant
    Up
    0
    Down

    The new script takes a long time to complete 1hr 15min so you need to be patient, it has mostly worked only the gui shows no current info.

    Version : 2.4.0-6
    Asterisk : Asterisk 16.6.2
    Linux Version : CentOS Linux release 7.7.1908 (Core)
    Welcome to : ombutel.local
    Uptime : 2 min
    Load : Last Minute: 0.29, Last 5 Minutes: 0.31, Last 15 Minutes: 0.13
    Users : 1 user,
    IP Address : 192.168.99.192
    Clock : Wed 2020-03-18 13:59:31 EDT
    NTP Sync. : yes

    [root@ombutel ~]# /usr/share/ombutel/scripts/apply_patches
    Executing 20191108.1.tc_codes.php…
    Importing 20191111.1.paging_announcement.sql…
    Importing 20191115.1.trunk_profiles.sql…
    Importing 20191115.2.trunks_dtmf.sql…
    Importing 20191127.1.my_voicemail.sql…
    Importing 20191205.1.addons.description.sql…
    Importing 20200121.1.shared_ars.sql…
    Importing 20200125.1.dnd_quick_mode.sql…
    Importing XEPM.6.fanvil_upgrade_server.sql…
    Importing XEPM.7.GXP21XX.sql…
    [root@ombutel ~]#

     

    0
    • March 18, 2020 at 6:28 pm
    Gary
    Participant
    Up
    0
    Down

    Ajusted firewall settings and info is now on dashboard.

     

    Thanks for updating upgrade script.

    0
Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.