Keep asking for sub site usermeta database. What should I do?

  • Resolved diannovita

    (@diannovita)


    10 years, 1 month ago

    Hi,

    I always get error message after add listing in my website. here is the mesage:

    WordPress database error Table '#dbname.wp_3_usermeta' doesn't exist for query SELECT user_id FROM wp_3_usermeta WHERE meta_value LIKE ('%*207*%') AND meta_key='email_subscriptions' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/DT/tpl-add.php') Status: 302 Moved Temporarily Expires: Wed, 11 Jan 1984 05:00:00 GMT Cache-Control: no-cache, must-revalidate, max-age=0 Pragma: no-cache Content-Type: text/html; charset=UTF-8 X-UA-Compatible: IE=edge,chrome=1 location: https://portalrumah.directory/productdirectory/?post_type=listing_type&p=3653

    I really don’t know why this happen. Since from Database Description article, mentioned that this table not re-create in multisite.

    At the first time, I thought it happened because of cache plugin. But after I deleted cache plugin, nothing change. I still get the same error.

    My question is how to fix this error. Should I create usermeta database table for each sub site?

    here is the link : https://portalrumah.directory/productdirectory/add-listing/.

    Thank you.

Viewing 1 replies (of 1 total)
  • Thread Starter diannovita

    (@diannovita)

    Hi,

    Please ignore my thread. I posted my problem in this forum before because I still could not fix it after spending hours to understand the error.

    In the late minute, finally, after having some frustation I understand what I have to is find php file that contain of this line:
    '#dbname.wp_3_usermeta' doesn't exist for query SELECT user_id FROM wp_3_usermeta WHERE meta_value LIKE ('%*207*%') AND meta_key='email_subscriptions'

    And I found it in my template theme. I looked for $wpdb->prefix and changed it to $wpdb->base_prefix.

    And bingo. My problem solve.

    Sorry. Perhaps could help somebody with the same problem.

Viewing 1 replies (of 1 total)
  • The topic ‘Keep asking for sub site usermeta database. What should I do?’ is closed to new replies.