|
Gabor Laszlo
|
August 26, 2014 at 1:10 pm
Hi
We upgraded event espresso to the newest version of EE3. We noticed that our questions and question groups dissapeared after we had upgraded to the newest EE3. We found the old questions and group questions in an “all group” category. Can we move the questions and groups to My category? Will it solve the problem that if we create a new event, we can not add groups or questions to the event?
Thank you
Best Regards
Gabor Laszlo
|
|
Lorenzo Orlando Caum
|
August 26, 2014 at 2:20 pm
Hi,
Is it possible that those questions were created by another user?
If you aren’t sure, have you used the Roles and Permissions basic or pro addons?
—
Lorenzo
|
|
Gabor Laszlo
|
August 26, 2014 at 2:37 pm
Hi
There is only one admin user so i think the creator had to be the same. We used before the 3.1.2p version with members and https addon. This is the first time to create new event sinve we upgraded from the older version, so we just realized that issue.
I’ve just checked roles and i found this notification: No role currently has the edit_roles capability. Please add this to each role that should be able to manage/edit roles. If you do not change this, any user that has the edit_users capability will be able to edit roles.
Thank you
|
|
Lorenzo Orlando Caum
|
August 26, 2014 at 3:41 pm
Thanks. If that is the Event Espresso https plugin, please deactivate. Its not compatible with the latest software and some like WordPress HTTPS plugin should be used instead.
You can reassign the questions through the database using some like PHPMyAdmin.
Have you used that tool or Adminer before?
Also, please go ahead and backup your site.
—
Lorenzo
|
|
Gabor Laszlo
|
August 26, 2014 at 3:54 pm
Thank you
I’m using Wp https now.
Can you tell me how to change via phpmyadmin?
If you can tell me an SQL code i would be glad.
Thanks
Gabor
|
|
Lorenzo Orlando Caum
|
August 26, 2014 at 4:48 pm
Backup your site.
Go to PHPMyAdmin or Adminer (available as a WP Plugin).
Then locate the wp_events_question table.
The column for wp_user is where the question is assigned to a user.
Change that value for each question to the wp user id of your account. You can find that numeric value by going to the WP users page and hovering over your user profile. You should see something like this for the URL in the corner of your web browser screen:
example.com/wp-admin/user-edit.php?user_id=123&wp_http_referer=%2Fwp-admin%2Fusers.php
In the example above, the user_id is 123.
Try the change manually for a couple questions. Then return to your WordPress admin and check that they have been assigned to you.
Then you can use a SQL query like this:
https://gist.github.com/lorenzocaum/3f6925ad7e03a418046a
—
Lorenzo
|
|
Gabor Laszlo
|
August 27, 2014 at 12:17 pm
Hi
Thank you for your answer.
I run the query and it succesfully changed the owner of the questions to the administrator, however we still can not choose question groups for events. Do we need to do an another query for the groups too? “question Groups: My Groups (0) | All Groups (15)”
|
|
Gabor Laszlo
|
August 27, 2014 at 12:19 pm
When we add or edit an event we can see this message:
Question Groups
Add a pre-populated group of questions to your event. The personal information group is required for all events.
Parent/Guardian Information
(no other option)
|
|
Lorenzo Orlando Caum
|
August 27, 2014 at 2:46 pm
Hi, questions belong to various question groups so you would need to apply similar changes to the question group table as well.
—
Lorenzo
|
|
Gabor Laszlo
|
August 27, 2014 at 3:27 pm
Thank you. It worked fine
|
