SQL field doesn't have default value

Discussion in 'MySQL' started by gregdavidson, Mar 9, 2017.

0
  1. #1
    Hi,

    I just setup the Arfooo directory script on Godaddy shared hosting and when I try to add a category I get this error:

    (1024) B��d SQL Field 'position' doesn't have a default value (1364) Database.php line 235

    Here's a screenshot of the error I get:

    https://s15.postimg.org/tuis8nk3v/sql_error.jpg

    I have the Arfooo directory script setup on another Godaddy shared hosting account and I'm not having this problem. Perhaps the MySQL version on the latest account has been updated. Any advice to help me resolve this issue would be greatly appreciated.
     
    gregdavidson, Mar 9, 2017 IP
  2. Rukbat

    Rukbat Well-Known Member

    Messages:
    2,908
    Likes Received:
    37
    Best Answers:
    51
    Trophy Points:
    125
    #2
    Use phpMyAdmin to add a default value to the field.
     
    Rukbat, Apr 9, 2017 IP