Missing Table error

Hello,

If you have access to the database with phpMyAdmin program check if the “wp_ymm” or “eMcGT_ymm” database table exists.

Stanislav

Nope, they do not exist in phpMyAdmin

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

Same thing. PIN is 8582

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

• This reply was modified 3 years, 3 months ago by ExplorerGT92.

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

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

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”

> No database selected

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

Use my email [email protected]
I cannot attach any files here.

Stanislav

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.

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”
https://hottons.com/ymm_modifications_other

Stanislav