[Plugin: RSVP Plugin] Custom Question is not saving

I had upgraded from the last version of the plugin, so when i did that, it didn’t update the database.

From the author Mike, (who was very helpful):

Basically you want to make sure there is a permissionLevel field in the _rsvpCustomQuestions table and the table _rsvpCustomQuestionAttendees exists.

So to fix it, i added the permissionLevel field to the proper table. Here is the sql details from the install file:

$sql = "ALTER TABLE <code>$table</code> ADD <code>permissionLevel</code> ENUM( 'public', 'private' ) NOT NULL DEFAULT 'public';";

I added the field and now everything is working again.

thanks for the help Mike!

I am having this problem too… about to try this fix.

This fix worked for me too; the plugin did not upgrade correctly. I had the table, and just needed to add the permissionLevel field.

Thanks bwoosh and Mike ??

Hi Guys,

I am new at wordpress and I am looking inside the plugins>RSVP Plugin>edit and cannot find where to edit the permission level for this table. Would you mind emailing me or posting simple instructions on how to modify this.

Thanks

Hi,

The instructions above are talking about the database table, not anything inside of the WordPress admin.
What you need to do is add a field called permissionLevel to the table called “_rsvpCustomQuestions”
It is very hard to post detailed instructions without knowing a bit more about your server setup, but the basics are:
Login to your hosts control panel
Find the tool for modifying your MySQL database (probably phpMyAdmin) and navigate through it to find _rsvpCustomQuestions. Check that the permissionLevel field doesn’t exist at the moment.
Then run the following via SQL to update the table:

ALTER TABLE _rsvpCustomQuestions ADD permissionLevel ENUM( ‘public’, ‘private’ ) NOT NULL DEFAULT ‘public’;

I’m afraid if you’ve not done something like this before, these instructions still won’t make a great deal of help. If you can provide more info – do you have phpMyAdmin etc then perhaps we can be more helpful.

Eris

I am at the phpmyadmin login screen. I have the wordpress site hosted with godaddy. I have never modified sql tables before ??

I am in the sql part of the database and I selected the customquestions part of my database and under sql copied and pasted the code you posted above. I am getting this error:

MySQL said: Documentation
#1146 – Table ‘cli1021807380000._rsvpCustomQuestions’ doesn’t exist

Thoughts?

Here is what I see when I get to the table:
SELECT * FROM wp_rsvpCustomQuestionAnswers WHERE 1

Where do I insert the command?

Where it says:

SELECT * FROM wp_rsvpCustomQuestionAnswers WHERE 1

Delete that text, and paste the code I gave you instead.

HOWEVER there is one modification you will need to make to the code, you need to add your WordPress prefix. I can see from what you pasted that you are using the default prefix which is “wp_”

Therefore the code you need to run is:

ALTER TABLE wp_rsvpCustomQuestions ADD permissionLevel ENUM( ‘public’, ‘private’ ) NOT NULL DEFAULT ‘public’;

Hope this helps,

Eris

That worked. Awesome. 2 letters throwing the whole thing off.

Thanks Eris