Welcome Visitor, Please Login or Register Now Saturday, April 20, 2024 02:28 AM 
Forums Index > Mewsoft Products > Auctionawy > Apostrophe problem
New Topic   New Reply
Search for:
Author Message
AuctionWeb AuctionWeb's personal page
Registered Member
Posts: 52 Display member's posts
Joined: 04-20-24 02:28 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Apostrophe problem Edit Delete Reply with quote Quote
First Post Posted on: 02-28-08 01:50 AM next post first post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-20-24 02:28 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Apostrophe problem Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 02-28-08 02:07 AM next post previous post
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 AuctionWeb's personal page
Registered Member
Posts: 52 Display member's posts
Joined: 04-20-24 02:28 AM
Member Offline
View Member's Profile Send private message
 
Back to top
Error message Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 02-28-08 10:40 AM next post previous post
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 mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 04-20-24 02:28 AM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: Apostrophe problem Edit Delete Reply with quote Quote
Reply #: 3 Posted on: 02-28-08 11:36 AM last post previous post
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
Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print  

  Mewsoft and Mewsoft Logos are registered trademarks. ® Corporation. All Rights Reserved.  Copyright -  Privacy -  Terms of Use  Page Load: 0.1108 Seconds 
Powered by Boardawy © 2000-2011. Mewsoft Corporation