Support

August 28, 2012 at 12:30 pm

Rob what’s the user ID of your admin user?

August 28, 2012 at 5:25 pm

Rob (and anyone else having this, or a similar issue):

This is your wp_events_qst_group table. Pay attention to the wp_user column at the end; that’s for the user id of the admin user who has rights to that question group. You can see there’s only 2 question groups and both are assigned to user id 1:

link

Here’s the problem. This is your wp_users table:

Do you see what I see (or don’t see)? There’s no user ID 1. There’s user ID 2 (“rob”), but no user ID 1. Hence, no one has access to those questions, not even you. So you don’t break everything in the entire site, your best bet is to change the wp_user IN THE wp_events_qst_group TABLE to 2 (as opposed to trying to change the ID of “rob” to 1 which will destroy your site and lock you out and cause the sky to fall on your head and you will die, trust me, I’ve done it before and all of that happened).

August 31, 2012 at 3:51 pm

Rob (and anyone else with a similar issue), this is what I found on your site:

First of all, since you had previously had a whole bunch of different question groups, you had all of these relationships between the questions and their question groups in your wp_events_qst_group_rel table:

These are your question groups

link

These are your question group relationships

That’s not even necessarily an issue in and of itself since it doesn’t matter if there are questions that don’t exist anymore linking to question groups that don’t exist anymore (though having questions that don’t exist anymore linking to question groups that do exist might be problematic.

However, then I decided to try to see if I could track down what question groups were actually being used on events. I found this:

This is in the wp_events_detail table. Note the entries that have N; as their value. What this should be storing is a serialized array with the question groups (based on those IDs) for that specific event. When I cross-referenced the events that weren’t showing the registration form with this column, it was the ones that had an N; in here that had a problem. So I replaced that on those active events with something I copied from the one active event that was showing a reg form (which in your case was a:1:{i:2;s:1:"2";}). So you should be all set for now.

Note: I wouldn’t recommend hacking in your db unless you know what you are doing. Too many interconnected things make it really easy for stuff like this to happen. What I’m guessing happened was that when you went in and deleted all those extra question groups it left those events without any question groups associated with them and replaced the serialized array with N;. Since your Questions and Question Groups pages are restricted to Admin-only, I can’t guarantee this won’t happen again when an Event Admin tries to create an event since they won’t have access to those question groups. The real solution needs to be on our end, to allow events to be universal to all users, so there’s a set of “shared” question groups that can be used by event admins. Seth and I are talking about ways to fix this in an update. Hopefully we can get it out in the next couple weeks.

September 18, 2012 at 4:25 pm

New versions have been posted:
https://eventespresso.com/topic/event-espresso-3-1-27-and-roles-permissions-updated-upgrade-now/

Please upgrade and report any new issues.