Forums (Obsolete)

Member

jjason-digiknow - 6/12/2012 4:03:05 PM

New System Table Fields are missing

I just added about 10 new fields to the Users system table (Site Manager > Development > System Table > User > Fields).

I clicked over to the Alternative Forms tab to set up a custom form and noticed only the first new field was showing in the list of available fields. Clicking back over to the Fields tab confirmed that 9 of the new fields were indeed missing. Fearing they were simply deleted I attempted to add the first missing field back into the table. However, I received an error about fields requiring unique names, meaning my fields still exist within the table.

My question is, how can I get to them and hopefully restore them?

Keep in mind I can only work on the front end, I'm not a back end developer and do not have access to the database directly.

Thanks in advance for any suggestions!
-Justin


Kentico Support	kentico_jurajo - 6/12/2012 7:20:30 PM RE:New System Table Fields are missing Hi, Have you tried restarting the application? It seems that the memory and its hash tables was not refreshed with new values (Site Manager -> Administration -> System -> Restart application). Best regards, Juraj Ondrus


Member	jjason-digiknow - 6/13/2012 6:54:04 AM RE:New System Table Fields are missing Hi Juraj, I restarted the application but the fields are still missing. Thanks for the tip though! -Justin

Member

jjason-digiknow - 6/13/2012 11:46:21 PM

RE:New System Table Fields are missing

I ended up having a back end developer look at the db tables.

The CMS_User table had columns for each of the fields I created but their attributes were empty.

I had him delete the columns and I am now able to add them back in again. So far they are working good.

While my issue is resolved I still don't know what caused it.


Member	jjason-digiknow - 6/14/2012 3:58:11 PM RE:New System Table Fields are missing The struggle continues. After adding my fields back into the system I made a round of changes today only to find them reverted an hour later. No idea what is happening. At least the fields still exist. I just can't make changes to them reliably.

Kentico Support

kentico_jurajo - 6/14/2012 4:25:02 PM

RE:New System Table Fields are missing

Hi,

Were there made any customizations to the CMS?
What is the exact version you are using? Have you tried applying the hotfix?

It is working fine on my end. My suspicion is that some custom code is affecting this - I have not seen this issue before and also I am not aware of any other customers having this problem - I am pretty sure that someone would already complain since it is pretty often used.

Could you please describe also all the steps you have made in details?

Best regards,
Juraj Ondrus