› VitalPBX Community Support › General Discussion › MIgration from Ombutel to VitalPBX database error
- This topic has 16 replies, 4 voices, and was last updated 1 year, 11 months ago by
Ofloo.
- Post
-
- August 22, 2018 at 6:35 pm
I am migrating an Ombutel to VitalPBX using the script on this page
wget https://raw.githubusercontent.com/VitalPBX/OmbutelMigration/master/ombutel-to-vpbx.sh chmod +x ombutel-to-vpbx.sh ./ombutel-to-vpbx.sh
After running my web page shows this errorFatal error: Uncaught exception ‘Exception’ with message ‘SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘ombutel.ombu_role_permissions’ doesn’t exist With Query: select `allowed` from `ombu_role_permissions` where `role_id` = ? and `permission` = ?’ 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/role.php(0): ombuteldb::query() #3 /usr/share/ombutel/www/themes/vital_pbx/topBar.php(0): ombutelrole->has_permission_for() #4 /usr/share/ombutel/www/themes/vital_pbx/topBar.php(0): themesvital_pbxtopBar->_buildVerticalMenu() #5 /usr/share/ombutel/www/themes/vital_pbx/vital_pbx.php(0): themesvital_pbxtopBar->render() #6 /usr/share/ombutel/www/themes/page.php(0): themesvital_pbxvital_pbx->render() #7 /usr/share/ombutel/www/themes/page.php(0): themespage->_buildBody() #8 /usr/share/ombutel/www/includes/app in /usr/share/ombutel/www/includes/db.php on line 0
So then I ran usr/share/ombutel/php scripts/apply_patches with the following result
php scripts/apply_patches
Importing 20170330.2.directdial_feature_codes.sql…
PHP Fatal error: Uncaught exception ‘Exception’ with message ‘ERROR 1062 (23000) at line 5: Duplicate entry ‘direct_toggle_cfi’ for key ‘feature_name’
‘ in /usr/share/ombutel/scripts/apply_patches:0
Stack trace:
#0 /usr/share/ombutel/scripts/apply_patches(0): patcher::shellcmd()
#1 /usr/share/ombutel/scripts/apply_patches(0): patcher->shellcmd()
#2 /usr/share/ombutel/scripts/apply_patches(0): patcher->import_dbscript()
#3 /usr/share/ombutel/scripts/apply_patches(0): patcher->apply()
#4 {main}
thrown in /usr/share/ombutel/scripts/apply_patches on line 0Can you help me please
Thank you
0
- Replies
-
- August 22, 2018 at 7:18 pm
- August 22, 2018 at 8:18 pm
- August 22, 2018 at 8:20 pm
- August 22, 2018 at 8:48 pm
- August 22, 2018 at 9:00 pm
- August 22, 2018 at 9:22 pm
That worked but when I run the patch I get this now
Importing 20170710.pin-lists.sql…
PHP Fatal error: Uncaught exception ‘Exception’ with message ‘ERROR 1050 (42S01) at line 2: Table ‘ombu_pin_list_entries’ already exists
‘ in /usr/share/ombutel/scripts/apply_patches:0
Stack trace:
#0 /usr/share/ombutel/scripts/apply_patches(0): patcher::shellcmd()
#1 /usr/share/ombutel/scripts/apply_patches(0): patcher->shellcmd()
#2 /usr/share/ombutel/scripts/apply_patches(0): patcher->import_dbscript()
#3 /usr/share/ombutel/scripts/apply_patches(0): patcher->apply()
#4 {main}
thrown in /usr/share/ombutel/scripts/apply_patches on line 00- August 22, 2018 at 9:26 pm
Looks like the ombu_patches table is corrupted. You must to cotinue doing the same process for messages like this:
Importing 20170710.pin-lists.sql...
PHP Fatal error: Uncaught exception 'Exception' with message 'ERROR 1050 (42S01) at line 2: Table 'ombu_pin_list_entries' already exists
' in /usr/share/ombutel/scripts/apply_patches:0mysql -uroot ombutel -e"insert into ombu_patches(filename) values ('20170710.pin-lists.sql')"
0- August 22, 2018 at 10:02 pm
- August 24, 2018 at 2:02 pm
after that I get:
Executing 20180625.5.migrate_destinations.php…
PHP Fatal error: Uncaught exception ‘Exception’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ’48f2e5306f01fb3b35c3f869d023f646.mod_dest’ in ‘field list’ With Query: select `48f2e5306f01fb3b35c3f869d023f646`.`queue_id` as `queue_id`,`48f2e5306f01fb3b35c3f869d023f646`.`extension` as `extension`,`48f2e5306f01fb3b35c3f869d023f646`.`queue_vip_list_id` as `queue_vip_list_id`,`48f2e5306f01fb3b35c3f869d023f646`.`ivr_id` as `ivr_id`,`48f2e5306f01fb3b35c3f869d023f646`.`cron_profile_id` as `cron_profile_id`,`48f2e5306f01fb3b35c3f869d023f646`.`description` as `description`,`48f2e5306f01fb3b35c3f869d023f646`.`prefix` as `prefix`,`48f2e5306f01fb3b35c3f869d023f646`.`mod_dest` as `mod_dest`,`48f2e5306f01fb3b35c3f869d023f646`.`destination` as `destination`,`48f2e5306f01fb3b35c3f869d023f646`.`mod_hangup_dest` as `mod_hangup_dest`,`48f2e5306f01fb3b35c3f869d023f646`.`hangup_dest` as `hangup_dest`,`48f2e5306f01fb3b35c3f869d023f646`.`strategy` as `strategy`,`48f2e5306f01fb3b35c3f869d023f646`.`music_group_id` as `music_group in /usr/share/ombutel/www/includes/db.php on line 0
[root@voip09-dierick scripts]#0- August 24, 2018 at 2:55 pm
- October 1, 2018 at 7:48 am
[root@voip01 ~]# rm -rf /var/cache/yum
[root@voip01 ~]# yum reinstall vitalpbx
Loaded plugins: auto-update-debuginfo, fastestmirror
No Match for argument: vitalpbx
LowayResearch | 951 B 00:00:00
base | 3.6 kB 00:00:00
base-debuginfo | 2.5 kB 00:00:00
epel/x86_64/metalink | 25 kB 00:00:00
epel | 3.2 kB 00:00:00
epel-debuginfo/x86_64/metalink | 29 kB 00:00:00
epel-debuginfo | 1.5 kB 00:00:00
extras | 3.4 kB 00:00:00
treasuredata | 2.9 kB 00:00:00
updates | 3.4 kB 00:00:00
(1/10): base/7/x86_64/group_gz | 166 kB 00:00:00
(2/10): epel/x86_64/group_gz | 88 kB 00:00:00
(3/10): epel/x86_64/primary | 3.6 MB 00:00:00
(4/10): base-debuginfo/x86_64/primary_db | 2.3 MB 00:00:00
(5/10): extras/7/x86_64/primary_db | 187 kB 00:00:00
(6/10): base/7/x86_64/primary_db | 5.9 MB 00:00:00
(7/10): epel/x86_64/updateinfo | 945 kB 00:00:00
(8/10): treasuredata/7/x86_64/primary_db | 44 kB 00:00:00
(9/10): epel-debuginfo/x86_64/primary | 510 kB 00:00:00
(10/10): updates/7/x86_64/primary_db | 6.0 MB 00:00:00
LowayResearch/primary | 8.6 kB 00:00:00
Determining fastest mirrors
* base: ams.edge.kernel.org
* epel: mirror.nl.leaseweb.net
* epel-debuginfo: mirror.nl.leaseweb.net
* extras: centos.mirror.transip.nl
* updates: centos.mirror.transip.nl
LowayResearch 52/52
epel 12695/12695
epel-debuginfo 2822/2822
Error: Nothing to dogot this when trying to reinstall… the installation doesn’t work now…
0- October 1, 2018 at 7:52 am
and when executing the script again
Installed size: 7.1 M
Downloading packages:
(1/2): vitalpbx-sounds-es-2.0.5-5.x86_64.rpm | 3.0 MB 00:00:01
(2/2): vitalpbx-sounds-2.0.5-5.x86_64.rpm | 3.0 MB 00:00:01
————————————————————————————————————————————————————————
Total 4.9 MB/s | 6.0 MB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : vitalpbx-sounds-2.0.5-5.x86_64 1/2
Installing : vitalpbx-sounds-es-2.0.5-5.x86_64 2/2
Verifying : vitalpbx-sounds-es-2.0.5-5.x86_64 1/2
Verifying : vitalpbx-sounds-2.0.5-5.x86_64 2/2Installed:
vitalpbx-sounds.x86_64 0:2.0.5-5 vitalpbx-sounds-es.x86_64 0:2.0.5-5Complete!
Loaded plugins: auto-update-debuginfo, fastestmirror
Cleaning repos: LowayResearch base epel extras treasuredata updates
Cleaning up everything
Maybe you want: rm -rf /var/cache/yum, to also free up space taken by orphaned data from disabled or removed repos
Cleaning up list of fastest mirrors
Welcome to VitalPBX!
/bin/bash: /etc/profile.d/vitalwelcome.sh: No such file or directory
[root@voip01 ~]#and no
0- October 1, 2018 at 8:01 am
[root@voip01 ~]# yum reinstall vitalpbx
Loaded plugins: auto-update-debuginfo, fastestmirror
No Match for argument: vitalpbx
Loading mirror speeds from cached hostfile
* base: mirrors.supportex.net
* epel: http://ftp.nluug.nl
* epel-debuginfo: http://ftp.nluug.nl
* extras: http://ftp.nluug.nl
* updates: http://ftp.nluug.nl
Error: Nothing to do
[root@voip01 ~]#0- January 24, 2019 at 7:00 am
I’ve been trying to upgrade now for a while but this is what the upgrade always resolves into
Fatal error: Uncaught exception 'Exception' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ombutel.ombu_role_permissions' doesn't exist With Query: select `allowed` from `ombu_role_permissions` where `role_id` = ? and `permission` = ?' 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/role.php(0): ombuteldb::query() #3 /usr/share/ombutel/www/themes/vital_pbx/topBar.php(0): ombutelrole->has_permission_for() #4 /usr/share/ombutel/www/themes/vital_pbx/topBar.php(0): themesvital_pbxtopBar->_buildVerticalMenu() #5 /usr/share/ombutel/www/themes/vital_pbx/vital_pbx.php(0): themesvital_pbxtopBar->render() #6 /usr/share/ombutel/www/themes/page.php(0): themesvital_pbxvital_pbx->render() #7 /usr/share/ombutel/www/themes/page.php(0): themespage->_buildBody() #8 /usr/share/ombutel/www/includes/app in /usr/share/ombutel/www/includes/db.php on line 00
- You must be logged in to reply to this topic.