Getting a SQL error on a multisite

  • Resolved Norman Cates

    (@normancates)


    11 months, 2 weeks ago

    I installed User Registration on my WordPress multi site and network activated it.

    It then worked great on the main site. I set up a bunch of stuff.

    Then I moved to a second site.

    And started getting SQL errors.

    SELECT?session_value
    FROM?lRsD5sW_2_user_registration_sessions
    WHERE?session_key = ‘1’

    ERROR: Table ‘<websiteTable>.lRsD5sW_2_user_registration_sessions’ doesn’t exist

    Its totally correct. That table does not exist.

    Is there any way of making the plugin create that table for us properly?

    Thanks

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Sandip Pokhrel

    (@sandippokharel)

    Hi there,

    Thanks for writing in,

    Sorry for the late response due to the weekend.

    Please uninstall, delete, and re-install the User Registration plugin. This should create the table properly.

    Regards!

    Plugin Support Sandip Pokhrel

    (@sandippokharel)

    Hi there,

    Since we haven’t heard from you in a while, I’m going to go ahead and conclude this thread for now. However, if you have any further questions or if there’s anything else we can assist you with, please feel free to continue the conversation.

    Regards!

    Thread Starter Norman Cates

    (@normancates)

    Hi ya,

    Sorry to leave this so long.

    Having to uninstall, then reinstall the plugin EVERY TIME a new subsite is created is not a good solution.

    It also makes me VERY nervous that somewhere in that process all the User Registration data will get deleted.

    Surely it should be possible to either check and confirm that the user wants those tables created when it detects they don’t exist, or just create them automatically.

    At the least, give us a button that does the table creation process for us.

    Plugin Support Sandip Pokhrel

    (@sandippokharel)

    Hi @normancates,

    Sorry for missing this out. We will try to recreate this scenario over here and see if we can replicate the issue. We will get back to you accordingly.

    Regards!

    Plugin Support Sandip Pokhrel

    (@sandippokharel)

    Hi @normancates,

    Could you please provide us with a screen recording to show the issue? We are unable to replicate it over here. Or, you can contact us via our live chat from WPEverest Support to get an instant response on this matter.
    We will then post the findings and solutions on this public forum accordingly.

    Regards!

    Plugin Support Sandip Pokhrel

    (@sandippokharel)

    Hi there,

    Since we haven’t heard from you in a while, I’m going to go ahead and conclude this thread for now. However, if you have any further questions or if there’s anything else we can assist you with, please feel free to continue the conversation.

    Regards!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Getting a SQL error on a multisite’ is closed to new replies.