wpdb function insert doesn’t work

Consider trying with $wpdb->insert() method instead of raw query. Using of functions/methods is recommended for interacting with database over raw requests, unless absolutely impossible.

Related Posts:

  1. Get multiple custom field values in a $wpdb query [duplicate]
  2. Help setting up a sql query
  3. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  4. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  5. So much data in postmeta
  6. What is the advantage of the wp_options design pattern?
  7. importing data from non-wordpress mysql db
  8. Query meta field using between
  9. Move value of one custom field to another
  10. How to filter a dd/mm/yyyy date from a custom field in a query
  11. Difference between ‘LIKE’ and ‘IN’ in meta queries
  12. little help with a mySQL query to wp database
  13. Importing users to Buddypress with custom fields
  14. MySQL query to set wp_postmeta using term_taxonomy_id value
  15. MySQL Query that looks for post with Custom Field, then changes Category
  16. Unique Post Meta Values
  17. Add custom field to all posts in specific post_type
  18. UPDATE on SELECT results. A SQL query to swap Author with Meta Box value
  19. Custom Query based on custom field of a single post
  20. Build index page from custom fields
  21. Importing WordPress Posts With Custom Meta Data As CSV Files Through PHPMyAdmin
  22. Inserting data into MagicFields using mysql queries
  23. Copy price categories to custom field
  24. If I update WordPress my custom data will be deleted from the wp_users table?
  25. Get emails from users by custom field SQL
  26. Update post meta data (custom field) by post link
  27. How to improve my non-unique metadata MySQL entries?
  28. What is the correct way to search 3 custom fields only in WordPress?
  29. Delete a custom field in mysql for all posts with specific category id
  30. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  31. use mysql to replace one custom field value with another custom field value
  32. Update custom table on metabox POST
  33. ACF plugin and field update
  34. Query postmeta values, and return multiple post_titles for common meta value
  35. Query Custom Fields in Searchform
  36. Copy url from post_content to custom field
  37. Convert many posts from having a specific meta_key to use a post_format
  38. Custom Search, MySql Query Gone Wrong?
  39. Site uses wpdb to fetch meta_keys but just displays first meta_key from a page (the post uses the same meta_key “filmmaker” more than once)
  40. Can running a WP-Cron to update_post_meta cause performance issues?
  41. Best way to programmatically remove a category/term from a post
  42. Add new “Insert Into Post” button with another function
  43. Multiple meta values for same meta_key adding on “Preview Changes” hit but not on saving or updating post
  44. Search multiple meta keys at once
  45. How to add new custom page or post blocks?
  46. Transients vs CRON +Custom Fields: Caching Data Per Post
  47. How to update serialized data in the user meta data
  48. Best way to allow manageable social media URLS?
  49. Adding a custom field or metabox to the post-thumbnail widget?
  50. Using $wpdb Class to Pull Recent Comments Across a Network
  51. Using WP Query to search by multiple meta fields
  52. Get aggregate list of all custom fields for entire blog
  53. Sort by posts that have a featured image?
  54. WP_Query display next custom post from today’s date
  55. Can ordering post list by meta_value cause performance issue?
  56. woocommerce product custom field
  57. Converting MYSQL to WordPress $WPDB
  58. two custom fields question
  59. How to save multiple options from a dropdown in user profile
  60. How to display multiple images in custom field
  61. How to split the a table in database?
  62. Display the contents of a custom field of a page on their child
  63. Read / Watch / Listen times – meta
  64. Login WP – Connect single field to an external api
  65. adding extra wordpress user info from registration form
  66. Turn raw url into clickable links
  67. Advanced Custom Fields functionality without plugin
  68. Get post ids sorted by meta_key
  69. Advanced Custom Fields Plugin – Unable to get URL from post_object
  70. Unable to get specific value from post meta
  71. 3.8 Media Upload and Custom Meta Box
  72. Displaying Custom Field Array
  73. Let’s Create Custom Field Template Documentation
  74. WordPress Settings API Repeatable fields
  75. Basic wpdb update question
  76. Accessing Custom Fields on Pages
  77. Display a different image for each page with editor
  78. WP_query multiple custom fields not working
  79. Help with Related Posts Function
  80. Custom Field Date Problem
  81. Approach to creating a site with this structure
  82. how to create meta key name in wp_usermeta table in database
  83. Display the output from Custom User Fields from a WordPress user profile on a WordPress Custom Page
  84. MySQL ‘duplicate entry’ error
  85. What is my error trying to create a new table in the database?
  86. Show image depending on the number in the custom fields
  87. Save, update, get and sanitize post meta as HTML not plain
  88. How can I get $wpdb to show MySQL warnings?
  89. MySQL Select within WP Page template
  90. Term specific featured post on taxonomy archive pages
  91. Saving metadata of related post on save_post
  92. Query Distinct Taxonomies of Custom Post Type
  93. Custom field value link title
  94. How to Order Posts by Custom Fields?
  95. added a meta box to post however when saving menu while debug on throws a warning
  96. How can i get the actor birthday by date?
  97. Advanced Custom Fields for Header that are Editable from a Page [closed]
  98. Order by a meta field in query loop
  99. Multiple triggers when publishing, saving or updating a post in WordPress
  100. If possible a field ID transfom in a Custom Field?
tech