#1067 - Invalid default value for 'created_date'

imabotmail

Well-known member

Trusted Uploader

Jan 17, 2020

338

302

63

• May 28, 2022

• #1

I'm trying to run the following query into mysql via phpmyadmin and I keep getting this error and I don't know know how to solve it.

Spoiler

I've tried to everything listed here: Google Search and nothing works. What am I doing wrong? Any mysql expert here, please help.

 

jackdanielz

New member

May 5, 2022

24

11

3

• May 28, 2022

• #2

imabotmail said:

I'm trying to run the following query into mysql via phpmyadmin and I keep getting this error and I don't know know how to solve it.

Spoiler

I've tried to everything listed here: Google Search and nothing works. What am I doing wrong? Any mysql expert here, please help.

Click to expand...

If you replace the following two lines, it should work.

`created_date` datetime DEFAULT NOT NULL CURRENT_TIMESTAMP,
`updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

or

`created_date` datetime DEFAULT NOT NULL CURRENT_TIMESTAMP,
`updated_date` datetime DEFAULT NOW()

 

imabotmail

Well-known member

Trusted Uploader

Jan 17, 2020

338

302

63

• May 28, 2022

• #3

I get this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL CURRENT_TIMESTAMP,
`updated_date` datetime DEFAULT CURRENT_TIMESTAMP' at line 17

 

jackdanielz

New member

May 5, 2022

24

11

3

• May 28, 2022

• #4

imabotmail said:

I get this:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NOT NULL CURRENT_TIMESTAMP,
`updated_date` datetime DEFAULT CURRENT_TIMESTAMP' at line 17

Click to expand...

`created_date` DATETIME DEFAULT CURRENT_TIMESTAMP NOT NUll,
`updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

or

`created_date` datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
`updated_date` datetime DEFAULT NOW()

Sorry, I guess I need a coffee..

 

Last edited: May 28, 2022

imabotmail

Well-known member

Trusted Uploader

Jan 17, 2020

338

302

63

• May 28, 2022

• #5

I hear you. Brewing a fresh pot as we speak. LOL Sorry, neither one work.
A little insight, I'm running Plesk CP with mysql 5.5.68-MariaDB and can't upgrade either.

 

jackdanielz

New member

May 5, 2022

24

11

3

• May 28, 2022

• #6

imabotmail said:

I hear you. Brewing a fresh pot as we speak. LOL Sorry, neither one work.
A little insight, I'm running Plesk CP with mysql 5.5.68-MariaDB and can't upgrade either.

Click to expand...

Oh dear... this is an old version of mysql, it is not implemented there yet.

Try the following:
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_date` timestamp NOT NULL DEFAULT ' 0000-00-00 00:00:00 '

 

imabotmail

Well-known member

Trusted Uploader

Jan 17, 2020

338

302

63

• May 28, 2022

• #7

Nope, but different error: #1005 - Can't create table 'scmdb.online_courses' (errno: 150)

 

T

TassieNZ

Premium Uploader and Sometimes Hacker!

Jan 17, 2019

9,017

19,812

120

New Zealand

• May 28, 2022

• #8

imabotmail said:

Nope, but different error: #1005 - Can't create table 'scmdb.online_courses' (errno: 150)

Click to expand...

Most certainly a jo-bot.exe error issue!!!

 

• 

Reactions: imabotmail and Mscv50

imabotmail

Well-known member

Trusted Uploader

Jan 17, 2020

338

302

63

• May 28, 2022

• #9

TassieNZ said:

Most certainly a jo-bot.exe error issue!!!

Click to expand...

Most definitely

 

• 

Reactions: TassieNZ

jackdanielz

New member

May 5, 2022

24

11

3

• May 28, 2022

• #10

imabotmail said:

Nope, but different error: #1005 - Can't create table 'scmdb.online_courses' (errno: 150)

Click to expand...

It could be the "Foreign Key"... Add it before and after your query.

SET FOREIGN_KEY_CHECKS = 0;
CREATE TABLE `online_courses` (
...
`created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`updated_date` timestamp NOT NULL DEFAULT NOW()
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS = 1;

If that doesn't work, I'm afraid I'm out.

 

• 

Reactions: TassieNZ

imabotmail

Well-known member

Trusted Uploader

Jan 17, 2020

338

302

63

• May 28, 2022

• #11

Thank you my friend @jackdanielz - I too, I'm giving up. Sadly this gives the following error. Thanks for all your help.

#1005 - Can't create table 'scmdb.online_courses' (errno: 150)