CSV is blank when I attempt to export list of participants
On the backend, I go into Participants Database > List Participants and I can see 190 contacts (with names and email addresses). If I click the Private ID to pull up the record it is blank.
Furthermore, when I attempt to export the entire database as a CSV the file is blank (except for the field labels).
In order for the private ID link to work, you need to configure the plugin with the page where you have placed the [pdb_record] shortcode. This is in the settings under the “Record Form” tab.
Normally, to edit records in the admin, you’d use the “pencil” link.
CSV will only export those field that have been configured for export by having the “CSV” checkbox ticked in the manage database fields page.
Thank you, xnau.
When I click the “pencil” link it opens a blank page (still within the plugin).
I have the CSV checkbox ticked as default on all records when they are created, so they should all be selected. Unfortunately I cannot confirm this because I can’t seem to get into a record to view all of the fields.
Other thoughts/ideas about what might be happening?
Oh, I see. In this case, you need to take a look at your PHP error log after attempting to open a record edit page. My guess is you may need to update your PHP version. The plugin requires at least 5.2, but 5.3 is recommended.
I’m admittedly not the most technical. I’m not sure how to look at the error log and not sure what it would tell me.
My PHP version is set to PHP 5.4 (FastCGI), through Bluehost.
So you PHP version is good…for the error log, install a plugin called “error log monitor” then post any errors you see after attempting to load the edit page here.
Finally got the error log plugin loaded and here are the results after 1) attempting to load the edit page and then 2) attempting to export the csv
ASCII text, with very long lines [23-Jun-2014 16:42:52 UTC] WordPress database error Unknown column 'p.2013_parade_interest_but_did_n' in 'field list' for query SELECT p.2013_parade_entry_type,p.2013_parade_interest_but_did_n,p.2013_parade_notes,p.2013_parade_participant,p.added_to_mailing_list,p.address,p.approved,p.city,p.company,p.country,p.date_recorded,p.date_updated,p.email,p.first_name,p.id,p.interests,p.last_accessed,p.last_name,p.mailing_list,p.occupation,p.phone,p.photo,p.pride_volunteer_history,p.private_id,p.state,p.website,p.zip FROM kaw_participants_database p WHERE p.id = '19' made by do_action('participants-database_page_participants-database-edit_participant'), call_user_func_array, Participants_Db::include_admin_file, include('/plugins/participants-database/edit_participant.php'), Participants_Db::get_participant [23-Jun-2014 16:43:06 UTC] WordPress database error Unknown column '2013_parade_interest_but_did_n' in 'field list' for query SELECT <code>first_name</code>,<code>last_name</code>,<code>company</code>,<code>occupation</code>,<code>address</code>,<code>city</code>,<code>state</code>,<code>country</code>,<code>zip</code>,<code>phone</code>,<code>email</code>,<code>mailing_list</code>,<code>photo</code>,<code>website</code>,<code>interests</code>,<code>added_to_mailing_list</code>,<code>approved</code>,<code>id</code>,<code>2013_parade_participant</code>,<code>2013_parade_entry_type</code>,<code>2013_parade_interest_but_did_n</code>,<code>2013_parade_notes</code>,<code>pride_volunteer_history</code> FROM kaw_participants_database ORDER BY <code>last_name</code> asc made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, Participants_Db::init, Participants_Db::process_page_request
OK I see. What has happened is your database is out of sync. Here’s how to fix it:
- make sure you are using the latest version of the plugin
- Using a database tool like PHPMyAdmin, look at the main database table: named something like wp_participants_database (the prefix may be different)
- identify the two columns with names that are close to the two columns in the error messages
- write those names down
- In the Manage Database Fields page, delete the two fields named in the error messages. The stored data will not be deleted.
- Create two new fields with names that match the names you wrote down. Set them up the same as the two fields you deleted
- Now you can edit the titles of those fields to be anything you want
Ok. I did the above.
Now when I click on the pencil I am able to edit the participant records as expected.
However, when I export the CSV I’m still getting a blank sheet with only the column headers.
Thoughts? I’m desperate to get my list exported so that I can actually USE the list!
You’ll need to see what kind of errors are happening when you try to export the CSV. Take a look at your PHP error log after attempting an export. If you don’t know how to see the error log, try installing a plugin named “Error Log Monitor”
So, when you go to export your list, are your records showing on the “participant List” page?
- The topic ‘CSV is blank when I attempt to export list of participants’ is closed to new replies.