WordPress plugin won’t create custom tables

dbDelta() is picky– maddeningly picky.

  • You must put each field on its own line in your SQL statement.
  • You must have two spaces between the words PRIMARY KEY and the definition of your primary key.
  • You must use the key word KEY rather than its synonym INDEX and you must include at least one KEY.
  • You must not use any apostrophes or backticks around field names.

https://codex.wordpress.org/Creating_Tables_with_Plugins#Creating_or_Updating_the_Table

You have violated at least one of those rules– the last one–, and I believe the second one as well.

Related Posts:

  1. Disable email notification after change of password
  2. __(): What if I have to pass in a variable?
  3. Run WP-CLI using PHP
  4. How to remove duplicate sub-menu name for top level menu items in a plugin?
  5. Plugin update error message
  6. category_name not working (not showing up in sql query debug)
  7. How can I make my custom shortcode work in a Custom HTML Widget?
  8. PHP Deprecated: Non-static method should not be called statically
  9. Update Multiple Post Meta for the Same Post In One call?
  10. WordPress Hook that will run when media file deleted
  11. Post source link plugin – small modification
  12. Which hook callback has priority if both plugin and theme use the same hook?
  13. Calling function from within functions.php returns unwanted value
  14. Ajax call doesn’t work in frontend but it’s working in backend (when I’m logged in)
  15. Check if a class exists within a method
  16. How can I make the “Preview Post” button save and preview in the same window?
  17. Escape special characters in image link
  18. Cannot run the code after I activate the plugin
  19. Displaying admin notice dynamically
  20. Get total number of comment of the posts written by an author
  21. force customers to add only single item to card per purchase EDD [closed]
  22. How to get post URL in the_content filter?
  23. Write to / remove from default .htaccess file from plugin?
  24. printf – problem to understand code
  25. Auto delete WordPress users according to time
  26. How to cancel WordPress’ action/filter when using OOP with anonymous callback
  27. Why isn’t admin_notices displaying my text? [Simple Plugin, Beginner]
  28. add_query_arg not working
  29. Programatically download a plugin
  30. Error shown for Trying to get property ‘roles’ of non-object in WordPress After Content for User Roles
  31. How to Use Parameters with a Do_Action Function Within PHP Tags
  32. Theme my Login plugin, how to update fields
  33. CSS from textarea in options page to frontend what to do
  34. How do I pass a post ID to the page URL?
  35. New to wordpress, Question about editing PHP
  36. wp_set_auth_cookie causes 403 error in the wooCommerce checkout
  37. add image crop function like in wp customizer
  38. Calculate price and display on woocommerce product single page under price (simple price, variable price) [closed]
  39. Bootstrap and Custom CSS in custom plugin are being overwritten by theme
  40. Self-serve ad system like Reddit’s for WordPress? [closed]
  41. Create a plugin from within WordPress
  42. WordPress call_user_func_array() expects parameter 1 to be a valid callback, class
  43. Call plugin with php function
  44. Why is my custom post type not being activated on plug-in activation?
  45. What happens when WordPress memory limit is exceeded?
  46. iframe not showing in post (with “allow php in posts” plugin activated)
  47. how can I do something on new user registration?
  48. Any idea how to get something like this to work? [closed]
  49. wp_dequeue_script for a Plugin
  50. How do I add $_SESSION[”] to my wordpress page?
  51. Built a second plugin but it overwrote the first one
  52. WordPress: Add custom add_filter for custom functions
  53. How can i add simple code in only in posts by function.php
  54. Hide DIV if empty – Plugin Gallery
  55. How to change layout of shop page in wordpress? [closed]
  56. preg_replace() No ending delimiter ‘.’ found [closed]
  57. Trying to include files in plugin isn’t working
  58. WP Insert Post If user refreshes override new post
  59. Code for unique user visit count on every page WordPress
  60. How to makes changes on the shop/category/tag pages but not on the product pages in woocommerce?
  61. implement custom roles in custom plugin
  62. How to get current cart values using WC_Shortcodes?
  63. How to authorize viewing and clicking a function only logged users?
  64. Cant create table on plugin activation
  65. How to arrange custom posts in the backend/admin by custom taxonomy
  66. Custom Plugin: How to Include Install Buttons of other 3rd Party Plugins?
  67. Why is my shortcode not working?
  68. Getting Fatal error: Uncaught Error: Call to undefined function plugin_dir_path() when linking to another file within my wordpress plugin
  69. the content of the uploads folder gets deleted periodically, how to figure out what causes it?
  70. front end editor creation for Restropress plug in – displaying information from a WP admin area, on a different URL
  71. implement checkbox or toggle switch in plugin code
  72. Custom Field used to allow a Free Story; no longer works
  73. How to send new visitor to a splash page for only one time in wordpress?
  74. Cron job shedules replace?
  75. Create a form and have custom menu display based on user answers?
  76. Can i add custom code in Source in specific page, Header from function.php?
  77. Problem with conditional woocommerce custom checkout field
  78. GET web api method from a WordPress PHP script
  79. Adding link on title its in description but not in title see screenshots attached
  80. Editing Global Variables from Inside Functions
  81. How to save information related to post in database?
  82. Save selectlist value (taxonomy) in wp:wp_set_object_terms
  83. Page doesn’t load
  84. Posting code inside the post instead of in the template file using shortcode
  85. Metabox Data not saving
  86. Can anyone tell me why I can’t edit a plugin when it is installed without having to re-install?
  87. conditional tags for the output of a plugin
  88. Xml output not places where i want
  89. Can’t insert files in other inputs
  90. Including a PHP file via a function that is part of a plugin?
  91. How to fix ‘Call to undefined function do_settings()’ error?
  92. How to tweak a plugin without preventing it from updating
  93. Place max_execution_time in plugin [closed]
  94. Integrate Razorpay quick payments plugin with contact form7 plugin
  95. wordpress illegal string offset ‘parameter’ error
  96. Passing an input variable through a switch statement
  97. How to get URL param for pagination in shortcode?
  98. Make plugin admin page visible to other roles
  99. Is there any WordPress Plugin that provides video editing from front end side? [closed]
  100. How Create LastMod and Update Date Only on Taxonomy Category and Tags