Topics

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.

Thanks.

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 -

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.

public_html\storefront\language\english\content\

Ideas of where this and similar edits are hidden?

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://smtp.gmail.com:465 (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

Ideas?

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?

[(NOT adding @gmail.com, although both ways fail]

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

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

SMTP Password - your gmail password

SMTP Port - 465

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.

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?

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?

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.

Ideas?

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
nginx/1.10.2

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.

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?

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?

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?

After struggling with AbanteCart that would not update past 1.2.6, or would export/import, I built a brand new one by hand using the latest 1.2.8 build. I noticed a series of "bugs" or features as some may call them that made the rebuild all the more difficult.

I decided to run a web based security scanner from tinfoilsecurity.com. The scan just finished. The initial headers was Your website is Very Unsafe for both the new and the production site. The new site had 26 problems, the production site, 23.

Here are some of the details from the most severe of the twenty-six vulnerabilities listed on the new site. I do not know if I can caused some, but I haven't done a lot more than adding products/categories and so on. I suggest running your own free scan.

   
Vulnerability Name    URL    Variable    Rescan   Severity       
   
Cross-Site Request Forgery   /index.php   loginFrm            
   
Cross-Site Request Forgery   /index.php   SubscriberFrm            
   
Unencrypted password form   /index.php   password            
   
Clickjacking   /               
   
Directory listing is enabled.   /storefront/view/default/javascript/               

I also ran the scan on the production site using 1.2.6 that has fewer problems that 1.2.8, even though 1.2.6 has been in use for a long time!
   
Vulnerability Name    URL    Variable    Rescan   Severity       
   
Cross-Site Scripting in event attribute of HTML element   /index.php   sort            
   
Cross-Site Scripting in event attribute of HTML element   /index.php   manufacturer_id            

Comments?

I am finishing a new 1.2.8 installation. When adding a product option to a product under options, and select text option, the system opens a text area box for insertion of content. The problem is that it doesn't save so the option is useless.

What am I doing wrong?

I haven't had any luck with importing products using an Excel spreadsheet.

I read this page - http://docs.abantecart.com/pages/tools/import.html and downloaded the sample "tab delimited" file for review.

When I created a simple spreadsheet in Excel and saved as tab delimited. I reopened the file, selected tax delimited and got this -
A   B   C   A   B   C   A   B   C
2   2   2   2   2   2   2   2   2
3   3   3   3   3   3   3   3   3

Very nice

Why does the sample not work the same way?

Excel imported the file, products-insert-example-tab. It looks like garbage.

"action   products.model   products.sku   products.location   products.quantity   products.stock_status_id   products.manufacturer_id   products.shipping   products.ship_individually   products.free_shipping   products.shipping_price   products.price   products.tax_class_id   products.date_available   products.weight   products.weight_class_id   products.length   products.width   products.height   products.length_class_id   products.status   products.viewed   products.sort_order   products.subtract   products.minimum   products.cost   product_descriptions[0].language_id   product_descriptions[0].name   product_descriptions[0].meta_keywords   product_descriptions[0].meta_description   product_descriptions[0].description   product_descriptions[1].language_id   product_descriptions[1].name   product_descriptions[1].meta_keywords   product_descriptions[1].meta_description   product_descriptions[1].description   products_related[0].related_id   products_to_categories[0].category_id   products_to_categories[1].category_id   products_to_categories[2].category_id   products_to_categories[3].category_id   products_to_downloads[0].download_id   products_to_stores[0].store_id   product_options[0].product_option_id   product_options[0].attribute_id   product_options[0].group_id   product_options[0].sort_order   product_options[0].status   product_options[0].element_type   product_options[0].required   product_option_descriptions[0][0].language_id   product_option_descriptions[0][0].name   product_option_descriptions[0][1].language_id   product_option_descriptions[0][1].name   product_option_values[0][0].product_option_value_id   product_option_values[0][0].group_id   product_option_values[0][0].sku   product_option_values[0][0].quantity   product_option_values[0][0].subtract   product_option_values[0][0].price   product_option_values[0][0].prefix   product_option_values[0][0].weight   product_option_values[0][0].weight_type   product_option_values[0][0].attribute_value_id   product_option_values[0][0].grouped_attribute_data   product_option_values[0][0].sort_order   product_option_value_descriptions[0][0][0].language_id   product_option_value_descriptions[0][0][0].name   product_option_value_descriptions[0][0][0].grouped_attribute_names   product_option_value_descriptions[0][0][1].language_id   product_option_value_descriptions[0][0][1].name   product_option_value_descriptions[0][0][1].grouped_attribute_names   product_option_values[0][1].product_option_value_id   product_option_values[0][1].group_id   product_option_values[0][1].sku   product_option_values[0][1].quantity   product_option_values[0][1].subtract   product_option_values[0][1].price   product_option_values[0][1].prefix   product_option_values[0][1].weight   product_option_values[0][1].weight_type   product_option_values[0][1].attribute_value_id   product_option_values[0][1].grouped_attribute_data   product_option_values[0][1].sort_order   product_option_value_descriptions[0][1][0].language_id   product_option_value_descriptions[0][1][0].name   product_option_value_descriptions[0][1][0].grouped_attribute_names   product_option_value_descriptions[0][1][1].language_id   product_option_value_descriptions[0][1][1].name   product_option_value_descriptions[0][1][1].grouped_attribute_names   product_specials[0].product_special_id   product_specials[0].customer_group_id   product_specials[0].priority   product_specials[0].price   product_specials[0].date_start   product_specials[0].date_end   product_tags[0].tag   product_tags[0].language_id   product_tags[1].tag   product_tags[1].language_id   product_tags[2].tag   product_tags[2].language_id   product_tags[3].tag   product_tags[3].language_id   resource_map[0].resource_id   resource_map[0].object_name   resource_map[0].object_id   resource_map[0].default   resource_map[0].sort_order   resource_library[0][0].resource_id   resource_library[0][0].type_id   resource_descriptions[0][0][0].language_id   resource_descriptions[0][0][0].name   resource_descriptions[0][0][0].title   resource_descriptions[0][0][0].description   resource_descriptions[0][0][0].resource_path   resource_descriptions[0][0][0].resource_code   resource_descriptions[0][0][1].language_id   resource_descriptions[0][0][1].name   resource_descriptions[0][0][1].title   resource_descriptions[0][0][1].description   resource_descriptions[0][0][1].resource_path   resource_descriptions[0][0][1].resource_code   resource_map[1].resource_id   resource_map[1].object_name   resource_map[1].object_id   resource_map[1].default   resource_map[1].sort_order   resource_library[1][0].resource_id   resource_library[1][0].type_id   resource_descriptions[1][0][0].language_id   resource_descriptions[1][0][0].name   resource_descriptions[1][0][0].title   resource_descriptions[1][0][0].description   resource_descriptions[1][0][0].resource_path   resource_descriptions[1][0][0].resource_code   resource_descriptions[1][0][1].language_id   resource_descriptions[1][0][1].name   resource_descriptions[1][0][1].title   resource_descriptions[1][0][1].description   resource_descriptions[1][0][1].resource_path   resource_descriptions[1][0][1].resource_code   resource_map[2].resource_id   resource_map[2].object_name   resource_map[2].object_id   resource_map[2].default   resource_map[2].sort_order   resource_library[2][0].resource_id   resource_library[2][0].type_id   resource_descriptions[2][0][0].language_id   resource_descriptions[2][0][0].name   resource_descriptions[2][0][0].title   resource_descriptions[2][0][0].description   resource_descriptions[2][0][0].resource_path   resource_descriptions[2][0][0].resource_code   resource_descriptions[2][0][1].language_id   resource_descriptions[2][0][1].name   resource_descriptions[2][0][1].title   resource_descriptions[2][0][1].description   resource_descriptions[2][0][1].resource_path   resource_descriptions[2][0][1].resource_code"
"insert   558003   testsku      99   1      0   0   0   0.0000   29.5000   1   2011-08-29   75.00   2   40.00   25.00   15.00   0   1   8   1   0   1   0.0000   1   Skinsheen Bronzer Stick         ""&lt;p&gt;"
"   Bronzes"

I am rebuilding our site by hand, as the export/import routine does not work properly. Some images were linked, some were not. I copied the images folder before the import with poor results.

Is there a way to bulk add images to a range of products to avoid the manual unlinking of non-existing images after the "restore" from each product. Then delete the non-images from the media manger and finally ... bulk edit from the product list to apply the same images to a number of product variations, each being a separate line item?

I setup a new 1.2.8 cart and although selecting not to import sample database, the website has lots of cosmetic images. How do I get rid of them? Nothing that I've tried works and they are not shown under Media Manager.

Is there a way to import just images, and if possible link them automatically with products? Perhaps a csv file. I've tried exporting and importing data but the import fails and nothing is imported.