Participants database list not showing after wordpress update

Yes, it’s generating some kind of error. What is the PHP version you are using? It must be at least 5.2

If that is OK, check your PHP error log after loading the page.

I check php error log and find these errors please tell what wrong

[26-Feb-2014 18:07:57 CST6CDT] WordPress database error Unknown column ‘v.readonly’ in ‘field list’ for query SELECT v.name,v.title,v.default,v.help_text,v.form_element,v.validation,v.readonly,v.values,v.persistent, “list” AS “module”
FROM wp_participants_database_fields v
WHERE v.name = “title”
ORDER BY v.order made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/map-theme/3_columnlayout.php’), get_template_part, locate_template, load_template, require(‘/themes/map-theme/loop-page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, Participants_Db::print_list, PDb_List::get_list, PDb_List->__construct, PDb_List->_setup_iteration, PDb_Shortcode->_get_record_field
[26-Feb-2014 22:04:49 CST6CDT] WordPress database error Unknown column ‘v.readonly’ in ‘field list’ for query SELECT v.name,v.title,v.default,v.help_text,v.form_element,v.validation,v.readonly,v.values,v.persistent, “list” AS “module”
FROM wp_participants_database_fields v
WHERE v.name = “title”
ORDER BY v.order made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/map-theme/3_columnlayout.php’), get_template_part, locate_template, load_template, require(‘/themes/map-theme/loop-page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, Participants_Db::print_list, PDb_List::get_list, PDb_List->__construct, PDb_List->_setup_iteration, PDb_Shortcode->_get_record_field
[27-Feb-2014 01:35:17 CST6CDT] WordPress database error Unknown column ‘v.readonly’ in ‘field list’ for query SELECT v.name,v.title,v.default,v.help_text,v.form_element,v.validation,v.readonly,v.values,v.persistent, “list” AS “module”
FROM wp_participants_database_fields v
WHERE v.name = “title”
ORDER BY v.order made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/map-theme/3_columnlayout.php’), get_template_part, locate_template, load_template, require(‘/themes/map-theme/loop-page.php’), the_content, apply_filters(‘the_content’), call_user_func_array, do_shortcode, preg_replace_callback, do_shortcode_tag, call_user_func, Participants_Db::print_list, PDb_List::get_list, PDb_List->__construct, PDb_List->_setup_iteration, PDb_Shortcode->_get_record_field

I am having the same problem. I am using PHP version 5.3.3. Just installed the latest version of WordPress but I’m pretty sure that is not the problem. Because the plug-in worked after I had updated WordPress, but does not work now that I have updated the plug-in.
The plugin is used on pages that are password protected, but I took the short code [pdb_record] off the page that it is usually on and put it on a page that was not password protected so you could look at it.
Here is the link to that page.
https://www.appfa.org/test-dates/?pid=CD3KJ

The page with the single record on it looks the same as this page. It only shows the h3 headers.

I would appreciate your taking a look. In the mean time, I will try to figure out how to find the php error logs.

We’re getting closer. Something has changed the database and I don’t know how it happened. The “readonly” column in the fields database table is either missing or renamed. If either of you is willing to let me take a look, email me a temporary admin login. support AT xnau.com

Wow did not expect you to answer so quickly. So I did some digging myself. Yes the “readonly” column in the database did not exist. (I figured this out by installing the Participants Database plugin on another site and comparing the databases)
I put the readonly column into the database and it all seems to work great! Thanks sooo much.

Hope this also works for shokydada

I think it will, but I still need to figure out how this happened in the first place.

The quick answer was just luck. I only get on here a couple of times a day at most.

thanks for the info!

Your welcome. As for me,I was using a very old version of the Plug-in…I just assumed that the field “readonly” was new. The other version did not seem to need it.

Your welcome! Thank You! As for me, I was using an old version of the Plug-in and I had just assumed that the “readonly” column was something new. The old version that I was using did not seem to need it.

Yes, that was a feature added in version 1.4.5

Thank You PeggyMe and Xnau your solution is working. Solve my problem.
My Participants list is showing fine.just add “readonly” column in “wp_participants_database_fields” table in wordpress database and it solves this issue.
Thanks for this kind and quick support.

opened a new topic, sorry.