Forum Replies Created

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter cherylglenn

    (@cherylglenn)

    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!

    Thread Starter cherylglenn

    (@cherylglenn)

    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

    text/x-generic php-errors.log

    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

    Thread Starter cherylglenn

    (@cherylglenn)

    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.

    Thread Starter cherylglenn

    (@cherylglenn)

    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?

    Thread Starter cherylglenn

    (@cherylglenn)

    I’ve got a support ticket in with them as well. I think I got confused and started following some of the directions to move a site to an existing subdirectory (http://codex.wordpress.org/Giving_WordPress_Its_Own_Directory). I’m thinking the issue could be related to the moving/copying part of the instructions related to the index.php, htaccess and wp-config files?

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