Support » Plugin: Year Make Model Search for WooCommerce » Missing Table error

  • Resolved John

    (@explorergt92)


    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

    (@pektsekye)

    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 John

    (@explorergt92)

    Nope, they do not exist in phpMyAdmin

    Plugin Author Pektsekye

    (@pektsekye)

    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 John

    (@explorergt92)

    Same thing. PIN is 8582

    https://sosautoatl.elementor.cloud/wp-content/debug.log

    • This reply was modified 5 months, 2 weeks ago by John.
    Plugin Author Pektsekye

    (@pektsekye)

    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 Steve Stern (sterndata)

    (@sterndata)

    Forum Moderator & Support Team Rep

    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

    Thread Starter John

    (@explorergt92)

    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

    (@pektsekye)

    > No database selected

    You should select the EL_2eVYoAkE database in phpMyAdmin and then run the sql query.

    Use my email pektsekye@gmail.com
    I cannot attach any files here.

    Stanislav

    Thread Starter John

    (@explorergt92)

    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

    (@pektsekye)

    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

    Stanislav

Viewing 10 replies - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.