Hey Guys,
Im having an issue with my PIAF server where the apply button wont go away. When I click apply I get this:
Reload failed because retrieve_conf encountered an error: 1
click here for more info
1 error(s) occurred, you should view the notification log on the dashboard or main screen to check for more details.
Ive found this link here:
freepbx.org/forum/freepbx/general-help/reload-failed-because-retrieve-conf-encountered-an-error-1-1
This is what I get when I run the suggestion in the thread:
root@pbx5:~ $ /var/lib/asterisk/bin/retrieve_conf
[FATAL] SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name [nativecode=1054 ** Unknown column 'name' in 'field list']SQL - <br /> SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name
Trace Back:
/var/www/html/admin/libraries/sql.functions.php:11 die_freepbx()
[0]: SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name [nativecode=1054 ** Unknown column 'name' in 'field list']SQL - <br /> SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name
/var/www/html/admin/modules/ivr/functions.inc.php:634 sql()
[0]: SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name
[1]: getAll
[2]: 2
/var/www/html/admin/libraries/usage_registry.functions.php:88 ivr_check_destinations()
[0]: 1
/var/www/html/admin/libraries/usage_registry.functions.php:281 framework_check_destination_usage()
[0]: 1
[1]:
/var/lib/asterisk/bin/retrieve_conf:612 framework_list_problem_destinations()
[0]:
[1]:
Anybody have any ideas?
Thanks,
Derrick
Im having an issue with my PIAF server where the apply button wont go away. When I click apply I get this:
Reload failed because retrieve_conf encountered an error: 1
click here for more info
1 error(s) occurred, you should view the notification log on the dashboard or main screen to check for more details.
Ive found this link here:
freepbx.org/forum/freepbx/general-help/reload-failed-because-retrieve-conf-encountered-an-error-1-1
This is what I get when I run the suggestion in the thread:
root@pbx5:~ $ /var/lib/asterisk/bin/retrieve_conf
[FATAL] SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name [nativecode=1054 ** Unknown column 'name' in 'field list']SQL - <br /> SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name
Trace Back:
/var/www/html/admin/libraries/sql.functions.php:11 die_freepbx()
[0]: SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name [nativecode=1054 ** Unknown column 'name' in 'field list']SQL - <br /> SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name
/var/www/html/admin/modules/ivr/functions.inc.php:634 sql()
[0]: SELECT dest, name, selection, a.id id FROM ivr_details a INNER JOIN ivr_entries d ON a.id = d.ivr_id ORDER BY name
[1]: getAll
[2]: 2
/var/www/html/admin/libraries/usage_registry.functions.php:88 ivr_check_destinations()
[0]: 1
/var/www/html/admin/libraries/usage_registry.functions.php:281 framework_check_destination_usage()
[0]: 1
[1]:
/var/lib/asterisk/bin/retrieve_conf:612 framework_list_problem_destinations()
[0]:
[1]:
Anybody have any ideas?
Thanks,
Derrick
Phone System 