vicidial_lists field discrepancy on vicibox 9.0
Posted: Wed Oct 02, 2019 1:54 amHello 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;
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;