SQLSTATE[HY000]: General error: 1364 Field 'file' doesn't have a default value"

upload form was working fine but now I get a SQLSTATE[HY000]: General error: 1364 Field ‘file’ doesn’t have a default value".

Well if you haven’t assigned value to store or it is optional just make sure you have a default value in your sql table structure. Usually it is just ‘’ for empty string

I have no idea what that means… but now I get server 500 error… and this output when I inspect in chrome… https://dev.irispod.com/tuts/dmxConnect/api/Files/insertfilename.php

https://dev.irispod.com/tuts/upload1.php just trying to insert this simple field.

https://dev.irispod.com/tuts/dmxConnect/api/Files/insertfilename.php as an error when I inspect because submit button does not work.

Well depending of what tool you use to manage your database structure, I presume you have MySQL database.

With MySQL Workbench:

With phpmyadmin:
https://www.homeandlearn.co.uk/php/php12p3.html