Table not getting created upon activation of WP Theme

dbDelta is extremely picky. Looking at your code I’d say you’ve violated this rule:

You must put each field on its own line in your SQL statement

Two of your fields are sharing lines with parenthesis. I haven’t tested that particular pattern but dbDelta is extremely picky.

I don’t know if that space after NOT NULL will matter.

I doubt that checking for the existence of the table is necessary. Checking your option should be sufficient.

And finally, register_activation_hook is for plugins, not themes. There is no similar specialized theme activation hook that I am aware of. There are a number of work-arounds that have been suggested if you search this site for them.

Related Posts:

  1. Display Tables in a slider
  2. Why majority of fileds in wp_posts table prefixed with post_?
  3. How to insert more than one row of data into a table at one time
  4. Tablepress won’t update the table data [closed]
  5. WP_List_Table error on WordPress 4.4
  6. Bulk actions redirects to “options.php” page when clicked (WP_List_Table)
  7. putting wp_query data into html table
  8. Looking for a simple tool to update a table
  9. Table editing in WordPress
  10. How can I add a row in a table from a Linux Shell?
  11. WordPress admin Tables use to display own data – In admin WP
  12. Creating a Restaurant Menu
  13. How to populate custom tables with rows of data
  14. How to build a dynamic data table with backend fields for the user
  15. How to add custom field to wp_list_table
  16. database select issue
  17. get table prefixes for SUB-SITES?
  18. WordPress Table didn’t look right
  19. CSS for Table Rows and Columns
  20. How can I create this type of table/catalog? [closed]
  21. table chaos since upgrade to 4.8
  22. echo spesific title get_the_title
  23. What is the use of to_ping and pinged column?
  24. Removing filter dropdown in posts table (in this case Yoast SEO)
  25. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  26. How do you display posts in a dynamic table?
  27. Create a formatted table-like menu
  28. How To Make Connection To WordPress Data Base In A Plugin?
  29. Are custom post types suitable for storing high numbers of data elements, in this case chat messages?
  30. Include custom table into search results
  31. Save custom post type in different table
  32. Visual Editor freezing on text highlight since 4.3
  33. Should I global $wpdb outside of any of my plugin’s functions scope?
  34. Database with mixed collation (utf8mb4 & utf8_general_ci)
  35. Return number of items in a table with post id
  36. How can I add data to a custom column in the Users section of the wordpress backend?
  37. Why my database table not created on activation?
  38. How to update an existing table while updating plugin?
  39. Jquery not showing in homepage
  40. Accessing data from a non-WP database/table within a page content
  41. How to add a sortable date column in an admin page?
  42. WooCommerce/WordPress: how hide entire table form after submit (Admin Dashboard)?
  43. Filter table with dropdown
  44. input data and output table [closed]
  45. User Meta Data in a Sortable Table
  46. How do I get create a custom table showing the hours remaining for all customers in one page from this transactions page?
  47. WordPress plugin output formatting
  48. Retrieve data from the database to table such as comments in the admin control panel
  49. Modification of how the data is controlled/showed and stored
  50. Pull data and display as rows and columns
  51. Obtaining user table for one site on multisite set up
  52. Gutenberg table block with Bootstrap .table class
  53. dbDelta not installing database
  54. Is it a good idea to add a column to the posts table?
  55. display menu as table layout
  56. Is there alternative to WP_List_Table?
  57. Create new database through static page code
  58. HTML tables in content areas
  59. Register custom table for WP to use in a plugin
  60. How to make wordpress use a non-wordpress users table?
  61. Duplicate rows in meta table, any known relations in WC?
  62. HTML Form Submit to table in same page
  63. In WordPress, I want to run a loop to get posts in tabular format
  64. If I update WordPress my custom data will be deleted from the wp_users table?
  65. Editing mysql tables/database with wordpress or other app/cms
  66. Pagination in html table is not working
  67. How to insert dash (-) into database using wpdb and new_to_publish hook?
  68. Can i set css class for table via TinyMCE [closed]
  69. How to avoid repeating similar properties for all tds of a table in a wordpress post
  70. Can’t create tables with my plugin
  71. Serial Number from custom table not appear in woocommerce_email_before_order_table action
  72. Create multiple pages with tables from json file
  73. Table Sorter sort by span title?
  74. WordPress search on a custom table
  75. Plugins custom table not being created on activation
  76. Right way to store a large set of similar information on website? [duplicate]
  77. How to edit custom table data in frontend
  78. I want to schedule email (date, time is in database->table) wp_schedule_event() not working
  79. How to display custom fields as table in Woocommerce
  80. How to map data on CSV to web pages?
  81. Table styles disappear when updating content
  82. Need help for creating custom table on wordpress
  83. Show a table from data submitted by a form from a user
  84. Adding list of Indexes in wordpress document
  85. Loop posts in a table ordered by a custom field value
  86. MySQL swap one table for another?
  87. Plugin does not create a custom table upon activation
  88. Insert double entry in DB
  89. Database custom table issues – incorrect result displayed
  90. MailPress plugin: table inline style tag removed when sending the newsletter
  91. get_var result empty for query of custom table in plugin admin
  92. Create hundreds of users with just ID in phpMyAdmin
  93. How to list Tags using get_tags in an html table?
  94. get the count of table rows
  95. Add new MCE button for toggle specific cell background color
  96. How to get value from wp_usermeta table in database?
  97. Share or sync user table data with another user table
  98. Have WordPress Use a Different Database for users
  99. How to set an exact search box in tablepress plug-in
  100. Extra HTML code added to my (on Chrome DevTools) but not on source code