ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

This is Not a Number

Updated on May 3, 2010
The "This is not a number!" ERROR
The "This is not a number!" ERROR

"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.

The Right Method
The Right Method
Finally! The table was created!
Finally! The table was created!

Click to enlarge the images.

Comments

    0 of 8192 characters used
    Post Comment

    • MyWebs profile image

      Anthony Goodley 7 years ago from Sheridan, WY

      I have got that error before several times. That PHPMyAdmin error message is rather vague.

    • Ultimate Hubber profile image
      Author

      Ultimate Hubber 7 years ago

      Exactly, it really is quite vague, not like the other errors where messages are quite self explanatory.

    • nicomp profile image

      nicomp really 7 years ago from Ohio, USA

      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.

    • profile image

      nihirop 6 years ago

      thanks! it solved my problem. such a headache!

    • Ultimate Hubber profile image
      Author

      Ultimate Hubber 6 years ago

      nihirop, I know, I have been through this and found it to be more than a headache. :P

    • profile image

      sadikshya 6 years ago

      thank u so much for the solution...i too had same problem.

    • profile image

      imak 6 years ago

      thanks a lot for the info. that helped!

    • profile image

      Alex 5 years ago

      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.

    • profile image

      priyanka 5 years ago

      hey thanks a lot it really helped me....

    • profile image

      Richard 5 years ago

      Thank you. Very helpful. I saw the other forum where they were told to press it harder...

    • Ultimate Hubber profile image
      Author

      Ultimate Hubber 5 years ago

      Richard, I remember going through that forum when I was looking for a solution.

      Thank you all for your comments!

    • profile image

      Kelly 5 years ago

      Thank you *so* much.

    • profile image

      omar 5 years ago

      thank you!

    • profile image

      tharindudoo 5 years ago

      Thanxx,,you save me

    • profile image

      viki 5 years ago

      Thanz man

    • profile image

      Tolis 5 years ago

      Thanks a lot pal

    • profile image

      h27472 5 years ago

      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

    • profile image

      Modular 5 years ago

      Thanks a million.

    • profile image

      Shishir 5 years ago

      Really, tahnks a looootttt.......

    • profile image

      tzs 5 years ago

      Thank you!

    • profile image

      5 years ago

      Thanks for being so helpful. :)

    • profile image

      saran 5 years ago

      thank you very much ...that was use full for me :)

    • profile image

      Nathan 5 years ago

      Thanks that saved me time as well, very helpful!

    • profile image

      Axelander 5 years ago

      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.

    • profile image

      josh 5 years ago

      Thanks, my table was finally created!

    • profile image

      sarah 5 years ago

      thanks a million - saved me lots of energy!

    • profile image

      gegegee1 5 years ago

      soooooooooooooooo cooooool man, u are the real valuable guy, indeed the blogs are talking trash about it, u got that answer, thumbs up!

    • profile image

      5 years ago

      Thank you, this was really helpful!

    • profile image

      Kayser Söse 5 years ago

      Diddent work.. all my varchar values has 255

      Thanks for the tips anyway! But i will have to try to press even harder. Brute?

    • profile image

      vinod 5 years ago

      thanks .........!!

    • profile image

      Sara 5 years ago

      Thanks man :)

      Really Helped me out

    • profile image

      Sharon 5 years ago

      Thank you for the helpful hub!

    • profile image

      LinCom 5 years ago

      $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;

    • profile image

      Sandip Bastapure 4 years ago

      Realy thanks a lot!

    • profile image

      elpop 4 years ago

      Thank you :)

    • profile image

      Murali 4 years ago

      Thank you.

      Great post

    • profile image

      Anon 4 years ago

      Thanks good post

    • profile image

      Mansoor Gombe 4 years ago

      But i tried to fill in the length/Value But is still poping the same error message. any suggestion guys? tnx

    • profile image

      rifki 4 years ago

      hahahaha thanks a lot !!!

    • profile image

      umer 4 years ago

      thanks a lot bro man , ...

    • profile image

      apoorv 4 years ago

      Thanks man...i was facing the same problem.

    • profile image

      Vicky 4 years ago

      This still gave me error when I used a BLOB datatype in the field, So I created the new table without the blob object . later updated with the field which has BLOB datatype and it worked . HTH

    • profile image

      sama 4 years ago

      thank you that's so useful ^^

    • profile image

      charu 4 years ago

      thanks it helped me a lot

    • profile image

      snowdog 4 years ago

      Thank you!

    • profile image

      lzinna 4 years ago

      Thank you so much!!

    • profile image

      Dharsh 4 years ago

      You just saved my head from bursting!!

      Hail Ultimate Hubber!!!

    • profile image

      cb...! 4 years ago

      its easy way try to change ur collation value as "general latin_cs"

    • profile image

      ramabu 4 years ago

      I tried that and it still gives me the same error

    • profile image

      Shraddha 4 years ago

      Thank You !!

    • profile image

      kid 4 years ago

      thanks so much

    • profile image

      Anand 4 years ago

      thanks solved the problem in just one click on google find this link and solved...

    • profile image

      Abdul 4 years ago

      I tried pressing the Save button with force! ;-) LOL

      Thanks for your help!

    • profile image

      xa. 3 years ago

      Thanks so much. This error was frustrating me so much...I kept asking the screen "WHAT is not a number?!?!?!?"

    • profile image

      Shannon 3 years ago

      Thank you! I was getting so frustrated with that error, it's too vague to be useful!

    • profile image

      ganesh 3 years ago

      thanks this works

    • profile image

      visiting helper 3 years ago

      I did enter the values for the length/values column and the error message was still there. Then I closed PHPMyAdmin and started the whole process again and the creation of the table was a success.

    • profile image

      asdf 3 years ago

      thank u.

    • profile image

      Yahia 3 years ago

      Thank you

    • profile image

      Kashif 3 years ago

      Thankyou :)

    Click to Rate This Article