Getting a SQL error on a multisite

  • Resolved Norman Cates

    (@normancates)


    2 years, 3 months 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)
  • Sandip Pokhrel

    (@sandippokharel)

    2 years, 3 months ago

    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!

    Sandip Pokhrel

    (@sandippokharel)

    2 years, 3 months ago

    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)

    2 years ago

    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.

    Sandip Pokhrel

    (@sandippokharel)

    2 years ago

    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!

    Sandip Pokhrel

    (@sandippokharel)

    1 year, 11 months ago

    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!

    Sandip Pokhrel

    (@sandippokharel)

    1 year, 11 months ago

    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.