Messages

please check this sql-request of upgrade script.
https://github.com/abantecart/abantecart-src/blob/1.4.1/public_html/install/abantecart_database_upgrade.sql#L87

Be sure table customer_sessions presents in the database

Hi all! I wanted to change the menu bar color (and other layout colors) and can't find the proper place to do it. I'm using the bootstrap theme. Is /storefront/view/default/stylesheet/bootstrap.css the right place?
I'm old. but the mind is still willing. A lot has changed since I made html web pages 25 years ago. Thanks for any help

You should to edit file style.css instead. bootstrap.css  is a file of css-framework. We prefer do not change such distributed files.
I guess you use our prior version of AbanteCart. Since 1.4.0 directories have name "css", not "stylesheet".
Please note, all your changes will be overwritten by upgrade process. To avoid that you should to create extension template based on your current "default" template via our developer_tools extension.

[Do not forget do full backup of your cart (see database export tab in phpMyAdmin)]

Run this sql-query before upgrade via phpMyAdmin.
Do not forget do full backup of your cart (see database export tab in phpMyAdmin)

Code Select Expand


--
-- DDL for table `user_sessions`
--
DROP TABLE IF EXISTS `abc_user_sessions`;
CREATE TABLE `abc_user_sessions` (
    `user_id` int(11) NOT NULL,
    `token` varchar(128) NOT NULL DEFAULT '',
    `ip` varchar(50) NOT NULL DEFAULT '',
    `last_active` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`user_id`, `token`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- DDL for table `customer_sessions`
--
DROP TABLE IF EXISTS `abc_customer_sessions`;
CREATE TABLE `abc_customer_sessions` (
    `customer_id` int(11) NOT NULL AUTO_INCREMENT,
    `session_id` varchar(128) NULL DEFAULT '',
    `ip` varchar(50) NOT NULL DEFAULT '',
    `last_active` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`customer_id`, `session_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

#update menu design item
UPDATE `abc_dataset_values`
SET value_varchar = 'design/template'
WHERE row_id=3 AND value_varchar='extension/extensions/template';

#fix or prior upgrade 1.3.4->1.4.0
UPDATE `abc_blocks`
SET controller='blocks/viewed_products'
WHERE controller='viewed_products/viewed_products' AND block_txt_id = 'viewed_products';


just try to set 755 for  directory home/heartpetsupply/public_html/admin/system/ and it's subdirectories via cPanel fileManager

Not all of us are dev's. There are many apps out there that provide both an easy upgrade, and a strong defense. We know because we have used them and upgrades are secure and seamless. These Abantecart upgrades have become intimidating and that should not happen. We just want to have the best products to present to our customers.

Agree.  Feel free send us donations. This project alive because of you and code is free.

you should to ask google about that.

https://www.google.com/search?q=how+to+add+my+website+to+google

They have a lot of tools for detecting problems with your domain records etc

See response from Gemini

this sounds so wierd.
Upgrade script works as chain.
1. step - running SQl upgrade script (database modification)
2. running php upgrade script.
3. replacement of files with new (including file public_html/core/version.php)

If you see version 1.4.2 in the footer of your admin side, this means previous steps was successful.

Do you have some errors in the error log?
Also you can seek some records in the install/upgrade history table.

Please give us more details.

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

probably same issue can be with table settings

Code Select Expand

CREATE INDEX `ac_settings_idx` ON `ac_settings` (`value`(333) ASC);

we are already first platform
And people got our code for free

[is that possible?]

Hello,

I just wanna know if it's possible to do something to embed a specific html block with a unique url link to share outside of website in 3rd parties webpages and apps.

is that possible?

Yes, in theory:
1. create your own controller, let's name it myBannerBlock. As example you can get method "main" from public_html/extensions/banner_manager/storefront/controller/responses/extension/banner_manager.php.
The main function of this controller to send piece of html (tpl-render of ready html-content of block) by request parameters.
2. Then create new html-banner. Get it's banner_id.
3. Insert into table url_aliases data, where `query`  =  'banner_id=123&format=html' and `keyword` = 'some_unique_your_seo_keyword'.
4. Then open browser and put url https://www.yourdomain.com/some_unique_your_seo_keyword

It's a good idea to extend functionality our native banner manager extension. Feel free to donate us for this feature :-)

[DirectoryIndex index.php]

You may have the same issue I had.

The webserver wouldn't serve index.php as the default index file, so any call to javascript would return 404, which was the wrong file type since it was expecting javascript, and it would get blocked.

The solution was go to the .htaccess file in the root folder of your AbanteCart installation and add this line:
DirectoryIndex index.php

Nope, this it database index related issue, not webserver

looks like you forgot ssl:/ as protocol in the settings.
See example here https://abantecart.atlassian.net/wiki/spaces/AD/pages/7372837/Mail+Settings

do you have fast_checkout extension installed?

you should to run sql queries manually via phpMyAdmin.
Regarding error i guess you should to start since line 1091
https://github.com/abantecart/abantecart-src/blob/master/public_html/install/abantecart_database_upgrade.sql#L1091

Do not forget to replace table prefix with yours before