Add a New Filter doesn't work

[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

[mflorell]

astguiclient version?

[teto114]

I'm using 2.0.4 version

[mflorell]

Please post the results of "select * from vicidial_filters;" in mysql.

[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.

[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.

[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.