Thread Starter
Anonymous User 20768
(@anonymized-20768)
I have downgraded a copy of the site to wp 3.8.3 and it works perfectly.
This doesn’t have anything to do with the WP version. If you save your plugin preferences with a value for the “Admin List Default Sort” this will go away. This happens if, for some reason, no sort value is set for the admin list.
I don’t want people thinking the plugin is incompatible with WordPress 3.9…
Thread Starter
Anonymous User 20768
(@anonymized-20768)
I have set the “Admin List Default Sort” to “nom” (name in french)
I have checked that the “Nom” field is marked as sortable as indicated.
But it does nt work. same result.
[Thu May 01 06:48:49.440788 2014] [:error] [pid 15230] [client 178.195.113.122:54926] Erreur de la base de donn\xc3\xa9es WordPress Unknown column '' in 'order clause' pour la requ\xc3\xaate SELECT * FROM wp_participants_database ORDER BYLIMIT 0,10 faite par 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-edit_participant
Curious…does it work if you try it with another field?
My guess is it is a problem with the translation. I don’t see anything wrong with the translation file, the word “Sort” is properly translated. I don’t know of any incompatibility with the translation files and the new version of WordPress, but I’ll take a look at that.
I tested it with the French translation and there were no problems.
Still doesn’t explain the blank sort value. Were there any other errors?
Thread Starter
Anonymous User 20768
(@anonymized-20768)
I changed the language parameter in wp-config.php to en_US.
change the field to email for the “Admin List Default Sort”.
Same message:
[Sat May 03 06:44:51.934909 2014] [:error] [pid 13143] [client 178.195.113.122:45560] WordPress database error Unknown column '' in 'order clause' for query SELECT * FROM wp_participants_database ORDER BYLIMIT 0,10 made by do_action('participants-database_page_participants-database-list_participants'), call_user_func_array, PDb_List_Admin::initialize, referer: http://wp-hcv-moju.virtualconfusion.net/wp-admin/admin.php?page=participants-database-manage_fields
when I try to filter on a specific field (email=…):
[Sat May 03 07:01:39.948561 2014] [:error] [pid 13142] [client 178.195.113.122:45768] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''' ORDER BY p. LIMIT 0,10' at line 1 for query SELECT * FROM wp_participants_database p WHERE p. '' ORDER BY p. LIMIT 0,10 made by do_action('participants-database_page_participants-database-list_participants'), call_user_func_array, PDb_List_Admin::initialize, referer: http://wp-hcv-moju.virtualconfusion.net/wp-admin/admin.php?page=participants-database-list_participants
Wow, I’ve no idea how that’s happening. There are no other errors? Did you do any editing to the database directly…not through the plugin interface? It looks like something is wrong with your database.
Thread Starter
Anonymous User 20768
(@anonymized-20768)
I have installed a fresh 3.9 installation with new database and installed just your plugin, I created 1 record same results.
when checking the source page of the admin page I have something like:
input type="hidden" name="query" value="SELECT%20%2A%20FROM%20wp_participants_database%20ORDER%20BY%20%60%60%20" /
on a working installation under 3.8 I have
input type="hidden" name="query" value="SELECT%20%2A%20FROM%20wp_participants_database%20ORDER%20BY%20%60last_name%60%20asc" /
Looks like the function building the query is not taking record name for the filter and it messes up the query.
The database is working fine as any page with a pdb shortcode shows correctly the information.
I have turned debug mode on and I have a lot of warnings related to mysqli_real_connect().
Thread Starter
Anonymous User 20768
(@anonymized-20768)
when I change the line 356 from PDb_List_Admin.class.php for
self::$list_query = ‘SELECT * FROM ‘ . Participants_Db::$participants_table . ‘ ORDER BY email’;
I have the records listed…
finally removing mysql_real_escape_string function from line 356 makes everything working fine… (same is needed on line 337)
so I guess that the issue is more because wordpress 3.9 switched to using the mysqli PHP library, when using PHP 5.5 or higher.
check this post http://make.wordpress.org/core/2014/04/07/mysql-in-wordpress-3-9/
Thread Starter
Anonymous User 20768
(@anonymized-20768)
and indeed I am using PHP 5.5.9-1ubuntu4 (cli) (built: Apr 9 2014 17:08:27) on ubuntu 14.04 server edition.
Hope it helps.
Ah, yes…I’ll have to check into this further. I guess on some installations, the regular mysql PHP functions have to be “mysqli” functions. I’ve only heard your report of trouble, though, so it must be uncommon.
I’ll have to figure out what I have to do about this.
Thanks for supplying so much information, it’s helpful.
Thread Starter
Anonymous User 20768
(@anonymized-20768)
Thanks for the update, works like a charm…
