WordPress.org

Forums

Participants Database
[resolved] MySQL connection problems with Participant Database (11 posts)

  1. AvWijk
    Member
    Posted 1 year ago #

    Hello,

    I used to run WordPress 3.9 installation and PDb with no problems whatsoever on my own server.

    I moved to a new web hoster and did a fresh installation and PDb (latest version) and came to the conclusion that I cannot edit or view the list in the backend anymore! Front-end works fine. I tried moving my old installation which works on my own server and a new installation. On the new host I get in both cases the same errors:

    This happens when I try to list records. Adding records doesnt do a think as well. Its only affecting the back-end.

    Can anybody help?

    Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'apache'@'localhost' (using password: NO) in /home/egegeg/domains/somedomain.nl/public_html/wp-content/plugins/participants-database/classes/PDb_List_Admin.class.php on line 356
    
    Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/egegeg/domains/somedomain.nl/public_html/wp-content/plugins/participants-database/classes/PDb_List_Admin.class.php on line 356
    
    Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'apache'@'localhost' (using password: NO) in /home/egegeg/domains/somedomain.nl/public_html/wp-content/plugins/participants-database/classes/PDb_List_Admin.class.php on line 356
    
    Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/egegeg/domains/somedomain.nl/public_html/wp-content/plugins/participants-database/classes/PDb_List_Admin.class.php on line 356

    https://wordpress.org/plugins/participants-database/

  2. xnau
    Member
    Plugin Author

    Posted 1 year ago #

    This is a question for your web host, they'll know what to do.

  3. aluiest
    Member
    Posted 1 year ago #

    I think this error hapen becouse wordpress 3.9 use now mysqli driver, then the function the plugin must use is mysqli_real_escape_string or use wordpress function like $wpdb->prepare.

  4. AvWijk
    Member
    Posted 1 year ago #

    No luck so far, my hosting provider doesn't offer any help.
    Any other ways so I can make this work? I guess I'm not the first not the last one with this problem.

  5. Sjourney
    Member
    Posted 1 year ago #

    @avwijk can you connect to your database manually without a script ?

  6. cedjo
    Member
    Posted 1 year ago #

    I have a similar issue, backend is not listing any record. Message is:

    WordPress Unknown column '' in 'order clause' for request SELECT * FROM wp_participants_database ORDER BY LIMIT 0,10 done by do_action('base-de-participants_page_participants-database-list_participants'), call_user_func_array, PDb_List_Admin::initialize, referer: http://www.hcv-moju.ch/wp-admin/admin.php?page=participants-database-list_participants

    wordpress 3.9

  7. AvWijk
    Member
    Posted 1 year ago #

    @Sjourney how do I do that? My back-end works fine, same for everything else of the WP install. Writing to the database (for example creating posts and such) is not a problem.

  8. Sjourney
    Member
    Posted 1 year ago #

    @AvWijk Do you have shell access via SSH?

  9. AvWijk
    Member
    Posted 1 year ago #

    Nope.. cheap hosting package

  10. cedjo
    Member
    Posted 1 year ago #

    I have posted a new thread instead of hijacking this one.
    Cheers

  11. AvWijk
    Member
    Posted 1 year ago #

    May seem a bit rigorous, but I couldn't make use of this plugin anymore. My webhost was unwilling to help me with any script-related issues.

    I decided to implement my own solution: a Custom Post Type with Custom Fields.

    Works great for my needs, just a simple member table with common fields like first name, last name, membership date, email, featured image, etc.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Participants Database
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic