Show Posts

Topics - jcschott

Pages: [1]

Tips and Tricks / Database Performance for a lot of Products

« on: December 03, 2024, 10:10:34 PM »

My site is product heavy (currently have 6,400 products) and I am seeing ok performance on the UI and checkout process but adding or editing products from the admin section routinely will spike my RAM usage coming from the Database performance causing timeout/500 errors to be generated. Before I upgrade my hosting again or split my DB and APP to different servers would figure if anyone else had a high product store using abantecart and any other performance tips they could provide.

Current Virtual Machine provided by hosting provider:
6 CPU Cores
8 GB RAM
250 GB SSD Storage
10.6.20-MariaDB - MariaDB Server
Apache 2.4.62

Support / Issue with sort in collections page

« on: November 18, 2024, 06:49:59 PM »

Found a bug and can replicate it in the demo store. Trying to sort in a collection page leads to a friendly 404 error in abantecart.

1) Go to collections page in the storefront (https://demo.abantecart.com/affordable-treasures)
2) Click on the dropdown and select a different sort order of products

3) Page loads "The page you requested cannot be found!" error in the storefront.

General Support / Error on status & Comments

« on: November 18, 2024, 05:14:50 PM »

When attempting to update an order and notify the customer after clicking on add order history (in admin--Orders-->status & Comments) I get the following only for guests. When clicking back from the below error message the status and message is saved to the database but the email is not sent. If a person creates a customer account the update works as expected and sends the email.
There has been a critical error processing your request
Error: Could not load model checkout/fast_checkout
Trace:
#0/devshop/shop/core/helper/utils.php:1608
#1 /devshop/shop/admin/model/sale/order.php:1143
#2 /devshop/shop/admin/controller/pages/sale/order.php:1156
#3 devshop/shop/core/engine/dispatcher.php:306
#4 //devshop/shop/core/engine/dispatcher.php:341
#5/devshop/shop/core/engine/page.php:110
#6 /devshop/shop/core/engine/router.php:204
#7 /devshop/shop/core/engine/router.php:86
#8 /devshop/shop/index.php:97
in /devshop/shop/core/engine/loader.php on line 126

General Support / Product Import Error

« on: November 18, 2024, 05:03:52 PM »

Trying to use the Product import process on 1.4. When importing I get the following messages displayed.
Step 1 - failed. (Connection error occurred. HTTP-status:403)
Step 2 - failed. (Connection error occurred. HTTP-status:403)
Step 3 - failed. (Connection error occurred. HTTP-status:403)
Step 4 - failed. (Connection error occurred. HTTP-status:403)
Step 5 - failed. (Connection error occurred. HTTP-status:403)
Step 6 - failed. (Connection error occurred. HTTP-status:403)
Step 7 - failed. (Connection error occurred. HTTP-status:403)

When checking the server logs I get file permission is restricted for script: /devshop/shop/task.php. I have verified the file permissions and adjusted them from 755 to 777 with the same result. Any ideas on what may be causing the restriction on task.php?

Templates / Collections, custom layout and Default Template

« on: October 25, 2023, 07:51:52 PM »

I am having some issues pinpointing where this issue is on the default template not showing a custom layout.
I have created a collection and modified the layout adding a custom HTML_block.
The html_block is active and saved under the default template. I can see the collection listed under the layout and Blocks manager.

If I use the same html_block and add it to the default page layout it appears as expected on the collection page (as well as all other default pages).
If I change to the bootstrap5 template and apply the custom layout using the same block it works.

General Support / Search Behavior

« on: September 14, 2023, 04:08:37 PM »

Notice an inconstancy with search thought it was my store but can recreate it on the DEMO site. If you are on the search page and search for something with no results, update search parameter with something that should return results nothing is returned.
Steps to reproduce in Demo Store:
1) Search for Shoe in upper right corner and press enter, results returned as expected
2) Search for Test and no results returned on search page
3) Search for Shoes from search page no results returned.

Basically anytime we have no results returned and update the search nothing is returned.

Extension Support / 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> </td> </tr> <tr> <td>Welcome and thank you for registering at {{ store_name }}</td> </tr> <tr> <td> </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> </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

Support / Extracts not working after store move

« on: March 06, 2017, 02:16:59 PM »

We just moved our cart to a new host. Everything works well and followed the steps in http://forum.abantecart.com/index.php/topic,426.0.html. I am trying to do a product extract to do some bulk pricing updates and it will download the tar.gz file but it comes through as a corrupted page. Winzip & 7ZIP won't open the file (no errors while downloading).
I've tried other exports and the same error. My old cart has no issues exporting the product file and I've tried 3 different computers with 3 different firewalls with no success. Have any ideas why the export suddenly fails after a server move?