|
koakley
|
February 24, 2022 at 4:34 pm
I seem to be having the same problem as is going on with this post: https://eventespresso.com/topic/cant-select-email-and-first-name-as-questions-for-personal-information/
Under the Question Group – Personal Information, I’m unable to select “First Name” or “Email Address”, they’re both greyed out.
I tried deactivating, and deleting the EE plugin, and then reinstalling, but to no avail. They remain greyed out. https://photos.app.goo.gl/Z1n9gZdPAAzTSV9k6
Any help on how to proceed next would be greatly appreciated.
|
|
Tony
|
February 25, 2022 at 5:02 am
Hi there,
That’s a very strange issue!
First name and Email are system questions, they should never be unchecked from Personal Info (which is why they are disabled).
Is this is a new install or one where you already have events and registrations?
|
|
koakley
|
February 25, 2022 at 6:42 am
Unfortunately it’s a current installation with events and registrations. I just started this job a few months ago, but it looks like it has been like this for a while. The person before just created a custom field called first name and email and just put that on the form to collect that information. The problem is, that because it’s not the system values, we’re unable to send out confirmation emails to people because the persons contact information doesn’t have the email in the system designated spot.
|
|
Tony
|
February 25, 2022 at 8:47 am
Unfortunately it’s a current installation with events and registrations. I just started this job a few months ago, but it looks like it has been like this for a while.
Yeah, that’s not great really.
The system questions are used to generate the EE_Contacts which link a lot of EE’s registrations together, removing the system questions from the group can be … iffy.
I’ve not see this happen before and we have multiple checks within EE to prevent you from removing those system questions, so I’m going to sit on the ‘this was an intentional change’ for now.
The reason I point that out is re-adding the system questions back in may well trigger an issue with whatever it was done for, but either way, I don’t recommend leaving it as is, it’s not how EE expects the questions to be.
Are you comfortable with PHP at all?
|
|
koakley
|
February 25, 2022 at 8:54 am
Yes, I’m comfortable with PHP.
And while I’m not sure it was intentional or not, I agree that we need to get it back to normal. We’re unable to sent out e-mail confirmations, and it’s apparently been going on for a while.
Let me know what you need me to do or get you.
I appreciate your help with this.
|
|
Tony
|
February 25, 2022 at 10:10 am
And while I’m not sure it was intentional or not, I agree that we need to get it back to normal. We’re unable to sent out e-mail confirmations, and it’s apparently been going on for a while.
I want to just make sure it’s clear that fixing those questions will help fix EE_Contacts created moving forward but it will likely not fix current ones as they’ve now been created with missing values for system questions (which is likely why you can’t trigger emails for them).
So, step one is to get the Personal Information question group the way it should be.
If you are comfortable with phpMyAdmin that will likely be the quickest way to fix this. Open up your site’s database and look in esp_question_group_question, check for rows where:
QSG_ID = 1 and QST_ID = 1
QSG_ID = 1 and QST_ID = 3
QGS_ID = question group ID 1 (that should be your personal info group)
QST_ID = 1 is the First Name system question
QST_ID = 3 is the Email system question.
If you don’t have them rows, add them (leave QGQ_ID blank, it auto increments)
So that ‘fixes’ the question back into personal info.
|
|
koakley
|
February 26, 2022 at 9:30 am
Thank you, that worked. I had to install phpMyAdmin on the server, which further leads me to believe that it wasn’t a deliberate action. Those two items were not in the sp_question_group_question. After adding them the checkbox remains greyed out, but there is a check inside of it. The “Last Name” which was there still has a check but isn’t greyed out.
Once I verified that it was working I had to also manually change the Order of the items within phpMyAdmin, it would not save the condition when I dragged them into the correct order through on the webpage and clicked save.
I appreciate your help on this. Have a great day!
|
|
Tony
|
February 28, 2022 at 5:40 am
I had to install phpMyAdmin on the server, which further leads me to believe that it wasn’t a deliberate action.
Unfortunately, there are lots of ways to do it, the Adminder plugin could have been used and then removed or, done through PHP using the WPDB class to manipulate the table or using our own model system to override the DB.
We’ll likely never know how/why this happened, but I can tell you that EE will never remove those system questions itself, those are the bare minimum required questions (First Name and Email).
After adding them the checkbox remains greyed out, but there is a check inside of it. The “Last Name” which was there still has a check but isn’t greyed out.
Some countries don’t use a last name, so originally the First Name, Last Name and Email system questions were all required and enabled by default, but we then switched off the requirement for Last Name (which is why it’s not greyed out).
So right now it is expected that First Name and Email are ALWAYS required and won’t allow you to remove them. Last name is enabled by default but can be removed.
Once I verified that it was working I had to also manually change the Order of the items within phpMyAdmin, it would not save the condition when I dragged them into the correct order through on the webpage and clicked save.
Hmm, strange. What value was set in the DB for that field when it wouldn’t save?
|
