I found the way to identify the issue through Support ALG's blog (see link below).
https://supportalg.blogspot.com/2015/06/how-to-fix-error-this-campaign-has-zero.html
/usr/share/astguiclient/AST_VDhopper.pl --debugX
Sorry, I was only able to get a partial screenshot |
Because of this, I was able to identify that the /asterisk/vicidial_list table had crashed. After googling "table vicidial list is marked as crashed", I found this vicidial.org forum thread:
http://www.vicidial.org/VICIDIALforum/viewtopic.php?t=20206
Scrolling down below, I found this command (first when mysql has no password, second has password - you'll only need one of them):
mysqlcheck --auto-repair asterisk vicidial_list
mysqlcheck --auto-repair asterisk vicidial_list -p
Now after running the mysqlcheck, I logged out of and in to the campaign, and I can dial outbound calls again!