1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

SQL field doesn't have default value

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

  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