Inbound route problem

Hi,
I think mysql is screwed up. I cannot create a new inbound route. The error I get is
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘rvolume’ in ‘field list’

Anyone got any ideas on how to fix. Everything else seems to be working fine. Thanks.

If it is a MySQL problem, it’s probably one that was self-inflicted. Which table is it saying the column is not found in - you probably need to reinstall the module that manages that table.

Looks like it’s from the INCOMING table which should have the following structure

mysql> desc incoming;
+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| cidnum       | varchar(20)  | YES  |     | NULL    |       |
| extension    | varchar(50)  | NO   |     | NULL    |       |
| destination  | varchar(50)  | YES  |     | NULL    |       |
| privacyman   | tinyint(1)   | YES  |     | NULL    |       |
| alertinfo    | varchar(255) | YES  |     | NULL    |       |
| ringing      | varchar(20)  | YES  |     | NULL    |       |
| mohclass     | varchar(80)  | NO   |     | default |       |
| description  | varchar(80)  | YES  |     | NULL    |       |
| grppre       | varchar(80)  | YES  |     | NULL    |       |
| delay_answer | int(2)       | YES  |     | NULL    |       |
| pricid       | varchar(20)  | YES  |     | NULL    |       |
| pmmaxretries | varchar(2)   | YES  |     | NULL    |       |
| pmminlength  | varchar(2)   | YES  |     | NULL    |       |
| reversal     | varchar(10)  | YES  |     | NULL    |       |
| rvolume      | varchar(2)   | YES  |     |         |       |
+--------------+--------------+------+-----+---------+-------+

Somehow I have a feeling it’s tied to Core or Framework but I could be wrong…

Looks like it stores the “Ringer Volume Override” which description is “Override the ringer volume. Note: This is only valid for Sangoma phones at this time”.

The column could be manually added but what happened to it in the first place?

Have a nice day!

Nick

Edit: I see code to add it in Core…

1 Like

Thanks, This command seems to have sorted it.

fwconsole ma install core