Title: Missing Table error
Last modified: December 11, 2021

---

# Missing Table error

 *  Resolved [ExplorerGT92](https://wordpress.org/support/users/explorergt92/)
 * (@explorergt92)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/missing-table-error/)
 * Trying to get YMM Search to work on a brand new WordPress 5.8.2
    site but it’s
   not saving the restrictions I enter on the product. I’ve removed all plugins 
   except WooCommerce Version 5.9.0 and YMM Search Version 1.0.10 , I switched to
   the Storefront theme, and turned on debug.
 * The errors I’m getting are:
 * “WordPress database error: [Table ‘EL_2eVYoAkE.eMcGT_ymm’ doesn’t exist]
    SELECT
   make, model, year_from, year_to FROM eMcGT_ymm WHERE product_id = 618 ORDER BY
   make”
 * and
 * “WordPress database error: [Table ‘EL_2eVYoAkE.eMcGT_ymm’ doesn’t exist]
    SELECT
   EXISTS (SELECT 1 FROM eMcGT_ymm)”

Viewing 10 replies - 1 through 10 (of 10 total)

 *  Plugin Author [Pektsekye](https://wordpress.org/support/users/pektsekye/)
 * (@pektsekye)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15154348)
 * Hello,
 * If you have access to the database with phpMyAdmin program check if the “wp_ymm”
   or “eMcGT_ymm” database table exists.
 * Stanislav
 *  Thread Starter [ExplorerGT92](https://wordpress.org/support/users/explorergt92/)
 * (@explorergt92)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15154367)
 * Nope, they do not exist in phpMyAdmin
 *  Plugin Author [Pektsekye](https://wordpress.org/support/users/pektsekye/)
 * (@pektsekye)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15154379)
 * Hello,
 * Try to deactivate and then activate the plugin back.
    It will force WordPress
   to recreate the missing database table.
 * Then check if the log file:
    wp-content/debug.log
 * contains any errors about the ymm table.
 * Stanislav
 *  Thread Starter [ExplorerGT92](https://wordpress.org/support/users/explorergt92/)
 * (@explorergt92)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15154421)
 * Same thing. PIN is 8582
 * [https://sosautoatl.elementor.cloud/wp-content/debug.log](https://sosautoatl.elementor.cloud/wp-content/debug.log)
    -  This reply was modified 4 years, 6 months ago by [ExplorerGT92](https://wordpress.org/support/users/explorergt92/).
 *  Plugin Author [Pektsekye](https://wordpress.org/support/users/pektsekye/)
 * (@pektsekye)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15154432)
 * Hello,
 * Try to create the database table in phpMyAdmin with this sql query:
 *     ```
       CREATE TABLE IF NOT EXISTS eMcGT_ymm
        (
         id int(11) unsigned NOT NULL,
         product_id int(11) unsigned NOT NULL,
         make varchar(100) NOT NULL,
         model varchar(100) NOT NULL,
         year_from int(4) unsigned NOT NULL DEFAULT '0',
         year_to int(4) unsigned NOT NULL DEFAULT '0'
       ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
       ALTER TABLE eMcGT_ymm
         ADD PRIMARY KEY (id),
         ADD UNIQUE KEY uk_ymm_product_id (product_id,make,model,year_from,year_to);
       ```
   
 * Stanislav
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [4 years, 6 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15154444)
 * If the table is there, but WP says it’s not, it may be because the table needs
   to be repaired. See [https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin](https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin)
 *  Thread Starter [ExplorerGT92](https://wordpress.org/support/users/explorergt92/)
 * (@explorergt92)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15154474)
 * the code doesn’t work with “varchar” make and model line. As soon as I type the(
   after make varchar, phpMYAdmin disconnects from the server everytime.
 * removing the make and model line the code runs but Errors
    “MySQL said: #1046–
   No database selected”
 *  Plugin Author [Pektsekye](https://wordpress.org/support/users/pektsekye/)
 * (@pektsekye)
 * [4 years, 6 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15154516)
 * > No database selected
 * You should select the EL_2eVYoAkE database in phpMyAdmin and then run the sql
   query.
 * Use my email [pektsekye@gmail.com](https://wordpress.org/support/topic/missing-table-error/pektsekye@gmail.com?output_format=md)
   
   I cannot attach any files here.
 * Stanislav
 *  Thread Starter [ExplorerGT92](https://wordpress.org/support/users/explorergt92/)
 * (@explorergt92)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15180742)
 * [https://carkeysatl.com](https://carkeysatl.com)
 * I got it to work after adding a table in PHPmyAdmin manually and then running
   “
   ALTER TABLE eMcGT_ymm ADD PRIMARY KEY (id), ADD UNIQUE KEY uk_ymm_product_id (
   product_id,make,model,year_from,year_to);” SQL query.
 * Do you happen to have a list of which lines in the main CSS style which parts
   of the front end?
 * I ‘ve figured out a few so far by searching other posts, and by trial and error,
   but I can’t find the right line to style the search button, center the text in
   the boxes, change the color of the “select the vehicle” or “your garage” headlines.
 *  Plugin Author [Pektsekye](https://wordpress.org/support/users/pektsekye/)
 * (@pektsekye)
 * [4 years, 5 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15181884)
 * Hello,
 * I have just checked your website.
    Try to use “YMM horizontal search” widget.
 * The horizontal widget looks better at the top of the page.
 * Also there is a modification to align the search button inline with the drop-
   down selects:
    “Search button inline with drop-downs and mobile view” [http://hottons.com/ymm_modifications_other](http://hottons.com/ymm_modifications_other)
 * Stanislav

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Missing Table error’ is closed to new replies.

 * ![](https://ps.w.org/ymm-search/assets/icon-256x256.png?rev=1750193)
 * [Year Make Model Search for WooCommerce](https://wordpress.org/plugins/ymm-search/)
 * [Support Threads](https://wordpress.org/support/plugin/ymm-search/)
 * [Active Topics](https://wordpress.org/support/plugin/ymm-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/ymm-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/ymm-search/reviews/)

 * 10 replies
 * 3 participants
 * Last reply from: [Pektsekye](https://wordpress.org/support/users/pektsekye/)
 * Last activity: [4 years, 5 months ago](https://wordpress.org/support/topic/missing-table-error/#post-15181884)
 * Status: resolved