ERROR: no custom list fields table

[douglaswscott]

GoAutoDial CE 2.1
Vicidial SVN 2.4-309a BUILD: 110430-1642
Asterisk 1.4.39.1-vici
Dahdi 2.4.1
CentOS 5.6


I added 1 custom list to the lead list.

Agent screen getting error... ERROR: no custom list fields table .

I updated the sql last night for the svn:trunk 2_x, not getting a quick responce over the admin.php issue...

I decided to install a ce 2.1 iso on a spare dialer and see how it goes....I am assuming I now have to run the upgrade_2.4.sql ??

[mflorell]

We have fixed a few issues with custom fields in the last couple months. I would suggest upgrading to a more recent SVN/trunk version.

[douglaswscott]

We have fixed a few issues with custom fields in the last couple months. I would suggest upgrading to a more recent SVN/trunk version.

I installed the trunk 2_x svn, same issue... acts like the db is missing a table.

svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk

cd /usr/src/astguiclient/trunk

perl ./install.pl

reboot.... already ran the db sql script last night.

clicking refresh on form tab gets - ERROR: no custom list fields table

[williamconley]

try copying the fields to that table from another (backup first!)

[mflorell]

Another solution might be to delete and then rebuild your custom fields

[douglaswscott]

I am backing up the MYSQL database, going to format the server and load it from the current iso, then restore.

What is the exact command to get the svn trunk for the current ce 2.1, just making sure I apply the correct one.

Another solution might be to delete and then rebuild your custom fields

[williamconley]

he meant delete the fields and recreate them. not the entire database.

the commands for SVN are in here:
http://wiki.vicidial.org/index.php/SVN:howto

but be sure to modify it for your file structure (CentOS is not part of Vicidial's setup ... but if you donate your exact commands after you do it, I'd be happy to put a section for CE2.1 -> Vici2.4SVN for the next guy ... the difference is only where the files reside ... and may not even BE different!)

[douglaswscott]

Its Midnight and the database is almost finished importing. I used the GoAutoDial CE 2.1 iso to set up the sql server and turned off asterisk then rc.local stuff and crontab stuff I didnt need. At least I know the asterisk database was created to match this version.

Having to sit and wait for the import to finish I went and got the correct trunk file you pointed out and put it on one of the dialers. Yes all of the folders are correct and you have to use the agc/vicidial.php for the agents. Same old grey menus ARGH... I will test the system tomorrow with the iso goautodialagent version, and the trunk agc version then let you know which works better.

*** Question is do I have to run the trunk/extras/upgrade_2.4.sql on the database or am I current with the 2.1 ce iso? And if I do run the trunk upgrade and want to go back to the non trunk menus will that be an issue?

Thanks.....

he meant delete the fields and recreate them. not the entire database.

the commands for SVN are in here:
http://wiki.vicidial.org/index.php/SVN:howto

but be sure to modify it for your file structure (CentOS is not part of Vicidial's setup ... but if you donate your exact commands after you do it, I'd be happy to put a section for CE2.1 -> Vici2.4SVN for the next guy ... the difference is only where the files reside ... and may not even BE different!)

[douglaswscott]

I have the MYSQL Asterisk Database - fresh and new from the CE 2.1 iso, same error.

ERROR: no custom list fields table

I did download the svn trunk and perl installed it on another dialer, it uses agc folder .... tried it from that webserver... same error.

I did not run the 2_4.sql patch from trunk svn until I hear back if it will mess up the baseline ce 2.1...


Went into admin, deleted the custom field, then added it back...

same error.

PLEASE HELP

[mflorell]

I am really confused as to why you did a full re-install.

If you upgraded to the most recent svn/trunk you have to run the upgrade SQL commands or vicidial will not work.

Maybe if you could give us more information on the field you are trying to create, as well as the following output from Mysql, we could help you.

$ mysql
> use mysql;
> select Host,User from user;

[douglaswscott]

Matt;

I had other issues with the SQL server and wanted to reload it... so it was an easy way to get a 2.1 database without upgrading from an older 1.4.

William posted a comment worried if the trunk would work under Centos, so I was trying baby steps.

A side note we use an APC 10kva 220v network ups, the network software will not run on Ubuntu, Centos is fine... that is why we have been in a spot to run any other flavor of OS.

I am really confused as to why you did a full re-install.

If you upgraded to the most recent svn/trunk you have to run the upgrade SQL commands or vicidial will not work.

