Particular field causing an error in update query (not sure if bug or not)

[TwitchBlade]

I have an update action that was working fine before completely recreating the update form. If I remove the smtp_password field from the update action, the form doesn’t throw an error, but if I add it back I get the error. It appears to be putting an empty string behind it. Doesn’t matter if I put the field at the end of the list of fields to update or in the middle somewhere.

Nothing out of the ordinary with the input code:

<input type="text" class="form-control" id="inputPassword" name="smtp_password" dmx-bind:value="scSingleData.data.qSingleData.smtp_password" required="">

The database column is just a string type field with null allowed:

Any suggestion would be greatly appreciated cause I'm banging my head against the wall.

Thanks in advance,
Twitch

[TwitchBlade]

Everything looks fine with the update query as well. That extra ‘‘, is not there.

"query": "update `apps` set `app_name` = ?, `app_home_page_id` = ?, `main_menu_id` = ?, `admin_menu_id` = ?, `user_menu_id` = ?, `primary_color` = ?, `secondary_color` = ?, `success_color` = ?, `danger_color` = ?, `warning_color` = ?, `info_color` = ?, `light_color` = ?, `dark_color` = ?, `link_color` = ?, `smtp_ssl` = ?, `smtp_host` = ?, `smtp_port` = ?, `smtp_username` = ?, `smtp_password` = ?, `smtp_sender_email` = ?, `default_user_role_id` = ?, `signed_in_redirect_page_id` = ?, `google_sync_src` = ?, `google_tag_id` = ?, `app_color_mode` = ?, `allow_user_registration` = ?, `square_production_access_token` = ?, `square_production_location_id` = ?, `square_sandbox_access_token` = ?, `square_sandbox_location_id` = ?, `use_merchant` = ? where `app_id` = ?"

[Cheese]

What version are you using @TwitchBlade? Also, have you tried rebuilding the Action itself? I can think of once or twice when I have done this things mysteriously fixed themselves...

[TwitchBlade]

7.4.1. I did try rebuilding the action with no luck. Guess I’ll try again and see if I get lucky. Perhaps I’ll rebuild the whole api file.

[Quy]

Try Open in Code Editor. Go to the step to see if something is there that is not reflected in the UI.

[TwitchBlade]

@Quy, I did try that. I’m thinking it’s something that happens at run time cause I tested leaving the smtp_password field in the update statement and then simply disabled the smtp_password input in the form, and when I submit the form, no error occurs. If I enable the input and send a value, then the error occurs.

[TwitchBlade]

Well rebuilding the whole api file didn’t work, so I thought, what if I change smtp_password to smtp_pass and for some reason that works. Wonder if there is something in the run time code that looks for column names that contain ‘password’ and it’s messed up. I guess for now I’ll go with this “work around” so I can move forward.

Not sure whether to mark this solved or not haha.