21.02.2018, 19:22
I haven't looked at the content, only at the picture.
But is pretty expected to not work.
You don't have default values for the field `ConnTime` (notice the default `None`) and so it cannot insert the line.
Either give default value using phpMyAdmin or expend your INSERT INTO query to insert default value to all fields.
I'd suggest to use phpMyAdmin > go to the table > tab "SQL" > press at the bottom "INSERT INTO", it will give you a ready query and just insert in the VALUES () appropriately.
You can also use this tab to test queries by inserting random expecting values.
Try to launch the query
INSERT INTO `playerdata` (`UserName`, `Password`, `IP`, `ConnTime`) VALUES('Ducati', SHA1('password'), '192.168.0.1', 0);
Another thing, I am unsure about the fields with "blank" as default (never tried or read about it), recommend to use 0 instead of blank and/or NULL.
To what I know, 0 is either faster or space efficient than NULL.
But is pretty expected to not work.
You don't have default values for the field `ConnTime` (notice the default `None`) and so it cannot insert the line.
Either give default value using phpMyAdmin or expend your INSERT INTO query to insert default value to all fields.
I'd suggest to use phpMyAdmin > go to the table > tab "SQL" > press at the bottom "INSERT INTO", it will give you a ready query and just insert in the VALUES () appropriately.
You can also use this tab to test queries by inserting random expecting values.
Try to launch the query
INSERT INTO `playerdata` (`UserName`, `Password`, `IP`, `ConnTime`) VALUES('Ducati', SHA1('password'), '192.168.0.1', 0);
Another thing, I am unsure about the fields with "blank" as default (never tried or read about it), recommend to use 0 instead of blank and/or NULL.
To what I know, 0 is either faster or space efficient than NULL.