[pdb_single] stopped showing records

the first thing to do is check the “member-listing-view” page to make sure the [pdb_single] shortcode is in there properly. Sometimes saving a page content in “visual” mode can mess up code-type items like shortcodes.

If it’s there, and it’s syntactically correct, then you’d need to have a look at the PHP error log to see what’s going wrong.

I am not a PHP programmer and therefore I do not understand what I see in the error log. Here is a snippet:

[Tue Mar 25 14:25:51 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?,p.when,p.where FROM wp_participants_database p WHERE p.id = '2389'' at line 1 for query SELECT p.approved,p.business_city,p.business_description,p.business_fax,p.business_name,p.business_phone,p.business_state,p.business_street,p.business_zip,p.by,p.contact_email,p.date_recorded,p.date_updated,p.donations,p.id,p.keywords,p.last_accessed,p.mailing_city,p.mailing_state,p.mailing_street,p.mailing_zip,p.membership,p.phone_number,p.primary_contact,p.private_id,p.resources,p.volunteered,p.website,p.what_is_the_sum_of_11_and_10?,p.when,p.where FROM wp_participants_database p WHERE p.id = '2389' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wracc2a1/page.php'), get_template_part, locate_template, load_template, require('/themes/wracc2a1/content-page.php'), theme_get_content, the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, Participants_Db::print_single_record, PDb_Single::print_record, PDb_Single->__construct, Participants_Db::get_participant, referer: https://www.westrichlandchamber.org/members-2/
[Tue Mar 25 14:25:51 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: PHP Warning:  array_merge(): Argument #1 is not an array in /var/www/clients/client59/web155/web/wp-content/plugins/participants-database/participants-database.php on line 1664, referer: https://www.westrichlandchamber.org/members-2/

That’s a server log.

Anyway, did you make sure the [pdb_single] shortcode is on the page they go to when they click the link in the list?

Sorry, Yes I did make sure the code was in place and not saved in visual mode.

OK, one of your fields has a name with a question mark in it. That is causing the error. Since you have data in that field, you need to change the name of that field directly in the database using PHPMyAdmin or some other database editor. The name has to be changed in both the participants_database_fields table and the name of the column in the participants_database table.

Thanks for the information. I made the changes you suggested and the display still is not functioning properly.
Any other ideas?

Well, now that you have that fixed, load the page again then see what shows up in the error log.

I am just not sure what I am looking at.
Here are the last few lines of the error log.

[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.when,p.where FROM wp_participants_database p WHERE p.id = '2389'' at line 1 for query SELECT p.approved,p.business_city,p.business_description,p.business_fax,p.business_name,p.business_phone,p.business_state,p.business_street,p.business_zip,p.by,p.contact_email,p.date_recorded,p.date_updated,p.donations,p.id,p.keywords,p.last_accessed,p.mailing_city,p.mailing_state,p.mailing_street,p.mailing_zip,p.membership,p.phone_number,p.primary_contact,p.private_id,p.resources,p.volunteered,p.website,p.what_is_the_sum_of_11_and_10.,p.when,p.where FROM wp_participants_database p WHERE p.id = '2389' made by do_action('wp_ajax_nopriv_pdb_list_filter'), call_user_func_array, Participants_Db::pdb_list_filter, PDb_List::get_list, PDb_List->__construct, PDb_Shortcode->_print_from_template, PDb_List->_include_template, include('/plugins/participants-database/templates/pdb-list-default.php'), PDb_Shortcode->the_record, PDb_Record_Item->__construct, Participants_Db::get_participant, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: PHP Warning:  array_merge(): Argument #1 is not an array in /var/www/clients/client59/web155/web/wp-content/plugins/participants-database/participants-database.php on line 1664, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.when,p.where FROM wp_participants_database p WHERE p.id = '1986'' at line 1 for query SELECT p.approved,p.business_city,p.business_description,p.business_fax,p.business_name,p.business_phone,p.business_state,p.business_street,p.business_zip,p.by,p.contact_email,p.date_recorded,p.date_updated,p.donations,p.id,p.keywords,p.last_accessed,p.mailing_city,p.mailing_state,p.mailing_street,p.mailing_zip,p.membership,p.phone_number,p.primary_contact,p.private_id,p.resources,p.volunteered,p.website,p.what_is_the_sum_of_11_and_10.,p.when,p.where FROM wp_participants_database p WHERE p.id = '1986' made by do_action('wp_ajax_nopriv_pdb_list_filter'), call_user_func_array, Participants_Db::pdb_list_filter, PDb_List::get_list, PDb_List->__construct, PDb_Shortcode->_print_from_template, PDb_List->_include_template, include('/plugins/participants-database/templates/pdb-list-default.php'), PDb_Shortcode->the_record, PDb_Record_Item->__construct, Participants_Db::get_participant, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: PHP Warning:  array_merge(): Argument #1 is not an array in /var/www/clients/client59/web155/web/wp-content/plugins/participants-database/participants-database.php on line 1664, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.when,p.where FROM wp_participants_database p WHERE p.id = '1988'' at line 1 for query SELECT p.approved,p.business_city,p.business_description,p.business_fax,p.business_name,p.business_phone,p.business_state,p.business_street,p.business_zip,p.by,p.contact_email,p.date_recorded,p.date_updated,p.donations,p.id,p.keywords,p.last_accessed,p.mailing_city,p.mailing_state,p.mailing_street,p.mailing_zip,p.membership,p.phone_number,p.primary_contact,p.private_id,p.resources,p.volunteered,p.website,p.what_is_the_sum_of_11_and_10.,p.when,p.where FROM wp_participants_database p WHERE p.id = '1988' made by do_action('wp_ajax_nopriv_pdb_list_filter'), call_user_func_array, Participants_Db::pdb_list_filter, PDb_List::get_list, PDb_List->__construct, PDb_Shortcode->_print_from_template, PDb_List->_include_template, include('/plugins/participants-database/templates/pdb-list-default.php'), PDb_Shortcode->the_record, PDb_Record_Item->__construct, Participants_Db::get_participant, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: PHP Warning:  array_merge(): Argument #1 is not an array in /var/www/clients/client59/web155/web/wp-content/plugins/participants-database/participants-database.php on line 1664, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.when,p.where FROM wp_participants_database p WHERE p.id = '1989'' at line 1 for query SELECT p.approved,p.business_city,p.business_description,p.business_fax,p.business_name,p.business_phone,p.business_state,p.business_street,p.business_zip,p.by,p.contact_email,p.date_recorded,p.date_updated,p.donations,p.id,p.keywords,p.last_accessed,p.mailing_city,p.mailing_state,p.mailing_street,p.mailing_zip,p.membership,p.phone_number,p.primary_contact,p.private_id,p.resources,p.volunteered,p.website,p.what_is_the_sum_of_11_and_10.,p.when,p.where FROM wp_participants_database p WHERE p.id = '1989' made by do_action('wp_ajax_nopriv_pdb_list_filter'), call_user_func_array, Participants_Db::pdb_list_filter, PDb_List::get_list, PDb_List->__construct, PDb_Shortcode->_print_from_template, PDb_List->_include_template, include('/plugins/participants-database/templates/pdb-list-default.php'), PDb_Shortcode->the_record, PDb_Record_Item->__construct, Participants_Db::get_participant, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: PHP Warning:  array_merge(): Argument #1 is not an array in /var/www/clients/client59/web155/web/wp-content/plugins/participants-database/participants-database.php on line 1664, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.when,p.where FROM wp_participants_database p WHERE p.id = '1990'' at line 1 for query SELECT p.approved,p.business_city,p.business_description,p.business_fax,p.business_name,p.business_phone,p.business_state,p.business_street,p.business_zip,p.by,p.contact_email,p.date_recorded,p.date_updated,p.donations,p.id,p.keywords,p.last_accessed,p.mailing_city,p.mailing_state,p.mailing_street,p.mailing_zip,p.membership,p.phone_number,p.primary_contact,p.private_id,p.resources,p.volunteered,p.website,p.what_is_the_sum_of_11_and_10.,p.when,p.where FROM wp_participants_database p WHERE p.id = '1990' made by do_action('wp_ajax_nopriv_pdb_list_filter'), call_user_func_array, Participants_Db::pdb_list_filter, PDb_List::get_list, PDb_List->__construct, PDb_Shortcode->_print_from_template, PDb_List->_include_template, include('/plugins/participants-database/templates/pdb-list-default.php'), PDb_Shortcode->the_record, PDb_Record_Item->__construct, Participants_Db::get_participant, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:32 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: PHP Warning:  array_merge(): Argument #1 is not an array in /var/www/clients/client59/web155/web/wp-content/plugins/participants-database/participants-database.php on line 1664, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:38 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.when,p.where FROM wp_participants_database p WHERE p.id = '1986'' at line 1 for query SELECT p.approved,p.business_city,p.business_description,p.business_fax,p.business_name,p.business_phone,p.business_state,p.business_street,p.business_zip,p.by,p.contact_email,p.date_recorded,p.date_updated,p.donations,p.id,p.keywords,p.last_accessed,p.mailing_city,p.mailing_state,p.mailing_street,p.mailing_zip,p.membership,p.phone_number,p.primary_contact,p.private_id,p.resources,p.volunteered,p.website,p.what_is_the_sum_of_11_and_10.,p.when,p.where FROM wp_participants_database p WHERE p.id = '1986' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wracc2a1/page.php'), get_template_part, locate_template, load_template, require('/themes/wracc2a1/content-page.php'), theme_get_content, the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, Participants_Db::print_single_record, PDb_Single::print_record, PDb_Single->__construct, Participants_Db::get_participant, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 08:26:38 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: PHP Warning:  array_merge(): Argument #1 is not an array in /var/www/clients/client59/web155/web/wp-content/plugins/participants-database/participants-database.php on line 1664, referer: https://www.westrichlandchamber.org/members-2/
[Tue Apr 08 09:31:09 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.when,p.where FROM wp_participants_database p WHERE p.id = '2306'' at line 1 for query SELECT p.approved,p.business_city,p.business_description,p.business_fax,p.business_name,p.business_phone,p.business_state,p.business_street,p.business_zip,p.by,p.contact_email,p.date_recorded,p.date_updated,p.donations,p.id,p.keywords,p.last_accessed,p.mailing_city,p.mailing_state,p.mailing_street,p.mailing_zip,p.membership,p.phone_number,p.primary_contact,p.private_id,p.resources,p.volunteered,p.website,p.what_is_the_sum_of_11_and_10.,p.when,p.where FROM wp_participants_database p WHERE p.id = '2306' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/wracc2a1/page.php'), get_template_part, locate_template, load_template, require('/themes/wracc2a1/content-page.php'), theme_get_content, the_content, apply_filters('the_content'), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, Participants_Db::print_single_record, PDb_Single::print_record, PDb_Single->__construct, Participants_Db::get_participant, referer: https://www.westrichlandchamber.org/wp-admin/admin.php?page=participants-database-list_participants
[Tue Apr 08 09:31:09 2014] [warn] [client 216.7.32.7] mod_fcgid: stderr: PHP Warning:  array_merge(): Argument #1 is not an array in /var/www/clients/client59/web155/web/wp-content/plugins/participants-database/participants-database.php on line 1664, referer: https://www.westrichlandchamber.org/wp-admin/admin.php?page=participants-database-list_participants

[Moderator Note: Please post log files between backticks (not single quotes) or use the code button.]

You have an illegal field name. “what_is_the_sum_of_11_and_10.” you must remove the period from the field name.

Wow. What a pain. Thanks for the help. That was what the problem was.
I’ll be paying more attention to punctuation.
Thanks again!

Resolved