Maybe if you could give us more information on the field you are trying to create, as well as the following output from Mysql, we could help you.

$ mysql
> use mysql;
> select Host,User from user;

[mflorell]

Vicibox runs OpenSuse. We have yet to find hardware that does not have drivers for Suse.

[williamconley]

I've found some! (But it was ... kinda old, and just a test box ... and another that was Brand Spankin' New, just released, bleedin' edge ... and also just a test box ...)

[douglaswscott]

Yes, that flavor does work with our APC UPS network software, good to know.

Vicibox runs OpenSuse. We have yet to find hardware that does not have drivers for Suse.

[douglaswscott]

SVN Trunk
VERSION: 2.4-330c BUILD: 110802-0122
CE 2.1

Just finished installing
svn checkout svn://svn.eflo.net:3690/agc_2-X/trunk

and here is what I did.

Ok, I upgraded thr 2.1 DB using the sql script in trunk/extras then ran perl script in trunk folder on dialers.

Rebooted DB
Rebooted Dialers
Created a new lead list for the campaign
Created a custom field for taking credit card info.

Logged into campaign

Still getting ERROR: no custom list fields table

How do i go about fixing the DB? I need step by step directions or better yet a sql script that would fix it for me. WE have never used the custom fields and that seems to be the issue, even though I just applied the latest trunk.

Another solution might be to delete and then rebuild your custom fields

[mflorell]

I'm going to ask for this one more time, the following output from Mysql:

$ mysql
> use mysql;
> select Host,User from user;

[douglaswscott]

Database changed
mysql> select Host,User from user;
+-----------------------+-------------+
| Host | User |
+-----------------------+-------------+
| % | cron |
| % | custom |
| % | goautodialu |
| % | vtiger |
| 127.0.0.1 | root |
| localhost | |
| localhost | cron |
| localhost | custom |
| localhost | goautodialu |
| localhost | root |
| localhost | vtiger |
| localhost.localdomain | |
| localhost.localdomain | root |
+-----------------------+-------------+
13 rows in set (0.00 sec)

mysql>

I'm going to ask for this one more time, the following output from Mysql:

$ mysql
> use mysql;
> select Host,User from user;

[mflorell]

OK, now this query:

show tables;

[douglaswscott]

