yep, not sure how common or what the exact problem is but the few cases i’ve seen people all seem to be doing a mysql dump, but when importing the db the data in fields_meta_data seems to be missing
just wish it would rebuild those fields based on what’s in vardefs :-/
ok in the end it worked, it’s some kind of a local environment issue it seems (may be a mismatch between mysql versions?). I went to get the raw .idb file for that same database from which I did the dump and then manually imported it using instructions found here:
https://dev.mysql.com/doc/mysql-enterprise-backup/3.11/en/partial.restoring.single.html
During import it threw an error about “Schema mismatch”
So I dumped current table, modified the line that creates the table so it has “ROW_FORMAT=compact” after with ENGINE=InnoDB and recreated it again and did the manual import of the idb files once again.
The re-imported the raw .idb file and voila, the fields are now in there. Very weird… But it has nothing to do with suitecrm, just some kind of an issue with how i exported and re-imported that specific table.