MySQL Errors in v.5

Discussion in 'MySQL' started by adkboards, Mar 22, 2006.

  1. #1
    I received the following error when trying to implement a new feature into my message board.

    MySQL error reported: [INSERT INTO pp_categories VALUES (1,'Main','',1,'no',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'2',0,0,0,0,0,0,0,'no', 0, '', 'no', NULL, NULL,'','','');]
    Result: Out of range value adjusted for column 'thumbnail' at row 1

    The software developer said the problem was that 'Strict Mode' was enabled on my server, which does not allow the insertion of 'NULL' values. They suggested putting MySQL into version 4 mode by changing the .ini file on the server. The problem comes that my hosting provider will not change this. Is there anything else I can do to get this statement to work? Thanks for any help you can give me.
     
    adkboards, Mar 22, 2006 IP
  2. jaymcc

    jaymcc Peon

    Messages:
    139
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Which column number is the thumbnail field, it's not clear from your insert statement.

     
    jaymcc, Mar 25, 2006 IP