vicidial_lists field discrepancy on vicibox 9.0

[bourneshell]

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;

[mflorell]

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!

[bourneshell]

It was my pleasure Matt!