mysql> use asterisk
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+-----------------------------------+
| Tables_in_asterisk |
+-----------------------------------+
| call_log |
| call_log_archive |
| callback_config |
| callcard_accounts |
| callcard_accounts_details |
| callcard_log |
| conferences |
| custom_5151 |
| custom_6969 |
| groups_alias |
| inbound_numbers |
| live_channels |
| live_inbound |
| live_inbound_log |
| live_sip_channels |
| park_log |
| parked_channels |
| phone_favorites |
| phones |
| phones_alias |
| recording_log |
| server_performance |
| server_updater |
| servers |
| system_settings |
| twoday_call_log |
| twoday_recording_log |
| twoday_vicidial_agent_log |
| twoday_vicidial_closer_log |
| twoday_vicidial_log |
| twoday_vicidial_xfer_log |
| user_call_log |
| vicidial_admin_log |
| vicidial_agent_log |
| vicidial_agent_log_archive |
| vicidial_agent_skip_log |
| vicidial_agent_sph |
| vicidial_api_log |
| vicidial_auto_calls |
| vicidial_call_menu |
| vicidial_call_menu_options |
| vicidial_call_notes |
| vicidial_call_notes_archive |
| vicidial_call_times |
| vicidial_callbacks |
| vicidial_campaign_agents |
| vicidial_campaign_dnc |
| vicidial_campaign_hotkeys |
| vicidial_campaign_server_stats |
| vicidial_campaign_stats |
| vicidial_campaign_stats_debug |
| vicidial_campaign_statuses |
| vicidial_campaigns |
| vicidial_campaigns_list_mix |
| vicidial_carrier_log |
| vicidial_carrier_log_archive |
| vicidial_closer_log |
| vicidial_closer_log_archive |
| vicidial_conf_templates |
| vicidial_conferences |
| vicidial_cpd_log |
| vicidial_custom_cid |
| vicidial_did_agent_log |
| vicidial_did_agent_log_archive |
| vicidial_did_log |
| vicidial_dnc |
| vicidial_drop_rate_groups |
| vicidial_extension_groups |
| vicidial_filter_phone_groups |
| vicidial_filter_phone_numbers |
| vicidial_grab_call_log |
| vicidial_hopper |
| vicidial_inbound_dids |
| vicidial_inbound_group_agents |
| vicidial_inbound_groups |
| vicidial_ivr |
| vicidial_lead_filters |
| vicidial_lead_recycle |
| vicidial_lead_search_log |
| vicidial_lead_search_log_archive |
| vicidial_list |
| vicidial_list_alt_phones |
| vicidial_list_copy |
| vicidial_list_copy1 |
| vicidial_list_pins |
| vicidial_list_update_log |
| vicidial_lists |
| vicidial_lists_copy |
| vicidial_lists_fields |
| vicidial_live_agents |
| vicidial_live_inbound_agents |
| vicidial_log |
| vicidial_log_archive |
| vicidial_log_extended |
| vicidial_log_extended_archive |
| vicidial_log_noanswer |
| vicidial_log_noanswer_archive |
| vicidial_manager |
| vicidial_manual_dial_queue |
| vicidial_music_on_hold |
| vicidial_music_on_hold_files |
| vicidial_nanpa_prefix_codes |
| vicidial_outbound_ivr_log |
| vicidial_outbound_ivr_log_archive |
| vicidial_override_ids |
| vicidial_pause_codes |
| vicidial_phone_codes |
| vicidial_postal_codes |
| vicidial_process_trigger_log |
| vicidial_process_triggers |
| vicidial_qc_codes |
| vicidial_remote_agent_log |
| vicidial_remote_agents |
| vicidial_screen_labels |
| vicidial_scripts |
| vicidial_server_carriers |
| vicidial_server_trunks |
| vicidial_shifts |
| vicidial_state_call_times |
| vicidial_stations |
| vicidial_status_categories |
| vicidial_statuses |
| vicidial_territories |
| vicidial_timeclock_audit_log |
| vicidial_timeclock_log |
| vicidial_timeclock_status |
| vicidial_tts_prompts |
| vicidial_url_log |
| vicidial_user_closer_log |
| vicidial_user_groups |
| vicidial_user_log |
| vicidial_user_territories |
| vicidial_user_territory_log |
| vicidial_users |
| vicidial_voicemail |
| vicidial_xfer_log |
| vicidial_xfer_presets |
| vicidial_xfer_stats |
| vtiger_rank_data |
| vtiger_rank_parameters |
| vtiger_vicidial_roles |
| web_client_sessions |
+-----------------------------------+
142 rows in set (0.00 sec)
--------------------------------------------------------------------------------
mysql> show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| func |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| host |
| proc |
| procs_priv |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
17 rows in set (0.00 sec)

OK, now this query:

show tables;

[mflorell]

describe custom_5151;

describe custom_6969;

select * from vicidial_lists_fields;

[douglaswscott]

mysql> describe custom_5151;
+---------+---------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------------------------------------------+------+-----+---------+-------+
| lead_id | int(9) unsigned | NO | PRI | NULL | |
| CC | enum('Amex','Discover','MasterCard','VISA') | YES | | NULL | |
+---------+---------------------------------------------+------+-----+---------+-------+


mysql> describe custom_6969;
+---------+-------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------------------------------+------+-----+---------+-------+
| lead_id | int(9) unsigned | NO | PRI | NULL | |
| ccinfo | enum('MC','Visa','Amex','Discover') | YES | | NULL | |
+---------+-------------------------------------+------+-----+---------+-------+
2 rows in set (0.01 sec)


mysql> select * from vicidial_lists_fields;
+----------+---------+-------------+------------+-------------------+------------+---------------------------+------------+------------------------------------------------------------------+------------+-----------+---------------+------------+----------------+---------------+----------------+-------------+
| field_id | list_id | field_label | field_name | field_description | field_rank | field_help | field_type | field_options | field_size | field_max | field_default | field_cost | field_required | name_position | multi_position | field_order |
+----------+---------+-------------+------------+-------------------+------------+---------------------------+------------+------------------------------------------------------------------+------------+-----------+---------------+------------+----------------+---------------+----------------+-------------+
| 2 | 6969 | ccinfo | CC Info | CC Info | 1 | CC Info | SELECT | MC, MC
Visa, Visa
Amex, Amex
Discover, Discover | 4 | 1 | NULL | 87 | Y | LEFT | HORIZONTAL | 1 |
| 3 | 5151 | CC | CC | CC | 1 | Credit card - select one. | SELECT | Amex, Amex
Discover, Discover
MasterCard, MasterCard
VISA, VISA
| 4 | 1 | NULL | 111 | Y | LEFT | VERTICAL | 1 |
+----------+---------+-------------+------------+-------------------+------------+---------------------------+------------+------------------------------------------------------------------+------------+-----------+---------------+------------+----------------+---------------+----------------+-------------+
2 rows in set (0.00 sec)

