Title: WordPress database error: [Column 'email' cannot be null] Last modified: August 31, 2016 --- # WordPress database error: [Column 'email' cannot be null] * [matesspace](https://wordpress.org/support/users/matesspace/) * (@matesspace) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-email-cannot-be-null/) * hi there, i notice that recently i’ve started to get this error when users tried to sign up. I’ve tried removing my plugins but the problem exists. * each time a new user signs up, they will get a “email column cannot be null” error. but i checked my database and both email and email verified are there and not empty in wslusesrprofiles. only wpym_wsluserscontacts is empty. * It is also a bit concerning that a new sign up user can see info of previous user’s sign up from the error message. see below and please help. thank you! * the website is [http://mates.space](http://mates.space) * here is the full error message when a user tries to sign up. (changed the ids for privacy sake) The new user is Nick1 but can see info of Nick2 from error message: * ``` WordPress database error: [Column 'email' cannot be null] INSERT INTO wpym_wsluserscontacts (user_id, provider, identifier, full_name, email, profile_url, photo_url) VALUES (62, 'Facebook', 'AAAAA', 'Nick1', NULL, 'https://www.facebook.com/app_scoped_user_id/AAAAA/', 'https://graph.facebook.com/AAAAA/picture?width=150&height=150') WordPress database error: [Column 'email' cannot be null] INSERT INTO wpym_wsluserscontacts (user_id, provider, identifier, full_name, email, profile_url, photo_url) VALUES (62, 'Facebook', 'BBBBB', 'Nick2', NULL, 'https://www.facebook.com/app_scoped_user_id/BBBBB/', 'https://graph.facebook.com/BBBBB/picture?width=150&height=150') Warning: Cannot modify header information - headers already sent by (output started at /public_html/mates.space/wp-includes/wp-db.php:1355) in /public_html/mates.space/wp-includes/pluggable.php on line 955 ``` * [https://wordpress.org/plugins/wordpress-social-login/](https://wordpress.org/plugins/wordpress-social-login/) Viewing 6 replies - 1 through 6 (of 6 total) * [Bazinga](https://wordpress.org/support/users/bazinga/) * (@bazinga) * [10 years, 2 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-email-cannot-be-null/#post-7110284) * Same here. How can we fix this? * [mbri](https://wordpress.org/support/users/mbri/) * (@mbri) * [10 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-column-email-cannot-be-null/#post-7110340) * Hi we are experiencing the same issues here. Any uptades? * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [10 years, 1 month ago](https://wordpress.org/support/topic/wordpress-database-error-column-email-cannot-be-null/#post-7110341) * **[@mbri](https://wordpress.org/support/users/mbri/)**: If you require assistance then, as per the [Forum Welcome](https://codex.wordpress.org/Forum_Welcome#Where_To_Post), please post your own topic. * [kevinwalsh](https://wordpress.org/support/users/kevinwalsh/) * (@kevinwalsh) * [9 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-email-cannot-be-null/#post-7110354) * @esml, that Forum Welcome also advises against duplicate posts. @mbrl is asking for an update, not for separate help as the Forum Welcome advises against. Besides, posting like that can let people (like author [@miled](https://wordpress.org/support/users/miled/)) know the issue is not limited to one user, and improves SEO of the page. * I have this issue as well but with “WordPress database error: [Column ‘profile_url’ cannot be null]” when I activated the Contacts API for Google for WordPress Social Login. It gives this error for every contact in my Google account, but still creates the account and sends an activation email to the user. However, the user cannot log in but instead gets these errors. Also, while the user shows up under“ Users” in the wordpress admin dashboard, the user is absent from WSL’s “User” area. * [VisualData](https://wordpress.org/support/users/visualdata/) * (@visualdata) * [9 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-email-cannot-be-null/#post-7110355) * Hi, * I am using the import contacts feature of this plugin. Allowing users to import contacts is the main reason I chose this plugin. I have made small changes to the database table for the import to work. The details of changes are available in this post, _[Link redacted – Please keep support on the WordPress.org forums]_. The article is written for people who may know little about this plugin or programming, so a lengthy background is given too. apologies if you already know and find it boring. * If you want to try the solution, please back up your database tables before making changes to the data type definition, or run the query in my post. * When social networks return the data, some fields may be empty. This is especially the case with Google+. The contacts from Google+ may be email or Android phone contacts who do not use Google+ at all, so email and urls may be missing. * It is possible to filter the returned data. The easier solution is to store all the returned contacts, allow the user to log in, and decide what to do with the missing data later. I use the second approach on my website. The full name of contacts can be helpful too, even if other fields are missing. * [@matesspace](https://wordpress.org/support/users/matesspace/), did you mean your error messages appear on the web pages at the front end? It is generally recommended to turn off error reporting on production server. The error messages disclose information about your database and server, and can be abused. * I hope it helps. * Best regards. * Oliver * [VisualData](https://wordpress.org/support/users/visualdata/) * (@visualdata) * [9 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-email-cannot-be-null/#post-7110356) * guys, I saw external links from time to time, and wasn’t aware external links are not allowed here. apologies if it offended someone. * the pull request has been added to this plugin’s repository on github to address the db errors, with color highlight on code to change. it is easy to see there. * since external links are not allowed, you should be able to search for wordpress social login on github and find the pull requests. Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘WordPress database error: [Column 'email' cannot be null]’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/wordpress-social-login_a1a2bc.svg) * [WordPress Social Login](https://wordpress.org/plugins/wordpress-social-login/) * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-social-login/#faq) * [Support Threads](https://wordpress.org/support/plugin/wordpress-social-login/) * [Active Topics](https://wordpress.org/support/plugin/wordpress-social-login/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-social-login/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wordpress-social-login/reviews/) * 6 replies * 6 participants * Last reply from: [VisualData](https://wordpress.org/support/users/visualdata/) * Last activity: [9 years, 11 months ago](https://wordpress.org/support/topic/wordpress-database-error-column-email-cannot-be-null/#post-7110356) * Status: not resolved