dbDelta does not create Table, but returns success

The Problem was in this line:

time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

I changed it to:

time TIMESTAMP DEFAULT CURRENT_TIMESTAMP,

Now, it works.

Related Posts:

  1. Problem in creating table through plugin code
  2. Create new database through static page code
  3. CREATE TABLE with dbDelta does not create table
  4. Can’t find out why dbDelta dosen’t create my table
  5. Creates only one table and not the other
  6. DBDelta: “table doesn’t exist” for a table that was just created
  7. $wpdb->get_row() only returns a single row?
  8. wpdb->insert: do I need to prepare against SQL injection?
  9. How to parse row results from $wpdb -> get_results
  10. Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
  11. what is the way to see the currently executing query in wordpress?
  12. Fetch array with $wpdb
  13. How do I check for a duplicate record before inserting using wpdb
  14. Does dbDelta delete columns as well?
  15. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  16. How to use $wpdb to delete in a custom table
  17. $wpdb->insert not working in any way
  18. WPDB prepare – like % – placeholders?
  19. dbDelta only creates the last table
  20. $wpdb->update multiple rows, like IN in normal SQL
  21. Matching database content types to PHP types
  22. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  23. How to define composite keys with dbDelta()
  24. get_results on large datasets
  25. $wpdb->insert() and Values for Datetime Columns?
  26. $wpdb->last_error doesn’t show the query on error
  27. Avoiding “Usage of a direct database call is discouraged”
  28. Theoretical Multi-Server WordPress Setup with Shared Users
  29. Change post status based on meta value
  30. wpdb->insert not working
  31. Saving custom form data into database
  32. passing variables as parameters to stored procedures via wpdb from php-script
  33. Why does dbDelta() not catch MysqlErrors?
  34. Get data from database table by post_id to get data from second database table
  35. wp-content/db.php : where is this file?
  36. Quotes in table name
  37. Delete/replace img tags in post content for auto published posts [closed]
  38. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  39. $wpdb->get_results() returns good result only in first foreach iteration
  40. $wpdb->insert – inserting multiple rows
  41. Speed optimization of $wpdb->get_results
  42. How do I create a single.php for a specific category?
  43. $wpdb prepared with search term
  44. WPDB->insert with special characters
  45. What does wp_update_post() do that the $wpdb class does not?
  46. How Can I Use $wpdb in PayPal IPN file?
  47. $wpdb is get_results escaped
  48. $wpdb->query() multiple query support
  49. wpdb-> not adding prefix to custom table
  50. Is there a (better) way to access $wpdb results?
  51. Using $wpdb generates DB error
  52. WordPress insert NOW() in TIMESTAMP column returns all zeros
  53. How do you use prepare when asking for a list of id’s
  54. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  55. $wpdb prepare issue with mysql DATE_FORMAT
  56. How-To: wpdb Insert Record With Date
  57. $wpdb->prepare not working with update table prefix
  58. How to use prepare to query with variables
  59. Use $wpdb in wordpress theme files
  60. How to pass NULL in where array for $wpdb->update
  61. how to execute different sql query in non-sanitized $wpdb->get_results function
  62. $wpdb not returning data
  63. Get random row from custom table
  64. How to get top 10 user is based on user meta value
  65. $wpdb Query Result not coming but in phpmyadmin it works [closed]
  66. WPDB update row with != in where clause
  67. store custom WP table names in a global variable
  68. wpdb prepare: passing varible number of fields as second argument
  69. $wpdb insert array
  70. I am not understandinhg $wpdb->prepare correctly
  71. Wpdb query for comment meta for current post
  72. How to update records using $wpdb?
  73. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  74. I want to update my postcontent with $wpdb
  75. How to save html and text in the database?
  76. XOR functionality for meta_query
  77. How to email user after inserting the username in database in WordPress
  78. $wpdb->replace / Replace or update primary key
  79. Join inside a wpdb query.. confused!
  80. Create an array with a string key from wpdb->get_results
  81. How to fetch an array in $wpdb?
  82. $wpdb – do you have to use foreach even if there will always only be one result?
  83. How to Modify this $wpdb query to accept an array of post statuses
  84. Replicating the WP_Query ‘s’ param with $wpdb
  85. Why doesn’t my insert query work?
  86. Need help writing a $wpdb query
  87. How to prevent $wpdb->prepare stripping a leading zero in variable value?
  88. Generate a unique hash/number for tracking on $wpdb insert
  89. get the number of queries made on a page(inside my plugin)
  90. Doing a loop with multiple DBs simultaneoulsy
  91. Using WPDB class
  92. show badge with count for pending items in custom post type
  93. WPDB Update using Conditional Arrays
  94. $wpdb->insert query changes to SHOW COLUMNS query Output
  95. How can I migrate mysql_fetch_array to $wbpdb?
  96. $wpdb->get_results returns empty but value exists
  97. Fixing wpdb->get_results and wpdb->prepare?
  98. How does the WXR file differ from the WPDB?
  99. WP Sql query multiple where clause
  100. Problem displaying inserted form

Leave a Comment