vicidial.org

Hello people, let me start with my server details:

vicidialnow 1.3 CE (almost sure..) | ADMIN VERSION: 2.0.5-174 | BUILD: 90522-0506 | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation

I am trying to create a filter to prevent specific cities from being called on specific campaigns..

after researching the forum i figured that the filter context should be something like:

city NOT IN('XXX','XXXX XXX',)

but when i attempt to create a new filter with that context and submit it, i get a return: FILTER CREATED but no filter is actually created..

Even stranger is the fact that if i create a new filter for example: "TEST" and put in it just the words: "test filter" and submit that, the filter does get created.

BUT if i edit the text "test filter" to: city NOT IN('BROOKLYN',) and attempt to submit i get a: "FILTER MODIFIED" responce but the text remains "test filter"...

My assumption is that mysql doesnt like the context i am placing but i cant figure out what i am doing wrong.. any and all help is greatly appreciated....

Upgrade to 2.2.1

also:

city NOT IN('XXX','XXXX XXX',)

has an extra comma that may cause an issue

city NOT IN('XXX','XXXX XXX')

Thanks for the replies gent's.. im honored, i got the 2 big shots on my first post, lol..


William; tried and it didn't work, same result as before, just refreshed the page and went back to the same "test" text within the Filter SQL: section.

mflorell wrote:Upgrade to 2.2.1

Please excuse the dumb question, but is there a good walk through on this forum on how to upgrade to latest & greatest without loosing any of the existing data?

That would be great!

Thanks again in advance..

not a walk through, but the Vicidial Wiki has a How To on SVN. Using SVN will allow downloading ANY version (2.2.1, 2.4 ...). Each version has an UPGRADE.txt document. Since SVN ONLY downloads the sources, you will then have access to the UPGRADE.txt file (for perusal) before actually making any changes to your system.

Before that, of course ... you DO have a backup ....?