• Resolved wd69

    (@wd69)


    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\tid BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,\n\t\t\t\tmodifier_type VARCHAR(150) NOT NULL,\n\t\t\t\tsub_type VARCHAR(255) NOT NULL,\n\t\t\t\traw_amount DECIMAL(18,6) NOT NULL,\n\t\t\t\tslug VARCHAR(150) NOT NULL,\n\t\t\t\tdisplay_name VARCHAR(255) NOT NULL,\n\t\t\t\tstatus VARCHAR(20) NOT NULL DEFAULT ‘draft’,\n\t\t\t\tcreated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n\t\t\t\tstart_time TIMESTAMP NULL DEFAULT NULL,\n\t\t\t\tend_time TIMESTAMP NULL DEFAULT NULL,\n\t\t\t\tupdated_at TIMESTAMP 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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support tristan083

    (@tristan083)

    Hi @wd69 ,

    Thank you for reaching out.

    For me to understand your situation and learn more about your setup, could you provide the version of the following?

    1. PHP
    2. MySQL or MariaDB and version
    3. WordPress
    4. The Events Calendar
    5. Events Calendar Pro (if using)
    6. Event Tickets
    7. Event Tickets Plus (if using)
    8. Theme and Version
    Plugin Support Darian

    (@d0153)

    Hi there,

    It seems like it has been some time since we received a response from you, therefore, I will go ahead and close this thread for now. If you require any further assistance, please do not hesitate to reopen this thread or start a new one.

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

The topic ‘Plugin breaks site on install! DB problem’ is closed to new replies.