21280 Posts in 5729 Topics by 2600 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 259 Views |
-
[SOLVED] No value from database, for enum field

23 August 2012 at 7:13am Last edited: 1 February 2013 11:38pm
Hi All,
Still running 2.4.6 (I will get round to upgrading eventually, but my CMS has custom scripts and stuff), and I have a field added to Member for 'Title' (Mr, Miss, Mrs etc). This was defined in a new file as:static $db = array(
'Title' => "Enum('Mr,Miss,Mrs,Ms,Dr,Rev')",
etc....However, when you go into the Security tab, and edit a member, the drop down list for this field ALWAYS shows the first value, 'Mr'. I've also got other fields, such as:
'HeardFrom' => "Enum('Word of mouth,Email,Website link,Facebook,Search Engine,Other','Other')",
Which works fine. I know there's a difference where the HeardFrom has a default value, but surely that shouldn't make a difference?
I've tried all sorts to fix it, even to the extent where Title is now in the Member.php file (sapphire/security), but still doesn't work! However, the actual field in the database DOES update, but is not reflected on the form.
If you have any ideas, please please help, as this is bugging me.
Many Thanks,
MathewUpdate
It's annoying when I find posts with the same error as I have, and no solution. So, although this post is now old, I would like to add the following solution for those looking for it in the future:Apparently, because the field was called 'Title', this caused the problem. Changing it to something like 'Salutation' seemed to fix the problem.
| 259 Views | ||
|
Page:
1
|
Go to Top |

