Creates only one table and not the other

dbdelta demands that:

  • 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.
  • Field types must be all lowercase.
  • SQL keywords, like CREATE TABLE and UPDATE, must be uppercase.

If we look at your call:

$sql_one="CREATE TABLE " . $table_add_toplist . '(
      id INT(11) UNSIGNED AUTO_INCREMENT,
      link_id INT(11),
      visitor_ip VARCHAR(15)
      click_at DATETIME NOT NULL,
      site_votes INT(11),
      on_page VARCHAR(255),
      UNIQUE KEY id (id)
) '. $charset_collate .';';

We can see that you do not append a comma to the end of every line:

      link_id INT(11),
      visitor_ip VARCHAR(15)
      click_at DATETIME NOT NULL,

So you have invalid SQL, as visitor_ip lacks a comma at the end

Related Posts:

  1. CREATE TABLE with dbDelta does not create table
  2. How to use $wpdb to delete in a custom table
  3. get_results on large datasets
  4. dbDelta does not create Table, but returns success
  5. Is there a (better) way to access $wpdb results?
  6. Using $wpdb generates DB error
  7. How do you use prepare when asking for a list of id’s
  8. how to execute different sql query in non-sanitized $wpdb->get_results function
  9. WPDB update row with != in where clause
  10. How to update records using $wpdb?
  11. Problem in creating table through plugin code
  12. Need help writing a $wpdb query
  13. show badge with count for pending items in custom post type
  14. WP Sql query multiple where clause
  15. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  16. Modify the structure of data returned by $wpdb
  17. Syntax for $wpdb->prepare when searching in two columns
  18. Confused by $wpdb->prepare
  19. How to display user_nicename and usermeta values by custom query in WordPress?
  20. Optimizing WordPress Queries – Removing Group By ID
  21. How can I combine one field using wpdb and group by?
  22. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  23. how to use $wpdb->prepare to update a custom table
  24. WPDB Placeholders and second argument for prepared statements
  25. Increment integer field in database when WHERE needs to be dynamic [closed]
  26. Create new database through static page code
  27. Custom SQL query ORDER BY term_order
  28. Custom $wpdb returns unexpected time based results
  29. How to left join meta in queries [closed]
  30. wpdb->get_row is selecting the variable as a column name
  31. $wpdb query outputs php code instead of executing it
  32. wpdb query not working
  33. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  34. WPDB SQL Ignore `post_status` Parameter
  35. Can’t find out why dbDelta dosen’t create my table
  36. how to list all post that are in the custom taxonomy using $wpdb
  37. How to store sensitive user data (passwords)
  38. WPDB SQL query SELECT from category
  39. How to use WHERE NOT EXISTS query to avoid duplicate entry using $wpdb to save in custom table?
  40. Creating an Angular factory from custom database table
  41. wpdb->update update the entire table instead of one row
  42. How do I update post based on meta_key in another table?
  43. How to set up prepared query using IN statement
  44. Custom database query to validate data
  45. Alter the main search query to search posts by coauthor user name
  46. Protect custom form from SQL injection
  47. looking for a way to allow users to backup the plugin db data(save as)
  48. SQL Query to select post title & post ID from a particular category
  49. Get comments after specific date
  50. DBDelta: “table doesn’t exist” for a table that was just created
  51. query using wpdb in wordpress gets me no result
  52. Get count of rows based if column exists in two different tables
  53. query_vars doesn’t return query string (trying to get data from $wpdb)
  54. Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
  55. How do I check for a duplicate record before inserting using wpdb
  56. Pagination with custom SQL query
  57. $wpdb->insert not working in any way
  58. wpdb->insert not working
  59. Retrieving custom fields with $wpdb->get_results
  60. How do I create a single.php for a specific category?
  61. How to get top 10 user is based on user meta value
  62. $wpdb insert array
  63. Select from wp_post and multiple meta_value from wp_postmeta
  64. create drop down menu in theme customizer from custom db
  65. Are there risks associated with using wp_options table using wpdb to update theme options
  66. $wpdb->insert is running multiple times on page load, but only called once
  67. Get an array of meta_values for a user meta_key
  68. Can’t get result from sql using ajax result
  69. WPDB – How to search a column in a table
  70. The function can not create a table on MariaDB server
  71. WordPress (on AWS ubuntu) database Fails “Connection refused in .. /wp-includes/wp-db.php on line 1531”
  72. How to get entry by title by using wpdb
  73. $wpdb not being defined in function: Fatal error: Call to a member function query() on a non-object
  74. WordPress is trimming leading 0s
  75. WPDB SQL query with prepare() returning variable, not db value
  76. get_results not returning anything
  77. Save data from a checkbox to a wpdb array
  78. WP-PostRatings: list current user’s rated posts
  79. WPDB Join with custom table
  80. $wpdb->prepare affecting the query?
  81. Getting values from wpdb
  82. Why is this $wpdb query looping 5 times?
  83. wpdb query not returning results containing single quotes
  84. duplicate entries in database while using save_post or wp_insert_post
  85. Unknown column ‘siteurl’ in ‘where clause’ WPDB outside
  86. $wpdb->get_results(…) with $wpdb->prepare(…) returns empty array despite correct query
  87. Passing a SQL query to the WP Query
  88. Creating multiple tables with Plugin
  89. sort title descending with title with number
  90. Escaping a WPDB Object in One Shot
  91. Correct and secure way to access a custom SQL database in a custom PHP template file
  92. Create a stored procedure on plugin activation
  93. Get last element from wpdb as a string
  94. $wpdb query for price in custom field value
  95. Object Cache – Avoid db queries totally
  96. adding a log row log table, when the draft post publish
  97. wp-postratings: list current user’s unrated posts
  98. Out of Memory – Line 791 of WP-DB.php (mysql_real_escape_string)
  99. Site going down due to slow queries
  100. Call to a member function get_results() on a non-object in wordpress plugin