[Asterisk-Users] vicidial and mysql ........help

[Hussain Umair]

hi all.....well ive installed each and everything according to the scratch 
installation but the problem is when i try to login a user through 
vicidialgui application it gives an error that there are 0 leads in the 
hopper to dial....well im pasting the result of a few queries .....plz if 
any one can do help me out ....
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/