Mantis mysql database upgrade problem

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
ctl_erp_support
Posts: 7
Joined: 02 Mar 2021, 03:53

Mantis mysql database upgrade problem

Post by ctl_erp_support »

Hi,

I am upgrading our Mantis from 1.1.7 to 2.24.2.

When I do upgrade my mysql database, the following error is displayed.

The upgrade process is trying to create the following tables
1) mantis_plugin_table
2) mantis_category_table
3) mantis_bug_revision_table

As these tables are already existing, I have renamed.

After sometime, this error displayed

Schema step 140: AddColumnSQL ( mantis_tokens_table )
BAD
ALTER TABLE mantis_tokens_table ADD timestamp_int INTEGER UNSIGNED NOT NULL DEFAULT 1
Invalid default value for 'timestamp'

Please anyone advise how to resolve this.

Our environment
--------------------
Mysql 8.0 database server
PHP 7.2
RedHot 8.0
Post Reply