Forum Replies Created

Viewing 15 replies - 1 through 15 (of 50 total)
  • Thread Starter macwinson

    (@macwinson)

    Hi!

    Thanks for the clarification!

    After checking the demo at 🔗 Participants Database I can definitely see the improvement with the inline spinner to the right of the pagination. That’s great progress!

    However, from my context (and theme), the main issue is that the entire pagination control has become too small, making it difficult for users to click comfortably.

    I’m wondering if there’s a way—maybe with a bit of CSS magic—to restore the previous layout while keeping the inline spinner. I’ll experiment with it and let you know how it goes.

    In any case, the workaround I mentioned earlier is still a reliable fallback.

    Best regards,

    Thread Starter macwinson

    (@macwinson)

    Hi Saji! Thanks so much for your response.
    The version we had installed was 1.7.0—not too old.
    Updating it to version 1.9.5 seems to have resolved the issue.

    By the way, is the plugin fully compatible with the latest version of WordPress (currently 6.8.1)?

    Thanks again!!

    Thread Starter macwinson

    (@macwinson)

    Hi, tested with Siteground hosting, with no issues so far:

    MySQL version 8.0.36-28
    WordPress 6.5.2
    Participants Database 2.5.7

    Thanks for the feedback!

    Thread Starter macwinson

    (@macwinson)

    Hi, thanks for the clarification!!
    I’m following the updates to keep the plugin compatible with PHP 8, so I was curious about what will happen when MySQL 8 arrives to most hosting servers. So, as you said, the upgrade to MySQL 8 should be “transparent” to Participants Database considering the current version of WordPress (since 6.4) is fully compatible.

    Thanks again!!

    Thread Starter macwinson

    (@macwinson)

    Hi!

    Updated to 2.1.11 and tested… seems to be working fine now.

    By the way, the update says:

    "fixed issue with blank “allowed” attribute in upload field"

    The fix was applied to “Image Upload Field” too?

    Many thanks for the urgent update. Glad to help!

    Thread Starter macwinson

    (@macwinson)

    Hi, thanks for the reply!!
    In the case of the “Image Upload Field”, I meant, it does NOT accept any type of file (with Attributes “allowed::” empty). So, I changed it to “allowed::jpg”

    Thanks again !!!

    Thread Starter macwinson

    (@macwinson)

    Can I, at least, know if it is possible before buying the Pro version?
    1) Is it possible? (please see the topic question).
    2) Using the Pro version, the customization requires an extra charge?
    Thanks!

    Thread Starter macwinson

    (@macwinson)

    The issue related with the drop-down “Show only records with: Multi-Field… Any Field/Any Text Field” seems to be solved after the update Version 1.9.7.6
    I will be checking the thing related with the plugin options.

    An enormous thank you!!!

    Thread Starter macwinson

    (@macwinson)

    By the moment I don’t use any add-on, because the people that use PDb are just starting to use the database and familiarizing with how it works. It seems simple, but is very powerful “as is” and complex in some ways. I’m planning to include Combo Multisearch and Directory Tools (Proxy Posts).

    Thread Starter macwinson

    (@macwinson)

    Hi Roland,
    Thanks for your concern and commitment!

    I know maybe is not related, but it draw my attention because of the connection with wp_options table: on another site with PDb (where I didn’t touch the database or update anything -WP core, plugins, themes…-) yesterday I found some things broken in the live site. When I went to the plugin settings I found nearly all settings restored to default (Single Record Link Field, Single Record Page, Record Edit Access Level, and so on).
    What can be the cause of suddenly get the PDb settings reseted to default? It’s very strange, because I never saw anything like this in WP. Thanks!!!

    • This reply was modified 4 years, 10 months ago by macwinson.
    Thread Starter macwinson

    (@macwinson)

    Just an update, I was able to recreate the error:

    1) go to List Participants

    2) change dropdown: Show only records with: “Multi-Field: Any Field”
    *the same situation “Multi-Field: Any Text Field”
    that – contains – *no need to enter anything to search*

    3) click on “Filter”

    4) you will get the error:

    using: “Multi-Field: Any Field”

    Fatal error: Uncaught Error: Call to undefined method PDb_admin_list\all_fields::is_numeric() in \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php:326 Stack trace: 
    #0 \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php(310): PDb_admin_list\query->empty_value_phrase(Object(PDb_admin_list\all_fields), false) 
    #1 \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php(276): PDb_admin_list\query->empty_value_where_clause('LIKE', Object(PDb_admin_list\all_fields)) 
    #2 \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php(119): PDb_admin_list\query->_add_where_clause(Array) 
    #3 \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php(46): PDb_admin_list\query->_process_search() 
    #4 \wp-content\plugins\participants-database\classes\PD in \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php on line 326

    using “Multi-Field: Any Text Field”

    Fatal error: Uncaught Error: Call to undefined method PDb_admin_list\text_fields::is_numeric() in \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php:326 Stack trace: 
    #0 \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php(310): PDb_admin_list\query->empty_value_phrase(Object(PDb_admin_list\text_fields), false) 
    #1 \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php(276): PDb_admin_list\query->empty_value_where_clause('LIKE', Object(PDb_admin_list\text_fields)) 
    #2 \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php(119): PDb_admin_list\query->_add_where_clause(Array) 
    #3 \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php(46): PDb_admin_list\query->_process_search() 
    #4 \wp-content\plugins\participants-database\classes in \wp-content\plugins\participants-database\classes\PDb_admin_list\query.php on line 326

    By now, I can reset the user options this way: go to phpmyadmin, table wp_options, and delete:

    pdb-admin-user-settings-(ID of the user)
    pdb-admin_list_filter-(ID of the user)

    Thread Starter macwinson

    (@macwinson)

    OK, I will try it. Thanks for the advice.
    Those records give you a hint of what string or search combination may have triggered the issue?

    Thread Starter macwinson

    (@macwinson)

    The ID of the user is “2”, so I guess these are the records that matter?

    "387","pdb-admin_list_filter-2","a:4:{s:6:""sortBy"";s:13:""date_recorded"";s:7:""ascdesc"";s:4:""desc"";s:17:""list_filter_count"";s:1:""1"";s:6:""search"";a:1:{i:0;a:4:{s:12:""search_field"";s:14:""pdb_all_fields"";s:5:""value"";s:0:"""";s:8:""operator"";s:1:""="";s:5:""logic"";s:3:""AND"";}}}","yes"

    "386","pdb-admin-user-settings-2","a:2:{s:10:""list_limit"";i:10;s:13:""with_selected"";s:6:""delete"";}","yes"

    What should I do? copy a working “option_value” (from user ID 4 for instance) for user ID 2 ? In pdb-admin-user-settings ?

    Thread Starter macwinson

    (@macwinson)

    Hi, thanks for the answer! I forgot to mention that below the error I have a blank page, I see nothing but the error and the WP menu in /wp-admin/admin.php?page=participants-database

    But maybe I can find the stored search configuration for that particular user in the database. Where I may start to look? This is what I get so far:

    "option_id","option_name","option_value","autoload"
    "365","pdb-admin_list_filter-1","a:4:{s:6:""sortBy"";s:12:""date_updated"";s:7:""ascdesc"";s:4:""DESC"";s:17:""list_filter_count"";s:1:""1"";s:6:""search"";a:1:{i:0;a:4:{s:12:""search_field"";s:4:""none"";s:5:""value"";s:0:"""";s:8:""operator"";s:4:""LIKE"";s:5:""logic"";s:3:""AND"";}}}","yes"
    "387","pdb-admin_list_filter-2","a:4:{s:6:""sortBy"";s:13:""date_recorded"";s:7:""ascdesc"";s:4:""desc"";s:17:""list_filter_count"";s:1:""1"";s:6:""search"";a:1:{i:0;a:4:{s:12:""search_field"";s:14:""pdb_all_fields"";s:5:""value"";s:0:"""";s:8:""operator"";s:1:""="";s:5:""logic"";s:3:""AND"";}}}","yes"
    "14688","pdb-admin_list_filter-4","a:4:{s:6:""search"";a:1:{i:0;a:4:{s:12:""search_field"";s:4:""none"";s:5:""value"";s:0:"""";s:8:""operator"";s:4:""LIKE"";s:5:""logic"";s:3:""AND"";}}s:6:""sortBy"";s:12:""date_updated"";s:7:""ascdesc"";s:4:""desc"";s:17:""list_filter_count"";i:1;}","yes"
    "364","pdb-admin-user-settings-1","a:3:{s:10:""list_limit"";i:10;s:13:""with_selected"";s:6:""delete"";s:17:""csv_base_filename"";s:21:""participants-database"";}","yes"
    "386","pdb-admin-user-settings-2","a:2:{s:10:""list_limit"";i:10;s:13:""with_selected"";s:6:""delete"";}","yes"
    "14687","pdb-admin-user-settings-4","a:1:{s:10:""list_limit"";s:2:""10"";}","yes"
    Thread Starter macwinson

    (@macwinson)

    Works perfectly, thanks!!

    In the PDb Documentation maybe you can include something about this?

    https://xnau.com/work/wordpress-plugins/participants-database/participants-database-documentation/field-types/#rich-text-form-element

    Thanks again! Cheers!!!

Viewing 15 replies - 1 through 15 (of 50 total)