Product name with '

Quote

Post by jakuba » Tue Nov 18, 2014 5:30 pm

Hi, I have products and in name are symbols ' like "Jack Daniel's" this products I can not order. Button Continue in checkout do not respond.

I remove this symbol and it is working.

How fix this? It is old MYSQL server?

Code: Select all

Server: Localhost via UNIX socket
Verze MySQL: 5.5.40-0+wheezy1
Verze protokolu: 10
Uživatel: superdrinks@localhost
Znaková sada v MySQL:  UTF-8 Unicode (utf8) 
Webserver
Apache/2.2.22 (Debian)
Verze MySQL klienta: 5.1.73
Rozšíření PHP: mysqli
OC 1.5.6.4

Error log was shown only for keyword like :

Code: Select all

Error: 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 'product_id=833'' at line 1<br />Error No: 1064<br />SELECT COUNT(`keyword`) AS total FROM url_alias WHERE keyword = 'Hardy-Noces- d'Or' AND query <> 'product_id=833'
jakuba
Active Member
Posts
509
Joined
Fri Jul 08, 2011 12:51 am
Location - CZ-Prague
Top

Re: Product name with '

Quote

Post by uksitebuilder » Tue Nov 18, 2014 7:18 pm

What did you enter for the Product SEO Keyword ?

Or do you use an extension that generates SEO Keywords for you on the fly ?
If so, what did it create as the SEO Keyword for that product ?
User avatar
uksitebuilder
Guru Member
Posts
7716
Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom
Top

Re: Product name with '

Quote

Post by jakuba » Tue Nov 18, 2014 7:56 pm

keywords are not the issue. I know this is bug and I remove it from this field.

I need to know why is not working order products with this symbol. It is issue mysql? How repair this and use ' in future?
jakuba
Active Member
Posts
509
Joined
Fri Jul 08, 2011 12:51 am
Location - CZ-Prague
Top

Re: Product name with '

Quote

Post by Dhaupin » Wed Nov 19, 2014 12:11 am

I tried this out in a test store that doesn't have SEO urls and it worked with apostrophe (and single quote) in title like you tried. Have you tried making just a test SEO url and trying it? Something like www.example.com/jack-daniel's

Generally its best practice to escape that single quote from strings using a back-slash. In the case of the title, it is based on ID in cart/checkout, so i would also lean towards its not the title field causing the hang. Even though it would be technically correct to escape it in titles, it would literally render the backslash like "Jack Daniel\'s" in product view.

I guess due to your location too, is your single quote on the keyboard the same as ' multi-purpose quote?

https://creadev.org | support@creadev.org - Opencart Extensions, Integrations, & Development. Made in the USA.

User avatar
Dhaupin
Active Member
Posts
835
Joined
Tue May 13, 2014 3:45 am
Location - PA
Top

Re: Product name with '

Quote

Post by jakuba » Tue Nov 25, 2014 2:09 am

seo keyword and url link are not the issue.

Bug is in SQL when I have 'jack daniel's' it is not working final button in checkout process and order is not send
jakuba
Active Member
Posts
509
Joined
Fri Jul 08, 2011 12:51 am
Location - CZ-Prague
Top

Re: Product name with '

Quote

Post by Dhaupin » Tue Nov 25, 2014 3:17 am

Did you try my suggested test?

Is your quotation mark an '?

https://creadev.org | support@creadev.org - Opencart Extensions, Integrations, & Development. Made in the USA.

User avatar
Dhaupin
Active Member
Posts
835
Joined
Tue May 13, 2014 3:45 am
Location - PA
Top

Re: Product name with '

Quote

Post by jakuba » Thu Dec 11, 2014 3:20 am

Yes, it is ' a.k.a '

I do not
jakuba
Active Member
Posts
509
Joined
Fri Jul 08, 2011 12:51 am
Location - CZ-Prague
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: Amazon [Bot] and 44 guests