Page 1 of 1

Add a New Filter doesn't work

PostPosted: Mon Jun 23, 2008 10:45 pm
by teto114
Hi:

I'm trying to add a new filter, I read the manual part and everything; fill in the name, description, and comments and my filter is:
state IN('CA')
I just want to dial California for this specific campaign, but the list has other states as well.

then I click "Submit" I get a screen that says it added the filter but it is not listed in the filter list nor I can select if from the campaign page; any suggestions?

Thanks in advance.

Roberto

PostPosted: Mon Jun 23, 2008 11:29 pm
by mflorell
astguiclient version?

PostPosted: Mon Jun 23, 2008 11:58 pm
by teto114
I'm using 2.0.4 version

PostPosted: Tue Jun 24, 2008 8:56 am
by mflorell
Please post the results of "select * from vicidial_filters;" in mysql.

PostPosted: Tue Jun 24, 2008 9:11 am
by teto114
Thank you Matt:

The result I get from running the command:
select * from vicidial_filters;
is
ERROR 1046 (3D000): No database selected

I use phpmyadmin to see what's there, but I don't see any vicidial_filters database, I search both in Asterisk and MySQL for it.

How can I create that database?

However, I do see a vicidial_lead_filters database that has no records.

Thanks again.

PostPosted: Tue Jun 24, 2008 11:05 am
by teto114
I created the filter directly with phpmyadmin on vicidial_lead_filters and it's working ok now, I can select it and see it listed in the vicidial gui, however, if I modify it on the gui it doesn't go thru.

PostPosted: Wed Jun 25, 2008 3:27 am
by mflorell
The admin.php script will not let the filter be created unless you give it an ID and description, that could be the problem.