Show Posts


Messages - abolabo

Pages: [1] 2 3 ... 146
1
Support / Re: Upgrade to AbanteCart 1.4.2 Fails with SQL Syntax Error on DROP INDEX
« on: June 30, 2025, 08:02:03 AM »
Quote from: Ali Arslan on June 27, 2025, 09:31:33 AM
Thank you for the response earlier.

Just following up on this issue regarding the failed upgrade to v1.4.2 due to the DROP INDEX IF EXISTS syntax. As mentioned, our MySQL server version is 8.0.38, which supports this syntax  yet the upgrade still fails with the SQL error referencing:

DROP INDEX IF EXISTS `ab_lang_definition_idx` ON `ab_language_definitions`

1. open phpMyAdmin and run this queries:
Code: [Select]
create index `ab_lang_definition_idx` on `ab_language_definitions` (language_value(500));


create index `ab_settings_idx` on `ab_settings` (value(500));

2. run upgrade process in admin with key abantecart_upgrade_142

2
Support / Re: Upgrade to AbanteCart 1.4.2 Fails with SQL Syntax Error on DROP INDEX
« on: June 27, 2025, 06:06:52 AM »
what version of mysql-server do you use?
https://github.com/abantecart/abantecart-src/blob/master/public_html/composer.json#L28

(see cpanel->phpMyAdmin -> server info)

3
General Support / Re: Login Redirect Loop After POST on AbanteCart v1.4.1 – Session/Cookie Not Persist
« on: June 23, 2025, 06:56:02 AM »
Quote from: Ali Arslan on June 23, 2025, 05:27:27 AM
But after redirection to account/account, session seems wiped.

You can play  with controllers to exclude extensions effect at all.
Just open controller pages/account/account and comment two rows with hooks call
i mean lines with
//$this->extensions->UpdateData();
and
//$this->extensions->InitData();

After that no one extension hooks will run. And you will be sure problem in the server configuration or in php-code.

Just add two slashes // before call.

4
General Support / Re: Help with Permissions Breakdown
« on: June 23, 2025, 04:13:10 AM »
Quote from: JessieSager on June 20, 2025, 06:59:18 PM
I am being told that my permissions are set to 755 and I keep getting errors. Cannot even update the version of abantecarte as I get these errors:
755 means write for file/directory owner and listing(reading) for group and other users.
Your web-server works under some user. Usually it's a username that your account registered. In your case it's a "heartpetsupply".
Looks like somebody uploaded your files with wrong permissions or did it by security reason.
So, you should to set 755 permissions for all directories and files in the list.
You can do this via cPanel FileManager. Just select directory, for example default_usps. Change permissions and files inside.
If you do not plan to use extensions default_usps and default_spanish(language pack), you can just delete them.

5
General Support / Re: Login Redirect Loop After POST on AbanteCart v1.4.1 – Session/Cookie Not Persist
« on: June 19, 2025, 09:57:30 AM »
Quote from: Ali Arslan on June 19, 2025, 07:22:46 AM
However, the issue still persists the login completes, but the redirection loops back to the login page instead of proceeding to the account dashboard.

one of such unexpected deleting of session can be 3d-party login extensions.
Try to uninstall them completely if presents.

6
General Support / Re: Login Redirect Loop After POST on AbanteCart v1.4.1 – Session/Cookie Not Persist
« on: June 19, 2025, 06:55:50 AM »
yes, structure is correct.

Do you have some old incompatible extensions installed? Can you try disable them?


7
General Support / Re: Login Redirect Loop After POST on AbanteCart v1.4.1 – Session/Cookie Not Persist
« on: June 19, 2025, 04:38:14 AM »
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

8
How-to questions / Re: Which style sheet for the bootstrap theme?
« on: June 17, 2025, 03:51:31 AM »
Quote from: laura458 on March 16, 2024, 03:22:33 PM
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.

9
Support / Re: 1146 Error Upgrading 1.4.1 > 1.4.2
« on: June 16, 2025, 03:59:32 AM »
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]
--
-- 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';

10
General Support / Re: Help with Permissions Breakdown
« on: June 13, 2025, 08:54:07 AM »
just try to set 755 for  directory home/heartpetsupply/public_html/admin/system/ and it's subdirectories via cPanel fileManager

11
Upgrade / Re: upgrading from V.1.4.1 to V. 1.4.2
« on: June 11, 2025, 04:30:19 AM »
Quote from: perplexed on June 10, 2025, 01:09:49 PM
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.

12
General Support / Re: Why Is My Website NOT Showing on Google?
« on: June 09, 2025, 04:23:14 AM »
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

13
General Support / Re: Upgrade to 1.4.2 mess!
« on: June 07, 2025, 10:36:00 AM »
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.

14
General Support / Re: Error During AbanteCart Upgrade from v1.4.0 to v1.4.2 – SQL Error
« on: June 05, 2025, 06:04:00 AM »
Hi,
please read this topic https://forum.abantecart.com/index.php/topic,11249.0.html

15
General Support / Re: SQL error when trying to upgrade to 1.4.2.
« on: June 05, 2025, 06:03:14 AM »
probably same issue can be with table settings

Code: [Select]
CREATE INDEX `ac_settings_idx` ON `ac_settings` (`value`(333) ASC);

Pages: [1] 2 3 ... 146

Powered by SMFPacks Social Login Mod