Title: Database error – using incorrect table prefix
Last modified: October 25, 2019

---

# Database error – using incorrect table prefix

 *  Resolved [Gal Baras](https://wordpress.org/support/users/galbaras/)
 * (@galbaras)
 * [6 years, 7 months ago](https://wordpress.org/support/topic/database-error-using-incorrect-table-prefix/)
 * I’m getting the following error on multiple sites:
 * `[22-Oct-2019 23:22:20 UTC] WordPress database error Table 'DBNAME.wp_postmeta'
   doesn't exist for query SELECT * FROM wp_postmeta WHERE meta_key LIKE '%classroom-
   375%' OR meta_value LIKE '%classroom-375%' made by do_action('wp_ajax_search_result'),
   WP_Hook->do_action, WP_Hook->apply_filters, Kuroit\AdvancedAdminSearch\AASKP_advancedAdminSearch-
   >AASKP_searchAction, Kuroit\AdvancedAdminSearch\AASKP_advancedAdminSearch->AASKP_getPostMeta`
 * DBNAME is correct on each site, but the table prefix is not “wp_”.
 * Line 268 of advanced-admin-search.php should change from:
 * `$postMeta = $wpdb->get_results("SELECT * FROM wp_postmeta WHERE meta_key LIKE'%".
   $post_search."%' OR meta_value LIKE '%".$post_search."%'");`
 * to
 * `$postMeta = $wpdb->get_results("SELECT * FROM ".$wpdb->prefix."postmeta WHERE
   meta_key LIKE '%".$post_search."%' OR meta_value LIKE '%".$post_search."%'");`
 * For security reasons, this statement should also be changed to using `prepare`:
 *     ```
       $search_term = '%' . $post_search . '%';
       $postMeta = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}postmeta WHERE meta_key LIKE '%s' OR meta_value LIKE '%s'", $search_term, $search_term );
       ```
   

Viewing 1 replies (of 1 total)

 *  Plugin Author [Kuroit](https://wordpress.org/support/users/kuroit/)
 * (@kuroit)
 * [6 years, 6 months ago](https://wordpress.org/support/topic/database-error-using-incorrect-table-prefix/#post-12211059)
 * Hi Gal Baras,
 * Thanks for pointing out the issue.
    We have just released an update for the plugin
   which should fix this problem.
 * Regards

Viewing 1 replies (of 1 total)

The topic ‘Database error – using incorrect table prefix’ is closed to new replies.

 * ![](https://ps.w.org/advanced-admin-search/assets/icon-128x128.png?rev=2371621)
 * [Advanced Admin Search](https://wordpress.org/plugins/advanced-admin-search/)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-admin-search/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-admin-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-admin-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-admin-search/reviews/)

 * 1 reply
 * 1 participant
 * Last reply from: [Kuroit](https://wordpress.org/support/users/kuroit/)
 * Last activity: [6 years, 6 months ago](https://wordpress.org/support/topic/database-error-using-incorrect-table-prefix/#post-12211059)
 * Status: resolved