this is what the error looks like...
SELECT count(*) FROM vicidial_hopper where campaign_id = '13' and status='READY';
0 - leads left to call in hopper
so the login fails..............
but these queries at the mysql cmd line tell me i got 7 leads in the database
select * from vicidial_list; 7 rows in set (0.00 sec)
but when i use count it gives this mysql>select count(1) from vicidial_hopper; +----------+ | count(1) | +----------+ | 0 | +----------+ 1 row in set (0.00 sec)
mysql> select status,count(1) from vicidial_hopper group by status; Empty set (0.00 sec)
mysql> select campaign_id from vicidial_hopper group by campaign_id; Empty set (0.00 sec)
please any ideas or help woud be greatly appreciated....im kinda lost in this mysql lala land cant figure out whats going on.....help me out here guys ....thankss
kurt... Network Engineer plus Asterisk Newbie u can say....
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
_______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users