Plugin breaks site on install! DB problem
-
Please can you advise / fix this? I see someone else had same problem 4 months ago. Thank you.
[Fri Mar 21 11:06:43.635057 2025] [php7:notice] [pid 16471] WordPress database error Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause for query \n\t\t\tCREATE TABLE
wp_tec_order_modifiers(\n\t\t\t\tidBIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n\t\t\t\tmodifier_typeVARCHAR(150) NOT NULL,\n\t\t\t\tsub_typeVARCHAR(255) NOT NULL,\n\t\t\t\traw_amountDECIMAL(18,6) NOT NULL,\n\t\t\t\tslugVARCHAR(150) NOT NULL,\n\t\t\t\tdisplay_nameVARCHAR(255) NOT NULL,\n\t\t\t\tstatusVARCHAR(20) NOT NULL DEFAULT ‘draft’,\n\t\t\t\tcreated_atTIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n\t\t\t\tstart_timeTIMESTAMP NULL DEFAULT NULL,\n\t\t\t\tend_timeTIMESTAMP NULL DEFAULT NULL,\n\t\t\t\tupdated_atTIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,\n\t\t\t\tPRIMARY KEY (id)\n\t\t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘plugins_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Tribe__Main->plugins_loaded, do_action(‘tribe_common_loaded’), WP_Hook->do_action, WP_Hook->apply_filters, Tribe__Tickets__Main->bootstrap, Tribe__Tickets__Main->bind_implementations, tribe_register_provider, TEC\Common\Contracts\Container->register, TEC\Common\lucatume\DI52\Container->register, TEC\Tickets\Provider->register, TEC\Common\Contracts\Container->register, TEC\Common\lucatume\DI52\Container->register, TEC\Tickets\Commerce\Provider->register, TEC\Common\Contracts\Container->register, TEC\Common\lucatume\DI52\Container->register, TEC\Common\Contracts\Provider\Controller->register, TEC\Tickets\Commerce\Order_Modifiers\Controller->do_register, TEC\Common\Contracts\Container->register, TEC\Common\lucatume\DI52\Container->register, TEC\Common\Contracts\Provider\Controller->register, TEC\Tickets\Commerce\Order_Modifiers\Tables->do_register, TEC\Common\StellarWP\Schema\Register::table, TEC\Common\StellarWP\Schema\Builder->up, TEC\Common\StellarWP\Schema\Tables\Contracts\Table->update, TEC\Common\StellarWP\DB\DB::delta, TEC\Common\StellarWP\DB\DB::runQueryWithErrorChecking, TEC\Common\StellarWP\DB\DB::TEC\Common\StellarWP\DB\{closure}, dbDelta, referer: http://website.co.uk/wp-admin/admin.php?page=tec-tickets-settings
[Fri Mar 21 11:06:43.635235 2025] [php7:error] [pid 16471] PHP Fatal error: Uncaught TEC\Common\StellarWP\DB\Database\Exceptions\DatabaseQueryException: Database Query in /home/var/www/html/website/wp-content/plugins/event-tickets/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php:291\nStack trace:\n#0 /home/var/www/html/website/wp-content/plugins/event-tickets/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php(79): TEC\Common\StellarWP\DB\DB::runQueryWithErrorChecking(Object(Closure))\n#1 /home/var/www/html/website/wp-content/plugins/event-tickets/common/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Tables/Contracts/Table.php(521): TEC\Common\StellarWP\DB\DB::delta(‘\n\t\t\tCREATE TABL…’)\n#2 /home/var/www/html/website/wp-content/plugins/event-tickets/common/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Builder.php(270): TEC\Common\StellarWP\Schema\Tables\Contracts\Table->update()\n#3 /home/var/www/html/website/wp-content/plugins/event-tickets/common/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Register.php(133): TEC\Common\StellarWP\Schema\Builder->up( in /home/var/www/html/website/wp-content/plugins/event-tickets/common/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php on line 291, referer: http://website.co.uk/wp-admin/admin.php?page=tec-tickets-settings
The topic ‘Plugin breaks site on install! DB problem’ is closed to new replies.