SQL Error: Table 'automecc_aban975.abmm_email_templates' doesn't exist
Error No: 1146
SQL: SELECT * FROM abmm_email_templates WHERE text_id='storefront_contact_us_mail' and language_id=1 and status=1 and store_id=0 LIMIT 1 PHP call stack: #0 /var/www/vhosts/lineshop.co.za/httpdocs/core/lib/db.php:100 #1 /var/www/vhosts/lineshop.co.za/httpdocs/core/engine/extensions.php:1176 #2 /var/www/vhosts/lineshop.co.za/httpdocs/core/engine/extensions.php:1127 #3 /var/www/vhosts/lineshop.co.za/httpdocs/core/lib/db.php:67 #4 /var/www/vhosts/lineshop.co.za/httpdocs/core/lib/mail.php:186 #5 /var/www/vhosts/lineshop.co.za/httpdocs/storefront/controller/pages/content/contact.php:133 #6 /var/www/vhosts/lineshop.co.za/httpdocs/core/engine/dispatcher.php:293 #7 /var/www/vhosts/lineshop.co.za/httpdocs/core/engine/dispatcher.php:328 #8 /var/www/vhosts/lineshop.co.za/httpdocs/core/engine/page.php:108 #9 /var/www/vhosts/lineshop.co.za/httpdocs/core/engine/router.php:176 #10 /var/www/vhosts/lineshop.co.za/httpdocs/core/engine/router.php:80 #11 /var/www/vhosts/lineshop.co.za/httpdocs/index.php:94 in /var/www/vhosts/lineshop.co.za/httpdocs/core/database/amysqli.php on line 119
Did you do upgrade recently? If you did, looks like the upgrade did not finish and required table was not created.
Some tables were not created during AbanteCart upgrade you can restore backup and upgrade manually (https://abantecart.atlassian.net/wiki/spaces/AD/pages/5275676/Upgrade+manually) (recommended) or try this solution (https://forum.abantecart.com/index.php/topic,8482.msg33700.html#msg33700)
Error
SQL query: Copy
--
-- SUBMENU DESIGN
-- ITEM_ID
INSERT INTO `abfi_dataset_values` (`dataset_column_id`, `value_varchar`,`row_id`)
VALUES (10,'email_templates',137)
MySQL said: Documentation
#1146 - Table 'automecc_aban975.abfi_dataset_values' doesn't exist
please run sql queries from attachment inside phpMyAdmin to solve upgrade issues