Matt

Resolved

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

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.]

What did you have to do to the wordpress install to make this work again? I am having a similar issue.

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

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

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/

Ah! I didn’t realize that was how it had to work. That fixed it.
Thank you for your assistance and patience.

I’m not sure what you mean by “aren’t shown in the list”. If you go to https://www.westrichlandchamber.org/members-2/membership-sign-up/ you can see the signup form and a drop down list for people to select the category that best suits their business.

I have the code set to show 5 records and when you perform a category search it shows the same first 5. It doesn’t matter what category I search for. Here is the list of categories.

Accountants-Certified Public
Advertising
Animal Feed
Assisted Living Facilities
Associations
Attorneys
Auto-Repair
Bakeries
Banks
Baseball
Beer and Wine Shop
Beer Wholesaler
Bookkeeping
Bowling
Brewery/Pub
Buildings - Pole
Business Lending
Cable Television
Candy & Confectionery Retail
Catering
Chamber of Commerce
Chiropractor
Cleaning
Collection Agency
Communications
Computers/Networks
Concrete
Construction
Consultant
Contractors
Convenience Store/Gas Station
Convention Center
Copiers & Supplies
Credit Unions
Cruises
Dentists
Design
Disaster Restoration
Distillery
Economic Development
Education
Electric Company
Electric Utility
Electronics & Appliance Store
Employment Services
Engineering
Engineering/Environmental Services
Engravers
Entertainment
Environmental Consulting
Equipment Rentals
Espresso
Event Center
Excavation
Fence
Financial Services
Fire Protection
Fitness
Flooring and Countertop Retail
Food Processing & Manufacturing
Foods
Frozen Yogurt
Funeral Home
Garage Doors
Garbage Collection
Gas distribution - Utility
Golf Courses
Graphic Design
Graphics
Grocery Store
Hair/Beauty
Home Builders
Hospital
Insurance
Interactive Media/Web
Internet Service Provider
Investment Services
Irrigation Products and Services
Lab & Safety
Landscaping
Lawn Care
Library
Limousine Service
Linen Rentals
Lodging
Mail & Shipping
Massage
Media
Medical
Medical Training - Orthopedic
Metal Fabrication
Military Surplus
Mortgages
Motorcycles
Municipalities
Non-profit
Nutrition
Office equipment and supplies
Opticians
Optometrist
Packaging & Storage
Paper
Paper Shredding
Pet Grooming
Pet Treats
Petroleum Products
Photographer
Physical Therapy
Piano Teacher
Pizza
Printing
Property Management
Public Power
Public Transportation
Publications
Radio
Real Estate
Recreation
Research & Development
Restaurant
Schools
Second Hand Store
Seniors
Service
Signs
Silk Screen Printing
Social Services
Soft Drink Distributor
Specialty Foods
Sporting Goods
Sports
Storage
Surveyor
Tax Preparation
Telecommunication
Television Station
Tour Bus Services
Touring
Tourism
Travel
Trophies
Truck Dealers
Vacation
Veterans
Vineyard
Waste Removal
Water Company - Utility
Wellness Supplements
Wholesale Warehouse
Winery

OK. That works.
Category search doesn’t seem to work though.

Sorry no. I have not been able to fix it. The search works but it returns the same top five entries regardless of what search terms you use.

I found VFB in order to try to accomplish the same basic idea that tg1 is trying to do.
What I want to be able to do it create a drop down list with 3 addresses. The sender would choose an address for the for information to be sent to. For example:
These addresses would be in the drop down list in the form.
[email protected]
[email protected]
[email protected]
When selected the form would be delivered to the selected address.
Is there a way to accomplish this?
Thanks in advance.
Matt