We receive "Database query error" when we attempt to update profiles using edit-persons-profile. Any field change encounters this error when clicking submit. Any suggestions on how to resolve? Thank you.
So, what may have happened is a User signed up and did not enter his email address correctly. So, we change the email settings to check for proper format. And, I believe since we did that we have not been able to update profiles. We are getting this response:
How do we ensure they enter their email address correctly without causing this error message?
Mysql error:
Unknown column 'profile_email' in 'field list'
Location:
The error was found in query function in the file public_html/inc/classes/BxDolForm.php at line 944.
It seems you enabled / added the profile_email field. It already exists in the Accounts, so no need to have it on the profiles too. Just disable it back.
Hello @fansfam !
Did you get the letters with the MySQL error in the subject? If yes, then please share the text about the error from the latest.
This is exactly what appears after we hit Submit when attempting to update.
You should get an email, to the main administrator registered email, with a complete debug log. That is the only way to know.
Thanks. Found it.
So, what may have happened is a User signed up and did not enter his email address correctly. So, we change the email settings to check for proper format. And, I believe since we did that we have not been able to update profiles. We are getting this response:
How do we ensure they enter their email address correctly without causing this error message?
Mysql error:
Unknown column 'profile_email' in 'field list'
Location:
The error was found in query function in the file public_html/inc/classes/BxDolForm.php at line 944.
It seems you enabled / added the profile_email field. It already exists in the Accounts, so no need to have it on the profiles too. Just disable it back.
YES!!!
So did it help?
Yes. It resolved the error! Thank you!