Title: Manage Database Fields Issue
Last modified: September 8, 2021

---

# Manage Database Fields Issue

 *  [rcgtech](https://wordpress.org/support/users/rcgtech/)
 * (@rcgtech)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/manage-database-fields-issue/)
 * When managing the Database Fields either adding new, or updating some original,
   when clicking Update fields, get a white page, can’t find any errors preventing
   this.

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

 *  Thread Starter [rcgtech](https://wordpress.org/support/users/rcgtech/)
 * (@rcgtech)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/manage-database-fields-issue/#post-14852039)
 * Using WordPress 5.8 and PHP 7.4.23
 *  Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/manage-database-fields-issue/#post-14852671)
 * White page indicates a fatal php error, which should be visible in your php error
   log.
 * One of the things that can cause this is too many fields in the field group, 
   resulting in a big submission that hits the server’s post_max_size limit. Since
   you can’t save the page to reassign the field group, you may have to alter the
   database entry directly to assign fields to another group. This will be in the
   wp_participants_database_fields table.
 * If you don’t have a large number of fields in the group, make sure you’re using
   the latest version of Participants Database, should be at least 1.9.7.6. Also
   any other Participants Database add-ons should be up to date.
 * If that checks out, you should set up your php error log. You say you don’t see
   any errors, I don’t know where you’re looking, but there should be an error in
   your php error log. That will contain the information needed to analyze the problem.
 *  Thread Starter [rcgtech](https://wordpress.org/support/users/rcgtech/)
 * (@rcgtech)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/manage-database-fields-issue/#post-14853085)
 * Thanks for the reply, I’ll try that with seperating my fields to another group.
   I did try to increase my post_max_size from 16M to 32M, which still getting a
   blank screen. I did try to go to advanced and set logging to verbose or even 
   plugin level, but the debugging log still isn’t showing a reason as to why the
   white page.
 * Another note now, trying to download the participant database, and I’m getting
   a weird database error.
 *     ```
       WordPress database error: [Unknown column 'p.oct_1' in 'field list']
       SELECT p.first_name, p.middle_name, p.last_name, p.address, p.city, p.state, p.zip, p.phone, p.cell_phone, p.email, p.gender, p.birth_date, p.age, p.over_18, p.cpr_training, p.emergency_name_1, p.emergency_phone_1, p.emergency_name_2, p.emergency_phone_2, p.medical_conditions, p.shirt_size, p.height, p.oct_1, p.oct_2, p.oct_8, p.oct_9, p.oct_15, p.oct_16, p.oct_22, p.oct_23, p.oct_29, p.mailing_list, p.signature, p.id, p.private_id, p.date_recorded, p.date_updated, p.last_accessed FROM wp_participants_database p ORDER BY date_updated desc
       ```
   
 * And looking in the field groups, there is a Oct_1 colum
 *     ```
       Edit Edit
       Copy Copy
       Delete Delete
       61
       1036
       oct_1
       Oct 1
       main
       PLEASE SPECIFY IF YOU ARE AVAILABLE TO WORK THIS N...
       dropdown
       NULL
       a:2:{s:3:"Yes";s:3:"Yes";s:2:"No";s:2:"No";}
       NULL
       yes
       NULL
       0
       0
       0
       1
       0
       1
       0
   
       Edit Edit
       Copy Copy
       Delete Delete
       54
       1037
       oct_2
       Oct 2
       main
       PLEASE SPECIFY IF YOU ARE AVAILABLE TO WORK THIS N...
       dropdown
       NULL
       a:2:{s:3:"Yes";s:3:"Yes";s:2:"No";s:2:"No";}
       NULL
       yes
       NULL
       ```
   
 *  Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/manage-database-fields-issue/#post-14857255)
 * An error like that happens because the named column doesn’t exist in the table.
 * A field is defined in the wp_participants_database_fields table, but the field
   data is stored in the wp_participants_database able in a column with the same
   name as the field.
 * If the column is missing from the table, I’m not sure how that happened, the 
   plugin does not delete those columns. It may also be that the name is slightly
   different from what you have in your CSV header.

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

The topic ‘Manage Database Fields Issue’ is closed to new replies.

 * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807)
 * [Participants Database](https://wordpress.org/plugins/participants-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/participants-database/)
 * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/)

 * 4 replies
 * 2 participants
 * Last reply from: [Roland Barker](https://wordpress.org/support/users/xnau/)
 * Last activity: [4 years, 9 months ago](https://wordpress.org/support/topic/manage-database-fields-issue/#post-14857255)
 * Status: not resolved