Custom table not created in Database

  • Resolved tiitosport

    (@tiitosport)


    2 years ago

    Hi Ultimate Member Support team,

    First of all thanks a lot for creating the Ultimate Member plugin, it’s really helping me with my website.

    Now I must say that I face a very similar issue to the one raised in the WordPress Support Center here: https://www.ads-software.com/support/topic/custom-table-for-usermeta-are-not-created-on-db/. This user enabled the option Enable custom table for usermeta and could not see the table in his database. I face the same issue.

    The issue was not resolved online, which is why I write to you this email.

    I enabled the option Enable custom table for usermeta, and when I check in my cpanel phpMyAdmin, the table was not created by the plugin. The only table is the um_metadata table.

    I suspect the issue could come from the fact the prefix of the website is not “wp”, but I could be wrong.

    Do you know what could be causing the issue?

    Let me know if you need information. I’m using version 6.1.1 of WordPress and version 2.5.4 of Ultimate Member. The option Enable custom table for usermeta is ticked and I made sure to save the settings.

    Best,

    Guillaume

Viewing 8 replies - 1 through 8 (of 8 total)
  • missveronica

    (@missveronicatv)

    @tiitosport

    Use phpMyAdmin SQL show grants for your WP database and verify that you have the CREATE MySQL privilege for the WP DB_USER defined in wp-config.php.

    Thread Starter tiitosport

    (@tiitosport)

    Hi @missveronicatv thanks a lot for taking a look. I confirm that I have CREATE privilege: here is the result of the query SHOW GRANTS

    GRANT USAGE ON *.* TO db_user@localhost IDENTIFIED BY PASSWORD 'fake_password_for_wp_support'
GRANT ALL PRIVILEGES ON db_name.* TO db_user@localhost

    where db_user and db_name are replaced with the values from my wp-config.php file

    Do you think the issue could come from somewhere else? Would you suggest any steps for me to take? ?? Let me know if you need more information from my side

    missveronica

    (@missveronicatv)

    @tiitosport

    You can enable PHP error logging, read this guide: “How to enable debug logging”

    https://docs.ultimatemember.com/article/1751-enable-debug-logging

    You will probably get a PHP log file with notices and errors in /wp-content/debug.log when you Enable custom table for usermeta.

    Post the content of this file here in the Forum and we can give you a PHP error explanation.

    Thread Starter tiitosport

    (@tiitosport)

    Hi @missveronicatv , before doing that, I just checked again in my phpMyAdmin database, and I see a table called wp_usermeta ??

    Could it be this table? When I check inside it, it contains the meta_key and meta_value columns with the different values of the test accounts I created and with the custom fields as well.

    I first disregarded this table because I was expecting a table with one user per row and all meta_keys in separate columns, but maybe this is not an available functionality?

    Let me know if I’m good to go with this table, or if you want me to check the PHP debug logs.

    Best,

    Tiito

    • This reply was modified 2 years ago by tiitosport.
    missveronica

    (@missveronicatv)

    @tiitosport

    wp_usermeta is the original WP table.

    UM is creating wp_um_metadata

    Thread Starter tiitosport

    (@tiitosport)

    @missveronicatv I also see the table called wp_um_metadata, so I think we are good to go! Sorry for bothering, it was unclear in my mind ??

    Plugin Support andrewshu

    (@andrewshu)

    Hello @tiitosport

    Did you solve your question? Can I close this topic?

    Thank you.

    Thread Starter tiitosport

    (@tiitosport)

    Yes you can! thanks for your support @andrewshu and @missveronicatv

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Custom table not created in Database’ is closed to new replies.