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.
More by this Author
Here are some interesting, inspirational and touching quotes about rain. I liked them and hope you will also like these quotable quotes. There's always a period of curious fear between the first sweet-smelling...
The bamboo palm (chamaedorea seifrizii) is a beautiful, commonly kept houseplant that works as an air purifier. It has a bamboo like stem and a few of these stems grow from an underground bulb of roots. Leaves are flat,...
I have collected these random facts from various sources on the internet(like Wikipedia), so they may or may not be true. Now please proceed to reading these interesting random bits. Butterflies cannot fly if their...