Database Error 1054
Posted: 02 September 2010 11:18 PM   [ Ignore ]
Wallflower
Avatar
Rank
Total Posts:  30
Joined  2010-08-10

I am getting this error when I submit an entry:

A Database Error Occurred

Error Number: 1054

Unknown column ‘field_id_24_2’ in ‘field list’

UPDATE exp_channel_data SET channel_id = ‘12’, field_id_22 = ‘test’, field_ft_22 = ‘none’, field_id_23 = ‘ing’, field_ft_23 = ‘none’, field_id_24_2 = ‘0’, field_id_24 = ‘0’, field_ft_24 = ‘none’, field_id_25 = ‘0’, field_ft_25 = ‘none’, field_id_26 = ‘0’, field_ft_26 = ‘none’, field_id_27 = ‘0’, field_ft_27 = ‘none’, field_id_28 = ‘0’, field_ft_28 = ‘none’, field_id_29 = ‘0’, field_id_30 = ‘0’, field_id_31 = ‘0’, field_id_32 = ‘0’, field_id_33 = ‘0’, field_id_34 = ‘0’, field_id_36 = ‘0’, field_id_37 = ‘0’, field_id_38 = ‘0’, field_id_39 = ‘0’ WHERE `entry_id` = ‘89’

Here is my template code:

{exp:safecracker 
         channel
="case_evaluations"
         
return="case-evaluation/form/success" 
         
class="standard"
         
entry_id="{segment_3}"
         
show_future_entries="yes"
 
}
                 
    {custom_fields}
        
<label for="{field_name}">{if required}{/if}{field_label}</label>  
        
{field_instructions} {formatting_buttons} 
        {if textarea} 
<textarea id="{field_name}" name="{field_name}" dir="{text_direction}" rows="{rows}">{field_data}</textarea>  {/if}
        {if text} 
<input type="text" dir="{text_direction}" id="{field_name}" name="{field_name}" value="{field_data}" maxlength="{maxlength}" size="50" />  {/if} 
        {if checkbox} {options}
<label class="checkbox">{option_value} <input type="checkbox" id="{field_name}" name="{field_name}[]" value="{option_value}"{checked} /></label>{/options} {/if} 
        {if radio} {options}
<label class="checkbox">{option_value}<label class="checkbox"> <input type="radio" id="{field_name}" name="{field_name}" value="{option_value}"{checked} /></label>{/options} {/if} 
    {
/custom_fields}
                        
<input id="saveForm" name="cef_saveForm" class="btTxt submit" type="submit" value="Save and Continue" />

 
{/exp:safecracker} 

Any ideas? Thanks.

Profile
 
 
Posted: 02 September 2010 11:48 PM   [ Ignore ]   [ # 1 ]
Teen Scream
Avatar
RankRankRank
Total Posts:  3541
Joined  2009-05-29

What is field_id_24?

Profile
 
 
Posted: 03 September 2010 12:07 AM   [ Ignore ]   [ # 2 ]
Wallflower
Avatar
Rank
Total Posts:  30
Joined  2010-08-10

field_id_24 is a text field:  cef_street_address

This probably isn’t related but field_id_25 is also a text field: cef_street_address_2
Is there a conflict?

Profile
 
 
Posted: 03 September 2010 12:14 AM   [ Ignore ]   [ # 3 ]
Teen Scream
Avatar
RankRankRank
Total Posts:  3541
Joined  2009-05-29

There was a build that was released yesterday. Update to that and let me know if you still have problems. If you want to wait, I’m gonna put a new build out today or tomorrow that addresses some of the other issues you’ve been having.

Profile
 
 
Posted: 03 September 2010 12:38 AM   [ Ignore ]   [ # 4 ]
Wallflower
Avatar
Rank
Total Posts:  30
Joined  2010-08-10

I updated to the latest build and the error is gone. Thanks.

Profile