SEOClerks

Assisting with 404 cleanup

Assisting with 404 cleanup

Looking for someone that is familiar with Joomla and it's functions that can look at my 404s and make the adjustments to fix them. Almost all of these 404s are not because of the content being gone, it's because in my haste to adjust my website for "Mobile First" I must have changed names, categories, and configuration in JoomSEF. January 9th Goog;r Webmaster Tools send me a message saying that I suddenly had 8,000 404 pages and the email was a heads-up. That's how I found out.

To someone skilled with Joomla, 301s, and SEO related this might be a 15-minute job because they might see what categories 404s, and shift everything or rename + adjust with 301's or whatever fixes it. I've sat down to do this myself but it's taking me too long.

Example:

///// SECTION/OLDCATEGORY/PAGE1.PHP <<<-----incoming link 404'd

You see the category has changed

///// SECTION/NEWCATEGORY/PAGE1.PHP <<<---- you 301 the 404 to the new page

If 100 links need that then all you have to do is rename the old category name to the new category name and.....it fixes 100 404s


Everyday 8,000 "404" pages isn't helping me so I just need someone that knows what to do to takecare of this for me.

I'll start at $10 and if you get this fixed up in a week or so I won't pay you that $10, I'll add a more and pay $20.

I really ask that if you don't have experience then don't apply or offer to give it a shot. Doing this is not maybe....you either know how to 301 on-site URLs and are able to work with something like JoomSEF+SH404 or you don't because 1 small thing changed can make 1,000 extra dead 404s.No OJT, need a PRO.

If you take care of that in a week you will be paid the $20 + I'll prioritize you ahead of everyone else when I order services. Go look at my orders if it shows, between Oct 2018 till now I have literally purchased like 80 to 100 things. I have the screenshots but won't post them because of privacy.


Requirements


Skills Required

Joomla Seoexpert

Bids

most powerful niche relevant wikipedia seo backlinks

create 145+ do-follow high pr and da google penguin safe seo backlinks for extra ranking

powerful niche relevant wikipedia seo backlink for fast google ranking for $6

4000 hour watch time on youtube for $100.
order now.
thank you.

Bid On Listing Created 7 years ago in Other

Other jobs by BoulderBridges

Order Now
Process Time: 0.47769808769226

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='67288' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='67288' AND A.category=B.CATID AND A.USERID=C.USERID

/opt/clerks-staging/docroot/viewwant.php 163 () ()

SELECT * FROM seoclerks.members_recommendations WHERE USERID=736722 AND status=1 ORDER BY MRID DESC limit 11SELECT recommendation_text, FROMID, time_added FROM seoclerks.members_recommendations WHERE USERID=736722 AND status=1 ORDER BY MRID DESC limit 1

/opt/clerks-staging/docroot/include/functions/main.php 21955 getLastRecommendation() ()

SELECT * FROM seoclerks.members WHERE USERID='663157'1SELECT username FROM seoclerks.members WHERE USERID='663157'

/opt/clerks-staging/docroot/include/functions/main.php 1577 insert_get_username_from_userid() ()

SELECT * FROM ratings_buyer WHERE USERID=7367221SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=736722

/opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 67288 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Joomla Seoexpert%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 67288 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Joomla Seoexpert%' ) LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 551 () ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 67288 AND A.category=B.CATID AND A.active=1 AND A.USERID=736722 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 67288 AND A.category=B.CATID AND A.active=1 AND A.USERID=736722 LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 568 () ()

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='67288' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='67288' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc

/opt/clerks-staging/docroot/viewwant.php 835 () ()

UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='67288'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='67288'

/opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()

SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='67288' ORDER BY w.bidid ASC 1SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='67288' ORDER BY w.bidid ASC

/opt/clerks-staging/docroot/viewwant.php 1192 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=5903341SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=590334

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=6845911SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=684591

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=6984281SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=698428

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=4349491SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=434949

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

SELECT * FROM posts WHERE USERID=7367221SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=736722

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='590334'1SELECT profilepicture FROM seoclerks.members WHERE USERID='590334'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='684591'1SELECT profilepicture FROM seoclerks.members WHERE USERID='684591'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='698428'1SELECT profilepicture FROM seoclerks.members WHERE USERID='698428'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='434949'1SELECT profilepicture FROM seoclerks.members WHERE USERID='434949'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='736722'1SELECT profile_data FROM seoclerks.members WHERE USERID='736722'

/opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.3060931SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.viewcount desc LIMIT 0,400.3060930.306093
0.1982531SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.1982530.198253
0.1221021SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 67288 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Joomla Seoexpert%' ) LIMIT 40.1221020.122102
0.1220921SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 53031 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Marketing Plays Socialmedia%' ) LIMIT 40.1220920.122092