Incorrect integer value: '' for column 'credits' at row 1

ChrisRetr0

Member
Jun 11, 2016
39
0
Not sure about this one but Incorrect integer value: '' for column 'credits' at row 1 dunno how you fix it

MY CREDITS @JayCustom @Sledmore Sledmores plus emu btw
96vB9oF.png
 

Velaski

winner
Aug 4, 2015
562
165
Post the column of "credits" or check the first row of the columns so user id 1 probably and check if theres a number, i think you probably put a letter there.
 

JayC

Well-Known Member
Aug 8, 2013
5,505
1,401
Post the code that is inserting the user into the database, my guess is its trying to get the configured credits and you did not set anything or it does not exist.
 

JayC

Well-Known Member
Aug 8, 2013
5,505
1,401
if u havent fixed, change it to varchar and see if that works
Nah. Not good advice at all. You want to avoid using varchar in a database where you can.

Especially with something like the credit column, the emulator is updating it as a(n) integer and you should only put an integer, the same reason you would check for constraints before filling/updating a table, setting these values to int, date, text will also help defend against people putting unwanted shit in your table.
 

Users who are viewing this thread

Top