Full service web hosting, great prices and support. Starts at $1.99/month!
Results 1 to 7 of 7

Thread: Customers able to have several logins.. with the same email address!

  1. #1
    Senior Member
    Customers able to have several logins.. with the same email address!


    Join Date
    Sep 2009
    Location
    Vancouver, BC, Canada
    Posts
    501
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    JRR     $ 180.00
    Rep Power
    75


    Default Customers able to have several logins.. with the same email address!

    Is there an obvious way to stop people from being able to create several accounts using the same email address? (I thought we had sprayed for that!)

    I've rummaged through the settings but I must be overlooking something obvious.

    And, now that I have a few customers who had two or more accounts, is there any way to merge them into the latest version AND include previous orders?

    Trying to tie up loose ends here...

    Thanks!

  2. #2
    osCMax Development Team

    Customers able to have several logins.. with the same email address!

    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    4,164
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    ridexbuilder     $ 15.00
    Rep Power
    98


    Default Re: Customers able to have several logins.. with the same email address!

    The system *should* disallow registration using the same email address, though I noticed the same problem recently on one site. I assumed it was due to upgrading an old version of osCmax. I haven't investigated the cause, however.
    In the database, I always thought the customer email was as a key field. Looking in the customers table, for the above mentioned site, I see that it is an indexed field but not a secondary key. This suggests the create_account code isn't checking for duplicates properly..
    I believe this is where the problem was introduced:
    Code:
          $check_email = tep_db_fetch_array($check_email_query);
     //---PayPal WPP Modification START ---//     
          //if ($check_email['total'] > 0) {
          if ($check_email['total'] > 0 && tep_paypal_wpp_create_account_check($email_address)) {
    //---PayPal WPP Modification END ---//
               $error = true;
    
               $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
          }
    I'll have some further thoughts on the subject (hopefully).

    As for merging records, that becomes complex. Fortunately on the above mentioned site, the duplicated records didn't have sales attached and I was able to delete the duplicated customer records.
    Last edited by ridexbuilder; 04-23-2020 at 03:22 AM.

    Developers resource at bitbucket
    *** *** ***
    oscmax.co.uk / ejsolutions.co.uk
    Hosting plans with installation, configuration, contributions, support and maintenance.
    *** FREE osCmax hosting available ***
    oscmaxtemplates.com

  3. #3
    osCMax Development Team

    Customers able to have several logins.. with the same email address!

    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    4,164
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    ridexbuilder     $ 15.00
    Rep Power
    98


    Lightbulb Re: Customers able to have several logins.. with the same email address!

    I suggest altering that section to the following:
    Code:
          $check_email = tep_db_fetch_array($check_email_query);
     //---PayPal WPP Modification START ---//     
          if ($check_email['total'] > 0) {
          // disabled WPP mod - if ($check_email['total'] > 0 && tep_paypal_wpp_create_account_check($email_address)) {
    //---PayPal WPP Modification END ---//
               $error = true;
    
               $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS);
          }

    Note: untested but I can't see the point of the check being exclusive to PayPal Pro.

    Developers resource at bitbucket
    *** *** ***
    oscmax.co.uk / ejsolutions.co.uk
    Hosting plans with installation, configuration, contributions, support and maintenance.
    *** FREE osCmax hosting available ***
    oscmaxtemplates.com

  4. #4
    Senior Member
    Customers able to have several logins.. with the same email address!


    Join Date
    Sep 2009
    Location
    Vancouver, BC, Canada
    Posts
    501
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    JRR     $ 180.00
    Rep Power
    75


    1 out of 1 members found this post helpful.

    Default Re: Customers able to have several logins.. with the same email address!

    Jeeze ridexbuilder (Jim, isn't it?) didn't you get enough beer already?

    In case people are coming in late the file to edit is create_account.php in /catalog

    I've made the change, now let's see if it works from today on. I can see more beer in your future if it does!

    Thanks!

    John :-#)#

  5. #5
    osCMax Development Team

    Customers able to have several logins.. with the same email address!

    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    4,164
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    ridexbuilder     $ 15.00
    Rep Power
    98


    Cool Re: Customers able to have several logins.. with the same email address!

    LOL. Nope wrong name.
    "There's life, Jim but not as we know it."

    You're the Guinea Pig. Should be easy enough to test that it prevents an additional signup. Now I'll need to visit my dozen or so client sites, to make the wee change. None of the clients use Website PayPal Pro, so there shouldn't be a problem.

    EJ


    Developers resource at bitbucket
    *** *** ***
    oscmax.co.uk / ejsolutions.co.uk
    Hosting plans with installation, configuration, contributions, support and maintenance.
    *** FREE osCmax hosting available ***
    oscmaxtemplates.com

  6. #6
    Senior Member
    Customers able to have several logins.. with the same email address!


    Join Date
    Sep 2009
    Location
    Vancouver, BC, Canada
    Posts
    501
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    JRR     $ 180.00
    Rep Power
    75


    Default Re: Customers able to have several logins.. with the same email address!

    Hi EJ and anyone else reading,

    Turns out that I had about 30 duplicate customer registrations in the 5,000+ list of customers so finding them was going to be tedious without some tools.

    I downloaded the customer list from osCmax and stuffed it into my spreadsheet (Liberoffice) and sorted by email.

    Then searched online for finding duplicate data in a column...

    Then ran the formula and which highlighted the duplicates, then I simply deleted all the customers who were not duplicate/triplicate/? leaving the customers with two or more email addresses.

    Then I opened my database - taking great care to opening it using the Read/Write user, NOT the ADMIN otherwise you might break your database!

    I then looked for orders under the last name in osCmax and if found, then went to orders in the database and changed them (if more than one) to the last user number. then I deleted the earlier user.

    Hope that is clear enough!

    John :-#)#

  7. #7
    osCMax Development Team

    Customers able to have several logins.. with the same email address!

    ridexbuilder's Avatar
    Join Date
    Jul 2008
    Location
    Haggisland
    Posts
    4,164
    Contribute If you enjoy reading the
    content here, click the below
    image to support our site.
    Click Here To Contribute To Our Site

    Total Contributions For

    ridexbuilder     $ 15.00
    Rep Power
    98


    Thumbs up Re: Customers able to have several logins.. with the same email address!

    Well done. That's pretty much the approach that I'd have gone for; I did say it'd be a bit complex.

    Developers resource at bitbucket
    *** *** ***
    oscmax.co.uk / ejsolutions.co.uk
    Hosting plans with installation, configuration, contributions, support and maintenance.
    *** FREE osCmax hosting available ***
    oscmaxtemplates.com

Similar Threads

  1. [Catalog Issue] When should one use SSL? Customers having trouble with logins.
    By JRR in forum Installation/Setup
    Replies: 11
    Last Post: 08-01-2013, 07:57 AM
  2. Replies: 3
    Last Post: 03-02-2012, 01:30 PM
  3. [Core Hack] Adding email address and phone number to Order Email
    By ozdunker in forum Custom Mods and Hacks
    Replies: 7
    Last Post: 06-07-2011, 02:06 AM
  4. Customers can create multiple accounts - same email address!
    By JRR in forum osCmax v2 Installation issues
    Replies: 1
    Last Post: 06-14-2010, 08:17 PM
  5. customer with no email address
    By earth-friendly in forum osCMax v2 Features Discussion
    Replies: 9
    Last Post: 12-26-2008, 12:15 PM

Tags for this Thread

Bookmarks

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
  •