Uknown Column in 'Field List'

What I'm trying to accomplish:

Setup a multiple selection field where the Value is an integer....but what the end user sees is text as the options to select.

example:

<select size="4" name="interests" multiple="multiple">
<option value="*" >Anything</option>
<option value="00" >Baseball</option>
<option value="01" >Basketball</option>
<option value="02" >Sky Diving</option>
</select>

Now I was told that the way to accomplish this is with Predefined Values. I set those values up and referenced the predefined list using #!list_name as the possible values.

The Problem:

After I click on Submit in the Join Now section, it errors out with something like:

Unknown column FieldName in 'Field List'

FieldName being the name of the field that I am trying to create.

This happens no matter how little data, how much data, the kind of data in the predefined list.

If I use the multiple selection field without the predefined list, it works fine....But then I cannot have the display text in the field different from the values sent to the DB.

Please help!

Also.......I noticed too that with a default install of my dolphin software....with no added fields.......It creates profiles just fine. But then when I try to view my profile using URL/username, I get error 404 Object Not Found.

Quote · 29 Oct 2009

<option value="*" >Anything</option>
-> value is not a value here, maybe a error becouse of it!!!


I will have done it like this:

1)
Settings/Predefined Values -> Create New

Name of new list: Interests

Value      LKey
1    _Baseball
2    _Basketball
3    _Sky Diving

SAVE

2)
Builders/Fields Builder -> Join Form

Add a New Items -> click on your New Item

General
Name: Interests
Caption: Interests
Type: Multiple Selector

SAVE


Click on Advanced

Multiple selector control: Select(Box)
Possible values: #!Interests

SAVE

3)
Builders/Fields Builder -> Edit Profile -> Owner

Move Item Interests from Inactive to Active Items

Click on item Interests

General
Caption: Interests

SAVE

Move Item Interests from Inactive to Active Items for Admin (and Moderator)

4)
Builders/Fields Builder -> View Profile -> Admin

Move Item Interests from Inactive to Active Items

Click on item Interests

General
Caption: Interests

SAVE

Move Item Interests from Inactive to Active Items for Member and Visitor (and Moderator)

5)
Builders/Fields Builder -> Search Profiles -> Simple

Move Item Interests from Inactive to Active Items

Click on item Interests

General
Caption: Interests

SAVE

(Move Item Interests from Inactive to Active Items for Advanced)

6)
Settings/Languages Settings

Click on Add a new language key

Make a new  language key for

_Baseball
_Basketball
_Sky Diving


7)
Then click on Compile

==============

When I try to open a Navigation Menu link or somebody's profile, I get this page: Not Found


Dolphin Documentation

Quote · 29 Oct 2009

I'll try that after work today!

Thanks.

But about the "*" value, I tried it without that as well. I did one where I inputted value=00, value=01 ...etc etc...and it gave the same error.

Quote · 30 Oct 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.