wpdb prepare insert table doesn’t work

I’m pretty sure that first SQL query isn’t correct SQL (insert has different syntax) 😉 It should be:

INSERT INTO {$wpdb->prefix}awpcp_adphotos (ad_id, image_name, disabled, isprimary) VALUES (%d, %s, %d,%d)

In second example, I’m almost sure that ad_id is not string, and image_name is not a number. Of cours I’m only guessing, because I haven’t seen this table definition.

Remember that you can always turn error reporting for wpdb on. Just put this line in your code and you will see wpdb errors:

$wpdb->show_errors();

Related Posts:

  1. Update results, Before deleting the related category [closed]
  2. select a single val though a table in wordpress
  3. How to edit the default database of WordPress [closed]
  4. How to return number of found rows from SELECT query
  5. Check if post of title already exists
  6. $wpdb->delete column values IN ARRAY()?
  7. How to use update and delete query in wordpress
  8. How to make WordPress plugin check for database changes and then do something?
  9. How To Make Connection To WordPress Data Base In A Plugin?
  10. Changing user_nicename
  11. Does WordPress cache get_user_meta() results?
  12. WordPress will not operate correctly
  13. How to Join two tables from separate databases within WordPress
  14. simple wordpress ajax plugin not working when not logged in
  15. error importing localhost export file to server
  16. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  17. How to sort results from a custom database table
  18. How can I call a row of user specific data from a custom table added to the WP Database
  19. How to merge local and live databases?
  20. How to track a users progress through pages by inserting data into WordPress Database?
  21. Import 10,000 Users into WordPress WITH a specific ID for each user
  22. WP database error for comments_popup_link()
  23. if statement on database query
  24. Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error
  25. No wp-config.php file on local install of wordpress – site still displays
  26. WordPress Ajax Custom Query – High CPU LOAD
  27. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  28. Different database query in function.php using mysqli
  29. How to create and work with custom data / tables (i.e., for arbitrary data)?
  30. Query String being Removed Creating a Pagination Issue within a Custom Plugin
  31. WordPress Scheduled Event Request Blocking
  32. Accessing the database from a plugin outside of action hooks
  33. Create WP_Query to search for posts by their categories or their parent/child categories
  34. WordPress not reflecting changed of the database
  35. PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
  36. How can I save unique user data on my site? [closed]
  37. Store a default value for a transient on plugin activation
  38. Execute long and heavy processes
  39. wp query foreach deleting record returning only first or last item
  40. database sent to a JSON file
  41. inserting a post from an extern php file but post content doesn’t show on wp site
  42. Using custom tables for old posts
  43. Not connecting to database in file with multiple MySQL connections
  44. Custom array from a query only write the last row of the query
  45. WordPress Block developer from exporting Database via PHP
  46. Should I use WordPress to skin a database website?
  47. How do I display offsite database info on my wordpress site?
  48. Creating Database Table vs. Adding MetaData to Post & User
  49. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  50. Building a REST API for your web app exposes primary keys of DB records?
  51. Most commented posts by time period (last 12h, last 24h and etc)
  52. I can’t update my data through $wpdb
  53. Set default Database Storage Engine when creating tables with plugins?
  54. WordPress WP_Query without query GET parameters
  55. How do I make this Metabox show current DB value?
  56. Why when I create a new post I found 2 record related to this post into the posts database table?
  57. Adding data to custom wordpress database table
  58. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  59. Add row to custom database Table and delete all rows older than 1 day
  60. How to display results from a data table with an encrypted user id?
  61. SQL error with custom query
  62. What’s wrong in my PHP code? I’m using WordPress Astra Theme and I can’t insert data into my SQL
  63. Please help! I have a problem with getting wordpress databas
  64. Error establishing a database connection (Set-up locally)
  65. PHP Warning: mysqli_query(): after updating my websites php from 5.6 to 7.2
  66. wp_update_post gives 500 internal error
  67. code that I can run, or a plug in to show what sql tables something pulls information from
  68. Using wpdb to connect to a different database is not working
  69. How to import woocommerce custom fields data into another site?
  70. Need help with format of nested array in MySQL
  71. The plugin generated 225 characters of unexpected output during activation
  72. Insert data from form to database
  73. can’t delete a row from post_meta table
  74. Send data from plugin to external database
  75. How to set max users to 17.000
  76. two wordpress sites, two themes, one database, same content
  77. Insert double entry in DB
  78. How to connect database table to each registered wordpress user.
  79. Let users register weight each day and save it in DB
  80. MySQL database migration to WordPress
  81. Custom query_posts() parameter
  82. MySQL update text field with ‘
  83. How to pass username into form that sends data to database
  84. Display total count of products in orders of a specific order status
  85. Create custom table for wordpress custom registration flow
  86. Execute multiple PHP Snippets causes error?
  87. Custom form that stores data in mysql database
  88. Putting form result in my database
  89. Can’t insert into a database wordpress
  90. How get value from URL
  91. Notice: wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
  92. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  93. Get updated query results on page after insert in database
  94. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  95. Hacked WordPress website /Homepage redirect [closed]
  96. Database query works fine outside WordPress
  97. Save html content of a widget textarea
  98. How to use AJAX in WordPress in MYSQL query?
  99. Passing in MySQL prepare statement parameter separately throwing error
  100. PHP: Why does my code work in index.php but not a widget?