Cristian
Level X3
Write the reason you're deleting this FAQ
I'm seeing this mistake time and time again. New clients with old websites have both uppercase URLs and lowercase URLs.
Google to some extent sees the two and separate entities and of course will treat them as duplicate content.
So always make sure to set this from .htaccess: www.example.com/TEST should always 301 to www.example.com/test
Always choose the lowercase as the main URL structure. Also, some website may not have duplicate URLs but it's still possible to load pages like www.Example.com/tEsT - don't know why someone will type like this buy sometimes people do.
Example: https://www.seoclerks.com/Faq leads to 404 - it should redirect 301 to lowercase URL.
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='18618' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='18618' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='134' | 1 | SELECT * FROM seoclerks.members WHERE USERID='134' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=134 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=134 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=18618 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=18618
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18618' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='18618' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=103123 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=103123
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=103059 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=103059
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=103062 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=103062
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=103094 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=103094
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=103098 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=103098
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=103114 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=103114
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=103118 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=103118
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=103193 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=103193
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='18618' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='18618' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='18618' AND status='1' AND (question like '%Uppercase Lowercase URL?%' OR question like '%Uppercase%' OR question like '%Lowercase%' OR question like '%URL?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='18618' AND status='1'
AND (question like '%Uppercase Lowercase URL?%' OR question like '%Uppercase%' OR question like '%Lowercase%' OR question like '%URL?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='17130' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17130' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='222087' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='222087' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='208786' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='208786' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='486647' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='486647' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=18618%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=18618%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='377074.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='134.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='306632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='2951.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
idealmike
As for the SEOClerks UPPER/lower case issue I agree that a rule should be created in htaccess to redirect all upper case traffic to the lower case version instead. The thing is I don't think anyone saves any of the URLS anywhere as upper case. In most cases if they did save the URL somewhere like on another site/forum or blog or something, they would be copying the URL as-is so it would be the lower case version anyway. I guess you could say that the lower case URL is the correct version of the URL and the upper case version is not. So when you look at it from that perspective, there is no real need to redirect UPPER case to the lower case version of the URL.
At the end of the day, if you're giving someone the URL to the Community Discussion here you wouldn't say oh the URL is https://www.seoclerks.com/supercalifragilisticexpialidocious. Just like you wouldn't say oh the URL is https://www.seoclerks.com/FAQ. You would say the URL is https://www.seoclerks.com/faq and give that out only because that's what it is.
However in some cases, there might be a need for it. I think not with WordPress though because WordPress has a built in URL suggest. So if you have a post on your WP site and the URL is site.com/my-long-url-slug-to-my-post and you manually typed site.com/my-long-url it would know (from the auto suggest) which URL you really wanted. It would work the same if someone manually typed your domain and the URL as well so if they had CAPS lock key on and typed SITE.COM/MY-LONG-URL it would know and redirect you to the closest matching URL. Many people don't know about this feature of WordPress but it was built in to try to reduce 404 page not found errors.
Pretty nifty really but it's not perfect and sometimes sends you to the wrong URL but it's better than seeing a 404! This has been an ongoing issue since the early days of the Internet in fact! I was reading something once by the guy who created the http protocol. He was saying that if he could go back he would have made something much less "clunkier" than all that http://www. stuff. He was saying that in hindsight he wishes he would have made it so that you couldn't even see any of that in the address bar and wishes that it didn't even exist as it's caused nothing but problems ever since and is really an unnecessary thing to have. Or something like that I can't remember in full now, I'll have to dig it up and make a discussion about it. As for the SEOClerks UPPER/lower case issue I agree that a rule should be created in htaccess to redirect all upper case traffic to the lower case version instead. The thing is I don't think anyone saves any of the URLS anywhere as upper case. In most cases if they did save the URL somewhere like on another site/forum or blog or something, they would be copying the URL as-is so it would be the lower case version anyway. I guess you could say that the lower case URL is the correct version of the URL and the upper case version is not. So when you look at it from that perspective, there is no real need to redirect UPPER case to the lower case version of the URL. At the end of the day, if you're giving someone the URL to the [url=https://www.seoclerks.com/faq]Community Discussion[/url] here you wouldn't say oh the URL is [color=#0000FF]https://www.seoclerks.com/supercalifragilisticexpialidocious[/color]. Just like you wouldn't say oh the URL is [color=#0000FF]https://www.seoclerks.com/FAQ[/color]. You would say the URL is [color=#0000FF]https://www.seoclerks.com/faq[/color] and give that out only because that's what it is. However in some cases, there might be a need for it. I think not with WordPress though because WordPress has a built in URL suggest. So if you have a post on your WP site and the URL is [color=#0000FF]site.com/my-long-url-slug-to-my-post[/color] and you manually typed [color=#0000FF]site.com/my-long-url[/color] it would know (from the auto suggest) which URL you really wanted. It would work the same if someone manually typed your domain and the URL as well so if they had CAPS lock key on and typed [color=#0000FF]SITE.COM/MY-LONG-URL[/color] it would know and redirect you to the closest matching URL. Many people don't know about this feature of WordPress but it was built in to try to reduce 404 page not found errors. Pretty nifty really but it's not perfect and sometimes sends you to the wrong URL but it's better than seeing a 404!
Are you sure you want to delete this post?