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

    • profile image

      Kashif 

      4 years ago

      Thankyou :)

    • profile image

      Yahia 

      4 years ago

      Thank you

    • profile image

      asdf 

      4 years ago

      thank u.

    • profile image

      visiting helper 

      5 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

      ganesh 

      5 years ago

      thanks this works

    • profile image

      Shannon 

      5 years ago

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

    • profile image

      xa. 

      5 years ago

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

    • profile image

      Abdul 

      5 years ago

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

      Thanks for your help!

    • profile image

      Anand 

      5 years ago

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

    • profile image

      kid 

      5 years ago

      thanks so much

    • profile image

      Shraddha 

      5 years ago

      Thank You !!

    • profile image

      ramabu 

      5 years ago

      I tried that and it still gives me the same error

    • profile image

      cb...! 

      5 years ago

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

    • profile image

      Dharsh 

      5 years ago

      You just saved my head from bursting!!

      Hail Ultimate Hubber!!!

    • profile image

      lzinna 

      5 years ago

      Thank you so much!!

    • profile image

      snowdog 

      5 years ago

      Thank you!

    • profile image

      charu 

      5 years ago

      thanks it helped me a lot

    • profile image

      sama 

      5 years ago

      thank you that's so useful ^^

    • profile image

      Vicky 

      5 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

      apoorv 

      5 years ago

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

    • profile image

      umer 

      5 years ago

      thanks a lot bro man , ...

    • profile image

      rifki 

      6 years ago

      hahahaha thanks a lot !!!

    • profile image

      Mansoor Gombe 

      6 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

      Anon 

      6 years ago

      Thanks good post

    • profile image

      Murali 

      6 years ago

      Thank you.

      Great post

    • profile image

      elpop 

      6 years ago

      Thank you :)

    • profile image

      Sandip Bastapure 

      6 years ago

      Realy thanks a lot!

    • profile image

      LinCom 

      6 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

      Sharon 

      6 years ago

      Thank you for the helpful hub!

    • profile image

      Sara 

      6 years ago

      Thanks man :)

      Really Helped me out

    • profile image

      vinod 

      6 years ago

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

    • profile image

      Kayser Söse 

      6 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

      6 years ago

      Thank you, this was really helpful!

    • profile image

      gegegee1 

      6 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

      sarah 

      6 years ago

      thanks a million - saved me lots of energy!

    • profile image

      josh 

      6 years ago

      Thanks, my table was finally created!

    • profile image

      Axelander 

      6 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

      Nathan 

      6 years ago

      Thanks that saved me time as well, very helpful!

    • profile image

      saran 

      6 years ago

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

    • profile image

      6 years ago

      Thanks for being so helpful. :)

    • profile image

      tzs 

      6 years ago

      Thank you!

    • profile image

      Shishir 

      6 years ago

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

    • profile image

      Modular 

      6 years ago

      Thanks a million.

    • profile image

      h27472 

      6 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

      Tolis 

      6 years ago

      Thanks a lot pal

    • profile image

      viki 

      6 years ago

      Thanz man

    • profile image

      tharindudoo 

      6 years ago

      Thanxx,,you save me

    • profile image

      omar 

      7 years ago

      thank you!

    • profile image

      Kelly 

      7 years ago

      Thank you *so* much.

    • Ultimate Hubber profile imageAUTHOR

      Ultimate Hubber 

      7 years ago

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

      Thank you all for your comments!

    • profile image

      Richard 

      7 years ago

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

    • profile image

      priyanka 

      7 years ago

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

    • profile image

      Alex 

      7 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

      imak 

      7 years ago

      thanks a lot for the info. that helped!

    • profile image

      sadikshya 

      7 years ago

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

    • Ultimate Hubber profile imageAUTHOR

      Ultimate Hubber 

      8 years ago

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

    • profile image

      nihirop 

      8 years ago

      thanks! it solved my problem. such a headache!

    • nicomp profile image

      nicomp really 

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

    • Ultimate Hubber profile imageAUTHOR

      Ultimate Hubber 

      8 years ago

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

    • MyWebs profile image

      Anthony Goodley 

      8 years ago from Sheridan, WY

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

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://hubpages.com/privacy-policy#gdpr

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)