Database query error
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.
-
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!
