Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Fast Checkout error 1146 after 1.2.16 upgrade  (Read 3107 times)

Offline jcschott

  • Newbie
  • *
  • Posts: 16
  • Karma: +5/-0
    • View Profile
Fast Checkout error 1146 after 1.2.16 upgrade
« on: May 16, 2020, 05:54:57 PM »
Got an error after trying to install the Extension right after the upgrade"

There has been a critical error processing your request
SQL Error: Table  'truckchr_aban311.abrm_email_templates' doesn't exist
Error No: 1146"

The local delivery new extension installed just fine. Here is the full error message:

SQL: INSERT INTO `abrm_email_templates` (`status`, `text_id`, `language_id`, `headers`, `subject`, `html_body`, `text_body`, `allowed_placeholders`, `store_id` ) VALUES (1,'fast_checkout_welcome_email_guest_registration',1,'','Welcome, {{store_name}}','<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> </head> <body> <table style="font-family: Verdana,sans-serif; font-size: 11px; color: #374953; width: 600px;"> <tr> <td class="align_left"> <a href="{{ store_url }}" title="{{ store_name }}"> {{# logo_uri}} <img src="{{ logo_uri }}" alt="{{store_name}}" style="border: none;"> {{/ logo_uri}} {{^ logo_uri}} {{# logo_html}} {{logo_html}} {{/ logo_html}} {{/ logo_uri}} </a> </td> </td> </tr> <tr> <td>&nbsp;</td> </tr> <tr> <td>Welcome and thank you for registering at {{ store_name }}</td> </tr> <tr> <td>&nbsp;</td> </tr> <tr> <td> Your account has now been created and you can log in by using your email address and password by visiting our website or at the following URL:<br/> <a href="{{ login_url }}">{{ login_url }}</a><br/> <br/> Your Login Name: {{login}} <br/> Your Password: {{password}} <br/> </td> </tr> <tr> <td>&nbsp;</td> </tr> <tr> <td> Thank you.<br/> {{ store_name }} <br/><br/> {{{ text_project_label }}} </td> </tr> </table> </body> </html>','Welcome and thank you for registering at {{ store_name }} Your account has now been created and you can log in by using your email address and password by visiting our website or at the following URL: {{ login_url }} Your Login Name: {{login}} Your Password: {{password}} Thank you. {{ store_name }} {{{ text_project_label }}}','store_name, login_url, store_url, logo_html, logo_uri, text_project_label, login, password',0); PHP call stack: #0 /home/truckchrome/public_html/shop/core/lib/db.php:100 #1 /home/truckchrome/public_html/shop/core/engine/extensions.php:1176 #2 /home/truckchrome/public_html/shop/core/engine/extensions.php:1127 #3 /home/truckchrome/public_html/shop/core/lib/db.php:67 #4 /home/truckchrome/public_html/shop/extensions/fast_checkout/install.php:27 #5 /home/truckchrome/public_html/shop/core/lib/extension_manager.php:479 #6 /home/truckchrome/public_html/shop/admin/controller/pages/extension/extensions.php:952 #7 /home/truckchrome/public_html/shop/core/engine/dispatcher.php:293 #8 /home/truckchrome/public_html/shop/core/engine/dispatcher.php:328 #9 /home/truckchrome/public_html/shop/core/engine/page.php:98 #10 /home/truckchrome/public_html/shop/core/engine/router.php:175 #11 /home/truckchrome/public_html/shop/core/engine/router.php:79 #12 /home/truckchrome/public_html/shop/index.php:94 in /home/truckchrome/public_html/shop/core/database/amysqli.php on line 119

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Fast Checkout error 1146 after 1.2.16 upgrade
« Reply #1 on: May 18, 2020, 04:13:34 AM »
hello.
i guess you have partial upgrade.
Table abrm_email_templates must be created during upgrade process.

anyway try to open phpMyAdmin and execute queries from attachment file
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline jcschott

  • Newbie
  • *
  • Posts: 16
  • Karma: +5/-0
    • View Profile
Re: Fast Checkout error 1146 after 1.2.16 upgrade
« Reply #2 on: May 18, 2020, 02:35:41 PM »
Thank you that enabled the extension upgrade.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Fast Checkout error 1146 after 1.2.16 upgrade
« Reply #3 on: May 19, 2020, 04:28:48 AM »
Thank you that enabled the extension upgrade.

Please also check another database changes here https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database_upgrade.sql
I guess some other changes has been not applied.
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod