{"id":8945530,"date":"2017-03-22T19:10:04","date_gmt":"2017-03-22T19:10:04","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-not-created\/"},"modified":"2017-03-22T19:10:04","modified_gmt":"2017-03-22T19:10:04","slug":"database-not-created","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-not-created\/","title":{"rendered":"Database not created"},"content":{"rendered":"<p>The following error is generated when visiting the settings of the plugin.<\/p>\n<pre><code>WordPress database error: [All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead]\nCREATE TABLE IF NOT EXISTS &lt;code&gt;wp_ebay_sites&lt;\/code&gt; ( &lt;code&gt;id&lt;\/code&gt; int(11) DEFAULT NULL, &lt;code&gt;title&lt;\/code&gt; varchar(128) NOT NULL, &lt;code&gt;code&lt;\/code&gt; varchar(16) DEFAULT NULL, &lt;code&gt;url&lt;\/code&gt; varchar(64) DEFAULT NULL, &lt;code&gt;enabled&lt;\/code&gt; int(11) DEFAULT NULL, &lt;code&gt;sort_order&lt;\/code&gt; int(11) DEFAULT NULL, &lt;code&gt;last_refresh&lt;\/code&gt; datetime DEFAULT NULL, &lt;code&gt;categories_map_ebay&lt;\/code&gt; text NOT NULL, &lt;code&gt;DispatchTimeMaxDetails&lt;\/code&gt; text NOT NULL, &lt;code&gt;MinListingStartPrices&lt;\/code&gt; text NOT NULL, &lt;code&gt;ReturnsWithinOptions&lt;\/code&gt; text NOT NULL, &lt;code&gt;CountryDetails&lt;\/code&gt; text NOT NULL,\t&lt;code&gt;ShippingPackageDetails&lt;\/code&gt; text NOT NULL, &lt;code&gt;ShippingCostPaidByOptions&lt;\/code&gt; text NOT NULL, &lt;code&gt;ShippingLocationDetails&lt;\/code&gt; text NOT NULL, &lt;code&gt;ExcludeShippingLocationDetails&lt;\/code&gt; text NOT NULL, PRIMARY KEY (&lt;code&gt;id&lt;\/code&gt;) ) DEFAULT CHARSET=utf8 ;\n\nWordPress database error: [Table &#039;wpro.wp_ebay_sites&#039; doesn&#039;t exist]\nSHOW FULL COLUMNS FROM &lt;code&gt;wp_ebay_sites&lt;\/code&gt;<\/code><\/pre>\n<p>Running PHP7 on Apache with Ubuntu 16.<\/p>\n","protected":false},"template":"","class_list":["post-8945530","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/8945530","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/8945530\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=8945530"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}