Show Posts


Messages - jcschott

Pages: [1] 2
1
Tips and Tricks / Re: Database Performance for a lot of Products
« on: December 30, 2024, 01:24:30 PM »
Yes I think it might be a cache issue if Abantecart attempts to clear the product cache after any type of product update I'll do some more digging as I am trying to avoid having to reimport all the data after dropping the tables. Interesting though it only is for one install and not the other using the same DB, same version just different folders on the host. Also running into mysql max users error during some peak CPU processing times (Currently set at the default 150 connections)

2
Tips and Tricks / Re: Database Performance for a lot of Products
« on: December 29, 2024, 03:07:24 PM »
Thanks guys, I wanted to update on what I have done so far as it doesn't appear to be an issue with the product table/ or database performance. I am still tracking down the issue on my end but abantecart appears to be handling the amount of products and categories just fine.

I tried to do some tracing and error capturing and I am going through that still. I did do a fresh install of abantecart and pointed that install to the existing database. Adding/Editing products was just fine and storefront was behaving as expected and copied all the resources over to the new store in case we had some heavy processing for some reason. I then made that fresh install my primary store by renaming the folders (My site's store is in /shop directory). Once renamed the now new install is having the same issue with spiking CPU upon editing products and the old install is not having the issue so I am leaning to some kind of local network routing issue or php path issue.

3
Tips and Tricks / Re: Database Performance for a lot of Products
« on: December 04, 2024, 12:20:50 PM »
PHP Version 8.3
AbanteCart Version 1.4.0
Template: Novator
Categories: 212 (17 parent categories, the rest childs)

The front end does ok and loads without resource spiking for the volume we get currently (4-5 concurrent users is generally the peak) but as soon as I start to edit a product in the admin section even with no current users hitting the site it causes the DB to spike in resources and often leads to 500 errors/timeouts for the front end.

4
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

5
General Support / Re: Product Import Error
« on: November 20, 2024, 10:29:52 PM »
Thank you that resolved the issue. I was able to disable mod_security and then run the import and also revert back the task.php permission back to 755 and it completed without error.

6
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.

7
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

8
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?

9
AbanteCart Chanrged (Former v2.0) / Re: So Version 2.0 is out, but limited to paid plan??
« on: May 13, 2024, 06:34:43 PM »
Looks like the decision had been made not to release 2.0 as open source according to the Readme in github?

10
General Support / Re: FEDeX won't connect to my shopping cart
« on: April 11, 2024, 07:07:05 PM »
Do you have any error messages in your logs? What versions of FedEX and STRIPE extensions are you using and are they enabled and have at least one shipping option (Ground/2nd Day/etc.) and at least one payment option (card/Affirm/etc.) ?

11
Support / Re: Cart page require "Add an Order Comment"
« on: January 23, 2024, 08:08:39 PM »
In the admin section navigate to System --> Localization --> Language Definitions.
Find the fast_checkout_text_comment_placeholder Key and you can update the wording.

12
Support / Re: Error when installing AbanteCart
« on: January 23, 2024, 11:39:38 AM »
Not sure about it being a file (Some other platforms and Payment API's use some classes named the same) but try moving the ZIP file to the root of your drive (C:\) and then unzip. Windows has a limit to the file path size to ~256 characters.

13
Support / Re: Setup SMTP Mail. I am using Godaddy as Host Provider
« on: December 30, 2023, 09:53:01 AM »
You can  set up your mail settings in the admin screens and change to smtp as long as your hosting plan allows and can support smtp. Here is the documentation:

https://abantecart.atlassian.net/wiki/spaces/AD/pages/7372837/Mail+Settings

14
Templates / Re: Collections, custom layout and Default Template
« on: November 01, 2023, 03:18:32 PM »
Thanks. I'll wait for the release as I am still getting some issues. All collections even with custom layouts (only using the collections --> Layout) are using the same template.

15
General Discussion / Re: Elevating Homes through Expert Roofing and Home Improvement
« on: October 26, 2023, 12:34:08 AM »
Here is the documentation on changing your logo in the admin section of your site. https://abantecart.atlassian.net/wiki/spaces/AD/pages/24543267/Change+Logo#Step-by-step

Pages: [1] 2

Powered by SMFPacks Social Login Mod