Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    May 2014
    Posts
    8
    Thanks
    1
    Thanked 0 Times in 0 Posts

    SQL Field Doesn't Have Default Value

    When I try to add a category to my PHP directory I get an error which states that the SQL field 'position' doesn't have a default value. I recently transferred my website to a new host and wasn't having this problem with the previous host. What do you think could be the problem?

    https://s17.postimg.org/n396g33gv/de...alue_error.jpg

  2. #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,713
    Thanks
    9
    Thanked 155 Times in 146 Posts
    Add a default value for that field/column then. Problem solved.


 

Tags for this Thread

Posting Permissions

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