Manage Database Fields Issue

  • rcgtech

    (@rcgtech)


    4 years, 9 months ago

    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

    (@rcgtech)

    4 years, 9 months ago

    Using WordPress 5.8 and PHP 7.4.23

    Plugin Author Roland Barker

    (@xnau)

    4 years, 9 months ago

    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

    (@rcgtech)

    4 years, 9 months ago

    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

    (@xnau)

    4 years, 9 months ago

    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.