Re: Anonymous to registered customer conversion
I discovered today that this add-on does not work in xcart 4.4.5 if the customer has a "special character" in their names.
For example:
i tried to create a user who's last name is O'Shaughnessy. Xcart would display an error message and shortly after i received the following email:
SQL query : INSERT INTO xcart_customers (`login`, `username`, `password`, `change_password_date`, `usertype`, `change_password`, `activity`, `status`, `language`, `membershipid`, `cart`, `referer`, `last_login`, `first_login`, `firstname`, `lastname`, `email`) VALUES ('***@hotmail.com', '***@hotmail.com', 'B-70c2b68cb973733118d286d5c678d5a6', '1377986143', 'C', 'Y', 'Y', 'Y', 'en', '0', '', '', '1377986143', '1377986143', 'John Doe', 'O'Shaughnessy', '***@hotmail.com')
Error code : 1064
Description : 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 'Shaughnessy', '***@hotmail.com')' at line 1
Request URI: /admin/order.php?orderid=300214&mode=bcse_create_user
Removing the special character allowed the user to be created
__________________
Austin!
X-Cart 4.7.7 (old) X-Cart Business 5.3.6.8 (new)
|