› VitalPBX Community Support › General Discussion › issues after upgrade
- This topic has 20 replies, 2 voices, and was last updated 2 years, 6 months ago by
gerrykernan.
- Post
-
- July 17, 2018 at 9:57 am
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
- Replies
-
- July 17, 2018 at 12:13 pm
- July 17, 2018 at 12:28 pm
- July 17, 2018 at 12:40 pm
- July 17, 2018 at 12:46 pm
- July 17, 2018 at 4:11 pm
- July 17, 2018 at 4:16 pm
[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 00- July 17, 2018 at 4:29 pm
- July 17, 2018 at 4:30 pm
- July 17, 2018 at 5:09 pm
- July 17, 2018 at 5:15 pm
- July 17, 2018 at 5:17 pm
- July 17, 2018 at 5:28 pm
- July 17, 2018 at 5:55 pm
- July 17, 2018 at 7:31 pm
- July 17, 2018 at 8:14 pm
- You must be logged in to reply to this topic.