Database: "Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP

TomNook

Hello Vanilla Community :)

I'm from Germany and I have a problem. I get the following error message when setting up:

• "Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause"

But when I look at the database, all the files have already been created .... I am desperate and do not remember; D Also in the title is already entered the website name. What do I have to do. I do not check it :( Please help me;)

Have a nice day. Thank you in advance! : D

CU

R_J

Not sure, but it might be a problem of the MYSQL version. Sure you have the minimum required version?

TomNook

Hallo aus Karlsruhe nach München ;-)

My webserver hoster says it would be the latest mysql version, but well: it's nitrado ^^

R_J

Hallo zurück!

I'm quite sure I have read that error message here before, but I could not find it. I do more research tomorrow, but maybe someone else has an idea before I find something

charrondev

I’ve got terrible internet so the best I can do is link these.

https://github.com/vanilla/vanilla/issues/7630#issuecomment-413076609

https://open.vanillaforums.com/discussion/36296/incorrect-table-definition-there-can-be-only-one-timestamp-column-with-current-timestamp-in-default

That second one in particular seems to have some resolution.