Column cannot be null

I tried GetSQLValueString($_POST[‘images’], “%s”));getting
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘)’ at line 1

And what does the manual tell you?

$_POST[‘images’]=‘images’; added code and fixed:smiley:
but now is problem name ,comment and images not same row in db

I ran into this problem a long time ago. It’s because newer versions of the MySQL server requires you to insert data into NOT NULL columns or have the column set to NULL. IMO, you should already be setting your columns to NULL and not NOT NULL because it doesn’t make sense to have a NOT NULL column when at times, that column will have nothing in there to begin with. NULL and being an empty column IMO is pretty much the same thing. Since there is no data to present, the returned value will be a boolean of false.

i tried didn work

Set the column to NULL, try the query again, and report back with what actually happened. Saying the word “doesn’t work” doesn’t really tell anyone anything.

2 Likes

Column ‘images’ cannot be null
that is what am getting

I am talking about setting the image column in the database as NULL. Not in your code. If it doesn’t work, please provide the exact error message or a screenshot of it so we know what’s going on.

it is same message

Tomcat Started/Stopped with errors, return code: -1073741510
is this cause problem or maybe not

I have no clue what you are doing. Changing a column in your database doesn’t effect your Apache server. Can you please stick to the questions? I am guessing you are touching random things to get this to work which is actually making it worse. Just stick to the questions and directions.

1 Like

ok :slightly_smiling_face:

Tomcat is for JSP, not your regular PHP use so what you posted is way way off-topic.

2 Likes

I got fixed,i am good.:sunglasses:

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.