Title: Database not created
Last modified: March 22, 2017

---

# Database not created

 *  Resolved [Steve North](https://wordpress.org/support/users/tex0gen/)
 * (@tex0gen)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-not-created/)
 * The following error is generated when visiting the settings of the plugin.
 *     ```
       WordPress database error: [All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead]
       CREATE TABLE IF NOT EXISTS <code>wp_ebay_sites</code> ( <code>id</code> int(11) DEFAULT NULL, <code>title</code> varchar(128) NOT NULL, <code>code</code> varchar(16) DEFAULT NULL, <code>url</code> varchar(64) DEFAULT NULL, <code>enabled</code> int(11) DEFAULT NULL, <code>sort_order</code> int(11) DEFAULT NULL, <code>last_refresh</code> datetime DEFAULT NULL, <code>categories_map_ebay</code> text NOT NULL, <code>DispatchTimeMaxDetails</code> text NOT NULL, <code>MinListingStartPrices</code> text NOT NULL, <code>ReturnsWithinOptions</code> text NOT NULL, <code>CountryDetails</code> text NOT NULL,	<code>ShippingPackageDetails</code> text NOT NULL, <code>ShippingCostPaidByOptions</code> text NOT NULL, <code>ShippingLocationDetails</code> text NOT NULL, <code>ExcludeShippingLocationDetails</code> text NOT NULL, PRIMARY KEY (<code>id</code>) ) DEFAULT CHARSET=utf8 ;
   
       WordPress database error: [Table 'wpro.wp_ebay_sites' doesn't exist]
       SHOW FULL COLUMNS FROM <code>wp_ebay_sites</code>
       ```
   
 * Running PHP7 on Apache with Ubuntu 16.

Viewing 7 replies - 1 through 7 (of 7 total)

 *  Thread Starter [Steve North](https://wordpress.org/support/users/tex0gen/)
 * (@tex0gen)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-not-created/#post-8945541)
 * Do you guys even test with debug mode ON? I’m sat looking at a flood load of 
   PHP Notices.
 *     ```
       Notice: Undefined offset: 0 in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/page/ProfilesPage.php on line 119
   
       Notice: Trying to get property of non-object in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/page/ProfilesPage.php on line 119
   
       Notice: Undefined property: WPLE_eBaySite::$ShippingLocationDetails in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/EbayShippingModel.php on line 427
   
       Notice: Undefined property: WPLE_eBaySite::$ExcludeShippingLocationDetails in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/EbayShippingModel.php on line 436
   
       Notice: Undefined property: WPLE_eBaySite::$CountryDetails in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/EbayShippingModel.php on line 449
   
       Notice: Undefined property: WPLE_eBaySite::$DispatchTimeMaxDetails in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/eBaySite.php on line 114
   
       Notice: Undefined property: WPLE_eBaySite::$ShippingPackageDetails in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/eBaySite.php on line 117
   
       Notice: Undefined property: WPLE_eBaySite::$ReturnsWithinOptions in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/eBaySite.php on line 120
   
       Notice: Undefined property: WPLE_eBaySite::$ShippingCostPaidByOptions in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/eBaySite.php on line 123
   
       Notice: Undefined offset: 0 in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/EbayCategoriesModel.php on line 385
   
       Notice: Trying to get property of non-object in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/EbayCategoriesModel.php on line 386
   
       Notice: Undefined offset: 0 in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/EbayCategoriesModel.php on line 420
   
       Notice: Trying to get property of non-object in /home/wpro/public_html/wp-content/plugins/wp-lister-for-ebay/classes/model/EbayCategoriesModel.php on line 421
       ```
   
 *  Plugin Support [WP Lab Support](https://wordpress.org/support/users/wp-lab-support/)
 * (@wp-lab-support)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-not-created/#post-8945550)
 * Hello tex0gen.
 * I am sorry to hear about the issues you are having, but I am happy to help. Unfortunately
   this is something a developer will need to examine, so I have notified them of
   this and as soon as I have something for you I will get back to you in this forum
   thread.
 * Kind regards,
    John
 *  Plugin Support [WP Lab Support](https://wordpress.org/support/users/wp-lab-support/)
 * (@wp-lab-support)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-not-created/#post-8947798)
 * Hello tex0gen.
 * I can send you the SQL file for the ebay_sites table that appears to be missing
   in your install. All the other notices seem to be related to the missing table
   so most if not all of them should clear up as soon as that missing ebay_sites
   table is created.
 * I would not suggest you provide your email in this forum thread (for me to send
   you the file), so instead why don’t you open a ticket here: [Support Form](https://www.wplab.com/request-support/)
   and ask for the “ebay_sites” table that is missing and I will send you the sql
   file through email.
 * Kind regards,
    John
 *  Thread Starter [Steve North](https://wordpress.org/support/users/tex0gen/)
 * (@tex0gen)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-not-created/#post-8948222)
 * Amazing, thank you very much.
 * Any idea why this happened? I did try re-installing with the proper selected 
   option to remove the installation but no luck.
 * Thank’s again, will be in touch shortly.
 *  Plugin Support [WP Lab Support](https://wordpress.org/support/users/wp-lab-support/)
 * (@wp-lab-support)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-not-created/#post-8948297)
 * Hello tex0gen
 * It seems to happen with some databases that have a different prefix on their 
   database tables if I remember correctly. We can discuss in further detail with
   the developer through your ticket if you would like.
 * Kind regards,
    John
 *  Plugin Author [WP Lab](https://wordpress.org/support/users/wp-lab/)
 * (@wp-lab)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-not-created/#post-9026783)
 * This issue where the ebay_sites table wasn’t created during the initial setup
   process should be finally fixed in the latest version 2.0.17. It only happened
   on very few servers with a particular MySQL configuration, which is why we couldn’t
   identify the actual reason for this problem until a few weeks ago.
 * kind regards,
    Matt
 *  Thread Starter [Steve North](https://wordpress.org/support/users/tex0gen/)
 * (@tex0gen)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/database-not-created/#post-9027062)
 * No worries. Thank you for the update!

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Database not created’ is closed to new replies.

 * ![](https://ps.w.org/wp-lister-for-ebay/assets/icon-256x256.png?rev=2372284)
 * [WP-Lister Lite for eBay](https://wordpress.org/plugins/wp-lister-for-ebay/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wp-lister-for-ebay/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wp-lister-for-ebay/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-lister-for-ebay/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-lister-for-ebay/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-lister-for-ebay/reviews/)

 * 7 replies
 * 3 participants
 * Last reply from: [Steve North](https://wordpress.org/support/users/tex0gen/)
 * Last activity: [9 years, 2 months ago](https://wordpress.org/support/topic/database-not-created/#post-9027062)
 * Status: resolved