OpenSanghaFoundation / OSF

Bug/Feature requests tracking and documentation managament
https://opensanghafoundation.org
0 stars 0 forks source link

Cleanups #8

Open coiby opened 5 months ago

coiby commented 5 months ago

The usermeta table

The following fields in the table usermeta table need to be deleted because only the profile_photo is needed by Ultimate Member,

  1. profile_image
  2. _um_custom_profile_photo
  3. Profile Image

Administrators

Currently there are 13 administrators. Some accounts like admin-sa (admin@botssoft.in) are most likely for development purpose and should be deleted.

Test users

For examples, users like Sock Puppet * can be deleted.

Delete unused pages

OSFOSF commented 1 month ago

there are many fields that can be deleted, i deleted about 40 a month ago and there are still a few that can be deleted, we have a page that can do it in b ulk

OSFOSF commented 1 month ago

there are a few pages that can ber deleted and some to keep to help maintain the website, there are unused plugings that are deactivated and can be deleted completely. there are some plugins that are active that can be deactivated

OSFOSF commented 1 month ago

still using https://opensanghafoundation.org/newsite/test-2/user-update/ as it is the most reliable way to make changes to the data base.

there have been many fielkdsw deleted and many more to go, some were created using csv imports lets keep the issue open and add new items to be removed as we find them.

there is a page delete-user-meta that uses shortcode delete-user-meta where a list of deletions can all be delete in a loop where we loop through all users and delete that field.

coiby commented 1 month ago

still using https://opensanghafoundation.org/newsite/test-2/user-update/ as it is the most reliable way to make changes to the data base.

@OSFOSF We now have https://opensanghafoundation.org/newsite/user/?um_action=edit to update the user profile. May I ask what is missing is user/?um_action=edit that makes you feel test-2/user-update/ as it is the most reliable way? Due to UM's large user base, I think it's fair to say much more users have tested UM's profile editing functionality than test-2/user-update. So I don't think test-2/user-update/ is the most reliable way. In fact, I quickly find one problem with test-2/user-update/ which is updating the profile description (Biography) won't take effect immediately after hitting the 'Update User Data" button and I have to refresh the page for the change to take effect.

coiby commented 1 month ago

I did more further tests and notice more problems with test-2/user-update/ ,

  1. The youtube filed can't be updated (it has a fixed value "https://www.youtube.com/results?search_query=coiby")
  2. There is no sanity check on the fields like website, mobile_number and etc (I can input an invalid url like aab or invalid phone number 22x22 or invalid country like zlib)
  3. The country field has a different value from the one on the user profile page
OSFOSF commented 1 month ago

I will still use user-update page because i can change and fix the code the user_email and website user_url and osf_youtube fields are now correct, also your link https://opensanghafoundation.org/newsite/user/?um_action=edit is for users to change data, i can not add fields test fields because i can not change the code. i find this page most useful for users, and completely useless for myself. in fact i do not like becuase i do not understand the php code that ultimate member does. this is an issue between us that will only be resolved by you taking a long time to teach me to fix all the bugs in UMs code. if i can not figure out how to fix the bugs in um code then only you can do it.