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. Objective Best Practices for Plugin Development? [closed]
  5. Post meta vs separate database tables
  6. How do i best handle custom plugin page actions?
  7. How to create an API for my plugin?
  8. Is it ever okay to include inline CSS in plugins?
  9. Plugins in symlinked directories?
  10. Is it mandatory to use $wpdb->prefix in custom tables
  11. In Which Contexts are Plugins Responsible for Data Validation/Sanitization?
  12. Plugin Form Submission Best Practice
  13. Update Option Stored in Multi-Dimensional Array
  14. Best way to abort plugin in case of insufficient PHP version?
  15. How can I configure Docker for developing and deploying a custom theme?
  16. What do you think about custom designed plugin/theme options UIs?
  17. No Error Log File, no debug info
  18. Where to put third party PHP library?
  19. Is the new WordPress 3.1 admin bar pluggable and how can I extend it?
  20. How to use PanelColorSettings in custom Gutenberg block?
  21. Getting a peer review for my new plugin?
  22. Default table collation on plugin activation?
  23. Optimize shortcode callbacks
  24. Using a database view = evil incarnate?
  25. How to integrate a PHP webmail script into the backend of WordPress?
  26. Using filters and actions for plugin API?
  27. Is There A Hook To Process The Content Of The Text Widget?
  28. How to Change the Entire WordPress Admin panel Look and Feel?
  29. Writing a plugin that notify my friends of new post that mentions(@) them
  30. Getting wrong relationship value in $args in wp_Query?
  31. Plugin Development for registered users
  32. Search: how to extend the existing search to include a custom table
  33. Is there documentation reference for forms in menu and setting pages?
  34. Optimising a big WordPress site
  35. wpdb->prepare and mysql UPDATE – how is it done?
  36. Enqueue script globally
  37. dbDelta SQL Query Not Working
  38. How to modify files inside wp-includes directory in wordpress
  39. How should I go about registering JavaScript that isn’t a file? [duplicate]
  40. dbDelta not installing database
  41. Is it necessary to do validation again when retrieving data from database?
  42. Custom entity search and display
  43. How to set a cookie for logged in users to md5($user->ID . “my_secret”)?
  44. What is the best way to store a few fields?
  45. Loading Modernizr (or other JavaScript libraries) for use in a plugin
  46. Adding columns to core tables
  47. How to query custom db table?
  48. Delete data from database using row action
  49. Show dynamic list of products from custom api of another database under same host
  50. How do I have now a duplicated user entry if this is not allowed (and I cannot replicate it)?
  51. Show message from backend
  52. Alternative functions for mysql_free_result and mysql_ping in wordpress functions
  53. Why in this archive page that call query_posts() function show only the last 10 posts?
  54. Make Database query only when option is updated
  55. Create Widget or Enable Shortcodes in Sidebar
  56. Can we intercept user_login and user_pass from a wp_login_form?
  57. How best to handle database version dependence (from $wp_db_version)
  58. WP: Search and replace in DB programmatically
  59. Using AND and bracket grouping in SQL not working
  60. Logout after clicking URL link results in “headers already sent” error
  61. Two different wordpress sites – same server and IP address. Gaining Access to database 1 of 2
  62. how to save wp_editor html content in options table
  63. Converting core modification to a plugin
  64. Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
  65. Plugin Development: Storing and Manipulating Data That Fits JSON in Database
  66. How to use a WP_Customize_Control outside of the Customizer?
  67. What might be the reason of Couldn’t fetch mysqli_result on another domain?
  68. How do I debug an error that a plugin is causing?
  69. How to replace settings in WordPress plugin from a theme
  70. Save temporary registration data
  71. How to remove/replace current page template?
  72. Update plugin settings option_name for big plugin update
  73. $wpdb->update Issue
  74. Integrating Custom Database with WordPress
  75. dbdelta failing with error: “WordPress database error Table ‘wp_2_myPlugin’ already exists
  76. Setting a post’s category
  77. WordPress database error: [Query was empty] – using $wpdb->prepare()
  78. Extract Information from post content (using regex?)
  79. How to determine which capability to use?
  80. Serial Number from custom table not appear in woocommerce_email_before_order_table action
  81. Customise Grouped Product display in Woocommerce with custom column
  82. Custom Endpoint – Does it possible to use PUT method with WP API Rest?
  83. Why won’t this submenu page show? – My First WordPress Plugin
  84. Error code when migrate
  85. How to create a custom post-new.php page for plugin , no wp menu
  86. Want to know how to reveal a WordPress theme, considering the theme name is hidden?
  87. Why User_login key doesn’t work with wp_update_user()
  88. How to get inserted row IDs for bulk/batch insert with wpdb query?
  89. Save meta box data from selected dropdown list in bbpress reply form
  90. Metabox types list
  91. Where to save Gutenberg plugin data?
  92. Rate limiting ajax requests in WordPress
  93. WordPress Fatal error: Uncaught Error: Call to undefined function dbDelta()
  94. Does hooking into a plugin action / filter override the plugin’s function for that hook?
  95. How to prevent users from deleting their accounts?
  96. Hiding class namespace from plugin’s extensions
  97. Use admin-post to submit form data to external database
  98. Set widget icon in Customizer?
  99. Save in my custom admin page and redirect to the saved object
  100. Relational / Associate tables using native WordPress functionality
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)