Got error while running the AST_VDhopper.pl script

[saqib.ali]

i am getting the below error after moving the DB to another server ...
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 961.

any suggestions why its giving this error ??

[mflorell]

astguiclient version?

[saqib.ali]

2.0.2

[mflorell]

I would strongly recommend upgrading to at least 2.0.4.1rc5.

[saqib.ali]

hmm .. actually i have made alot of interface changes as well some custom codes in 2.0.2 version ... i m also working on the new release to reflect that changes in that version so hopefully will use that new version very soon .

for the problem the vicidial_list, vicidial_campaign table got corrupted while taking backup but after fixing/repair those tables now the script is working fine.

[mflorell]

We don't really support 2.0.2 at this point, you should check the source to see where the script is stopping and try to fix it.