Plugin: database creation

This part in your table creation SQL looks wrong: DEFAULT CHARSET=CHARSET=utf8. It should just be DEFAULT CHARSET=utf8.

Also, dbDelta() is quite a delicate function. Don’t ask me why, but you need to put a double space after the PRIMARY KEY keyword. You also need to get rid of the quotes around the field names because dbDelta() chokes on those. Don’t use backticks neither.

And, of course, set WP_DEBUG to TRUE while debugging.

Related Posts:

  1. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  2. Associating special meaning with user id 0
  3. Can I log the searches that are returning 404 in the DB?
  4. Is it ever okay to include inline CSS in plugins?
  5. Is it mandatory to use $wpdb->prefix in custom tables
  6. How can I configure Docker for developing and deploying a custom theme?
  7. Is the new WordPress 3.1 admin bar pluggable and how can I extend it?
  8. Getting a peer review for my new plugin?
  9. Default table collation on plugin activation?
  10. Using filters and actions for plugin API?
  11. How to Change the Entire WordPress Admin panel Look and Feel?
  12. Getting wrong relationship value in $args in wp_Query?
  13. Allowing for multiple template views on the Gallery Settings page when using the Visual Editor
  14. Using Primary Color in Plugin Block
  15. What is the added “complexity” of custom tables?
  16. How is the data stored in the database?
  17. When is it appropriate to put functions on page template vs. functions.php?
  18. How to modify post content before writing to database?
  19. Actions or filters fired when data is saved in a custom table
  20. How to use wp_set_password in a plugin?
  21. Is there any reason only 1 (my) IP would be added to this table using $wpdn->insert?
  22. How to store data for posts/pages built with drag-n-drop builder?
  23. Delete a specific item menu when I deactivate my plugin
  24. What for the tables ending with the meta used in database of wordpress?
  25. Creating table with plugin is not working
  26. Get the password key when using the wp_new_user_notification_email filter
  27. Order properties should not be accessed directly
  28. dbDelta() Error – Incorrect index name ” for query ALTER TABLE
  29. How to deal with equal & similar arguments for a function?
  30. Update/insert only a column of database table
  31. Executing a function upon webhook calling wordpress
  32. How to Create database table when Plugin installed/activated, and delete database when Plugin deleted
  33. Customizer: widget-synced triggers twice
  34. WordPress not working on localhost
  35. how to use hook deleted_user into custom function to delete user from custom table
  36. Where to store the name of a custom table?
  37. WordPress is automatically linking plain text email addresses
  38. Is Using WordPress Supplied WYSIWYG Advisable?
  39. ServerSideRender and Media Object: attributes passing image data object to php renderer even though it’s not set
  40. I’m designing a plugin to create database indexes. Suggestions?
  41. WordPress database error for query INSERT INTO
  42. How to connect to AWS RDS external database (not for the core WordPress db)
  43. Clearing caches on plugin uninstall
  44. How to use a hook to override an update_post_meta call in a plugin?
  45. Are there any scripts, classes, and/or functions built-in to WP for a plugin to export/import its saved data from wp_options?
  46. Strange issue saving custom field data for a WooCommerce order
  47. Form doesnt save to database
  48. Updating Woocommerce Settings API when WordPress Settings API saved and vise versa
  49. Is using custom table to suit business needs instead of transients a big hit to page load speed?
  50. Optimising a big WordPress site
  51. How to modify files inside wp-includes directory in wordpress
  52. How to set a cookie for logged in users to md5($user->ID . “my_secret”)?
  53. What is the best way to store a few fields?
  54. Loading Modernizr (or other JavaScript libraries) for use in a plugin
  55. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  56. Make Database query only when option is updated
  57. Create Widget or Enable Shortcodes in Sidebar
  58. Can we intercept user_login and user_pass from a wp_login_form?
  59. Logout after clicking URL link results in “headers already sent” error
  60. Plugin Development: Storing and Manipulating Data That Fits JSON in Database
  61. How to use a WP_Customize_Control outside of the Customizer?
  62. How do I debug an error that a plugin is causing?
  63. Update plugin settings option_name for big plugin update
  64. Integrating Custom Database with WordPress
  65. Setting a post’s category
  66. WordPress database error: [Query was empty] – using $wpdb->prepare()
  67. Extract Information from post content (using regex?)
  68. Customise Grouped Product display in Woocommerce with custom column
  69. Custom Endpoint – Does it possible to use PUT method with WP API Rest?
  70. Why won’t this submenu page show? – My First WordPress Plugin
  71. How to get inserted row IDs for bulk/batch insert with wpdb query?
  72. Metabox types list
  73. Where to save Gutenberg plugin data?
  74. Rate limiting ajax requests in WordPress
  75. Does hooking into a plugin action / filter override the plugin’s function for that hook?
  76. How to prevent users from deleting their accounts?
  77. Hiding class namespace from plugin’s extensions
  78. Set widget icon in Customizer?
  79. Save in my custom admin page and redirect to the saved object
  80. Relational / Associate tables using native WordPress functionality
  81. Determine if the current page, is being edited
  82. WordPress delete mysql rows with string
  83. How to store in the database directly the translation?
  84. PHP includes with AJAX actions
  85. How and when would I implement some code which would take data from one part of the Db and put it in another?
  86. Custom Post Type and Functions
  87. Theming Custom Plugin Page
  88. Best practice: What belongs in theme and what in plugin for large eCommerce website
  89. Adding class to the parent of current-post-ancestor / current-menu-parent / current-post-parent
  90. Dynamic banner for use on external sites
  91. What method should I use to store my plugin data (multi level menus with options on each item)
  92. Adding Meta box to thrid-party plugin
  93. How to add additional field in a table row after creating a table?
  94. WordPress plugin tables become corrupt
  95. How do I store a custom dataset in WordPress to best take advantage of API?
  96. Is Explicit Versioning a better alternative to Semantic Versioning for wordpress?
  97. Custom plugin not appearing
  98. Leveraging Core Functionality in Icon Upload Plugin [closed]
  99. Is there any other ways to replicating changes on live from staging without pushing from git
  100. WordPress database error: [Table ‘bitnami_wordpress.questions’ doesn’t exist]