osCmax v2.5 User Manual
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

New Account filtering

This is a discussion on New Account filtering within the osCmax v2 Customization/Mods forums, part of the osCmax v2.0 Forums category; Thanks for the details...really helped. Now it gives me this: 1064 - You have an error in your SQL syntax; ...

      
  1. #11
    New Member
    Join Date
    Sep 2009
    Posts
    21
    Rep Power
    0


    Default Re: New Account filtering

    Thanks for the details...really helped. Now it gives me this:

    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

    select customers_language_id from customers where customers_id =

    I'm sure I could figure it out, but what I can't figure out is what file am I looking in for this? I checked members.php, member-mail.php etc...

  2. #12
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Default Re: New Account filtering

    Did you run the SQL update for database (if there was one?)

    Regards
    pgmarshall
    _______________________________

  3. #13
    New Member
    Join Date
    Sep 2009
    Posts
    21
    Rep Power
    0


    Default Re: New Account filtering

    I did, but it was before installing this contribution. I'm still going through the coding line by line for it.

  4. #14
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Smile Re: New Account filtering

    Hi there,

    Did you apply NEMROD34's fix posted on the osCommerce site?

    I have looked at login.php on osCmax and updated the fix for you ... I don't know if this will work but it worth a try ...

    Find on line 41

    Code:
    $check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_group_id, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
    and replace with

    Code:
    $check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_lastname, customers_group_id, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
    See if that does the trick ...

    Regards,
    pgmarshall
    _______________________________

  5. #15
    New Member
    Join Date
    Sep 2009
    Posts
    21
    Rep Power
    0


    Default Re: New Account filtering

    Thanks for the try....didn't change anything unfortunately. I'm just wondering where the "language" file is that I may have to change or delete.

  6. #16
    osCMax Development Team
    pgmarshall's Avatar
    Join Date
    Feb 2009
    Location
    London
    Posts
    2,678
    Rep Power
    49


    Default Re: New Account filtering

    Look in catalog/includes/languages/

    for english.php

    and then in the subfolder english/

    Regards,
    pgmarshall
    _______________________________

Page 2 of 2 FirstFirst 12

Similar Threads

  1. No account
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 05-19-2008, 02:00 AM
  2. No account
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 05-16-2008, 07:30 AM
  3. No account
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 05-16-2008, 06:10 AM
  4. No account
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 05-15-2008, 04:12 PM
  5. Create Account,Checkout,My Account, Language Pictures probs!
    By Mikey in forum osCommerce 2.2 Installation Help
    Replies: 0
    Last Post: 03-08-2004, 10:20 PM

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
  •