Field 'count' doesn't have a default value

Question

Field 'count' doesn't have a default value

Closed this issue 7 years ago · 8 comments

pwlgrzs commented 7 years ago

Hello,

SQL query:
INSERT INTO servers (device, ip, info, purpose) VALUES ('Google', '8.8.8.8', 'Google DNS', '')

MySQL said: Documentatio
#1364 - Field 'count' doesn't have a default value

I'm getting this in 2 separate databases.

Answer 1 · 2017-05-29T07:27:04.000Z

I assume this is adding a new server?

I've updated it to add a default value of 0 when the record is created... can you try it now?

Answer 2 · 2017-05-29T07:33:33.000Z

Correct, when adding new server.

Now same happens to 'ups' field, so my guess is other fields touched when adding will come back with the same message.

Answer 3 · 2017-05-29T07:34:46.000Z

OK, give me a few minutes

Answer 4 · 2017-05-29T07:39:05.000Z

I've adjusted the database design to included default values (or NULL) for the date fields.. would you mind testing it?

Answer 5 · 2017-05-29T07:50:24.000Z

Retried on fresh 'install':

Error: INSERT INTO servers (device, ip, info, purpose, count) VALUES ('Google', '8.8.8.8', 'Google DNS', '', '0')
Field 'ups' doesn't have a default value

Answer 6 · 2017-05-29T12:14:37.000Z

Hey, thanks for testing again.. i've just updated the table def to allow NULL in those fields.. mind trying again?

Answer 7 · 2017-05-29T12:23:31.000Z

Good on my end now!

Answer 8 · 2017-05-29T12:25:08.000Z

Awesome.. thanks for your changes too!

I've found a bug which i'll have to sort out with the datatable.. if you have more than 10 devices, then the subsequent pages or search results don't highlight green or red when online.. i may be able to detect it differently with bootstrap but i'll have to look.