[wp-trac] [WordPress Trac] #41601: wp_update_user creates an error

[WordPress Trac]

#41601: wp_update_user creates an error
--------------------------+------------------------------
 Reporter:  iamklaus      |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Users         |     Version:  4.8.1
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by subrataemfluence):

 Thank you for detailed error message. I can see the table name is absent.
 But wondering how it worked for me! I will dig into it more and see if I
 can reproduce the same error!

 Replying to [comment:2 iamklaus]:
 > I am using PHP 7.1 and  10.1.23-MariaDB-9+deb9u1 for debian-linux-gnu on
 x86_64 (Debian 9.0).
 >
 > But the error was already there when I was still using PHP 5.6.
 >
 > Here is the full error message. See the bold areas: The table name is
 just missing.
 >
 > [Thu Aug 10 16:31:55.944041 2017] [proxy_fcgi:error] [pid 10778] [client
 10.130.37.117:64185] AH01071: Got error 'PHP message: 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 'WHERE user_id = 1706 AND blog_id = 1' at line 1 for query SELECT
 COUNT(id) FROM  WHERE user_id = 1706 AND blog_id = 1 made by require('wp-
 blog-header.php'), require_once('wp-load.php'), require_once('wp-
 config.php'), require_once('wp-settings.php'),
 do_action('after_setup_theme'), WP_Hook->do_action,
 WP_Hook->apply_filters, ad_sso_login, logmeintothesystem,
 ad_sso_register_user_wrapper, ad_sso_register_user, wp_update_user,
 wp_insert_user, do_action('profile_update'), WP_Hook->do_action,
 WP_Hook->apply_filters, bp_blogs_add_user_to_blog, bp_blogs_record_blog,
 BP_Blogs_Blog->save, BP_Blogs_Blog->exists\nPHP message: 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 '( user_id, blog_id ) VALUES ( 1706, 1 )' at line 1 for query
 '''INSERT INTO  ( user_id, blog_id ) VALUES ( 1706, 1 )''' made by require
 ('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-
 config.php'), require_once('wp-settings.php'),
 do_action('after_setup_theme'), WP_Hook->do_action,
 WP_Hook->apply_filters, ad_sso_login, logmeintothesystem,
 ad_sso_register_user_wrapper, ad_sso_register_user, wp_update_user,
 wp_insert_user, do_action('profile_update'), WP_Hook->do_action,
 WP_Hook->apply_filters, bp_blogs_add_user_to_blog, bp_blogs_record_blog,
 BP_Blogs_Blog->save\n'
 > [Thu Aug 10 16:32:03.102375 2017] [proxy_fcgi:error] [pid 10804] [client
 10.70.36.82:57000] AH01071: Got error 'PHP message: 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 'WHERE user_id = 385 AND blog_id = 1' at line 1 for query '''SELECT
 COUNT(id) FROM  WHERE user_id = 385 AND blog_id = 1''' made by require
 ('wp-blog-header.php'), require_once('wp-load.php'), require_once('wp-
 config.php'), require_once('wp-settings.php'),
 do_action('after_setup_theme'), WP_Hook->do_action,
 WP_Hook->apply_filters, ad_sso_login, logmeintothesystem,
 ad_sso_register_user_wrapper, ad_sso_register_user, wp_update_user,
 wp_insert_user, do_action('profile_update'), WP_Hook->do_action,
 WP_Hook->apply_filters, bp_blogs_add_user_to_blog, bp_blogs_record_blog,
 BP_Blogs_Blog->save, BP_Blogs_Blog->exists\nPHP message: 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 '( user_id, blog_id ) VALUES ( 385, 1 )' at line 1 for query INSERT
 INTO  ( user_id, blog_id ) VALUES ( 385, 1 ) made by require('wp-blog-
 header.php'), require_once('wp-load.php'), require_once('wp-config.php'),
 require_once('wp-settings.php'), do_action('after_setup_theme'),
 WP_Hook->do_action, WP_Hook->apply_filters, ad_sso_login,
 logmeintothesystem, ad_sso_register_user_wrapper, ad_sso_register_user,
 wp_update_user, wp_insert_user, do_action('profile_update'),
 WP_Hook->do_action, WP_Hook->apply_filters, bp_blogs_add_user_to_blog,
 bp_blogs_record_blog, BP_Blogs_Blog->save\n'

--
Ticket URL: <https://core.trac.wordpress.org/ticket/41601#comment:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform