Talk:No user in rights window

From Open-Xchange
Revision as of 11:31, 23 March 2007 by DerCisco (talk | contribs)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

What about setting defaults for that instead of changing every occurence afterwards?

Without testing and some years past since I wrote mySQL, I'd recommend something like:

 ALTER TABLE prg_contacts \
   ALTER intfield02 SET DEFAULT = null, \
   ALTER intfield03 SET DEFAULT = null, \
   ALTER intfield04 SET DEFAULT = null, \
   ALTER intfield05 SET DEFAULT = null, \
   ALTER intfield06 SET DEFAULT = null, \
   ALTER intfield07 SET DEFAULT = null, \
   ALTER intfield08 SET DEFAULT = null;



It's not a question of defaults, I'm afraid. The admin fills this table with incorrect values ('4', to be precise) when it inserts the contact corresponding to some user.

DerCisco - 23.03.2007