I have a user input to a collection - it works in the preview but not onces the site publishes.

Do you get WARNINGS in your LIVE DB ?