|
bulimbakindy
|
March 15, 2023 at 9:36 pm
We are trying to add two system questions to a question group, but they are not visible on the list when trying to add to a question group.
|
|
Tony
|
March 16, 2023 at 3:06 am
Hi there,
System questions are limited to be within the system groups.
This si so that Event Espresso always has its ‘required’ system questions in a consistent location so registrations can function.
What questions are you looking to move?
Can I ask what the use case is?
|
|
bulimbakindy
|
March 16, 2023 at 8:34 am
Hi Tony,
Sorry I forgot to specify; the two system questions are being moved to a system question group as well.
For example, I have two system questions asking for the first name and last name which I want to put into a system question group named “Personal Information”. However, when I go to the system question group to add those two system questions, only the first name question comes up as being able to be selected/checked. The last name system question is missing from the list.
|
|
Tony
|
March 16, 2023 at 12:50 pm
Hmm yeah, that’s not correct.
Ok, so when you go to Event Espresso -> Registration Form -> Questions.
Can you see the ‘Last name’ question there?
Does the admin label show as ‘Last Name – System Question’?
It ‘should’ be question ID 2 (technically it’s possible for it now to be, but usually it will). ID’s may not be set to show on the list table in the screen options (top right).
If you can find it in the table and click to edit it, does it show up as system question, like this:
https://monosnap.com/file/6vov9ROeHn8Xrma66M8hSWPnjzDPjj
|
|
bulimbakindy
|
March 16, 2023 at 7:31 pm
Hi Tony,
Sorry, actually both system questions are not visible. Our client created a new question just so it is present in the form.
How the two system questions show up as.
The two system questions that can’t be added to the system question group.
The system question group
https://monosnap.com/file/GTllwkdmSE8b1GFbYHAAlExBRh3DpO
As you can see, those two system questions can’t be added to the system question group. Parent/Carer Name question was created due to the two system questions that can’t be added to the group.
|
|
bulimbakindy
|
March 16, 2023 at 7:32 pm
Hi Tony,
Apologies, the link was missing on the first two.
How the two system questions show up as.
https://monosnap.com/file/CeObtpoLy23pxYX7EIc3Ylpybke5Rz
The two system questions that can’t be added to the system question group.
https://monosnap.com/file/iAh6S1294D3OCD2W8hTj9jcm9agarN
Parent/Carer Surname
Parent/Carer First Name
|
|
Tony
|
March 17, 2023 at 5:09 am
Ok, so the Personal Info system question group is fine there.
However, a couple of things stand out on those system question screenshots.
The system questions are generated when you first install EE and you’ll have clean tables when those are created yet your ‘Perent/Carer First Name’ question has an ID of 24? 23 other questions were generated before that (EE creates 10/11).
Question label is not set to something EE would have used by default, ‘pfname’?
How were those questions created?
|
|
bulimbakindy
|
March 17, 2023 at 9:11 am
Hi Tony,
The current setup was migrated from Event Espresso 3. We’ve just upgraded recently to Event Espresso 4.
|
|
Tony
|
March 17, 2023 at 4:05 pm
Interesting!
Can I take a look? I’m interested in what is going on here. I can’t promise a fix but I’ll happily take a look at it.
Do you have PHPMyAdmin access?
|
|
bulimbakindy
|
March 17, 2023 at 5:13 pm
Hi Tony,
No problem, we access it via cPanel.
|
|
Tony
|
March 17, 2023 at 5:26 pm
Hmm, so I wouldn’t ask for cPanel access but its up to you if you want to send it over or not.
I want to take a look in the EE admin to view what the questions show up as there to see what else stands out and I’d also like to take a look at the esp_question DB table to see what the questions show up.
If you’d prefer to export just that table and send a link I can use to download it to support[at]eventespresso.com that’s fine too.
Temp login creds can be sent over using this form:
https://eventespresso.com/send-login-details/
|
|
bulimbakindy
|
March 18, 2023 at 11:44 pm
This reply has been marked as private.
|
|
Tony
|
March 20, 2023 at 8:39 am
Thank you.
So… in short, although those are showing as System questions, they aren’t what EE4 considers system questions. They are showing as system questions because they have text values set within the ‘QST_system’ DB field.
Can you send me the {prefix}_events_question table from the DB? (Thats the EE3 table, I’d like to see what’s happened here)
The ‘real’ system questions there are Questions ID 1-10 and ID 36 (confirm email), all of the others should be considered Custom Questions.
What are you trying to set up within the question groups currently?
|
|
bulimbakindy
|
March 22, 2023 at 5:56 pm
Hi Tony,
Here is the link to the SQL dump for the table you specified.
Every year, we setup a registration form that contains the same details except for a few questions that are unique. The questions that I mentioned are part of the questions that are supposed to be constant on every version of the form every year. These missing questions are no longer visible for adding to the form after the upgrade.
|
|
Tony
|
March 23, 2023 at 3:52 pm
Ok, so they shouldn’t be system questions within Event Espresso 4, I can’t see how they’ve become system questions, but thats a battle for later… for now, lets get this working in EE4 for you.
Can I take a quick look at the question groups/questions in the admin?
I’d like to get a feel for how this is setup before moving forward, I suspect we are going to need to edit the questions DB table to stop those questions from being treated as system questions (because they aren’t what EE4 expects to be system questions) but before digging into that I want to make sure I follow how your questions are set up properly.
If that’s ok you can send temp login details using this form:
https://eventespresso.com/send-login-details/
|
|
bulimbakindy
|
March 23, 2023 at 6:55 pm
Hi Tony,
I have submitted the form just a few minutes ago. Please let me know if there is trouble with the temp access.
|
|
Tony
|
March 28, 2023 at 2:25 pm
Hi there,
My apologies for the delay, I spent some time digging into this as this is a fairly complex issue.
So the problem stems from someone ‘repurposing’ system questions within EE3 for tasks other than what they are intended to be used for which has now passed over into EE4 with the migrations.
EE3 creates system questions in a similar way to how EE4 does.
The First Name, Last Name, Email Address questions are intended to be used for the registration details. On your install of EE3, the First Name question appears to have been removed from the group and the Last Name question has been repurposed to be ‘Child Last Name’ which means that data within EE3 is not in an unexpected format. The system questions in EE4 are messed up because they were messed up in EE3 and the migrations bring your data over, which is now going to be difficult to fix.
I assume the registrations being made on the site now are real, live registrations?
|
