I had by dynamic directory all working. Then....I needed and additional field. I added a new profile property field in the dnn users module. Went to dynamic registration and added the corresponding fields there. Now my dynamic directory is missing over half my fields in the directory list. And the temp table is not building. The log viewer says
InnerException: Invalid column name 'Sex1'. Invalid column name 'Sex1'. Invalid column name 'LGHEIRep'. Invalid column name 'LGHEIRep'.
My new field name was LGHEIRepApproval so I'm thinking that there was some conflict. I have sense deleted the field, forced the rebuild in the scheduler but I now have 2 record users host and admin in the temp tables and only about half the fields.
What do you suggest I do to get the table to rebuild correctly. I have looked at the dnn user table and user profile and all the 700 users with their profile info is there. So it is definitly the rebuild. Can I just delete the two temp tables and let them rebuild?