SEO keywords case sensitive?

Quote

Post by mixxin » Fri Aug 17, 2012 6:59 am

I have two shops, one is using V1.5.3.1 and the other V1.4.9.3.

On both stores, if you try to go to a URL which does not use the exact case sensitive SEO keyword you get a "The page you requested cannot be found" error.

i.e. http://demo.com/Apple vs http://demo.com/apple

I tried searching the forum but cannot find any threads relating to this. This is quite a major issue for backlinks etc.

Z
mixxin
Newbie
Posts
16
Joined
Thu Sep 23, 2010 9:03 am
Top

Re: SEO keywords case sensitive?

Quote

Post by mixxin » Fri Aug 17, 2012 7:24 am

Ok looks like it has something to do with my code in htaccess, trying to sort it out.
mixxin
Newbie
Posts
16
Joined
Thu Sep 23, 2010 9:03 am
Top

Re: SEO keywords case sensitive?

Quote

Post by MrSmileyJr » Mon Dec 17, 2012 9:47 am

my research has shown to possible solutions:

apache mod_spelling:

<IfModule mod_speling.c>
CheckCaseOnly On
CheckSpelling Off
</IfModule>

or
a custom 404 page:
http://www.forbrugerportalen.dk/sider/c ... nglish.htm

Never lose data again! Use Dropbox - DO THIS BEFORE YOU SIGNUP for Extra Space!!
http://db.tt/inKP3mv Signing up via this link gives you a bonus of 256 MB
More Bonuses: http://www.dropbox.com/free .5 GB
http://www.dropbox.com/edu = double your bonus referrals by giving an edu address.
Total ~ 3gb

MrSmileyJr
New member
Posts
39
Joined
Fri Mar 11, 2011 5:07 am
Top

Re: SEO keywords case sensitive?

Quote

Post by Traces » Tue Dec 18, 2012 12:44 am

I'm having this problem too! Any news?
Traces
Newbie
Posts
5
Joined
Mon Dec 17, 2012 7:31 am
Top

Re: SEO keywords case sensitive?

Quote

Post by joshgeake » Fri Jul 12, 2013 12:08 am

It's not a problem, it's deliberately so you don't have duplicate page content.

If you *really* want it then go to /catalog/controller/common/seo_url.php and change...

Code: Select all

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE keyword = '" . $this->db->escape($part) . "'");
to...

Code: Select all

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE LOWER(keyword) = lower('" . $this->db->escape($part) . "')");
joshgeake
Newbie
Posts
11
Joined
Fri Aug 03, 2012 10:25 pm
Top

Re: SEO keywords case sensitive?

Quote

Post by MrSmileyJr » Fri Jul 12, 2013 12:24 am

joshgeake wrote:It's not a problem, it's deliberately so you don't have duplicate page content.

If you *really* want it then go to /catalog/controller/common/seo_url.php and change...

Code: Select all

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE keyword = '" . $this->db->escape($part) . "'");
to...

Code: Select all

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "url_alias WHERE LOWER(keyword) = lower('" . $this->db->escape($part) . "')");

wouldn't your method effectively avoid the duplicate page content by effectively sending them to the lowercase version everytime?

As an aside - this functionality is necessary when your client has spent $500 printing out marketing materials with a url of mixed upper and lowercase. Wouldn't want her to find out later half her customers never got to the special page for that event... :-)

Never lose data again! Use Dropbox - DO THIS BEFORE YOU SIGNUP for Extra Space!!
http://db.tt/inKP3mv Signing up via this link gives you a bonus of 256 MB
More Bonuses: http://www.dropbox.com/free .5 GB
http://www.dropbox.com/edu = double your bonus referrals by giving an edu address.
Total ~ 3gb

MrSmileyJr
New member
Posts
39
Joined
Fri Mar 11, 2011 5:07 am
Top
Post Reply
Return to “General Support”
Who is online

Users browsing this forum: No registered users and 65 guests