Forums / All Other Contributions/Addons / PCI error: Potentially Exploitable Database Error Message -- links_alias table

PCI error: Potentially Exploitable Database Error Message -- links_alias table

Locked

Started by srigari on 20 Jun 2009, 7:24 PM · Views: 2,366

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
20 Jun 2009, 7:24 PM
#1
srigari avatar

srigari

New Zenner

Join Date:
Dec 2008
Location:
USA
Posts:
61
Plugin Contributions:
0

PCI error: Potentially Exploitable Database Error Message -- links_alias table

I am using 1.3.8a with installed the security patch.
I ran McAfee PCI test on the site. It reported a "Potentially Exploitable Database Error Message" error.

Details:

http ://www.salevalley.com/ad_click.asp/banner_id//'

error msg on the site

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 '/%' ) ORDER BY length(link_alias) DESC' at line 1
in:
[SELECT DISTINCT link_url, link_alias FROM links_aliases WHERE (link_alias LIKE '%/ad_click.asp/%' OR link_alias LIKE '%/banner_id/%' OR link_alias LIKE '%//%' OR link_alias LIKE '%/'/%' ) ORDER BY length(link_alias) DESC]

Please help me to solve this.

20 Jun 2009, 8:35 PM
#2
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: PCI error: Potentially Exploitable Database Error Message -- links_alias table

Please do a search for this
this is a false positive

Zen cart PCI compliant Hosting

20 Jun 2009, 10:57 PM
#3
srigari avatar

srigari

New Zenner

Join Date:
Dec 2008
Location:
USA
Posts:
61
Plugin Contributions:
0

Re: PCI error: Potentially Exploitable Database Error Message -- links_alias table

I checked on other Zencart sites. I see "404 page not found" So the problem is specific to my site. One more thing I see is my site is not going to "404" at all, if I give a random text after the domain name , instead it is going to my home page.

20 Jun 2009, 11:08 PM
#4
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,737
Plugin Contributions:
0

Re: PCI error: Potentially Exploitable Database Error Message -- links_alias table

What SEO add on are you using?

Please do not PM for support issues: a private solution doesn't benefit the community.

Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

20 Jun 2009, 11:19 PM
#5
srigari avatar

srigari

New Zenner

Join Date:
Dec 2008
Location:
USA
Posts:
61
Plugin Contributions:
0

Re: PCI error: Potentially Exploitable Database Error Message -- links_alias table

I checked on other Zencart sites. I see "404 page not found" So the problem is specific to my site. One more thing I see is my site is not going to "404" at all, if I give a random text after the domain name , instead it is going to my home page.

20 Jun 2009, 11:23 PM
#6
srigari avatar

srigari

New Zenner

Join Date:
Dec 2008
Location:
USA
Posts:
61
Plugin Contributions:
0

Re: PCI error: Potentially Exploitable Database Error Message -- links_alias table

Kim:

What SEO add on are you using?

I am using Simple SSU URL module. I checked other sites which are using the same module and I do not see this problem..

Looks like something I did somewhere is causing this problem.

The heading of this post "-- links_alias table" is a cut and paste problem. which I just removed. It should be just "Re: PCI error: Potentially Exploitable Database Error Message " This is how it is shown in McAfee error report. Sorry for the confusion.