What on earth does this error mean
Results 1 to 4 of 4

Thread: What on earth does this error mean

  1. #1
    Senior Member
    Join Date
    Apr 2005
    Posts
    1,339

    What on earth does this error mean

    I'm updating a database and update the word Bronze'

    Error is

    "Truncated incorrect DOUBLE value: 'Bronze'"

    the column is a varchar (150) so ample size.

  2. #2
    PHP Witch laserlight's Avatar
    Join Date
    Apr 2003
    Location
    Singapore
    Posts
    13,915
    What are the PHP code and SQL statements involved?
    Use Bazaar for your version control system
    Read the PHP Spellbook
    Learn How To Ask Questions The Smart Way

  3. #3
    Settled 4 red convertible dalecosp's Avatar
    Join Date
    Jul 2002
    Location
    Accelerating Windows at 9.81 m/s....
    Posts
    8,505
    Quote Originally Posted by NZ_Kiwis View Post
    I'm updating a database and update the word Bronze'

    Error is

    "Truncated incorrect DOUBLE value: 'Bronze'"

    the column is a varchar (150) so ample size.
    Whatever you're inserting is not VARCHAR, then, most likely (it may be being coerced to something else ... server may be in strict mode?). The internal RDBMS converts both the column definition and the data you sent to type DOUBLE in order to check for an appropriate value before the insert, and this check is failing. Showing the SQL statement might give us a clue as to exactly why ....
    /!!\ mysql_ is deprecated --- don't use it! Tell your hosting company you will switch if they don't upgrade! /!!!\ ereg() is deprecated --- don't use it!

    dalecosp "God doesn't play dice." --- Einstein "Perl is hardly a paragon of beautiful syntax." --- Weedpacket

    Getting Help at All --- Collected Solutions to Common Problems --- Debugging 101 --- Unanswered Posts --- OMBE: Office Machines, Business Equipment

  4. #4
    High Energy Magic Dept. NogDog's Avatar
    Join Date
    Aug 2006
    Location
    Ankh-Morpork
    Posts
    14,855
    In other words, it's probably not inserting into the column you think it is.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •