Jump to content
TNG Community
JPT

Upgrade from 11 to 12 SQL fails

Recommended Posts

JPT

Hi,

I just updated from TNG-11 to 12. Most of it went fine, but there is an SQL statement that fails:

ALTER TABLE tng_users ADD dt_consented DATETIME NOT NULL after dt_activated

The statement does not make sense, as you cannot ADD ! a column without ! allowing NULL. (I think)

Any replacement for the failed statement?

I tried removing NOT NULL. Seems to work. Any hint how to test if everything was done as it should?

thanks

JPT

MySQL 5.7.25 on Ubuntu 18.10

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×