Sort 404s by frequency

Question

Sort 404s by frequency

i-make-robots opened this issue 8 years ago · 20 comments

Something like

SELECT url, COUNT(url) c, ref 
    FROM `{$table_prefix}404_to_301`
    GROUP BY url
    ORDER BY c DESC
    LIMIT 25

A big challenge is that this method is slower (count()) and does not mesh well with the existing behavior of tabling every single item separately by date.

Answer 1 · 2016-07-27T18:20:14.000Z

@i-make-robots Group By feature is added. Need testing. Will merge to master branch after testing and few other structural improvements.

You can test it by downloading and activating the dev branch here. Let me know your suggestions too 😋

Answer 2 · 2016-07-27T18:22:58.000Z

screenshots might need updating.

On Wed, Jul 27, 2016 at 11:20 AM, Joel James notifications@github.com
wrote:

@i-make-robots https://github.com/i-make-robots Group By feature is
added. Needs testing. Will merge to master branch after testing and few
other structural improvements.

You can test it by downloading and activating the dev branch here
https://github.com/joel-james/404-to-301/archive/dev.zip. Let me know
your suggestions too 😋

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#34 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABZYhr5ndITuPpBmv1LR50M6MyZmrmBxks5qZ6FegaJpZM4JKuvD
.

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Answer 3 · 2016-07-27T18:25:42.000Z

Sure. Will do that upon master merge.

Answer 4 · 2016-07-27T18:27:48.000Z

version number in dev matches live, makes installing them side-by-side
confusing.

On Wed, Jul 27, 2016 at 11:25 AM, Joel James notifications@github.com
wrote:

Sure. Will do that upon master merge.

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#34 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABZYhh2lw7ZrXB3QeB3czM8MG9iAICruks5qZ6KngaJpZM4JKuvD
.

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Answer 5 · 2016-07-27T18:29:27.000Z

i-make-robots commented 8 years ago

Answer 6 · 2016-07-27T18:29:49.000Z

see both the ref=missing link and giant checkbox on left.

Answer 7 · 2016-07-27T18:30:15.000Z

Delighted to have the new feature!

Answer 8 · 2016-07-27T18:48:16.000Z

Sorry. Forgot to tell. Just test on a staging/test site.

Answer 9 · 2016-07-28T06:31:42.000Z

see both the ref=missing link and giant checkbox on left.

Just make sure that you have NOT unchecked the ref column in screen options.

Answer 10 · 2016-07-28T06:35:32.000Z

What about CSS maxwidth on the column?

Answer 11 · 2016-07-28T06:41:47.000Z

max width was there before. I don't know why I removed that line. lol.

See here.

Answer 12 · 2016-07-28T06:42:38.000Z

No one ever said coding was easy.

Answer 13 · 2016-07-28T06:43:41.000Z

Haha. I will fix that 👍 Thanks for the heads up.

Answer 14 · 2016-11-08T17:35:12.000Z

Hi @i-make-robots

I have a complete revamped version with some cool additional features ready to publish. Would you be able to test it? Please see the new version here - https://github.com/DuckDev/404-to-301

Answer 15 · 2016-11-08T19:21:12.000Z

I have scheduled time later today to give a look see.

On Tue, Nov 8, 2016 at 9:35 AM, Joel James notifications@github.com wrote:

Hi @i-make-robots https://github.com/i-make-robots

I have a complete revamped version with some cool additional features
ready to publish. Would you be able to test it? Please see the new version
here - https://github.com/DuckDev/404-to-301

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#34 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABZYhjDpIyWiWjJg8qEHk5NABusYP_1dks5q8LLRgaJpZM4JKuvD
.

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Answer 16 · 2016-11-09T00:18:12.000Z

The settings window has widgets. the cursor has the "move widget" icon
when I hover over the titles. I can't move the widgets. I can't minimize
them, either.
Best solution probably don't show move widget icon.

On Tue, Nov 8, 2016 at 11:21 AM, Dan Royer dan@marginallyclever.com wrote:

I have scheduled time later today to give a look see.

On Tue, Nov 8, 2016 at 9:35 AM, Joel James notifications@github.com
wrote:

Hi @i-make-robots https://github.com/i-make-robots

I have a complete revamped version with some cool additional features
ready to publish. Would you be able to test it? Please see the new version
here - https://github.com/DuckDev/404-to-301

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#34 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABZYhjDpIyWiWjJg8qEHk5NABusYP_1dks5q8LLRgaJpZM4JKuvD
.

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Answer 17 · 2016-11-09T00:19:02.000Z

Maybe send support questions to the github issues page instead of your
email? Your call.

On Tue, Nov 8, 2016 at 4:18 PM, Dan Royer dan@marginallyclever.com wrote:

The settings window has widgets. the cursor has the "move widget" icon
when I hover over the titles. I can't move the widgets. I can't minimize
them, either.
Best solution probably don't show move widget icon.

On Tue, Nov 8, 2016 at 11:21 AM, Dan Royer dan@marginallyclever.com
wrote:

I have scheduled time later today to give a look see.

On Tue, Nov 8, 2016 at 9:35 AM, Joel James notifications@github.com
wrote:

Hi @i-make-robots https://github.com/i-make-robots

I have a complete revamped version with some cool additional features
ready to publish. Would you be able to test it? Please see the new version
here - https://github.com/DuckDev/404-to-301

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#34 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABZYhjDpIyWiWjJg8qEHk5NABusYP_1dks5q8LLRgaJpZM4JKuvD
.

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Answer 18 · 2016-11-09T00:21:48.000Z

This plugin was developed and being managed by a single brain, named Joel
James https://thefoxe.com/ from the "Gods Own Country"
https://goo.gl/6mpFYf, Kerala, a beautiful state of India.

This plugin was developed and is maintained by Joel James, from God's own
country - Kerala, India.

On Tue, Nov 8, 2016 at 4:19 PM, Dan Royer dan@marginallyclever.com wrote:

Maybe send support questions to the github issues page instead of your
email? Your call.

On Tue, Nov 8, 2016 at 4:18 PM, Dan Royer dan@marginallyclever.com
wrote:

The settings window has widgets. the cursor has the "move widget" icon
when I hover over the titles. I can't move the widgets. I can't minimize
them, either.
Best solution probably don't show move widget icon.

On Tue, Nov 8, 2016 at 11:21 AM, Dan Royer dan@marginallyclever.com
wrote:

I have scheduled time later today to give a look see.

On Tue, Nov 8, 2016 at 9:35 AM, Joel James notifications@github.com
wrote:

Hi @i-make-robots https://github.com/i-make-robots

I have a complete revamped version with some cool additional features
ready to publish. Would you be able to test it? Please see the new version
here - https://github.com/DuckDev/404-to-301

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
#34 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ABZYhjDpIyWiWjJg8qEHk5NABusYP_1dks5q8LLRgaJpZM4JKuvD
.

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Dan Royer, Owner, Marginally Clever Robots
https://www.marginallyclever.com/
Ph: +1 (604) 259-9564
Mo: +1 (604) 916-2281

Answer 19 · 2016-11-09T03:36:46.000Z

Thanks. Yes. That's right. Will work on the Help section today.

Were you able to test functionality?

Answer 20 · 2016-11-09T04:03:30.000Z

@i-make-robots Changes pushed as per your suggestions.

About the support question, I would like to keep it as it is. I am working a new support system.