Title: Database not created Last modified: September 20, 2025 --- # Database not created * Resolved [uponity](https://wordpress.org/support/users/uponity/) * (@uponity) * [8 months, 3 weeks ago](https://wordpress.org/support/topic/database-not-created-3/) * Error: `AH01071: Got error 'PHP message: WordPress database error Table 'XX.dptvndp_price_alerts_subscriptions' doesn't exist for query \n SELECT subs.*\n FROM dptvndp_price_alerts_subscriptions AS subs\n WHERE subs.status = 'pending' ORDER BY subs.date_created DESC made by require('wp-admin/menu.php'), require_once('wp-admin/includes/menu.php'), do_action('admin_menu'), WP_Hook->do_action, WP_Hook->apply_filters, Devnet\\ PriceAlerts\\Admin\\AdminSide->admin_menu, Devnet\\PriceAlerts\\Includes\\Helper:: get_subscriptions', referer: https://xxx.de/wp-admin/admin.php?page=price-alerts- subscriptions` Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Author [Marin Matosevic](https://wordpress.org/support/users/marinmatosevic/) * (@marinmatosevic) * [8 months, 3 weeks ago](https://wordpress.org/support/topic/database-not-created-3/#post-18649590) * That’s an unusual error, the plugin should automatically create its database tables during activation. Could you please try deactivating the plugin and then activating it again? This will trigger the table creation process. * Thread Starter [uponity](https://wordpress.org/support/users/uponity/) * (@uponity) * [8 months, 3 weeks ago](https://wordpress.org/support/topic/database-not-created-3/#post-18649597) * Thank you. I tried id. But not working. I find another Error in the Plugin Activation Process. Maybe it helps:`AH01071: Got error 'PHP message: WordPress database error Invalid default value for 'date_created' for query CREATE TABLE dptvndp_price_alerts_subscriptions(\ n\t\t\tid BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\n\t\t\t\n\t\t\t-- Product info\n\t\t\tproduct_id BIGINT(20) UNSIGNED NOT NULL,\n\t\t\tproduct_type VARCHAR( 20) NULL,\n\t\t\tproduct_price DECIMAL(10,2) NOT NULL,\n\t\t\tcurrency VARCHAR( 3) NULL,\n\t\t\ttarget_price DECIMAL(10,2) NULL,\n\t\t\n\t\t\t-- User info\n\ t\t\tname VARCHAR(120) NULL,\n\t\t\temail VARCHAR(120) NOT NULL,\n\t\t\topt_in TINYINT(1) UNSIGNED NULL,\n\t\t\tmarketing TINYINT(1) UNSIGNED NULL,\n\t\t\n\ t\t\t-- Tracking / extra data\n\t\t\tsecurity_token VARCHAR(255) NULL,\n\t\t\ tcustom_input VARCHAR(255) NULL,\n\t\t\tcustom_data TEXT NULL,\n\t\t\n\t\t\t-- Status & timestamps\n\t\t\tstatus VARCHAR(20) NULL,\n\t\t\tnotification_date DATETIME NULL,\n\t\t\tdate_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,\ n\t\t\n\t\t\tPRIMARY KEY (id),\n\t\t\tINDEX (product_id),\n\t\t\tINDEX (email),\ n\t\t\tINDEX (status),\n\t\t\tCONSTRAINT email_product_unique UNIQUE (email, product_id)\n\t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE...; PHP message: WordPress database error Can't create table 'wp_hfdso.dptvndp_price_alerts_meta' (errno: 150) for query CREATE TABLE dptvndp_price_alerts_meta (\n\t\t\tid BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,\n\t\t\tsubscribe_id BIGINT(20) UNSIGNED NOT NULL,\n\t\t\tmeta_key VARCHAR(100) NOT NULL,\n\t\t\tmeta_value TEXT NOT NULL,\ n\t\t\tPRIMARY KEY (id),\n\t\t\tINDEX (subscribe_id),\n\t\t\tFOREIGN KEY (subscribe_id) REFERENCES dptvndp_price_alerts_subscriptions(id) ON DELETE CASCADE\n\t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by activate_plugin, do_action(' activate_price-alerts/price-alerts.php'), WP_Hook->do_action, WP_Hook->apply_filters, activate_devnet_price_alerts, Devnet\\PriceAlerts\\Includes\\Activator::activate, Devnet\\PriceAlerts\\Includes\\Activator::setup_db_tables, Devnet\\PriceAlerts\\ Includes\\Activator::setup_price_alerts_meta_db_table, dbDelta', referer: https:// xxx.de/wp-admin/plugins.php?plugin_status=all&paged=1&s` * Plugin Author [Marin Matosevic](https://wordpress.org/support/users/marinmatosevic/) * (@marinmatosevic) * [8 months, 3 weeks ago](https://wordpress.org/support/topic/database-not-created-3/#post-18649634) * Thanks for reporting this! The issue might be related with how MySQL is configured on your server. Some setups don’t allow a `DATETIME` column to use `DEFAULT CURRENT_TIMESTAMP`. Because of that, the first table wasn’t created and the second one (with the foreign key) failed too. * If you’re comfortable editing code, find a file located: `/price-alerts/includes/ activator.php` * and change this line * ```wp-block-code date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ``` * to * ```wp-block-code date_created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ``` * Then deactivate and activate the plugin again to re-run table creation. * We’ll include this fix in the next release so it works on all setups. * Thanks again! * Thread Starter [uponity](https://wordpress.org/support/users/uponity/) * (@uponity) * [8 months, 3 weeks ago](https://wordpress.org/support/topic/database-not-created-3/#post-18649928) * Now it works 🙂 Thank you very much * Plugin Author [Marin Matosevic](https://wordpress.org/support/users/marinmatosevic/) * (@marinmatosevic) * [8 months, 3 weeks ago](https://wordpress.org/support/topic/database-not-created-3/#post-18650766) * Great to hear it’s working now 🙂 The new version is already released. Thanks for letting me know! Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘Database not created’ is closed to new replies. * ![](https://ps.w.org/price-alerts/assets/icon-256x256.png?rev=3309720) * [Price Alerts for WooCommerce](https://wordpress.org/plugins/price-alerts/) * [Support Threads](https://wordpress.org/support/plugin/price-alerts/) * [Active Topics](https://wordpress.org/support/plugin/price-alerts/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/price-alerts/unresolved/) * [Reviews](https://wordpress.org/support/plugin/price-alerts/reviews/) * 5 replies * 2 participants * Last reply from: [Marin Matosevic](https://wordpress.org/support/users/marinmatosevic/) * Last activity: [8 months, 3 weeks ago](https://wordpress.org/support/topic/database-not-created-3/#post-18650766) * Status: resolved