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 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Feb 2018
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Members can not create accounts SQL error

    Members can not create accounts, and if I try to activate them they disappear does anyone know what's happening?


    ---------[SQL Error]------------------------------------------------------------------------------------------------------------
    - [29 Jan 2019 - 09:54:11] -
    User: Gregsta
    URL: /modules.php?name=Your_Account&file=admin

    File: /home/oldskool/public_html/modules/Your_Account/admin/activateuserconf.php
    Line: 73
    Message: Field 'user_rep_last_time' doesn't have a default value
    Code: 1364
    Query: INSERT INTO nuke_users (user_id, name, username, user_email, user_regdate, user_password, user_level, user_active, user_avatar, user_avatar_type, user_from) VALUES ('2', 'steven', 'koolio', '[email protected]', 'Jan 29, 2019', 'ff0e2798b97bc567d2b6bcd72c03dc46', 1, 1, 'gallery/blank.gif', 3, '')

  2. #2
    Master Coder Dormilich's Avatar
    Join Date
    Jan 2010
    Location
    Behind the Wall
    Posts
    5,803
    Thanks
    26
    Thanked 602 Times in 595 Posts
    Message: Field 'user_rep_last_time' doesn't have a default value
    You need to provide the value for user_rep_last_time in the insert query.
    The computer is always right. The computer is always right. The computer is always right. Take it from someone who has programmed for over ten years: not once has the computational mechanism of the machine malfunctioned.
    André Behrens, NY Times Software Developer

  3. #3
    New to the CF scene
    Join Date
    Feb 2018
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Dormilich View Post
    You need to provide the value for user_rep_last_time in the insert query.
    so what query do I need to put into mysql ?


 

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
  •