|
Angus Russell
|
September 25, 2015 at 4:01 am
I’ve loaded the coding as per my query https://eventespresso.com/topic/transferring-or-copying-ownership-of-questionsquestion-groups/ into the custom_functions file.
However, I think I messed things up when changing names on a login “eventadmin” and ending up with questions & question groups with no user associated. I’ve now deleted this user to try and resolve the issue. I think I made things worse though!
Now, irrelevant of which login, only the system question group, from the deleted login, is offered in the event overview page, none others.
So how can I removed all of these remaining question groups, and questions, and then have the metabox on the event overview page populated with the correct question groups, and hopefully if the coding is working, with other users question groups too?
Thank you
Angus
|
|
Angus Russell
|
September 25, 2015 at 4:46 am
Addendum – for now I have removed the code from the custom_functions file and this enables us to access our own question groups.
|
|
Angus Russell
|
September 25, 2015 at 4:51 am
I suspect it may be something to do with the 30 or so events associated with with this login?
This are all from last season, so if I delete these events, what else do I delete?
Thanks
Angus
|
|
Josh
|
September 25, 2015 at 2:07 pm
Hi Angus,
I don’t think deleting those events will restore the relationships between the question groups and users.
One thing you can check is the value in the wp_user column for those question groups in the _events_qst_group database table. You’ll need to make sure that the value is pointing to a user ID for a user that exists in the system. For example, if the wp_user column has the value of 5, and there is not a user with the ID of 5, you can change the value in _events_qst_group to match an existing user ID that needs to access that question group.
|
|
Angus Russell
|
September 25, 2015 at 10:18 pm
Thanks Josh I follow all of that except one question – where do I find _events_qst_group database table?
Thanks
|
|
Tony
|
September 28, 2015 at 5:10 am
It’s within the database used by your site, the name of the database can be anything (set by yourself or your host) so its not something we can provide. If you look within wp-config.php you’ll see DB_NAME with a value, that is the database used by your site,
The table will be {db_prefix}_events_qst_group. {db_prefix} can be different for every site as it is set by your host, by default WordPress uses ‘wp’.
Do you have cPanel with your host? That will have phpMyAdmin which will allow you to alter the database.
Or you can use a plugin called Adminer that will allow you to do it from within the WordPress dashboard.
However, note that you are directly editing the database, this is not really recommended if you are not comfortable doing so. Be sure to make a backup of the DB before you attempt to make any changes. If you make a mistake when editing the database you’ll need a backup to restore and try again.
If you are unsure and do not have a developer available to help with this we can do so with the use a support token.
|
|
Angus Russell
|
September 28, 2015 at 8:03 am
OK, that’s great, I’ve been in there and deleted all the null groups.
However, I now have one group, a system group, that has been associated with events, and has a user id of a deleted user. This is the group that is causing the issue. So, if I delete it, will it screw up the data of the old events it was associated with? Can I associate with another user, and if which group will take precedence?
I’m thinking if I change the “system code” to 0 instead of 1 then it will no loner be a system group and I can then change it’s associated user id to mine, without conflicting with my current system group.
Or will the fact of a different group identifier remove that issue?
Thanks
Angus
|
|
Angus Russell
|
September 28, 2015 at 8:06 am
Same query about questions too. If I have questions that were used in questions groups that were associated with past events, what happens if I delete them?
Cheers
|
|
Josh
|
September 29, 2015 at 10:38 am
Please do not delete questions and question groups. That will break things. Instead, you’ll set the wp_user column for the custom question groups to point to the admin’s user ID. So for example, if you deleted the previously used admin account, and it had the ID of 1, and the new admin account has the user ID of 2, you change the value for the user_id field for the question group to be 2.
|
|
Angus Russell
|
September 29, 2015 at 10:42 am
OK, thanks
|
|
Angus Russell
|
September 29, 2015 at 10:45 am
I now have two “Personal Information” locked system groups in my account. Have suffixed the names to differentiate them.
|
|
Josh
|
September 29, 2015 at 2:03 pm
You can avoid having more than one Personal Information group by only assigning one personal information group to a user account when you alter the database directly. EE assigns one Personal Information group per user by default.
|
