View Issue Detail

ID	Project	Category	Submitted / Last Updated
01907	UserSpice	Misc	2023-10-26 11:31:18 / 2024-01-28 21:53:04
Reported	Sina Banan	Resolved By	Dan Hoover
Priority	none	Reported	5.6.4
Status	resolved fixed	Resolution Version and Commit	5.6.7
Summary	Can&#039;t insert JSON field by DB-&gt;insert
Description	The code is: $logic_detail = array( &#039;pre1&#039; =&gt; $pre1, &#039;pre2&#039; =&gt; $pre2, &#039;conc&#039; =&gt; $conc, ); $resaon_params = array( &#039;reaction_type&#039; =&gt; $reaction_type, &#039;reason_type&#039; =&gt; $reasoning_type, &#039;logic_detail&#039; =&gt; $logic_detail, &#039;reason&#039; =&gt; $comment, &#039;react_user_id&#039; =&gt; $user-&gt;data()-&gt;id ); $reas_result = $db-&gt;insert(&#039;reasonings&#039;, $resaon_params); the logic detail is a JSON constraint in the DB, I return error for this array even I tried with JSON_encode(), it still returns errors from the db

October 2023

I would start by calling dnd($db->errorString()); right after your insert to see if you could be getting some unrelated error Can you tell me what that says? I also encourage you to pop over to discord as you may get a response faster.