DEV Community

Discussion on: Build a simple app using Node JS and MySQL.

Collapse
 
apple24hrs93 profile image
APPLE 24Hrs

A VERY USEFUL POST, BUT I GET THIS ERROR EACH TIME TRY TO ADD A PLAYER :(

PD: I ONLY CHANGE "NUMBER" FOR "NUMBERO" ITS THE SAME

{"code":"ER_TRUNCATED_WRONG_VALUE_FOR_FIELD","errno":1366,"sqlMessage":"Incorrect integer value: 'undefined' for column 'numbero' at row 1","sqlState":"HY000","index":0,"sql":"INSERT INTO players (first_name, last_name, position, numbero, image, user_name) VALUES ('Joseph Bryan', 'Gonzalez Ruiz', 'Midfielder', 'undefined', 'code.jpeg', 'code')"}

Collapse
 
achowba profile image
Prince

Sorry for the delayed reply, I think you should also check the sql statement that creates the database and also change the "number" to "numbero"