This doesn’t surprise me. I was certain that the migration wasn’t done properly. But it happened so long ago, that the DEV site wouldn’t match up anymore.
Luckily the subsite has only 6 records and they are backed up. I could easily recreate them if needed.
If you forced Connections to rebuild it’s table structure, would it have any impact on the main site? The main site works properly and has over 300 records — so I wouldn’t want to jeopardize that in the process.
I’ve just made a backup of the database as a precaution. If you feel that rebuilding the table would fix the problems on the subsite and not impact the main site, then please proceed.
Thanks for helping,