2.5.1 IVR Local install problems

FreePBX Installation / Upgrade
1

I recently installed ver.2.5.1.5. The module admin is telling me that IVR is not installed and it is available locally. When I try to install I get the following error:

ALTER TABLE ivr CHANGE COLUMN announcement announcement VARCHAR ( 255 ) [nativecode=1054 ** Unknown column ‘announcement’ in ‘ivr’]

I am not sure what is going on here. I cannot find anything information on this problem. Any tips or suggestions would be greatly appreciated.

Thanks

2

I am having the exact same problem… please let me know if you find a solution to this problem!

Thanks,
Dan

3

Just ran into this. I’m testing a reinstall of freepbx 2.6.0 onto an existing trixbox install. (after removing the var/www/html/admin directory contents first)

Fixed by adding the column to the IVR table manually in mysql, and then re-installing IVR module.

In mysql:

use asterisk;
ALTER table ivr add column announcement VARCHAR (255);

4

Hi kjohnsoncda,

I want to confirm - your procedure works perfect !

Just enter to call mysql :

[root@asterisk]# mysql -p
Password : (enter your mysql root password)

use asterisk;
ALTER table ivr add column announcement VARCHAR (255);
\q

Bye