This result set should be compared with the list of correct combinations-<pre>SELECT
`field`. fieldtype,
`field`.display_mechanism,
`field`.display_mechanism ASC,
customdefinedfield.cdf_datatype ASC
</pre>
----------------------------------------------------------------------This UPDATE query is just one of several that might need to be applied<pre>
UPDATE `field`
SET `field`.display_mechanism = NULL
WHERE `field`.display_mechanism = ''
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]