AbanteCart Community

Shopping Cart Operations => Support => Extension Support => Topic started by: jcschott on May 16, 2020, 05:54:57 PM

Title: Fast Checkout error 1146 after 1.2.16 upgrade
Post by: jcschott 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
Title: Re: Fast Checkout error 1146 after 1.2.16 upgrade
Post by: abolabo 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
Title: Re: Fast Checkout error 1146 after 1.2.16 upgrade
Post by: jcschott on May 18, 2020, 02:35:41 PM
Thank you that enabled the extension upgrade.
Title: Re: Fast Checkout error 1146 after 1.2.16 upgrade
Post by: abolabo 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.