Support » Plugin: UsersWP - User Profile & Registration » wp_uwp_usermeta’ doesn’t exist

  • Resolved pauloc

    (@pauloc)


    Hi, great plugin. It seems to be working fine, but when I set WP_DEBUG to true, I get this error almost everywhere: wp_uwp_usermeta’ doesn’t exist SELECT * FROM wp_uwp_usermeta WHERE user_id = 1.

    I’ve been looking through the code and it seems that this table is not been created unless you have updated the plugin from a previous version (not sure about this).

    Any help is appreciated.

    Regards, Paulo

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Stiofan

    (@stiofansisland)

    Hello,

    That table should exist (assuming your using standard prefix)
    Can you try deactivating and then reactivating the plugin to see if that triggers the table creation?

    Thanks,

    Stiofan

    @stiofansisland

    As a plugin developer, you should never assume that a user is using the default DB prefix. Most security measures tell users to change it nowadays.

    You should adjust your code accordingly, with the prefix variable from the $wpdb object (like so: $wpdb->prefix).

    • This reply was modified 1 year, 4 months ago by  VERYA.
    • This reply was modified 1 year, 4 months ago by  VERYA.

    I’ve tried deactivating and reactivating, I’ve also deleted the plugin from the plugins’ admin page, after tweaking the settings to delete all the plugin’s data. The table is not created on new install.

    I’m using the default DB prefix also.

    Weird behavior.

    Plugin Author Stiofan

    (@stiofansisland)

    @pauloc there must be something preventing it from being created, my guess would be that the sql user does not have the right permissions but that is not something i can debug here. My advice would be to check your sql user has permission to create tables or you can post on our own support forums where a member of staff can assist further: https://userswp.io/support/forum/userswp-core-plugin/userswp-core-plugin-support/

    @veryaca i was simply referencing the debug log, you should not assume while trying to school people on plugin basics 🙂

    @stiofansisland

    I misread your reply, my bad 🙂

    • This reply was modified 1 year, 4 months ago by  VERYA.
    Plugin Author Stiofan

    (@stiofansisland)

    @veryaca np 🙂

    @stiofansisland, it could be that if the other two tables were not created. I’ve tried on a new installation and it’s the same thing: wp_uwp_form_extras and wp_uwp_form_fields are created, but not wp_uwp_usermeta and I get the same errors.

    My be it’s my stack, I’m on mac MAMP: PHP Version 7.2.1 and mysql Ver 14.14 Distrib 5.6.38 if this helps.

    Thanks for your help.

    Hi again @stiofansisland, it’s definitely my stack. I’ve installed the plugin in a new WP using Vagrant and PHP 7.0.3 and MySql 5.5 and it installs without problem. Then I’ve copied the table to the other installation and it seems to be working fine.

    Sorry about all the hassle and thank you for the all the work put on this plugin and its support.

    Best regards, Paulo.

    Plugin Author Stiofan

    (@stiofansisland)

    @pauloc thanks for letting us know, that ver was only tested to 7.1.6, we will do some further testing with 7.2 and if we find anything we will do a release.

    Thanks,

    Stiofan

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘wp_uwp_usermeta’ doesn’t exist’ is closed to new replies.