Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    201
    Plugin Contributions
    0

    Default Customer creation failed in updated 1.5.7

    WARNING: An Error occurred, please refresh the page and try again.
    i got this error when i tried to create a customer account.

    here is the debug file i don't know how to fix thiss[04-Aug-2020 23:36:52 UTC] Request URI: /shop/index.php?main_page=create_account, IP address: 24.113.181.201
    #1 trigger_error() called at [/home/herasonl/public_html/shop/includes/classes/db/mysql/query_factory.php:170]
    #2 queryFactory->show_error() called at [/home/herasonl/public_html/shop/includes/classes/db/mysql/query_factory.php:142]
    #3 queryFactory->set_error() called at [/home/herasonl/public_html/shop/includes/classes/db/mysql/query_factory.php:269]
    #4 queryFactory->Execute() called at [/home/herasonl/public_html/shop/includes/modules/create_account.php:341]
    #5 include(/home/herasonl/public_html/shop/includes/modules/create_account.php) called at [/home/herasonl/public_html/shop/includes/modules/pages/create_account/header_php.php:17]
    #6 require(/home/herasonl/public_html/shop/includes/modules/pages/create_account/header_php.php) called at [/home/herasonl/public_html/shop/index.php:35]
    --> PHP Fatal error: 1364:Field 'customers_info_source_id' doesn't have a default value :: INSERT INTO customers_info
    (customers_info_id, customers_info_number_of_logons,
    customers_info_date_account_created, customers_info_date_of_last_logon)
    VALUES ('1151', '1', now(), now()) ==> (as called by) /home/herasonl/public_html/shop/includes/modules/create_account.php on line 341 <== in /home/herasonl/public_html/shop/includes/classes/db/mysql/query_factory.php on line 170.
    My Multi_Site Zen Carts
    http://herasonlinemarket.com

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,684
    Plugin Contributions
    123

    Default Re: Customer creation failed in updated 1.5.7

    Be sure to open new threads for new topics. This was split off from your last thread.

    The issue here is that you have modified the customers_info table in your database to include a field called customers_info_source_id with no default value. So your choices are:

    - modify your database to set a default value for customers_info.customers_info_source_id
    - modify your includes/modules/YOURTEMPLATE/create_account.php to correctly set the customers_info_source_id field
    - remove the customers_info_source_id field from your customers_info table
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #3
    Join Date
    Mar 2004
    Posts
    201
    Plugin Contributions
    0

    Default Re: Customer creation failed in updated 1.5.7

    i tried to add this to the other thread but it said the thread was closed. thank you so much.. i will delete that row.
    Noppie
    My Multi_Site Zen Carts
    http://herasonlinemarket.com

  4. #4
    Join Date
    Mar 2004
    Posts
    201
    Plugin Contributions
    0

    Default Re: Customer creation failed in updated 1.5.7

    that worked, thank you so much again.
    My Multi_Site Zen Carts
    http://herasonlinemarket.com

 

 

Similar Threads

  1. v150 Customer account creation
    By UrKoS in forum Managing Customers and Orders
    Replies: 5
    Last Post: 28 Mar 2012, 08:08 PM
  2. v139h Customer Account Creation
    By mbschwerin in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 9 Mar 2012, 06:38 PM
  3. Customer status updated email
    By rockmellon in forum General Questions
    Replies: 2
    Last Post: 13 Sep 2009, 04:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR