Results 1 to 10 of 10

Hybrid View

  1. #1
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Error message when creating an account

    Check the structure of your table:
    znc_customers_info

    IF it matches this one, run this in the SQL:
    Code:
    DROP TABLE IF EXISTS znc_customers_info;
    CREATE TABLE znc_customers_info (
      customers_info_id int(11) NOT NULL default '0',
      customers_info_date_of_last_logon datetime default NULL,
      customers_info_number_of_logons int(5) default NULL,
      customers_info_date_account_created datetime default NULL,
      customers_info_date_account_last_modified datetime default NULL,
      global_product_notifications int(1) default '0',
      PRIMARY KEY  (customers_info_id)
    ) ENGINE=MyISAM;
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  2. #2
    Join Date
    Jul 2011
    Posts
    106
    Plugin Contributions
    0

    Default Re: Error message when creating an account

    Only got one more column, customers_info_source_id. This is for the 'How did you hear about us' mod by Dr Byte. I took note of the values and added it to your SQL command.
    So mine looked like this
    Code:
    DROP TABLE IF EXISTS znc_customers_info;
    CREATE TABLE znc_customers_info (
      customers_info_id int(11) NOT NULL default '0',
      customers_info_date_of_last_logon datetime default NULL,
      customers_info_number_of_logons int(5) default NULL,
      customers_info_date_account_created datetime default NULL,
      customers_info_date_account_last_modified datetime default NULL,
      customers_info_source_id int(11) default none,
      global_product_notifications int(1) default '0',
      PRIMARY KEY  (customers_info_id)
    ) ENGINE=MyISAM;

  3. #3
    Join Date
    Jul 2011
    Posts
    106
    Plugin Contributions
    0

    Default Re: Error message when creating an account

    Ajeh, managed to get it fixed.. well sort of. After posting my previous comment I realized that perhaps it may just be the 'how you hear about us' mod. So I have commented out the relevant lines out of the modules and templates files regarding the mod and creating an account works brilliant now...
    Will do a fresh install of the mod to see if it fixes itself up otherwise I think I will need to jump to Dr Bytes thread.

    Thanks so much for your help so far.

    Jay

 

 

Similar Threads

  1. 1064 syntax error when creating account
    By mayleine in forum General Questions
    Replies: 3
    Last Post: 2 Jan 2011, 11:31 AM
  2. Error when creating an account.
    By Graphicman in forum General Questions
    Replies: 4
    Last Post: 23 Aug 2010, 10:33 AM
  3. Error when creating new account
    By sinsor in forum Managing Customers and Orders
    Replies: 1
    Last Post: 17 Nov 2009, 10:14 PM
  4. [NOT A BUG] Warning message when creating new account.
    By CobraPlant in forum Bug Reports
    Replies: 4
    Last Post: 24 Nov 2007, 06:59 AM
  5. Getting error when creating account
    By shastaMatt in forum General Questions
    Replies: 2
    Last Post: 24 Apr 2007, 08:39 PM

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