Show Posts


Topics - alevene

Pages: [1] 2
1
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 -

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?

2
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?

3
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://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?

4
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?

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

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


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

8
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?

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

10
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?

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

12
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?

13
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?

14
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?

15
Security / Your website is Very Unsafe
« on: September 23, 2016, 01:30:21 PM »
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?

Pages: [1] 2

Powered by SMFPacks Social Login Mod