Recent posts

#41

General Support / Create Account

Last post by MGBReg - October 29, 2025, 06:02:23 AM

Sorry!!

My Create account page is not working.

It does not show any labels for the boxes.
I have checked GitHub to see if my create.tpl file is incorrect, but it looks the same.

1.4.2 has a different layout but if I swap it over it just causes a major crash.

I would like to remove the Newsletter option from the create account page as well.

I seem to have removed it from everywhere else within the pages and notifications.

Regards
paul

#42

General Support / Re: Date Added

Last post by MGBReg - October 29, 2025, 05:52:15 AM

Thank You

#43

General Support / Re: *FIXED* PayPalecommerce ex...

Last post by MGBReg - October 29, 2025, 05:15:49 AM

Hi Basara,
I seem to have fixed the issue. by manually inputting API info. Although it does not display the disconnect from PayPal.

I thought it might be the server, however I installed a fresh copy on the old server and I had the same result.

Looking at my screenshot below. This is how it displays including API info.

But it is now working, which I'm happy about.

The automatic connection button seems to be the issue.

Regards
Paul

#44

General Support / Re: Date Added

Last post by abolabo - October 29, 2025, 05:06:22 AM

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

Code Select Expand

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;

#45

General Support / Re: Checkout Page Redirects to...

Last post by Ali Arslan - October 29, 2025, 03:43:52 AM

Thanks for your response! Let me try this solution, and I'll update you if anything goes wrong with the proposed solution.

#46

General Support / Re: Checkout Page Redirects to...

Last post by Basara - October 29, 2025, 03:25:00 AM

Hello.
Please try this https://forum.abantecart.com/index.php/topic,11657.msg43972.html#msg43972

#47

General Support / Checkout Page Redirects to Ord...

Last post by Ali Arslan - October 29, 2025, 03:23:40 AM

When I click on Checkout after adding products to my cart, I'm redirected to the first checkout page. However, instead of showing all the available payment methods (e.g., PayPal), the page only displays the Order Summary. I checked the browser console and server logs, and I noticed a 400 Bad Request error for one of the checkout-related AJAX/API requests:

Request URL
https://domain/shop/index.php?rt=r/checkout/pay
Request Method
GET
Status Code : 400 Bad Request

The request fails due to what appears to be database field issues (you can see this in the attached admin log screenshots).

#48

General Discussion / Re: How to speed up product im...

Last post by Basara - October 29, 2025, 03:23:13 AM

Hello.
CDN is a great idea to speed up image loading. You can find some ready-made options in the AbanteCart Marketplace. Or, if you prefer, you can set up your own integration with another CDN provider

#49

Template Support / Re: on last upgrade 1.4.3 vers...

Last post by Basara - October 29, 2025, 03:16:58 AM

Please try running the upgrade manually to ensure all files and database updates are properly applied. You can follow the detailed steps here: https://abantecart.atlassian.net/wiki/spaces/AD/pages/5275676/Upgrade+manually

After the manual upgrade, clear all caches and check again.

#50

General Support / Re: *FIXED* PayPalecommerce ex...

Last post by Basara - October 29, 2025, 03:12:00 AM

Hello.
To clarify, do you see this problem only on the new server, or does it also happen with your old installation (before the move)?

Please try the following steps to narrow it down:
1. Disconnect the PayPal extension completely.
2. Clear your browser cache and cookies to make sure there are no old PayPal sessions stored.
3. Then, log in again to your Live PayPal account from the AbanteCart admin and see if the error appears.

If you still get the "Oops, something went wrong" message, please take a screenshot of the error and also check your AbanteCart error log for the latest entries. That will help pinpoint what's going on.