If this is your first visit, check our documentation. To post, register or login.
Forums / Bug Reports / [Duplicate] I believe I found a v1.3.7 defect with an apostrophe in an address?

[Duplicate] I believe I found a v1.3.7 defect with an apostrophe in an address?

Locked

Started by mumzie on 3 May 2011, 8:53 PM · Views: 1,327

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
3 May 2011, 8:53 PM
#1
mumzie avatar

mumzie

Inactive

Join Date:
Feb 2007
Posts:
211
Plugin Contributions:
0

[Duplicate] I believe I found a v1.3.7 defect with an apostrophe in an address?

Zen Cart 1.3.7.1

Database Patch Level: 1.3.7.1

Entered an order into my store. During the middle of the input, when I got an error stating "that kind of card isn't taken", I went into the admin and enabled that type of credit card. I then went back to checkout in my account, entered everything - credit card PROCESSED, but then I got an SQL error -

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 'Neill Ct. [x_city] => removed[x_state] =>removed [x_zip] => removed ' at line 1
in:
Looks to me that the error was because the apostrophe isn't supported in the address - although accepted as an address in hte cart itself. The street name is O'Neill ...
I have full text and will provide upon request...

And yes - I should update. The store is a private one, and gets about $100 of orders a quarter - it's low on the priority list.:blush:

3 May 2011, 10:08 PM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: [Duplicate] I believe I found a v1.3.7 defect with an apostrophe in an address?

mumzie:

I believe I found a v1.3.7 defect with an apostrophe in an address?
Yes, you did.
And it's been fixed in subsequent versions.
v1.3.7.1 and older are no longer officially supported.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

9 Jun 2011, 3:08 AM
#3
ginar avatar

ginar

New Zenner

Join Date:
Feb 2006
Posts:
83
Plugin Contributions:
0

Re: [Duplicate] I believe I found a v1.3.7 defect with an apostrophe in an address?

I have just upgraded to 1.3.9 and after suffering through this issue with 1.3.7 was hoping it was gone. Had our first new customer register today using an apostrophe in her business name, after the recent upgrade and she got the sql error and subsequently placed the order again. When this happens we don't get the middle 8 card digits emailed to us. Is there somewhere I can fix this?

9 Jun 2011, 5:27 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: [Duplicate] I believe I found a v1.3.7 defect with an apostrophe in an address?

Zen Cart 1.3.9 doesn't have an option to email middle digits of credit cards.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

9 Jun 2011, 5:34 AM
#5
ginar avatar

ginar

New Zenner

Join Date:
Feb 2006
Posts:
83
Plugin Contributions:
0

Re: [Duplicate] I believe I found a v1.3.7 defect with an apostrophe in an address?

I am using the CEON mod, do you think this is where the problem could be?

9 Jun 2011, 5:47 AM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: [Duplicate] I believe I found a v1.3.7 defect with an apostrophe in an address?

Might be. Might not. The error in post #1 above was from the authorize.net module and was triggered when communications activity was saved for history logging. Not sure why your add-on would be saving that info to the database for any reason when the core code already does that. Seems like a lot more information is needed to diagnose your specific problem, including the actual error message and what screen it appears on etc.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.