Quote from: timlight10 on November 07, 2026, 12:46:36 PM

Code Select Expand

File data for export is empty! error message appears when I try to upload a large CSV file for import with the import tool. This is only affecting one of my files, not all of them. This particular file is very large, about 113 MB, but I have been able to import it before. Not sure what has changed, but this is also not a very helpful error message.

please check these directives on the your phpinfo() page (see admin->system->settings->system button phpinfo()

upload_max_filesize
post_max_size
)

To solve you should to update php version to apply patch to you host.
Please check https://www.php.net/archive/2026.php for details.

To check what version do you use just open Admin->System->Settings->System and click button phpinfo(); at the heading.

If your version less than patched just ask your hosting provider to upgrade.

Quote from: yonghan79 on September 16, 2026, 11:19:20 PMOr is it possible when a customer makes multiple payment attempts cause the error?

or you had test with two instances of the same store.
or you have placed an order and then have reinstalled the cart.

See table paypal_orders for details

version of AbanteCart/paypal_commerce ?

Quote from: Heemet on July 20, 2026, 11:13:05 PMHello Basara,

If you ship via PayPal, the USPS rates are commercial rates.  However, the default USPS extension in AbanteCart returns retail rates, which are higher.  Thus, if a customer checks-out and selects a USPS shipping option, he will be overcharged at the retail rate.

It appears that the USPS API allows for the API call to request commercial rates.  See here:
https://github.com/USPS/api-examples

The field is "priceType": "COMMERCIAL"

It seems that this would be an easy change in the USPS extension in AbanteCart, but I can't figure out where to set this field.

Thanks,
Peter

please change manually file (via cPanel filemanager)
public_html/extensions/usps/storefront/model/extension/usps.php

See lines 514 and 545.

Please let us know about result.

hi,
the easiest way is a auto-forwarding on your store main mailbox.

please test this solution.
https://github.com/abantecart/abantecart-src/commit/d8e4737bbdafadb49b94521bd49c3cdb6cc980d0

you can replace your file with new

what version of abantecart do you use?
I remember we added more clear message for such case in the 1.4.0

Hi,
please read this topic https://forum.abantecart.com/index.php/topic,11249.0.html

Shortly, you should to create two indexes before upgrade process.

please try this fix and let us know

https://github.com/abantecart/abantecart-src/commit/14872852c907429920291d8e7630fb43e2d80bb5

Looks like you ran upgrade.sql twice.

If you do not have a database backup of 1.4.2, you can rollback database structure manually.

See https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database_upgrade.sql for details

it's just a warning.
Please check table data via phpMyAdmin.
Open table "pages" and find rows with controller "pages/product/category"
You will see another columns "key_param" and "key_value".
Please check if some data presents in "key_param" but "key_value" is empty.

To fix warning you should be sure that both columns are filled or empty.

To solve this issue run this sql in your phpMyAdmin.
Do not forget replace table prefix `ac_ with your's before run.

alter table `ac_ant_messages`
    modify `start_date` timestamp null;

alter table `ac_ant_messages`
    modify `viewed_date` timestamp null;

alter table `ac_banner_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_banners`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_block_descriptions`
    modify `date_added` timestamp default current_timestamp() not null;

alter table `ac_block_descriptions`
    modify `date_modified` timestamp default current_timestamp() not null on update current_timestamp();

alter table `ac_block_templates`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_blocks`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_categories`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_collections`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_content_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_contents`
    drop primary key,
    MODIFY COLUMN `content_id` INT AUTO_INCREMENT PRIMARY KEY;

alter table `ac_coupons`
    modify `date_start` date null;

alter table `ac_coupons`
    modify `date_end` date null;

alter table `ac_coupons`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_coupons_categories`
    charset = utf8mb4;

alter table `ac_custom_blocks`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_custom_lists`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_customer_notifications`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_customer_transactions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_customers`
    modify `telephone` varchar(32) default '' not null,
    modify `date_added` timestamp default current_timestamp() null,
    modify `last_login` timestamp null;
update `ac_customers` SET `date_added` = `date_modified` WHERE `date_added` = '0000-00-00 00:00:00';

alter table `ac_downloads`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_email_templates`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_extensions`
    modify `date_installed` timestamp null;

alter table `ac_extensions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_global_attributes_type_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_language_definitions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_layouts`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_length_classes`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_locations`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_messages`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_online_customers`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_data`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_data_types`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_downloads`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_order_history`
    modify `date_added` timestamp default current_timestamp() null;

ALTER TABLE `ac_orders` MODIFY date_added timestamp default current_timestamp();
update `ac_orders` SET date_added = date_modified WHERE date_added = '0000-00-00 00:00:00';

alter table `ac_page_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_pages`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_product_discounts`
    modify `date_start` date null;

alter table `ac_product_discounts`
    modify `date_end` date null;

alter table `ac_product_discounts`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_product_specials`
    modify `date_start` date null;

alter table `ac_product_specials`
    modify `date_end` date null;

alter table `ac_product_specials`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_products`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_resource_descriptions`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_resource_library`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_resource_map`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_reviews`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_settings`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_task_details`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_task_steps`
    modify `last_time_run` timestamp null;

alter table `ac_task_steps`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_task_steps`
    engine = InnoDB;

alter table `ac_tasks`
    modify `last_time_run` timestamp null;

alter table `ac_tasks`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_tax_classes`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_tax_rates`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_user_groups`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_user_notifications`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_users`
    modify `last_login` datetime null;

alter table `ac_users`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_weight_classes`
    modify `date_added` timestamp default current_timestamp() null;

alter table `ac_zones_to_locations`
    modify `date_added` timestamp default current_timestamp() null;

try this

<div class="col-md-5 col-xl-12 text-center text-white ">
    <h1 class="ms-4 text-white">Custom Metal Work</h1>
    <p class="mb-4">Shop our collection of Metal signs and decor</p>
    <a href="#" class="btn btn-outline-light">Shop Now</a>
</div>
For more information see standard bootstrap css-classes here

hi, error code 400 usually set in case code is "unknown". 
Please provide more details how we can replicate this bug locally.
We need to know
host, OS, php version, url which returns 400 and precise settings of your cart. 
Screencast video and screenshots will be useful.