issues after upgrade

› VitalPBX Community Support › General Discussion › issues after upgrade

  • Post
    • July 17, 2018 at 9:57 am
    gerrykernan
    Participant

    hi

    ive run in to some issue when i updated to lastest version,

    after the update all my inbound route where gone and in IVR’s , entries are missing , when i try and update teh IVR config i get the errors below

     

     

    Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘5e9fd4dce07ec548f7ec66e66264d4aa.’ in ‘where clause’ With Query: select `5e9fd4dce07ec548f7ec66e66264d4aa`.`ivr_id` as `ivr_id`,`5e9fd4dce07ec548f7ec66e66264d4aa`.`option` as `option`,`5e9fd4dce07ec548f7ec66e66264d4aa`.`destination_id` as `destination_id`,`5e9fd4dce07ec548f7ec66e66264d4aa`.`enabled` as `enabled`,`5e9fd4dce07ec548f7ec66e66264d4aa`.`sort` as `sort` from `ombutel`.`ombu_ivr_entries` as `5e9fd4dce07ec548f7ec66e66264d4aa` where `5e9fd4dce07ec548f7ec66e66264d4aa`.“ = ? at file /usr/share/ombutel/www/includes/db.php on line 0

     

    Error Trace

    # File Function
    1 /usr/share/ombutel/www/index.php:0 appCore->run(…args);
    2 /usr/share/ombutel/www/includes/app/Core.php:0 appCore->_loadModule(…args);
    3 /usr/share/ombutel/www/includes/app/Core.php:0 appCore->loadModuleAction(…args);
    4 /usr/share/ombutel/www/includes/app/Core.php:0 modulesivrivr->put(…args);
    5 /usr/share/ombutel/www/modules/ivr/ivr.php:0 ombutelivr->save(…args);
    6 /usr/share/ombutel/www/includes/ivr.php:0 ombutelivr->_addEntries(…args);
    7 /usr/share/ombutel/www/includes/ivr.php:0 modulesivrivr_entry->__construct(…args);
    8 /usr/share/ombutel/www/includes/persistent.php:0 ombuteldb->query_into(…args);
    9 /usr/share/ombutel/www/includes/db.php:0 ombuteldb->__construct(…args);
    10 /usr/share/ombutel/www/includes/db.php:0 ombuteldb->__construct(…args);
    0
Viewing 15 replies - 1 through 15 (of 20 total)
1 2
  • Replies
    • July 17, 2018 at 12:13 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    We will try to reproduce the issue.

    Do you have a backup of your system?

    0
    • July 17, 2018 at 12:28 pm
    gerrykernan
    Participant
    Up
    0
    Down

    hi

    i had a backup of extensions.conf . so pbx is accepting calls. but i cant do any updates via GUI as it will over write the exenensions conf files.

     

    gerry

    0
    • July 17, 2018 at 12:40 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    I meant a system back up generated by the back module of VitalPBX

    0
    • July 17, 2018 at 12:46 pm
    gerrykernan
    Participant
    Up
    0
    Down

    no , i only had backup of the conf files.

     

    gerry

    0
    • July 17, 2018 at 4:11 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Try to execute the following command: 

    php /usr/share/ombutel/scripts/apply_patches

     

    Post any output generated by the script.

    0
    • July 17, 2018 at 4:16 pm
    gerrykernan
    Participant
    Up
    0
    Down

    [root@localhost ~]# php /usr/share/ombutel/scripts/apply_patches
    Executing 20180625.5.migrate_destinations.php…
    PHP Fatal error: Uncaught exception ‘Exception’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘700’ for key ‘number’ With Query: insert into `ombutel`.`ombu_numbers` (`module_id`,`number`) values (?,?)’ in /usr/share/ombutel/www/includes/db.php:0
    Stack trace:
    #0 /usr/share/ombutel/www/includes/db.php(0): ombuteldb::__construct()
    #1 /usr/share/ombutel/www/includes/db.php(0): ombuteldb->__construct()
    #2 /usr/share/ombutel/www/includes/persistent.php(0): ombuteldb::query()
    #3 /usr/share/ombutel/www/includes/persistent.php(0): ombutelnumber->insert()
    #4 /usr/share/ombutel/www/includes/number.php(0): ombutelnumber->save()
    #5 /usr/share/ombutel/www/includes/parking_lot.php(0): ombutelnumber::register_range()
    #6 /usr/share/ombutel/www/modules/parking/parking.php(0): ombutelparking_lot->save()
    #7 /usr/share/ombutel/patches/20180625.5.migrate_destinations.php(0): modulesparkingparking::migrateDestinations(false)
    #8 /usr/share/ombutel/scripts/apply_patches(0): unknown()
    #9 /usr/share/ombut in /usr/share/ombutel/www/includes/db.php on line 0

    0
    • July 17, 2018 at 4:29 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    We will check it, don’t worry we will make an update to fix any issue reported by the community

    0
    • July 17, 2018 at 4:30 pm
    gerrykernan
    Participant
    Up
    0
    Down

    cheers,  much appreciated

    0
    • July 17, 2018 at 5:09 pm
    gerrykernan
    Participant
    Up
    0
    Down

    hi

    is custom contexts module gone after update as well?

     

    gerry

    0
    • July 17, 2018 at 5:15 pm
    gerrykernan
    Participant
    Up
    0
    Down

    its ok found customs context . had to re-install it

     

    gerry

    0
    • July 17, 2018 at 5:17 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Update the custom context add-on to the latest version, you can do it from the GUI or from the Linux console

    0
    • July 17, 2018 at 5:28 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    Please update the VitalPBX to the latest version (2.0.4-2), let me know if that fix the issue.

    0
    • July 17, 2018 at 5:55 pm
    gerrykernan
    Participant
    Up
    0
    Down

    custom context are ok , thanks

    0
    • July 17, 2018 at 7:31 pm
    Jose Miguel Rivera
    Keymaster
    NI
    Up
    0
    Down

    did you update vitalpbx to latest version(2.0.4-2)?

    0
    • July 17, 2018 at 8:14 pm
    gerrykernan
    Participant
    Up
    0
    Down

    hi

    tried via yum and the gui and its not finding any updates for vitalpbx

     

    Gerry

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