Bulk approval

joanneparra
(@joanneparra)

8 years, 1 month ago

Bulk approval does not seem to be working. When I’m in List Participants, I select all of the visible records, change “with selected” to approve and then click apply. I get the popup box that asks if I want to approve the selected records and say yes, but the records aren’t being approved.

I’m able to approve the records one by one, but as I have a volunteer who is entering about 150 records per day, that’s not practical.

I’m logged in as a site admin and my volunteer is logged in as an editor.

Is there a setting I’m missing somewhere?

Viewing 14 replies - 1 through 14 (of 14 total)

Plugin Author Roland Barker
(@xnau)

8 years, 1 month ago

In order for this to work, your “Approved” field needs to be named “approved” It is one of the default fields that is included in the plugin when it is first installed. If you are using a different field for your approval field, the bulk approval won’t work.

Thread Starter joanneparra
(@joanneparra)

8 years, 1 month ago

I am using the default field that was installed with the plugin. Here’s what it looks like: http://prntscr.com/jg8pv7

Plugin Author Roland Barker
(@xnau)

8 years, 1 month ago

OK, looks good. I really don’t know why it’s not working for you, I just tested it again, and it’s OK. What do you see that tells you it’s not working?

Thread Starter joanneparra
(@joanneparra)

8 years, 1 month ago

When I go into an individual record and check the approval box, the status under the approval column in List Participants changes to yes. I’m also able to find the record when I search.

When I try to do a bulk approval, the status in the approval changes from a no to a blank and I’m not able to find those records when I search.

Plugin Author Roland Barker
(@xnau)

8 years, 1 month ago

I’m sorry, I’m unable to see what’s going wrong here. Do you get the confirmation message afterwards? Are you able to see your php error log for anything that pertains to this?

Thread Starter joanneparra
(@joanneparra)

8 years, 1 month ago

I am getting a confirmation message that says “Approval status for xx records has been updated.”

I checked the error logs, and this is what I see:
PDb_List_Admin::_process_general
action: approve
query: UPDATE wp_participants_database SET approved = ” WHERE id IN ( ‘3’,’4′ )

It’s definitely changing the approval status from NO, but it’s not changing it to YES, if that makes any sense?

Would it help if I gave you a temp login for my site so that you could see?

Plugin Author Roland Barker
(@xnau)

8 years ago

If that is the case, I would suspect the “values” parameter of the approved field is somehow hot getting parsed right. This is where the function gets the string that is used to save a “yes” state. Maybe check that for spurious characters or something? It looked right in your screenshot, so something invisible.

andyt1980
(@andyt1980)

8 years ago

Were you able to find the cause of this? – I’m having the same problem, bulk approval isn’t changing the status of the record to yes or no.

Plugin Author Roland Barker
(@xnau)

8 years ago

I was unable to find a specific bug that caused this problem. The best this I have for this at the moment is to make sure that the “values” parameter of the “approved” field is simply:

yes,no

Making sure there are no invisible characters in there. An easy way to do that is to blank it out and retype it.

andyt1980
(@andyt1980)

8 years ago

I would really appreciate any further help with this as we really need this feature for bulk displaying/hiding records as required.

– Things I’ve tried so far, cleared out values field and retyped in yes,no
– De-activated/Re-activated plugin
– Re-imported sample data so they are already set to the default value of no, then tried bulk approving

For your information, both the ‘delete’ and ‘unapprove’ options DO work in the with selected: dropdown, but the ‘approve’ option doesn’t.

andyt1980
(@andyt1980)

8 years ago

I’ve been able to reproduce the error on a clean install of WordPress. I confirmed the default approved field that comes with the insatllation was working. I then deleted it and re-created it exactly as it was before and the batch approval stops working.

Plugin Author Roland Barker
(@xnau)

8 years ago

Thanks, that’s helpful info. I’ll be taking a look at that today.

Plugin Author Roland Barker
(@xnau)

8 years ago

I found the issue, it will be fixed in the next release. You can fix it yourself right away if you want.

In the plugin file classes/PDb_List_Admin.class.php on line 439, you’ll see:

list ( $yes, $no ) = maybe_unserialize( $approval_field->values );

change it to:

list ( $yes, $no ) = array('yes','no');

andyt1980
(@andyt1980)

8 years ago

Excellent, I actually looked at that line myself as it was mentioned in the debugging log, but my PHP knowledge wasn’t good enough to suggest a fix.

I can confirm that it’s fixed it for me too 🙂

Viewing 14 replies - 1 through 14 (of 14 total)

The topic ‘Bulk approval’ is closed to new replies.