This is the second time its happened. We get a report that when a caller types in the first three characters of a user’s name, they are offered two choices, 1 and 2. Choosing either 1 or 2 does not work though.
When I look in the directory_entries database, there are (at least) two entries for each user, but the second entry has NULL for the “type” and “audio” columns. I’ve included an export of the data in the table below (before I subsequently delete the extra entries).
If I delete the additional entries all is fine, but its come back once and I imagine it will again.
Any ideas on what might be causing this?
Thank you - Richard
– Query: SELECT * FROM asterisk.directory_entries
LIMIT 0, 1000
– Date: 2010-11-08 10:12
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,user,1001,vm,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,user,1002,vm,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,user,1005,vm,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,user,1006,vm,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,user,1007,vm,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,1006,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,1005,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,1005,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,1002,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,1001,);
INSERT INTO table (id,name,type,foreign_id,audio,dial) VALUES (1,1007,);