CITY Filter Issue

General and Support topics relating to ViciDialNow and GoAutoDial ISO installers

Moderators: enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, s0lid

CITY Filter Issue

Postby dragonsdofly » Fri Apr 15, 2011 4:01 am

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....
dragonsdofly
 
Posts: 4
Joined: Fri Apr 15, 2011 3:03 am

Postby mflorell » Fri Apr 15, 2011 7:57 am

Upgrade to 2.2.1
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby williamconley » Fri Apr 15, 2011 10:19 am

also:

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


has an extra comma that may cause an issue

city NOT IN('XXX','XXXX XXX')
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Upgrading

Postby dragonsdofly » Fri Apr 15, 2011 2:15 pm

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..
dragonsdofly
 
Posts: 4
Joined: Fri Apr 15, 2011 3:03 am

Postby williamconley » Fri Apr 15, 2011 3:29 pm

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 ....?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20258
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to ViciDialNow - GoAutoDial

Who is online

Users browsing this forum: No registered users and 58 guests