Solved

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

  • 20 March 2020
  • 2 replies
  • 168 views

Userlevel 1
Badge +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>

 

icon

Best answer by Mike The FSM TechnoGeek 8 April 2020, 17:31

View original

2 replies

Userlevel 5
Badge +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.

Userlevel 7
Badge +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