Can't Add a row of data to any of MySql database

Wappler General Bugs
1

Wappler Version :v5.8.2
Operating System : win 10
Server Model: ?
Database Type: mysql
Hosting Type: local

Hi just trying to add a row of data or insert data into a MySQL database using Wappler and I’m getting the following error when I attempt to save.

" Error exec update query : insert into ’ database.table’
(‘ActAct’,ActFch’,‘ActNom’) values (‘2023-08-07’, ‘2023-9-07’, ‘This’) - Field ‘Actld’ doesn’t have a default value

Also Wappler is not allowing me to insert anything into the Actid ( primary key).

2

Regarding the 1st issue, the ActId column is (probably) missing the auto increment property, please check your column settings

1 Like
3

This is not a bug, but a coding error.

The error message is misleading and has often to do with the wrong data type being used. In the example that you have shown, the dates seem to be the problem.

1 Like
4

Thanks much,will check it out and see, thanks again.

5

Interesting will check these also.Thank you fpr the assist.