Custom Profile Field Failed Causing Join Fail
Standard member
Floundering, urgent help needed!
Hi All,I tried to create a new custom profile field but when I saved it an error occurred 'PHP timed out after 60 seconds'.
This caused any attempt to view/edit a profile to produce it's own error (row 59 related).
I removed row 59 from the cms_f_custom_fields table which then allowed me to view/edit a users profile but joining the site now fails with the following error:
Unfortunately a query has failed .... [Field 'field_59' doesn't have a default value] ....
I have restricted joining the site with 'Invites Enabled' (because I couldn't find a method of disabling new members) as I get up to 20 new members per day and don't want them to see the error message.
I see in cms_f_member_custom_fields contains columns field_59 and field_59_text_parsed but don't have the courage to delete these columns without confirmation that this won't make things worse.
Could someone advise me on this and point me in the direction of anywhere else I need to look to resolve this problem.
Any help or suggestions would be greatly received.
Nick
Site director
Become a fan of Composr on Facebook or add me as a friend. Add me on on Mastodon. Follow me on Minds (where I am most active). Support me on Patreon
- If not, please let us know how we can do better (please try and propose any bigger ideas in such a way that they are fundable and scalable).
- If so, please let others know about Composr whenever you see the opportunity or support me on Patreon.
- If my reply is too Vulcan or expressed too much in business-strategy terms, and not particularly personal, I apologise. As a company & project maintainer, time is very limited to me, so usually when I write a reply I try and make it generic advice to all readers. I'm also naturally a joined-up thinker, so I always express my thoughts in combined business and technical terms. I recognise not everyone likes that, don't let my Vulcan-thinking stop you enjoying Composr on fun personal projects.
- If my response can inspire a community tutorial, that's a great way of giving back to the project as a user.
Standard member
Chris Graham said
Deleting the columns as you figured necessary should fix it.
From “Post #8,664”, 6th August 2022, 12:50 am
Thank you for your timely response Chris. All seems to be in order now.
Kind regards
Nick
1 guest and 0 members have just viewed this.
