syntax error for changing user role from database

Found it.

It was a field in phpMyAdmin which is set to a semicolon(;) by default.

I have changed it to an unused char and the query ran normally.

enter image description here

Related Posts:

  1. Delete all post meta except featured image
  2. Set Display Name to first and last name (phpmyadmin SQL Query)
  3. Emojis getting converted to “?”
  4. How to replace values in WordPress DB using phpMyAdmin
  5. Delete all post meta except featured image Using SQL
  6. Accidentally deleted active_plugins portion of the wp_options DB table
  7. WordPress database import: Row size too large
  8. WordPress Database Huge wp_usermeta Table
  9. Connection refused on locahost after importing database?
  10. Changing root password in PHPMyAdmin for WordPress Database when going live
  11. Can’t update WordFence Options, clear data manually
  12. Post Views / Hit Counter Problem?
  13. How to migrate a database from a server to another
  14. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  15. Files on Localhost, Database on Server
  16. Backing up WordPress database and files
  17. wp_option table error while importing
  18. Installing local to live WP into subdirectory
  19. Delete user with only subscriber role
  20. Can’t log into wordpress site – I have made a new user and still cant access
  21. Is there any way to monitor a MySQL db and check what has changed?
  22. DB prefix not updating
  23. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  24. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  25. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  26. Is there any defects for using same database prefix in WordPress for multiple sites?
  27. Migrating meta_key and meta_value from old theme to new one
  28. What is recommended data type and encryption type for password in a database
  29. Duplicate database to roll back theme & content changes
  30. WP website showing blank page after moving from subdomain to main domain
  31. How to retrieve user data based on role using SQL?
  32. WordPress character set issue
  33. Missing latest posts and options after DB migration via phpMyAdmin
  34. Check if a database is well installed
  35. Changed meta_key value in structures, now dashboard shows zero users
  36. Options table – where does my values go?
  37. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  38. Deleting WordPress posts and media files based on author via MYSQL database
  39. Database table prefix different between wp-config.php and in database
  40. Rename a table in MySQL
  41. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  42. Keeping WP database synced across multiple developers using git
  43. How to define composite keys with dbDelta()
  44. Connect forms in WP to external database
  45. How to get site URL if database is disconnected?
  46. Is it wise to delete post revisions and autosaves from database?
  47. Multiple WP install with same users database
  48. Dynamic data in `wp_register_script` needed
  49. Using two different DB users on one WP install
  50. Can I transfer a mysql database to another site?
  51. Weird issue with database migration and SSL links
  52. Backup another database with BackUpWordPress plugin [closed]
  53. How to use a different database to list and manage comments in the backend
  54. Error establishing a database connection on Installation
  55. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  56. Use mulitple usernames?
  57. Routine to convert custom post meta from old to new value
  58. sanitize POST arrays
  59. WP character encoding error after sharing post on Facebook �
  60. Sending data with multi step form to wp database
  61. WordPress query is not returning proper results
  62. Localhost to Staging to Development Dynamic WP-CONFIG
  63. Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
  64. In which format the data is stored in WordPress Databases?
  65. Is it possible to rebuild the website while not accesseing the original database?
  66. Error message on blog posts only on my local environment [closed]
  67. how to read database fields
  68. $wpdb->query can’t insert data
  69. Can you refresh ONLY the wordpress adminbar and not the whole page?
  70. Sending posts from Python to WordPress
  71. Remote database connection and local development
  72. How can I detect right db type?
  73. Add search bar to Custom Database Table in WordPress Dashboard
  74. Design problems when exporting remote database for local development
  75. A change in URL slug in database returns 404, how can I do auto-redirect?
  76. muliple wordpress installs (network) on different databases
  77. White Screen in Home Page
  78. Continuous SQL query errors from outside source
  79. Whats the best practise on how to store json data from a custom settings page?
  80. Recovery – Restore Database after moving folder location locally
  81. Migrate Users From laravel to wordpress
  82. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  83. Job and Employee Performance Tracking with Product Safety
  84. how add more field to wp user and save it to database
  85. How do I cleanup my database with data that is no longer being used?
  86. Error establishing a database connection with XAMPP
  87. How to map data on CSV to web pages?
  88. Search and replace http:// to https:// 10x my database size
  89. Database size for news publishers?
  90. do I need to change the default database prefix?
  91. WordPress Database Posts Table query
  92. How to use separate database on differrent server with different username and password in wordpress for users data
  93. Theme options not being sent to Database
  94. What’s wrong with my $wpdb query?
  95. Moving database from WP 2.6 to 3.5 problem
  96. How do I find posts?
  97. Homepage redirects to other site of mine? [closed]
  98. Recover Same WordPress Admin Password
  99. WordPress, Error when trying to insert data >> Notice: wpdb::prepare was called incorrectly
  100. Sharing plugin tables between 2 sites in the same database