Forums Index > Mewsoft Products > Auctionawy > Apostrophe problem
AuctionWeb First Post Posted on: 02-28-08 01:50 AM
Apostrophe problem

Hi,
At registration while the "First Name" or "Last Name" includes apostrophe
(the character ' like that th'rn) an error message very not user friendly comes out.
Can it be fixed?
If not, how can this message be friendly?
How can i edit this message?

Thanks

Auction Web
mewsoft Reply #: 1 Posted on: 02-28-08 02:07 AM
Re: Apostrophe problem

I tested that on the demo and have no problem, (also please test it, you may have older versions), are you suing the free version?. The free version is 2 years old and will not be updated.

Please also post the error messsage or post your site url to test.

Mewsoft Support
www.mewsoft.com

AuctionWeb Reply #: 2 Posted on: 02-28-08 10:40 AM
Error message

I'm using the current version not the free version.
Also, try at MewSoft Demo to register user with first or last name th'rn.
Try to register User ID th'rn, also causing problems, but not fatal error.

The error message:
SQL Error: You have an error in your SQL syntax near 'rn', 'thrn', 'df', 'wer', 'ewr', 'wer', 'wer', '1231', 'United States', '213', '' at line 1
Query:
INSERT INTO Pending_Users (User_ID, Password, Email, FName, LName, Company, Job_Title, Street, City, State, Zip, Country, Phone, Mobile, Fax, Website, Payment_Method, CC_Number, CC_Name, CC_Type, CC_Month, CC_Year, Street1, City1, State1, Zip1, Country1, Start_Date, Last_Updated, Status, User_Icon, Total_Paid, Current_Balance, Last_Paid_Date, Promotional_Code, Confirmation_Code) VALUES ('jkh', '1111', 'a@a.com', 'th'rn', 'thrn', 'df', 'wer', 'ewr', 'wer', 'wer', '1231', 'United States', '213', '', '213', '231', '', '', '', '', '', '', '', '', '', '', '', '1093192149', '1093192149', '0', '', '', '', '', '123', 'TZRZ8XP7')
Line 530, File /home/httpd/vhosts/mewsoft.com/cgi-bin/na/sqldriver.pm.

Auction Web
mewsoft Reply #: 3 Posted on: 02-28-08 11:36 AM
Re: Apostrophe problem

This should be changed anyway in the new update as it is fixed in our demo. The new update will be available may be by this monday.
Thank you

Mewsoft Support
www.mewsoft.com