News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

error on customer registration

Started by andrevdb, May 21, 2020, 08:43:49 AM

Previous topic - Next topic

andrevdb

SQL Error: Table 'stopstor_aban959.abfi_email_templates' doesn't exist
Error No: 1146
SQL: SELECT * FROM abfi_email_templates WHERE text_id='storefront_welcome_email_approval' and language_id=1 and status=1 and store_id=0 LIMIT 1 PHP call stack: #0 /var/www/vhosts/acw.co.za/httpdocs/core/lib/db.php:100 #1 /var/www/vhosts/acw.co.za/httpdocs/core/engine/extensions.php:1176 #2 /var/www/vhosts/acw.co.za/httpdocs/core/engine/extensions.php:1127 #3 /var/www/vhosts/acw.co.za/httpdocs/core/lib/db.php:67 #4 /var/www/vhosts/acw.co.za/httpdocs/core/lib/mail.php:186 #5 /var/www/vhosts/acw.co.za/httpdocs/storefront/model/account/customer.php:1087 #6 /var/www/vhosts/acw.co.za/httpdocs/storefront/model/account/customer.php:1004 #7 /var/www/vhosts/acw.co.za/httpdocs/storefront/controller/pages/account/create.php:72 #8 /var/www/vhosts/acw.co.za/httpdocs/core/engine/dispatcher.php:293 #9 /var/www/vhosts/acw.co.za/httpdocs/core/engine/dispatcher.php:328 #10 /var/www/vhosts/acw.co.za/httpdocs/core/engine/page.php:108 #11 /var/www/vhosts/acw.co.za/httpdocs/core/engine/router.php:176 #12 /var/www/vhosts/acw.co.za/httpdocs/core/engine/router.php:80 #13 /var/www/vhosts/acw.co.za/httpdocs/index.php:94 in /var/www/vhosts/acw.co.za/httpdocs/core/database/amysqli.php on line 119

abolabo

to solve please open phpMyAdmin,
select your database,
click on SQL  tab and paste sql queries from attachment .
Then run query.
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens


moebius

oh dear - have same problem, however when I run the SQL patch, I get this:
--
-- 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 'i4754285_ac2.abfi_dataset_values' doesn't exist

deeply in trouble here..

Forum Rules Code of conduct
AbanteCart.com 2010 -