vicidial_lists field discrepancy on vicibox 9.0

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

vicidial_lists field discrepancy on vicibox 9.0

Postby bourneshell » Wed Oct 02, 2019 1:54 am

Hello everyone!

Just wanted to share our experience when we were trying to migrate to vicibox 9.0.

We were migrating a couple of our boxes to the latest version of vicibox and we came across a discrepancy on the field structure

The old server was on DB Schema: 1561

When we were migrating the vicidial_lists table we kept on getting the field count error. Even if he have already ran the upgrade_2.14.sql script on the database that came from the old server. So what we did was we compared both tables and notice that the field "cache_count_dialable_new" does not exist on the vicibox 9 install.

To fix this issue we ran the following commands on the vicibox 9 DB server.

ALTER TABLE vicidial_lists DROP cache_date;
ALTER TABLE vicidial_lists ADD cache_count_dialable_new INT(9) UNSIGNED default '0';
ALTER TABLE vicidial_lists ADD cache_date DATETIME;
https://www.dialer.host/
bourneshell
 
Posts: 29
Joined: Mon May 14, 2018 12:55 pm

Re: vicidial_lists field discrepancy on vicibox 9.0

Postby mflorell » Wed Oct 02, 2019 8:21 am

This was a problem with the create database sql file, not specifically an issue with VICIbox. It has been fixed in svn/trunk so it shouldn't happen again.

Thanks for reporting the issue!
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: vicidial_lists field discrepancy on vicibox 9.0

Postby bourneshell » Wed Oct 02, 2019 8:23 am

It was my pleasure Matt!
https://www.dialer.host/
bourneshell
 
Posts: 29
Joined: Mon May 14, 2018 12:55 pm


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 133 guests