Thread

I’m having a serious issue with the Filter By Author CP extension that is causing a lot of headaches for me.

Basically, every time I delete an entry for a member, their name disappears from the list of authors in edit section. I could understand if there were no entries for that member, but there are still several entries but now I can’t filter through the content by that author. I have several thousand entries and scrolling page by page to find entries from a particular author is very time consuming.

Is there some other alternative to edit entries from a particular member? Or is there a place in the code of the extension that can be changed?

Thanks,

Chad Boswell

Chad,

What version and build of EE are you using?
What other extensions if any are you using?

I did a quick test here and couldn’t replicate. Is this what you are doing?

I am on the Edit screen and have several entries by different authors. I can use the filter and hit search to filter these entries by author.
If I select one and delete it I can still see other entries by the same author in the folder drop-down.
Is it this step that is different for you? That the author is no longer available in the drop-down menu?

John,

Hope you’re having a good Thanksgiving Holiday. I’m using EE 1.6.9 Build 20100430.

You’ve described the problem correctly. When I delete even just one entry from the CP Edit screen for a member, their name disappears from the list of authors in the Author Filter.

All of their other entries are still visible on the Edit screen, its just now I can’t select their name to filter out entries for the future.

Here are the other Extensions I have installed:

FieldFrame (v.1.4.2)

BN Absolute Total Results (v.1.0.0)

LG Member List (v.1.2.1)

jQuery for the Control Panel (v.1.1.1)

Simple SAEF Enctype (v.0.0.1)

Low Seg2Cat (v.1.3)

User (v.3.2.1)

I appreciate any assistance I can get on this.

Thank you,

Chad Boswell

Hi Chad,

Can you please upgrade to the latest version and build so that we are troubleshooting with the latest code. Was this working at any point?

Cheers

Greg

Greg,

Sorry I haven’t responded sooner. I am concerned about upgrading because the plugins and extensions I’m using might stop working. Is there any reason that a plugin that worked for 1.6.9 wouldn’t work for 1.7.0?

Regarding your other question about the Filter By Author extension, it has never worked right since I installed it. I didn’t notice the problem right away but I started noticing the Members weren’t showing up in the Author list anymore. If I create a quick entry for them then they reappear in the list. So I’ve resorted to that if I have to delete a bunch of records for a client. I’ll delete 150 records, create a test record, then search for them again and delete another 150 records.

It seems to me that it would be better if the Filter by Author worked like the Author list inside of the publish page. It shows all members in the list.

Thanks,

Chad Boswell

Hi, Chad. Occasionally a plugin or extension might not work with newer versions. I’ve not heard of any in this case. You might want to create a local install and test with that if you’re concerned it’s an issue.

I’m posting what I did to fix this issue for myself in case someone else has this problem and needs a solution:

On line 64 of the plugin it reads:

$sql = "SELECT member_id, screen_name from exp_members WHERE total_entries > 0 ORDER BY screen_name ASC";

I removed the WHERE clause and it seems to have fixed my issue:

$sql = "SELECT member_id, screen_name from exp_members ORDER BY screen_name ASC";

Now it shows all the members in the list and their name stays in the list even after deleting all of their entries. This is exactly what I was needing.

Now if someone who knows PHP and SQL has a better solution or sees a problem with the change I made, please let me know. I haven’t seen any errors or had any issues since making this change so I feel comfortable that everything is going to be good now.

Thank you,

Chad Boswell

Glad you are up and running again and thanks for sharing. Feel free to start a new thread if you have any more questions.