Show Posts

Topics - alevene

Pages: [1] 2 3
General Support / Error upgrading 1.3.0 to 1.3.1
« on: August 18, 2021, 10:20:53 AM »
I get this error upgrading from 3.0 to 3.1. App

Warning: AbanteCart core v.1.3.0 mobile_app directory is missing.

I've completed many upgrades without problems. If I have to manually create a mobile app directory, or more, where is it created and what name/permissions are needed for it.

The system starts the download and then shows this message.


Upgrade / Error running 1.2.13 PHPMyAdmin command
« on: October 13, 2018, 11:49:09 AM »
I copied over the contents of 1.2.13 upgrade.sql in a PHPmyAdmin database SQL Query window after editing the command prefix from abc_ to ac_. It failed -

This is the upgrade.sql file contents -

ALTER TABLE `ac_store_descriptions`
CHANGE COLUMN `description` `description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `title` `title` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `meta_description` `meta_description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `meta_keywords` `meta_keywords` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ;

ALTER TABLE `ac_customer_transactions`
  CHANGE COLUMN `credit` `credit` DECIMAL(15,4) NULL DEFAULT '0',
  CHANGE COLUMN `debit` `debit` DECIMAL(15,4) NULL DEFAULT '0';

It showed this error -


SQL query:

ALTER TABLE `ac_store_descriptions`
CHANGE COLUMN `description` `description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `title` `title` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `meta_description` `meta_description` LONGTEXT NULL DEFAULT '' COMMENT 'translatable' ,
CHANGE COLUMN `meta_keywords` `meta_keywords` LONGTEXT NULL DEFAULT '' COMMENT 'translatable'

MySQL said: Documentation
#1054 - Unknown column 'title' in 'ac_store_descriptions'

Any ideas on how to fix this problem?

I've edited the contact.xml file and content.xml files for this advisory message, and other minor messages, but the text changes don't seem to any effect, even after clearing the cache.


Ideas of where this and similar edits are hidden?

Fresh Installation / Email issues with gmail smtp connection
« on: October 04, 2018, 03:53:37 PM »
I have an on and off scenario with sending customer/order email using my upgraded AbanteCart 1.2.13 so did an experiment.

I installed a fresh NEW installation using dummy data, and setup the generic SSL connection using the AbanteCart manual as a guide. I am told by my ISP that port 465 is open.

I setup a NEW gmail account and allowed non secured apps to use its SMTP service -

IMAP Access:
Status: IMAP is enabled

(if there are other settings, having changed the settings to ALLOW non-secure apps, let me know.

...and sent test emails. Result, failure -

2018-10-03 18:30:12 - warning: AbanteCart core v.1.2.13 fsockopen(): unable to connect to ssl:// (Connection timed out) in <b>/xxxxxxxxxxxx/public_html/xxxxxxxxxxxxxxxxxxxxpublic_html/core/lib/mail.php</b> on line <b>295</b>

I changed to the SendMail client option in AbanteCart. This time the mail was shown as sent, but NOT received by me.

When I did a password reset to test the internal system, I did receive that email with a link, so the system does work -

Web Store Name - Password Reset Request


Upgrade / Failed upgrade?
« on: October 01, 2018, 11:14:26 AM »
I did an inline upgrade from 1.2.12  to 1.2.13 that posted a "failed" message but I noticed that the footer stated that I had installed the latest version was. How do you force a upgrade reinstallation to be sure all of the new files, etc. are installed correctly?

Configuration / Email system fails using gmail account
« on: October 01, 2018, 10:32:27 AM »
I have never been able to get the smtp gmail email system to work. I've followed the instructions carefully, but only get a 500 error message. Ideas?

Example of Gmail SMTP

Mail Protocol – SMTP

SMTP Host - ssl://

SMTP Username - your username (aka username if your email is (NOT adding, although both ways fail)

SMTP Password - your gmail password

SMTP Port - 465

Support / Updating Abantecart using manual update MySql error
« on: April 24, 2017, 02:03:24 PM »
I've tried to do a manual update using the PHPmyAdmin interface and get this message -

#1061 - Duplicate key name 'unique_id in the ac_settings_idx settings. I've looked at the structure keys and compared the settings to another AbanteCart structure. The working system does not have primary keys for either Group or Key. How is the Group key removed as it may be the problem.

I have only found one reference to this phrase - FULLTEXT INDEX `ac_settings_idx` (`value` ASC) apparently to setup the ac_setup.

See photo.

If not how do I fix the problem? I can restore prior versions of the MySql database and the original 1.2.6 files.

Installation and Configuration / Problems with included template
« on: April 23, 2017, 09:08:41 AM »
I have noticed that 1.2.10's template doesn't actually change when you move sections around, or add/delete them! Earlier versions using the same template didn't have this problem.

How can you force a change to factory default to start making the changes again, or backup and overwrite with another version?

General Support / Lost items
« on: April 22, 2017, 11:17:22 AM »
Is there a switch in the latest AbanteCart (1.2.10)version that will show items that are not completely setup? For example, when I want to add an item, where there is an existing very similar item, I copy it and then edit to make the needed changes.

If I do not make the new item active and log out, when I log in again it's gone. If I export the product database, I can see it in the CSV file (MySQL) but not in the web interface.

How do I see them again, to delete or complete?

General Support / One to many
« on: April 22, 2017, 07:41:21 AM »
I have noticed that it's easy to add a multiple choice for variations on a single product, white, gray, black, red and so on and let the buyer click on the color. The problem with this is that only one product is displayed in that section.

Is it possible for an product clickable image to appear under that section where the options are display one at a time? For example if you have 10 colors, it's better to have ten product images than one.

Unless there is a better way (excluding the impossible to use fragile CSV export/import), is it possible to create a complex option and then copy/paste it into many products without tedious editing? Or is it possible to select all of the products that need this option and edit them all at the same time, so one entry is posted to them all?

Or are there other ways? Adding the same option, even using the option select box is tedious and labor intensive.


General Support / Export and import under the latest version, 1.2.10
« on: April 02, 2017, 03:41:57 PM »
I upgraded Abantecart to 1.2.10, made some additions and then exported to a CSV file for review. I found some minor description errors - much, much easier to see in Excel tabular format - corrected them and attempted to import the edited CSV file. I got this message and the process failed -

405 Not Allowed

It HAS worked before. Now it doesn't. Ideas and where is the built in tabular listings without all of the graphical fluff. They's be much easier to edit and correct errors.

General Support / Help with export and import
« on: March 24, 2017, 02:51:04 PM »
When I export the product database I an overwhelmed with hundreds of columns. Does anyone know what column numbers are the mostly commonly used to change product descriptions/prices/accessories prices and so on.

Excel can hide unused columns and if the visible tables can be reduced to a dozen columns or so, it will be much easier to work with as an export and a subsequent import.

Are there any videos or guides specifically on working with exports and imports?

Extension Support / Extension to link Excel directly to Abantecart
« on: March 24, 2017, 02:40:13 PM »
Is there an extension where you can dynamically link (or just easily post to the MySQL database) that allows instant price or other changes to the key fields - price, description, title and so on?

I've found that exporting to Excel, editing and then posting back is not easy to use. If no extension, are there any YouTube videos that clearly explain how to export and import effectively.

Also, is it possible to export in one version, 1.2.x and import to the current, 1.2.9?

Support / Will not update past 1.2.6
« on: March 20, 2017, 10:06:55 AM »
I am tried a variety of methods to update past 1.2.6 without any success. Does anyone know how the files and database can be updated to the current version 1.2.9?

Pages: [1] 2 3

Powered by SMFPacks Social Login Mod