describe custom_5151;

describe custom_6969;

select * from vicidial_lists_fields;

[mflorell]

What is the "Manual Dial List ID" set to in your campaign?

What list IDs are assigned to this campaign?

Is this error occurring on inbound calls as well?

[douglaswscott]

Manual dial list ID was at the default 999, I just tried it at 5151 too, same error.

list ID for leads 5151 is assigned to campaign 5151

We are taking phone calls for the telethon and not calling out, so yes inbound has the issue. WE have not tried outbound as it wont be used for this campaign.

What is the "Manual Dial List ID" set to in your campaign?

What list IDs are assigned to this campaign?

Is this error occurring on inbound calls as well?

[mflorell]

What list ID do you have set on the inbound DIDs or Call Menus?

[douglaswscott]

Inbound DID is set to 5151
Not sure where you mean for Call menus.

What list ID do you have set on the inbound DIDs or Call Menus?

[mflorell]

Not sure what could be wrong since everything else looks correct.

When you click on the "refresh" link in the top corner of the form frame does it stay the same?

[douglaswscott]

Still same error.

ERROR: no custom list fields table

Even rebooted the dialer and tried it again.

Inbound campaign, go to form ... clicked refresh...

ERROR: no custom list fields table

I noticed the script page was empty until clicked refresh... but it was fine, no matter how many times i try your refresh link doesnt help the form page.

Not sure what could be wrong since everything else looks correct.

When you click on the "refresh" link in the top corner of the form frame does it stay the same?

[mflorell]

At this point I don't really know what the problem would be. We have installed hundreds of systems with vicibox in the last year and we just don't run into this problem.

[douglaswscott]

Downloaded the 32 bit iso and installed it on dialer16, ran web and telephony from 16 pointed db at 10.10.0.10...

Same error using this other software.


We are going to go from 48 to 80 + seats this week and I do have a dedicated mysql server. All of the production servers are Dell Poweredge 6850's with dual quads.

*** A Side question, how do I set the inbound so that overflow will go to another call center?? ***

At this point I don't really know what the problem would be. We have installed hundreds of systems with vicibox in the last year and we just don't run into this problem.

[mflorell]

You can use "No Agent No Queue" to have calls go somewhere else when there are no agents available to take a call.

[douglaswscott]

I am set to no agent no queue now, and the vicibox iso 32 bit - same issue.... with :
VERSION: 2.4-330c BUILD: 110802-0122 Server: 10.10.0.16

ERROR: no custom list fields table

refesh link clicked many times on page still same error.

running an inbound_manual

You can use "No Agent No Queue" to have calls go somewhere else when there are no agents available to take a call.

[mflorell]

OK, well something has to be configured wrong somewhere then.

Is this on a new install or did you dump and move you existing database over to the new install?

[douglaswscott]

I installed all except the sql.

OK, well something has to be configured wrong somewhere then.

Is this on a new install or did you dump and move you existing database over to the new install?

[mflorell]

Could you explain in more detail exactly what you mean by that?

[douglaswscott]

I choose not to install sql on the dialer as an option during install and pointed it at my dedicated sql server 10.10.0.10 that you already looked at the tables on..

Could you explain in more detail exactly what you mean by that?

[mflorell]

What happens when you do a full install with SQL? Does it work then?

[williamconley]

Remember: You do not have to "wipe" your old database to do this. You CAN use a database named vicidial, or asterisk2, or jehosaphat ... and then just "change it back" when done testing.

[douglaswscott]

Thank you for all of the help. I have to load up 50 more workstations the next couple days and will not be back on this project for a short time.

Remember: You do not have to "wipe" your old database to do this. You CAN use a database named vicidial, or asterisk2, or jehosaphat ... and then just "change it back" when done testing.

[tensai]

I was having this problem too. Its just when you log in and click the form field immediately without clicking dial, it would show the same error that douglas was experiencing. It doesn't seem to be working on manual dial. Will play around some more to see if I am not being a total n00b about this.

[williamconley]

if you click form without dialing it cannot work. there's no data yet.