This is Not a Number
"This is not a number" Error in PHPMyAdmin
While creating an SQL database in PHPMyAdmin, I repeatedly faced this error and after searching the web for a solution, I got nothing useful. Someone who asked about it in a forum was laughed at and was told to press the save button with more force and eventually it will work. People do not blog about less searched keywords, so I didn't really find a good post on this topic.
Finally I resolved the error by making all the field types either TEXT, ENUM or SET; it continually gave error while the type was VARCHAR. But this obviously wasn't the rite way to do it as some values have to be VARCHAR. So, I asked a friend and he told me to enter length in the third column, I did it and everything went alright.
So, the bottom line is that In case you get this error, fill the "Length/Values" field.
Click to enlarge the images.
Comments
Exactly, it really is quite vague, not like the other errors where messages are quite self explanatory.
Open source and community-supported software is notoriously deficient in diagnostics and technical documentation. Typical programmers don't enjoy tweaking their work to that extent.
thanks! it solved my problem. such a headache!
nihirop, I know, I have been through this and found it to be more than a headache. :P
thank u so much for the solution...i too had same problem.
thanks a lot for the info. that helped!
This error often comes up when people choose the "VARCHAR" data-type for the field's 'Type' but then forget / fail to specify the max-length in in the 'Length/Values' field next to it. If you're telling MySQL that the field is a VARCHAR, you need to tell it the max length (from 1 up to 255 characters) that field will need to hold. If you're going to store more than 255 characters, use a TEXT or MEMO type.
hey thanks a lot it really helped me....
Thank you. Very helpful. I saw the other forum where they were told to press it harder...
Richard, I remember going through that forum when I was looking for a solution.
Thank you all for your comments!
Thank you *so* much.
thank you!
Thanxx,,you save me
Thanz man
Thanks a lot pal
thank you soooooo much, I was going insane asking myself WHAT is not a number!?
I also came across the same thread you talk about. People are just so rude.
You were very helpful :D
Thanks a million.
Really, tahnks a looootttt.......
Thank you!
Thanks for being so helpful. :)
thank you very much ...that was use full for me :)
Thanks that saved me time as well, very helpful!
Than you, it is useful, a lot more useful than post on that forum. You should have included link or something of the sort so that people would see.
Thanks, my table was finally created!
thanks a million - saved me lots of energy!
soooooooooooooooo cooooool man, u are the real valuable guy, indeed the blogs are talking trash about it, u got that answer, thumbs up!
Thank you, this was really helpful!
Diddent work.. all my varchar values has 255
Thanks for the tips anyway! But i will have to try to press even harder. Brute?
thanks .........!!
Thanks man :)
Really Helped me out
Thank you for the helpful hub!
$r1 = -31.03;
$r2 = 28.63;
$r5 = log($r1/$r2);
This is generating Nan error, can you solve it.
**r1 and $r2 are two different expression output obtained from array;
MyWebs 2 years ago
I have got that error before several times. That PHPMyAdmin error message is rather vague.