Skip to main content
Solved

FSM 5.7.6 Column '' does not belong tot table xxx on save


Forum|alt.badge.img+7

I have Added a extension table to the place table. then added the new fields to the place screen. but when i go an update the one of the fields i am getting this error 


“Column '' does not belong to table imax_place_extension.”

 

Can anyone suggest where this error is coming from.

 

If i try to post the update message in the XML Poster i get the same message.

 

<perform_batch>
 <sequential_dependent>
 <update_place regex_validated="true">
 <place>
 <update>
 <original_place>
 <place_id>20759</place_id>
 </original_place>
 </update>
 <place_id>20759</place_id>
 <e_ref1>1000</e_ref1>
 </place>
 </update_place>
 </sequential_dependent>
</perform_batch>
<perform_batch_result>
 <update_place_result>
 <result type="Exception">
 <error>
 <system_error>
 <severity>ERROR</severity>
 <message>Column '' does not belong to table imax_place_extension.</message>
 </system_error>
 </error>
 </result>
 </update_place_result>
</perform_batch_result>

if i update another field on the extension table i am not getting the error

 

<perform_batch>
 <sequential_dependent>
 <update_place regex_validated="true">
 <place>
 <update>
 <original_place>
 <place_id>20759</place_id>
 </original_place>
 </update>
 <place_id>20759</place_id>
 <e_customer>20759</e_customer>
 </place>
 </update_place>
 </sequential_dependent>
</perform_batch>
<perform_batch_result>
 <update_place_result>
 <place>
 <place_id>20759</place_id>
 <e_customer>20759</e_customer>
 </place>
 </update_place_result>
</perform_batch_result>

 

Best answer by Mike The FSM TechnoGeek

I think we’d need to see your custom extension relationship from both sides, and especially would need to see the metadata for the custom extension table ‘e_ref1’ column.

My guess is you have a business rule defined for the place table that has something invalid/incomplete, and references the e_ref1 field in some way.

View original
Did this topic help you find an answer to your question?

2 replies

Mike The FSM TechnoGeek
Superhero (Employee)
Forum|alt.badge.img+17

I think we’d need to see your custom extension relationship from both sides, and especially would need to see the metadata for the custom extension table ‘e_ref1’ column.

My guess is you have a business rule defined for the place table that has something invalid/incomplete, and references the e_ref1 field in some way.


Lee Pinchbeck
Ultimate Hero
Forum|alt.badge.img+24

Hi @graeme86,

Are you able to provide the details requested by Mike above?

Alternatively, if you have found a solution to this would you be able to add that to this thread so that others may also share the knowledge? If Mike’s post gave you the answer please mark the post with Best answer to help other forum users quickly identify the solution if they have this same issue.

Kind regards,

Lee Pinchbeck


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings