GOautodial Open Source Omni-channel Contact Center Suite

Hi Mark,

Good day! We actually haven't encountered that error yet, May we know what was the last thing you have done so we can check and try to replicate the issue you encountered.

Regards,
Ryan

Nothing beyond installing the software and setting up a static IP address. I also ran yum update.

I looked at the back end 'asterisk' database and noticed that there is no 'access_type' column in the 'go_useraccess' table. Is this an error in the php script? What is the name of the file that is being called when I click on 'users'?

Distributor ID: CentOS
Description: CentOS release 5.9 (Final)
Release: 5.9
Codename: Final

Asterisk 1.4.39.1-vici.go

ViciDial
VERSION: 2.4-364a
BUILD: 120409-1136

GoAutoDial
Kernel Version 2.6.18-348.6.1.el5 (SMP)
Distro Name GoAutoDial CE 3.0

Hi,

got the same issue after udpating to goautodial-ce.noarch 0:3.0-1369368000

Rgds

Hi,

got it :

short way :
run this in mysql :

ALTER TABLE `go_useraccess` ADD `access_type` ENUM CHARACTER SET latin1 COLLATE utf8 NOT NULL DEFAULT '1';

UPDATE go_useraccess SET `access_type` =0 WHERE `id` >=41 ;

long way :

run this in mysql :

DROP TABLE `go_useraccess`;

CREATE TABLE IF NOT EXISTS `go_useraccess` (`id` int(11) NOT NULL auto_increment, `useraccess_name` varchar(500) character set utf8 default NULL, `useraccess_desc` varchar(500) character set utf8 default NULL, `vicidial_users_column_name` varchar(255) character set utf8 NOT NULL, `access_type` enum('1','0') character set utf8 NOT NULL default '1', PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=58 ;

--
-- Dumping data for table `go_useraccess`
--

INSERT INTO `go_useraccess` (`id`, `useraccess_name`, `useraccess_desc`, `vicidial_users_column_name`, `access_type`) VALUES

(1, 'View Reports', 'Allow to view reports ui', 'view_reports', '1'),
(2, 'Alter agent interface options', NULL, 'alter_agent_interface_options', '1'),
(3, 'Modify Users', 'Allow to modify a user', 'modify_users', '1'),
(4, 'Change Agent Campaign', NULL, 'change_agent_campaign', '1'),
(5, 'Delete Users', NULL, 'delete_users', '1'),
(6, 'Modify User Groups', NULL, 'modify_usergroups', '1'),
(7, 'Delete User Groups', NULL, 'delete_user_groups', '1'),
(8, 'Modify Lists', NULL, 'modify_lists', '1'),
(9, 'Delete Lists', NULL, 'delete_lists', '1'),
(10, 'Load Leads', NULL, 'load_leads', '1'),
(11, 'Modify Leads', NULL, 'modify_leads', '1'),
(12, 'Download Lists', NULL, 'download_lists', '1'),
(13, 'Export Reports', NULL, 'export_reports', '1'),
(14, 'Delete From DNC', NULL, 'delete_from_dnc', '1'),
(15, 'Custom Fields Modify', NULL, 'custom_fields_modify', '1'),
(16, 'Modify Campaigns', NULL, 'modify_campaigns', '1'),
(17, 'Campaign Detail', NULL, 'campaign_detail', '1'),
(18, 'Delete Campaigns', NULL, 'delete_campaigns', '1'),
(19, 'Modify InGroups', NULL, 'modify_ingroups', '1'),
(20, 'Delete InGroups', NULL, 'delete_ingroups', '1'),
(21, 'Modify Inbound DIDs', NULL, 'modify_inbound_dids', '1'),
(22, 'Delete Inbound DIDs', NULL, 'delete_inbound_dids', '1'),
(23, 'Modify Remote Agents', NULL, 'modify_remoteagents', '1'),
(24, 'Delete Remote Agents', NULL, 'delete_remote_agents', '1'),
(25, 'Modify Scripts', NULL, 'modify_scripts', '1'),
(26, 'Delete Scripts', NULL, 'delete_scripts', '1'),
(27, 'Modify Filters', NULL, 'modify_filters', '1'),
(28, 'Delete Filters', NULL, 'delete_filters', '1'),
(29, 'AGC Admin Access', NULL, 'ast_admin_access', '1'),
(30, 'AGC Delete Phones', NULL, 'ast_delete_phones', '1'),
(31, 'Modify Call Times', NULL, 'modify_call_times', '1'),
(32, 'Delete Call Times', NULL, 'delete_call_times', '1'),
(33, 'Modify Servers', NULL, 'modify_servers', '1'),
(34, 'CallCard Admin', NULL, 'callcard_admin', '1'),
(35, 'Agent API Access', NULL, 'vdc_agent_api_access', '1'),
(36, 'Add Timeclock Log Record', NULL, 'add_timeclock_log', '1'),
(37, 'Modify Timeclock Log Record', NULL, 'modify_timeclock_log', '1'),
(38, 'Delete Timeclock Log Record', NULL, 'delete_timeclock_log', '1'),
(39, 'Manager Shift Enforcement Override', NULL, 'manager_shift_enforcement_override', '1'),
(40, 'Realtime Block User Info', NULL, 'realtime_block_user_info', '1'),
(41, 'Agent Choose Ingroups', NULL, 'agent_choose_ingroups', '0'),
(42, 'Agent Choose Blended', NULL, 'agent_choose_blended', '0'),
(43, 'Hot Keys Active', NULL, 'hotkeys_active', '0'),
(44, 'Scheduled Callbacks', NULL, 'scheduled_callbacks', '0'),
(45, 'Agent-Only Callbacks', NULL, 'agentonly_callbacks', '0'),
(46, 'Agent Call Manual', NULL, 'agentcall_manual', '0'),
(47, 'Vicidial Recording', NULL, 'vicidial_recording', '0'),
(48, 'Vicidial Transfers', NULL, 'vicidial_transfers', '0'),
(49, 'Closer Default Blended', NULL, 'closer_default_blended', '0'),
(50, 'VICIDIAL Recording Override', NULL, 'vicidial_recording_override', '0'),
(51, 'Agent Alter Customer Data Override', NULL, 'alter_custdata_override', '0'),
(52, 'Agent Alter Customer Phone Override', NULL, 'alter_custphone_override', '0'),
(53, 'Agent Shift Enforcement Override', NULL, 'agent_shift_enforcement_override', '0'),
(54, 'Agent Call Log View Override', NULL, 'agent_call_log_view_override', '0'),
(55, 'Agent Lead Search Override', NULL, 'agent_lead_search', '0'),
(56, 'Alert Enabled', NULL, 'alert_enabled', '0'),
(57, 'Allow Alerts', NULL, 'allow_alerts', '0');

Or you can do this:

mysql -f -pvicidialnow < /usr/src/goautodial/sql/asterisk.sql

This should fix:

Error Number: 1054 Unknown column 'access_type' in 'order clause'
SELECT * FROM (`go_useraccess`) ORDER BY `access_type` desc