Campaigns list got hidden

[dukemuzaffar]

Guys,

I am having a working vicidial setup based on vicibox working great from sept -2014 onwards without any issues. Its for 20 Agents.
Unfortunately from few days back, campaigns list got disappeared from Vicidial admin-->Campaigns-->Show campaigns.
I am really in need of it and want the functionality to be restored as soon as possible on the same setup.
Please any suggestions and advice from your side as to how can i restore it?
Thanks in advance.

ViciBox Server v.6.0
Asterisk 1.8.28.2
Opensuse

[udy786]

Hi

May be your database crashed. Try to repair your database.

Code: Select all

mysqlcheck -u root -p --auto-repair --check --optimize --all-databases

[dukemuzaffar]

Thanks for your reply. However, if DB is crashed, it will affect other functionalities as well right?
Any other suggestion please from others.

[mflorell]

admin.php version and build?

Have you checked your User Group permissions for allowed campaigns?

[dukemuzaffar]

Sorry for delayed reply Mr. Matt

Below is the version and build for
VERSION: 2.10-451a
BUILD: 140902-0816

[dukemuzaffar]

Also, in the user group
Allowed Campaigns: field has no value and even i dont have an option to select any campaign as well.
Help says
"Allowed Campaigns - This is a selectable list of Campaigns to which members of this user group can log in to. The ALL-CAMPAIGNS option allows the users in this group to see and log in to any campaign on the system. "

But literally, there is no selectable list from where i can select any value.

Please help.

[dukemuzaffar]

Can someone please help on this?

[dukemuzaffar]

Any help please

[mflorell]

You will have to go into mysql and fix it manually then. Look in the vicidial_user_groups table.

[dukemuzaffar]

Thanks for the response Mr Matt.

I will follow your advise.

Currently I am facing one more issue not sure if they are interlinked. My real-time summary report is not working as well.

[dukemuzaffar]

allowed_campaigns column value was null in `vicidial_user_groups` for ADMIN group.



I have update the entry with –ALL-- .

Issue resolved.

Thanks Mr Matt, really appreciated.

[williamconley]

Thanks for your reply. However, if DB is crashed, it will affect other functionalities as well right?
Any other suggestion please from others.

Actually, not necessarily. This depends on which table broke. So it never hurts to run the check instead of dismissing it out of hand. Just sayin'

Even though that did not turn out to be the issue this time, it's a good thing to check when you have any problem with "stuff missing" from the GUI.

allowed_campaigns column value was null in `vicidial_user_groups` for ADMIN group.



I have update the entry with –ALL-- .

EXCELLENT postback. You've probably helped another user save some hair pulling

And on a final note: Never Edit the ADMIN user group. If you feel the need to edit the access/permissions of a user, move them OUT of ADMIN and into another group, and edit the other group. Safe.

[atkins513]

allowed_campaigns column value was null in `vicidial_user_groups` for ADMIN group.

I have update the entry with –ALL-- .

Issue resolved.

Thanks Mr Matt, really appreciated.

Can you give me a step by step on how to do this? I am having exactly the same problem. I have putty but i am very very new to Vicidial. Please give me step by step as though you are talking to a child from the point of logging in to my server with putty to setting my group ADMIN to see all campaigns.... Thank you

[williamconley]

Code: Select all

mysql -u cron -p1234 asterisk -e "select * from vicidial_user_groups where user_group='ADMIN'\G"

View the "allowed_campaigns" and "qc_allowed_campaigns" and "qc_allowed_inbound_groups". All should be -ALL-XXXXXX- -".

Code: Select all

mysql -u cron -p1234 asterisk -e "update vicidial_user_groups set allowed_campaigns='-ALL-CAMPAIGNS- -', qc_allowed_campaigns='-ALL-CAMPAIGNS- -', qc_allowed_inbound_groups='-ALL-GROUPS- -', agent_status_viewable_groups='--ALL-GROUPS-- --CAMPAIGN-AGENTS-- --NOT-LOGGED-IN-AGENTS-- ADMIN', admin_viewable_groups='---ALL---', admin_viewable_call_times='---ALL---', agent_allowed_chat_groups='--ALL-GROUPS-- --CAMPAIGN-AGENTS-- ADMIN' where user_group='ADMIN'"

Note that if your version is old, one (or more) of these fields may actually be missing and cause the query to fail. If so, delete the offending field and value.

[carpenox]

good shit Bill. Thx for this. I had it all set right but definitely good debugging info to have for the future

[atkins513]

Code: Select all

mysql -u cron -p1234 asterisk -e "select * from vicidial_user_groups where user_group='ADMIN'\G"

View the "allowed_campaigns" and "qc_allowed_campaigns" and "qc_allowed_inbound_groups". All should be -ALL-XXXXXX- -".

Code: Select all

mysql -u cron -p1234 asterisk -e "update vicidial_user_groups set allowed_campaigns='-ALL-CAMPAIGNS- -', qc_allowed_campaigns='-ALL-CAMPAIGNS- -', qc_allowed_inbound_groups='-ALL-GROUPS- -', agent_status_viewable_groups='--ALL-GROUPS-- --CAMPAIGN-AGENTS-- --NOT-LOGGED-IN-AGENTS-- ADMIN', admin_viewable_groups='---ALL---', admin_viewable_call_times='---ALL---', agent_allowed_chat_groups='--ALL-GROUPS-- --CAMPAIGN-AGENTS-- ADMIN' where user_group='ADMIN'"

Note that if your version is old, one (or more) of these fields may actually be missing and cause the query to fail. If so, delete the offending field and value.

Wow.. I never got this problem fixed but was searching for the solution yet again tonight, 4 months later, and I came across your post.. and you didn't direct it towards anyone so i wasnt even sure if it was for me.... BUT i ran both of these commands and fixed my issues... wow... thank you so much!!!

[sandstone]

Thank you williamconley! This solution fixed an error for me as well! You Rock!!!!