04-17-2016, 07:44 AM
OK, 2 down, still one more to go.
I downloaded a new copy of corebos-master.zip (from your recommendation).
There was an index on the vtiger_field table that included the selected field. After removing the index, these 2 queries worked with no issues:
ALTER TABLE vtiger_field CHANGE COLUMN selected defaultvalue TEXT default ''
UPDATE vtiger_field SET defaultvalue='' WHERE defaultvalue='0'
I tried copying over the tabdata.php and parent_tabdata.php from the production system after they were overwritten with the corebos-master code.
However, this still happens:
FAILURE UPDATE vtiger_field SET presence = 2 WHERE tabid= AND fieldname = 'ship_pobox'
It's been a long time since this instance of vtiger 5.2.1 was setup, so there is a good possibility that changes were made to the code and database directly to remove modules and change the look and feel of vtiger. Is there something else that you can recommend?
I downloaded a new copy of corebos-master.zip (from your recommendation).
There was an index on the vtiger_field table that included the selected field. After removing the index, these 2 queries worked with no issues:
ALTER TABLE vtiger_field CHANGE COLUMN selected defaultvalue TEXT default ''
UPDATE vtiger_field SET defaultvalue='' WHERE defaultvalue='0'
I tried copying over the tabdata.php and parent_tabdata.php from the production system after they were overwritten with the corebos-master code.
However, this still happens:
FAILURE UPDATE vtiger_field SET presence = 2 WHERE tabid= AND fieldname = 'ship_pobox'
It's been a long time since this instance of vtiger 5.2.1 was setup, so there is a good possibility that changes were made to the code and database directly to remove modules and change the look and feel of vtiger. Is there something else that you can recommend?