Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT

Hi,

I try to install vanilla forums to test it but i have an error :
Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
How do i install it ?
I use MySQL 5.5 and i have seen no pre-requisite about the minimum version i can use.

Comments

  • whu606whu606 I'm not a SuperHero; I just like wearing tights... Moderator

    @Jice

    Welcome to the community.

    Please make sure you have met the following minimum requirements (from the README)

    Our minimum requirements are now:

    • PHP 7.0 or newer.
    • PHP extensions mbstring (--enable-mbstring), cURL (--with-curl), and PDO (on by default).
    • To import into Vanilla you need MySQLi (--with-mysqli).
    • To use our social plugins you need OpenSSL.
    • MySQL 5.0 or newer (or Percona/MariaDB equivalent).
    • MySQL strict mode disabled.
  • Im also getting the same error while trying to install vanilla. Since my server is only having php 5.6 I'm installing version 2.5.2 of vanilla

  • JiceJice New
    edited May 2018

    Hi
    Everything seems ok to me.

    my php is 7.0.27
    and my php info says :

    mbstring
    Multibyte Support enabled

    curl

    cURL support enabled
    cURL Information 7.56.0

    mysqli

    MysqlI Support enabled
    Client API library version mysqlnd 5.0.12-dev - 20150407

    mysql is 5.5 and sql-mode is empty (=disabled ?)
    my.ini :
    Set the SQL mode

    sql-mode=""

    And i still have the error.
    When I search for it on google, it's always said that 2 current_timestamps are not allowed in the same table definition...

  • ShadowdareShadowdare π Moderator
    edited May 2018

    Are you able to upgrade to a newer version of MySQL? This TIMESTAMP restriction has been lifted in v5.6.5 and newer.

    Add Pages to Vanilla with the Basic Pages app

  • Not sure... I'll have a try but for the real use, it probably won't be possible

  • Hi there.

    I am having the same issue with the last version of Vanilla.
    Problem is, I am using php 7.2 and 5.5.60-MariaDB.

    So I really don't know where the error come from. :o

  • R_JR_J Cheerleader & Troubleshooter Munich Moderator

    @Shadowdare said:
    Are you able to upgrade to a newer version of MySQL? This TIMESTAMP restriction has been lifted in v5.6.5 and newer.


  • So I have update to MariaDB version 10.1.37, and it works great now. Thanks!
    Strange thing is the last version of plesk ( 17 ) is shipped with MariaDB 5.5.6.

    I followed this guide:
    https://support.plesk.com/hc/en-us/articles/213403429

    But why isn't Plesk shipped with version by version 10 by default ?

  • @Carlo_13 said:
    So I have update to MariaDB version 10.1.37, and it works great now. Thanks!
    Strange thing is the last version of plesk ( 17 ) is shipped with MariaDB 5.5.6.

    I followed this guide:
    https://support.plesk.com/hc/en-us/articles/213403429

    But why isn't Plesk shipped with version by version 10 by default ?

    you would have to ask plesk that.

    grep is your friend.

Sign In or Register to comment.