AST_VDhopper.pl problem.

[umop3plsdn]

I moved some tables from another database for call history and such and everything pulls up fine its just the hopper wont fill this is what i get running it with the debug option. I also want to mention that i brought these tables over from a regular vicidial installation into this vicidialnow install.

[root@vici ~]# /usr/share/astguiclient/AST_VDhopper.pl --debug

----- DEBUG -----

TIME DEBUG: -5|-4|1| GMT: 18:15
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 4
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('127','134','999','599');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2008-07-28 14:15:18' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 7|6
Starting hopper run for Test campaign- GMT: 24hours HOPPER: 5
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
hopper READY count: 0
hopper too low (0|5) starting hopper dump
campaign lists count: 0 | ''
no lead filter defined for campaign: Test
leads to call count: 0
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER
Starting hopper run for NUWAVE_B campaign- GMT: 9am-9pm HOPPER: 100
hopper DONE cleared: 0E0
hopper GMT BAD cleared: 0E0
hopper READY count: 0
hopper too low (0|100) starting hopper dump
campaign lists count: 2 | '120','143'
campaign lists count: 2 | '120','143'
lead filter 3MOS defined for NUWAVE_B
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 975.
executing: SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NP','A','NEW') and list_id IN('120','143') and ((gmt_offset_now IN('2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','99') ) ) and ; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 975.


Is this a character set problem between the two databases?

[umop3plsdn]

I also made sure 100% that all the fields matched in the tables before moving them over.... just sooooooooo close only the hopper wont fill... reports are functional everything is but the hopper.

[umop3plsdn]

Only scheduled callbacks are going into the hopper

[gardo]

Can you check the mysql versions from the old installation and your VicidialNOW? You need to have them have the same major version number so that the database structure are identical.

It would also help if you can post the output of:

/usr/share/astguiclient/AST_VDhopper.pl --debugX

[umop3plsdn]

I uploaded a new batch and the hopper filled just fine