What could cause a WP Option to get truncated?

It was a 👼 character. Make sure you sanitize everything that gets written as field values, even if it’s a username.

trim(preg_replace("/[^\w\s]+/", "", $user->full_name))

I assumed there are no special characters in Instagram usernames. Never assume. I don’t really use Instagram, just my plugin supports it. BTW it got truncated on the first occurrence of the special character.

Related Posts:

  1. Performance of several get_option() calls
  2. WordPress setting with select – where is my mistake?
  3. update_option() passing empty array() but still updating
  4. Should I use wpdb prepare?
  5. How do I add CSS options to my plugin without using inline styles?
  6. “Error: Options Page Not Found” on Settings Page Submission for an OOP Plugin
  7. Is get_option function cached?
  8. How come `wp_options` table does not have an index on `autoload`?
  9. What are the advantages to the Settings API?
  10. Adding Widget form fields dynamically
  11. Is get_option() faster than accessing get_transient()?
  12. WordPress updates defined vs add_filter?
  13. Creating Settings Page with dropdowns for Plugin
  14. How to properly sanitize strings for update_option()
  15. Getting wrong relationship value in $args in wp_Query?
  16. How to add a new plugin page under desired Options page?
  17. How to get data from WordPress $wpdb into React Gutenberg Blocks Frontend?
  18. How is the data stored in the database?
  19. How do I handle multiple Submit buttons in plugin’s option page?
  20. Deletion of shared options using uninstall.php
  21. Why won’t register_setting() create a setting?
  22. Multiple entries in get_option results? or why is _multiwidget set to 1?
  23. update_option is not working!
  24. Save user-specific options in WordPress admin
  25. How to store accumulate multiple option values in a single array using Options_API
  26. array_map() for sanitizing $_POST
  27. WordPress Plugin Setting’s POST
  28. Passing array of strings to a SQL statement in a WordPress plugin
  29. Extend plugin options page
  30. Activation hook not creating table
  31. Using Checkboxes on Plugin Options Page for Custom Plugin
  32. Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
  33. How to edit mySQL wp_posts table from plugin php?
  34. Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
  35. How to store a medium amount of options?
  36. query users by role
  37. How to add settings subpage from a plugin to a settings page created in theme?
  38. Plugin options not being saved or created
  39. Remove Internal Style Sheet if no Value Provided?
  40. What could cause my plugin’s options/settings page not to load?
  41. How to set “Site Address (URL)” programmatically on WP multisite?
  42. Using wp_parse_args to set up Plugin Default Settings
  43. WordPress database error for query INSERT INTO
  44. How to connect to AWS RDS external database (not for the core WordPress db)
  45. Storing product price data in the database
  46. WP_Editor – Saving Value into Plugin Option – Stripping HTML
  47. Multiple options pages validation for a plugin
  48. Add Plugin options as subpage to Theme options page
  49. get_option() not returning expected value from plugin
  50. Parse form values before sending to options.php
  51. Prevent invalid or empty values from being saved to the database and retain the form field values upon error
  52. How to add user details to different tables immediately after user registration
  53. Update problem with update_option() in combination with register_setting()
  54. mysql_real_escape_string() vs. esc_sql() in WordPress
  55. Insert/Update values to a table after blogname option etc. is updated
  56. wordpress how to query wp_options table
  57. How Can I add Fields in wp-option table?
  58. Plugin Options Array Set to Undefined
  59. Checked() function on a multidimensional array
  60. How to add new options to my WordPress plugin
  61. $wpdb->prepare with LIKE and sprintf
  62. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  63. Issue on Checkbox with Custom Option Page
  64. Make Database query only when option is updated
  65. The Correct Way to Use Nonce Field without Settings API
  66. Settings API: Setting default option via ‘get_option’ fails
  67. Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
  68. how to save wp_editor html content in options table
  69. Custom Plugin Options Won’t Update
  70. How can I programmatically change a MySql variable (foreign_keys_check)?
  71. Problem with display data from get_option
  72. Auto-complete or auto-suggest from stored data in database
  73. What might be the reason of Couldn’t fetch mysqli_result on another domain?
  74. Brainstorm – Slow Query from Plugin Need to Speed It Up
  75. Create an user on external database
  76. why does get_option( ‘home’ ) not work while using in plugin [closed]
  77. Plugin Options not saving options and doesn’t work
  78. WordPress database error: [Query was empty] – using $wpdb->prepare()
  79. Decontruct serialized data array from wp_options
  80. wp_options not returning value for logged out users?
  81. How to Get Last ID?
  82. How does one update complex options?
  83. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  84. Why is that only the first row getting inserted into Mysql table when i import csv file on backend custom plugin?
  85. Error Connecting to Database WHEN Installing WordPress on XAMPP [Tried All the Usual Stuff] (Pics Included)
  86. Plugins Settings page not updating
  87. WordPress delete mysql rows with string
  88. add_settings_error on validating plugin options API
  89. Organising and completing posts (mark as read and hide)
  90. Cannot save settings value
  91. pull data from wordpress database
  92. sql query not working in wp plugin
  93. $wpdb Mysql trigger problem
  94. Custom MySQL query to pull out Advanced Custom Fields?
  95. the correct way to use options from settings page [closed]
  96. Add_menu_page and saving settings
  97. Nothing happens on WordPress Update command
  98. Menu_slug used for creating options page
  99. Update option hook not firing
  100. WordPress plugin options page not saving options, no errors