MYSQL vicidial_cn onferences error

[wasdak]

Hi,

I have error below when im inserting conferences, but when i use the admin interface of vicidial it works.

VERSION - 2.0.5b0.5

Database changed
mysql> insert into vicidial_conferences
-> values('8600086','192.168.1.5','');
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql>

[mflorell]

Which db_schema_version are you using?(look in system settings)

[wasdak]

Hi Matt,

This is the schema version

DB Schema Version: 1106

[mflorell]

I believe I had fixed that in the first_server_install.sql file in SVN trunk. It should look like this:

INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600051','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600052','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600053','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600054','10.10.10.15');
INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600055','10.10.10.15');

I will be fixing that in the SCRATCH_INSTALL doc shortly.

Thanks for catching that.

[wasdak]

Thanks matt it works


debian:~# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6390
Server version: 5.0.32-Debian_7etch6-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use asterisk;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> INSERT INTO vicidial_conferences(conf_exten,server_ip) values('8600056','10.10.10.15');
Query OK, 1 row affected (0.00 sec)

mysql>