MySQL connection problems with Participant Database

Resolved

(@avwijk)

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/

Viewing 10 replies - 1 through 10 (of 10 total)

Plugin Author xnau webdesign
(@xnau)

9 years, 12 months ago

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

aluiest
(@aluiest)

9 years, 12 months 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.

Thread Starter AvWijk
(@avwijk)

9 years, 12 months 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.

Sjourney
(@sjourney)

9 years, 11 months ago

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

Anonymous User 20768
(@anonymized-20768)

9 years, 11 months 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

Thread Starter AvWijk
(@avwijk)

9 years, 11 months 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.

Sjourney
(@sjourney)

9 years, 11 months ago

@avwijk Do you have shell access via SSH?

Thread Starter AvWijk
(@avwijk)

9 years, 11 months ago

Nope.. cheap hosting package

Anonymous User 20768
(@anonymized-20768)

9 years, 11 months ago

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

Thread Starter AvWijk
(@avwijk)

9 years, 10 months 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.