Messages

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.

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;

try this

Code Select Expand

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

hi,
what about install/upgrade log?

Hi

I believe this has been asked before but was 9 years ago under a totally different release.  So I cannot seem to find the comparison files that were apparently java files.

I'd like to be able to adjust the image speed for the next image in the slider.

So if a product is viewed and there are 5 images for example, its a bit too slow for my liking so wondered if we can adjust this. Its currently about 5 seconds.

Unless I haven't see it in the configuration....

1. go to admin->design->layout->choose Home page layout
2. Click gear button of block you should to change.
if block based on bootstrap5 carousel component:
- In the html-Editor find all divs with class "carousel-item" and add new html-attribute data-bs-interval="1000". See more details here https://getbootstrap.com/docs/5.3/components/carousel/#individual-carousel-item-interval
- For "owl" based sliders you should to edit template of it. See wrapper selector on the block edit form.
For example: public_html/extensions/novator/storefront/view/novator/template/blocks/listing_block/popular_brands_content_bottom.tpl

please replace two files with attached

public_html/admin/controller/responses/sale/invoice.php
and
public_html/admin/view/default/template/responses/sale/order_invoice.tpl

Looks like you had ran upgrade twice.
Your database structure now under v1.4.2, but php code is 1.4.1.
Just restore database from backup and run upgrade again

[.htaccess]

I can only say that I know next to nothing about Apache server files and editing .htaccess files so I haven't touched them at all. please help. 

Hi, this error depends on your current apache version.
Thank you for your report. Good catch.

To solve try to replace content of file C:/wamp64/www/abantecart/admin/.htaccess with this:

Code Select Expand

<IfModule !mod_authz_core.c>
    # Apache 2.2
    <FilesMatch "\.php$">
        Order deny,allow
        Deny from all
    </FilesMatch>
</IfModule>

<IfModule mod_authz_core.c>
    # Apache 2.4+
    <FilesMatch "\.php$">
        Require all denied
    </FilesMatch>
</IfModule>

and tell us result. If all fine we'll give you instruction what other places should be edited.

Thank you.

Hi,
The first thing you need to know about modifying the product grid is that AbanteCart uses several types of controllers.
The grid configuration itself is defined in the page controller — in your case, `catalog/product`.
This configuration is passed to the `common/listing_grid` controller, which renders the grid using jqGrid.

Right after loading, an AJAX request is sent to a response controller. You can find all the response controllers for grids under the `responses/listing_grid` path.

As you've probably guessed, at each stage of the code execution path, you can make changes to the controllers using our hook system.
Each controller has calls like `$this->extension->hk_InitData()` or `$this->extension->hk_UpdateData()` (there are actually more),
which allow you to modify public properties of the controller from a hook, both before and after execution.

So, to add a column, you need to modify the configuration before the `common/listing_grid` controller executes.
(The configuration data contains a `table_id`, so you can easily detect which grid is being called. In your case, it's `'table_id' == 'product_grid'`).

You'll also need to modify the response controller `listing_grid/product` to include `title` in the data list.
As an example, check the method `public function onControllerResponsesListingGridExtension_UpdateData()` from the `avatax_integration` extension.

It's best to work with Xdebug so you can see which data is available at each step.

For more details on how hooks work, refer to (https://abantecart.atlassian.net/wiki/spaces/DOC/pages/17793156/Hooks]our documentation:

My second question is, on the checkout page, it keeps saying "Error: No Shipping options are available. Please contact us for assistance!".

I have no idea why it keeps saying this - I activated ship by weight and also paypal is available as a payment method.

Please help, thanks

usually this mean you have a misconfiguration of weight rate.
AbanteCart shipping selection based on inner filtration. Filtration based on limitations such as allowed location, weight min/max limits and rates-by-weight and parcel dimensions.
All these restrictions you can change on the shipping method extension page.
Also be sure your parcel not zero-weight. 
We suggest to enable setting config_cart_weight(settings->checkout or just type in search key in admin) to see total weight on the cart page (see heading title)
More detailed info you can find in our documentation

because it's hardcoded in tpl
public_html/extensions/novator/storefront/view/novator/template/common/menuoffcanvas.tpl line 49