How to fix this insert? Don’t work for me!

Make sure that the value portion of the data parameter’s column=>value pairs must be
scalar. If you pass an array (or object) as a value to be inserted you will generate a warning similar to mysql_real_escape_string() expects parameter 1 to be string, array given on line 880 in file
/var/www/html/wp-includes/wp-db.php”.

Rather then above your code is looking correct with :

<?php $wpdb->insert( $table, $data, $format ); ?>

So finally check that every $_POST are not in array format.

Related Posts:

  1. Differences between wpdb->get_results() and wpdb->query()
  2. How to Use Wildcards in $wpdb Queries Using $wpdb->get_results & $wpdb->prepare?
  3. wpdb get posts by taxonomy SQL
  4. Multipart/formatted MySQL query problem
  5. Custom $wpdb Query for Custom Post Type by Category
  6. Can’t pass table to $wpdb->prepare
  7. $wpdb->get_var not returning a result
  8. Most effective use of DB querys
  9. $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
  10. wpdb::prepare() isn’t working
  11. $wpdb doesn’t appear to work on page inside of a plugin
  12. Strange string in console from wpdb query
  13. Using $wpdb->update but confused on the WHERE in and SET
  14. What’s wrong with my $wpdb prepare?
  15. Make one query for adding entries to database
  16. How to execute a SQL-query which contains multiple queries using $wpdb->query?
  17. Alter a specific query on WordPress
  18. wpdb->term_taxonomy count posts from both published and private posts?
  19. wpdb print all post meta
  20. Plugin will sort users by usermeta
  21. wpdb query problem to access previous 3 days posts
  22. How to write: $wpdb->update having WHERE NOT value pair in the array
  23. I can’t figure out what’s wrong with this statement. $wpdb->query update
  24. Use mysql_query instead of $wpdb query
  25. wpdb COALESCE won’t work
  26. Custom Query – Based on user input
  27. Custom SQL Query passing array to WHERE p.id
  28. Get posts from category with custom query
  29. Custom Query returns array, but I can’t see it’s elements
  30. Valid SQL query return empty
  31. mysql query – how to escape apostrophe?
  32. $wpdb->prepare affecting the query?
  33. prepare function sql safe method
  34. Updating with $qpdb->query() always returns 0 rows affected
  35. How to return count of custom post type posts with a specific custom field value via $wpdb?
  36. WordPress Mysql query and Duplicate
  37. How do I query for posts by custom meta and those that have been stickied?
  38. Help with Related Posts Function
  39. wpdb update multiple row?
  40. Formatting a date/time returned from a custom $wpdb query
  41. Improve performance of slow query
  42. How do I get specific readable results from this query and array results
  43. implementing my wp_query using $wpdb class
  44. Exclude Posts from a Widget
  45. Fastest and most efficient SQL query to check if UID exists
  46. Use $wpdb->get_results with filter based on array
  47. $wpdb query for price in custom field value
  48. Display result from custom post meta query
  49. Wpdb empty result only if language is Russian
  50. Run an update query in a function
  51. Problem on wpdb queries, wp_insert_post, wp_insert_user etc. The query runs twice
  52. Update vs Insert logic but the last key is always inserted?
  53. There is way to improve this query? wordpress get post data and some meta data
  54. $wpdb: how to use a query as a base for another query?
  55. Wpdb generates too many queries
  56. Custom Query for searching through custom fields
  57. Mysql query and odd results
  58. How to reference same column name but different table in custom db query
  59. Retrieving custom field array value through db query
  60. How to get one result using wpdb class?
  61. Delete query won’t run
  62. update $wpdb one query
  63. How to get comments by post ID?
  64. Create pagination and order according to alphabet
  65. How to display Section for certain time
  66. Query set using tax_query with relation ‘OR’ modifies category object?
  67. When add_query_arg() is necessary?
  68. Filter query posts by the count of metas for a meta key
  69. Save default value for empty or missing post meta
  70. Listing posts by grouping dates
  71. Query posts by content lenght
  72. How to export current year posts from WordPress?
  73. Search query -> Show all pages except certain template
  74. WordPress Query wp-terms SLOW
  75. Different values for get_author_posts_url and get_the_author (posts 2 posts)
  76. query statement containing variable won’t execute
  77. Placing a widget with $wpdb query
  78. Related post based on content
  79. How to interfere to default search to make it search in custom fields?
  80. WP_User_Query with more than two custom meta values
  81. Declaring a var, placing it in a query and using the output of the query?
  82. Sort query_terms_list for post_tags alphabetically
  83. Target a page with query
  84. List only parent attributes on woocommerce admin atrributes page
  85. Add rewrite rule for archive search
  86. How to create a filter and add query params to all links
  87. My custom pagination not displaying
  88. Wpdb->last_query returns bad query
  89. WP search exclude last letter from string
  90. Query reversed when I use “category__not_in”
  91. How to reduce the load / no of queries on MySql Database
  92. Show certain number of post from tags
  93. Query for distance OR taxonomy term
  94. Ajax Form data is not posted back to the get_results()
  95. How to query custom post type one after another
  96. Apply ordering args to newly merged queried
  97. Get blog id of subdirectory multisite blog from name – *outside* of wordpress request processing
  98. Remove last comma from this query
  99. WordPress Unknown Query
  100. List of buyers for each product