?
avatar Spudley
Spudley
17 Mar 2017

I was looking at the records in my ##__user_profile table recently and noticed there were records there for the dob field, even though that field has always been disabled on my system.

Steps to reproduce the issue

  • Set up the user profile plugin and disable all fields except Terms Of Service.
  • Now create a few user accounts.

Expected result

The new accounts should only have a single record in the user_profile table, being "profile.tos", with a value of "1".

Actual result

The new accounts actually have two records in user_profile table, "profile.tos" as expected, and also "profile.dob", with a blank value. This dob record should not be getting created.

System information (as much as possible)

This is on a Joomla system that is currently on v3.6.5, having been upgraded regularly since v3.4.8 as new versions were released.

Additional comments

The spurious dob record doesn't have any negative effect, other than wasting space in the database, so this isn't a particularly serious bug, but I do consider it a bug nevertheless.

avatar Spudley Spudley - open - 17 Mar 2017
avatar joomla-cms-bot joomla-cms-bot - change - 17 Mar 2017
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 17 Mar 2017
avatar franz-wohlkoenig franz-wohlkoenig - change - 30 Mar 2017
Category com_users
avatar franz-wohlkoenig franz-wohlkoenig - change - 3 Apr 2017
Category com_users com_users SQL
avatar franz-wohlkoenig franz-wohlkoenig - change - 3 Apr 2017
Status New Needs Review
avatar Quy
Quy - comment - 17 Jun 2017

It is auto created from this line c62bf8b#diff-23e0a7ef508c9ce6eac98c42767a6077R327

Removing it fixes this issue. I can do a PR once I get confirmation that it is safe to do.

avatar brianteeman
brianteeman - comment - 18 Aug 2017

@Quy can you make the PR and then it can be tested

avatar franz-wohlkoenig franz-wohlkoenig - change - 19 Aug 2017
Status Needs Review Information Required
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 17 Sep 2017

@Quy can you make the Pull Request?


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/14691.

avatar franz-wohlkoenig franz-wohlkoenig - change - 4 Oct 2017
Status Information Required Closed
Closed_Date 0000-00-00 00:00:00 2017-10-04 12:50:49
Closed_By franz-wohlkoenig
avatar joomla-cms-bot joomla-cms-bot - change - 4 Oct 2017
Closed_By franz-wohlkoenig joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 4 Oct 2017
avatar joomla-cms-bot
joomla-cms-bot - comment - 4 Oct 2017
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 4 Oct 2017

closed as having Pull Request #18224


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/14691.

Add a Comment

Login with GitHub to post a comment