Blog Documentation Book a Demo
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

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

JiceJice New
in Vanilla 2.0 - 2.8

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 MVP

    @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.
  • bijumkbijumk New

    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 MVP
    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

  • JiceJice New

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

  • Carlo_13Carlo_13 ✭

    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 Admin

    @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.

  • Carlo_13Carlo_13 ✭

    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 ?

  • x00x00 MVP

    @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.