Steven Zahm@ Eric
I took a look and what I found is not good… The primary table is missing its primary index key. And several of the support tables such as addresses and phone numbers have not structure at all, but seem to exist. honestly, I’m a little surprised it able to run at all.
My guess is when you migrated from the dev server the tables were not properly migrated. Are the tables intact on the dev server? If they are, I would suggest migrating them again. IMPORTANT, only migrate the Connections tables for this subsite only. The others may be fine, at least one other I checked seems to have the correct structure.
If you would like to compare… navigate to the Connections : Tools admin page on both the subsite you are having an issue with and the healthmanagement.com subsite which seems to be working fine. Click the System Info tab for both. Scroll down to the Table Structure.
If your dev tables are not usable either, I suppose I could force Connections to rebuild it’s table structure and import the existing entries. But there is a good chance those are lost.