mysql date error.

[maxime_vhw]

So im trying to install an admin panel (bgpanel.net) but that was made for an older mysql.

i get  Incorrect datetime value: '0000-00-00 00:00:00' for column 'lastlogin' at row 1

I did ssh into my server (ubuntu 16.04) and then mysqld -u root -p, then i tried: SET SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; (because i found this on the internet).

But i still get the message SET SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';.

 

All suggestions are welcome.

 

[Leonard]

Did you use an online syntax checker?.....if this is not for national security or your financial gain you can use this

[maxime_vhw]

5 minutes ago, Leonard said:

Did you use an online syntax checker?.....if this is not for national security or your financial gain you can use this

Might be a stupid question but how do i use this?  Do i have to copy code from the php files or what? im not that used to mysql and php i just love to experiment. (and im just in my 1 year of applied informatics, im a newbie)

[Leonard]

Not a stupid question IMO......Mysql, in my day like eight years ago, had a code viewer like Visual Basic and we would just open that and paste the code for error checking for database creation.

 

You copy the mysql code and just paste it in the  field provided for the relevant code language, e.g. if you want to check mysql you copy the mysql code and select the mysql on the page then paste it and hit check, the same goes for php and all the other languages they support. 

 

To me the error points to like date/s that do not exist or will cause conflict with what ever you are trying to create No it can also be that there is a conflict with the older mysql version and the present one you are using and it may have nothing to do with the dates at all..