WordPress.org

1. bwoosh
   Member
   Posted 1 year ago #

   I just installed the latest version of this plugin and it is no longer saving my custom questions. In the version before this, i was able to make custom questions, but it wouldn't let the person RSVP'ing add guests that were not already on the list.

   help please!

   thank you :)

2. bwoosh
   Member
   Posted 1 year ago #

   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!

3. ErisDS
   Member
   Posted 1 year ago #

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

4. elusiveclouds
   Member
   Posted 1 year ago #

   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 :)

5. HisShatness
   Member
   Posted 1 year ago #

   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

6. ErisDS
   Member
   Posted 1 year ago #

   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

7. HisShatness
   Member
   Posted 1 year ago #

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

8. HisShatness
   Member
   Posted 1 year ago #

   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?

9. HisShatness
   Member
   Posted 1 year ago #

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

   Where do I insert the command?

10. ErisDS
    Member
    Posted 1 year ago #

    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

11. HisShatness
    Member
    Posted 1 year ago #

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

    Thanks Eris

Topic Closed

This topic has been closed to new replies.