Apply Settings Message

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Add a new Gateway & save
2. Apply Settings will come
3. Switch for example to Extensions - Apply Settings will come also
4. Press Apply Settings & Switch again for example to extension - Apply 
Settings will come again.
5. Logout & Login - Apply settings are gone.

What is the expected output? What do you see instead?
Press apply settings without receive everytime the Apply Settings (without 
login logout).

What version of the product are you using? On what operating system?
FusiobPBX 3.2, Ubuntu 12.04 LTE installed with MySQL - upgrade worked perfect.

Any solutions?

Original issue reported on code.google.com by r...@raya-tech.ch on 7 Feb 2013 at 12:19

[GoogleCodeExporter]

Also I'm not able to add new users with the user manager. The users were also 
not created in the database.

freeswitch version: 1.2.5.2
fusionpbx rev: 1876 (installed and upgraded with ubuntu installation script)

multitenant setup.

Original comment by r...@raya-tech.ch on 7 Feb 2013 at 4:09

[GoogleCodeExporter]

Also it is impossible to add a new fax server. Get no errors nothing - can 
someone test it? whats going on? :-)

Original comment by r...@raya-tech.ch on 8 Feb 2013 at 3:21

[GoogleCodeExporter]

Run upgrade schema at the top of the page if it shows you any SQL there then 
run it in Advanced -> SQL Query. Your database is out of synch and that is 
preventing you from being able to add users. Seems there is a bug with MySQL 
and upgrade schema.

Original comment by markjcrane@gmail.com on 9 Feb 2013 at 6:54

[GoogleCodeExporter]

under upgrade shema i've the following querys:
ALTER TABLE v_extensions modify forward_all_destination text;
ALTER TABLE v_fax modify fax_destination_number text;
ALTER TABLE v_users modify add_user text;
ALTER TABLE v_users modify add_date text;

if i run it in advance -> sql query i got the following errors:
SQL Query:
ALTER TABLE v_extensions modify forward_all_destination text
Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 
'forward_all_destination' in 'v_extensions'
SQL Query:
ALTER TABLE v_fax modify fax_destination_number text
Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fax_destination_number' 
in 'v_fax'
SQL Query:
ALTER TABLE v_users modify add_user text
Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'add_user' in 'v_users'
SQL Query:
ALTER TABLE v_users modify add_date text
Error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'add_date' in 'v_users'

seems there is really a database problem. any solution?

Original comment by r...@raya-tech.ch on 9 Feb 2013 at 8:04

[GoogleCodeExporter]

Run the following from advanced -> sql query.

ALTER TABLE v_extensions add forward_all_destination text;
ALTER TABLE v_fax add fax_destination_number text;
ALTER TABLE v_users add add_user text;
ALTER TABLE v_users add add_date text;

Original comment by markjcrane@gmail.com on 9 Feb 2013 at 5:57

[GoogleCodeExporter]

add user and fax works now but got the following errors on execute under 
advanced -> sql query:

SQL Query:
ALTER TABLE v_extensions add forward_all_destination text
Error:
SQLSTATE[HY000]: General error
SQL Query:
ALTER TABLE v_fax add fax_destination_number text
Error:
SQLSTATE[HY000]: General error
SQL Query:
ALTER TABLE v_users add add_user text
Error:
SQLSTATE[HY000]: General error
SQL Query:
ALTER TABLE v_users add add_date text
Error:
SQLSTATE[HY000]: General error

but the fields are there - checked with phpmyadmin.

but the problem with apply settings, like described above, is still here. for 
example if you just update a gateway - click on save the apply settings window 
will come in every settings page :(.

Original comment by r...@raya-tech.ch on 9 Feb 2013 at 7:44

[GoogleCodeExporter]

I agree MySQL needs some attention to fix these new bugs. My development 
computers are mainly SQLite, and Postgres and MySQL least often of the three. I 
have been talking to another developer who talks like he is interested to help 
out with MySQL.

The apply settings is told to enable when a change has been made. If you logout 
that clears the session that indicated that you had a change that needed 
reloadxml.

Another option FusionPBX can be run from the db and doesn't even need reloadxml 
for most cases.

Original comment by markjcrane@gmail.com on 9 Feb 2013 at 7:54

[GoogleCodeExporter]

a fix for this bugs would be nice. i use mysql for a ha-system of 
freeswitch&fusionpbx.

thx for support!

Original comment by r...@raya-tech.ch on 9 Feb 2013 at 8:14

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

I fixed the apply settings bug. The apply settings message is no longer needed 
so it was removed.

Original comment by markjcrane@gmail.com on 24 Feb 2013 at 7:04

• Changed state: Fixed