Invalid default value for ‘user_registered’

Resolved anonymized-16400223
(@anonymized-16400223)

7 years, 6 months ago

Hi when i add this to database (ALTER TABLE wp_users ADD tspveremy INT(10) NULL AFTER display_name😉 it gives me (Invalid default value for ‘user_registered’), can somebody help me?

Viewing 6 replies - 1 through 6 (of 6 total)

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

7 years, 6 months ago

DO NOT — do not — Do Not — alter core wordpress tables.

What are you trying to accomplish?

Thread Starter anonymized-16400223
(@anonymized-16400223)

7 years, 6 months ago

Í need to add 2 int with null and 1 boolean so I need username data (for WHERE user= $user and etc.)that’s why I tried that

Moderator Steven Stern (sterndata)
(@sterndata)

Volunteer Forum Moderator

7 years, 6 months ago

No. You do NOT add columns to wp_users. You add attributes to wp_usermeta via the proper WordPress apis.

So you need 2 or 3 custom fields for a user.

https://wordpress.org/plugins/profile-extra-fields/

or if you prefer coding

https://developer.wordpress.org/plugins/users/working-with-user-metadata/

Thread Starter anonymized-16400223
(@anonymized-16400223)

7 years, 6 months ago

wp_usermeta is not good for me but thx for warning i fixed this by creating new table and defined user by $current_user = wp_get_current_user(); $userte = $current_user->ID;

solocrowd
(@solocrowd)

7 years, 6 months ago

Steven is correct, do not modify the core WordPress tables.

FYI, the error you encountered was due to the default value for ‘user_registered’ being zero. So to fix this, you could change the default value to any non-zero date. It has to do with PHP versions changing their rules.

Read more about it here:
https://medium.com/@infinitesimal_/fixing-invalid-default-value-for-timestamp-field-mysql-a4dd22bdad85

Thread Starter anonymized-16400223
(@anonymized-16400223)

7 years, 6 months ago

I know i created new one this is now solved

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Invalid default value for ‘user_registered’’ is closed to new replies.

Invalid default value for ‘user_registered’

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics