Plugin generating unexpected output – on WP mysql dump import

Its not that $wpdb->query does not need $wpdb->prepare(), it’s because of not using $wpdb->prepare() in a correct manner. In your case $wpdb->prepare() never received any values which it must.

Please refer to the Codex for details about using $wpdb->prepare().

Related Posts:

  1. How does WordPress handle MySQL row lock errors?
  2. $wpdb->get_results() does not fetch results with unicode ‘WHERE’ clause
  3. Help With MySQL to WPDB Query Conversion
  4. Creating mySQL procedure with $wpdb
  5. WordPress Gutenberg react make import of __experimentalUseInnerBlocksProps which is no more experimetal
  6. How to export post 2 posts WordPress plugin data [closed]
  7. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  8. WordPress plugin creation how to execute .sql in order to insert multiple rows at activation of plugin
  9. Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working
  10. Insert data from .sql file in wordpress plugin
  11. WP All Import – Execute Imports
  12. WordPress Backend HA (Automatic failover)
  13. DB Query not working in Plugin
  14. Way to send multiple values for column to MySQL?
  15. WordPress plugin: efficient way to store large data
  16. Can’t create tables with my plugin
  17. Integrating Custom Database with WordPress
  18. How to display results from a data table with an encrypted user id?
  19. How to get the custom field value using SQL query
  20. Need to know if my approach to designing a geneaology plug-in for wordpress makes sense
  21. I created a plugin with ‘view page’ that uses MYSQL + PHP. When I use wp_insert_post(), it turns everything to HTML
  22. best way to upload a large file to wordpress using wp all import
  23. WordPress UPDATE queries on MySQL database stuck
  24. Resetting AUTO_INCREMENT primary key
  25. Re-writing MySQl query for execute faster
  26. Create Database Tables on Plugin Activation hook
  27. Linking Plugin Files to WP
  28. how to search through plugin in wordpress cimy-user-extra-fields?
  29. Get all the related data from WordPress DB
  30. How to display blog posts only authored by the administrator
  31. How can I delete the options from DB when the plugin is deleted?
  32. WP_Query does not return the result even if the data is present in the database
  33. How to prevent WP All Export from wrapping XML nodes in CDATA? [closed]
  34. What’s the preferred method of writing AJAX-enabled plugins?
  35. Redesigning Custom Post Type “Add New” page
  36. Notify Admins about Plugin Merge
  37. Is there any record of installed plugins in the database?
  38. Using require_once in a Plugin?
  39. How to call “page specific menu items” in template [closed]
  40. Adding Featured Image in Post List
  41. Why does including a file in theme’s functions.php not work?
  42. WooCommerce – Call to undefined function is_woocommerce()
  43. Custom headers for the WordPress plugin directory
  44. plugin wants to update to wrong plugin
  45. OEmbed from Pinterest
  46. How can I add a custom header to a custom template in a plugin without using the theme folders
  47. Trying to avoid including wp-load.php
  48. AJAX Call Via Vanilla JavaScript In WordPress Plugin Development
  49. Understanding apply_filters
  50. Custom values are not translated
  51. Make the plugin directory recognize new version numbers
  52. Master menu item for multiple plugins?
  53. Add Top-Level Menu that opens URL
  54. Change the name of an installed plugin
  55. Where do I add a new table’s name in wpdb?
  56. Issue with post request to admin-post.php
  57. How to create popup same as wordpress popup feature
  58. action-scheduler vs wp-background-processing
  59. How to customize user search
  60. Upgrade Private Plugin without Deleting
  61. Sanitizing, Validating and Escaping in WordPress (Plugin)
  62. How to make first_name and last_name required fields in user profile?
  63. Making my plugin translation ready. Poedit not working
  64. like to keep reading plugin
  65. Check if email address exists front end with AJAX in a plugin
  66. Avoiding Duplicate function names in Post Loop (WP_Footer script)
  67. Global matrix for shortcodes/content for every page
  68. How to add class in plugin only for network site?
  69. Plugin Development sqlite or WordPress’ database
  70. How to write a plugin to add users to a mail list
  71. WordPress plugin for activating other plugins
  72. Can we use a webservice with WordPress?
  73. WooCommerce get_price returning wrong price when used via ajax
  74. Open Post Thumbnail in New Child Theme File in WordPress
  75. Pulling data from custom plugin settings using PHP shortcode and Javascript
  76. New User Form – Custom Menu Page
  77. Checking instances of scripts in wp_head
  78. AJAX search posts and pages
  79. Combine scripts from all extensions of the plugin when an extension is activated
  80. Fetch Children of Grouped Products Inside WooCommerce Product Loop
  81. How can I prevent my plugin go development trunk [closed]
  82. Best way to maintain and update 3rd-party WP plugin when developer is unresponsive?
  83. Are functions in main plugin file called before function bound to register_activation_hook runs?
  84. Best place for if/else piece of code related to custom plugin?
  85. How do you assign a UUID to posts/products/comments/reviews?
  86. How to make a implement queue for scheduling tasks in WordPress?
  87. Checkbox conflict in my custom plugin admin page
  88. how to do login using woocommerce rest api From android
  89. How to create a code editor for my plugin .?
  90. How to create a custom shortcode based on the layout?
  91. Manually set a custom admin sub-menu selected?
  92. wp-pagenavi getting 404 page not found
  93. How to get custom setting from get_option and pass it in getEntityRecords in gutenberg block?
  94. Custom URL image is not zooming
  95. The Admin page isn’t showing in the sidebar of the dashboard
  96. Display file contents within Plugin
  97. When to store store plugin options as a single database record?
  98. WordPress hack code issue, help required
  99. WordPress Global Var in Plugin but Outside Function
  100. Call to undefined function create_function() – PHP 8.2