Messages

I checked and deleted three of the extensions that weren't working and now there is an "Archive error." These are the errors...

App Error: AbanteCart core v.1.3.0 Error: Cannot unpack file
App Error: AbanteCart core v.1.3.0 internal corruption of phar

My host offers php 8.0, 7.4 and 7.3. None work.

Ideas?

I should have added that it's running PHP 7.4. The only other options are 7.3 and 8.0.

None work.

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 will try that, but I installed a demo version and checked that table. It didn't have a column either.

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?

That being said, and I cannot find a clear example of applying the upgrade.sql file to my database, can anyone actually describe how it's done?

1  I don't see a way to import the file and run it within PHPMyAdmin. Can I, and if so how? Yes, I select the database where I can view the tables, click on the SQL tab and then...?

2  Do I only need to copy and paste the lengthy text contents of the upgrade.sql file into the box, Run SQL query/queries on database and then Go?

Please don't point to articles that are not relevant. This is a simple questions to someone who has done it, and the AbanteCart manual instructs are close to useless.

Thanks,

Is this true?

I now have to "Run modified upgrade.sql" I think I open PHPmysadmin, select the database and click the SQL tab. I copy and paste the lengthy text contents of the upgrade.sql file into the box, Run SQL query/queries on database and then Go?

The update to 1.2.13 partially failed so I've been working on that. If the update was robust, or there were clear instructions to do a manual update, they aren't, then 7.x may have worked and saved a lot of time.

I'm working through the very, very vague instructions here as the automatic upgrade failed, so I have some questions -

https://abantecart.atlassian.net/wiki/spaces/AD/pages/5275676/Upgrade+manually

After copying and overwriting the current files structure using the 1.2.13 upgrade files I now have to "Run modified upgrade.sql" I think I open PHPmysadmin, select the database and click the SQL tab. I copy and paste the lengthy text contents of the upgrade.sql file into the box, Run SQL query/queries on database and then Go?

As upgrade.php file present in upgrade 1.2.13 archive, copy the upgrade.php file into /folder_where_cart_installed/admin/controller/common/head.php in about line 30, (whatever that actually means).

This is the "about line 30" from the head.php file -

//use to init controller data
      $this->extensions->hk_InitData($this, __FUNCTION__);

      $this->load->helper('html');
      $this->loadLanguage('common/header');

      $message_link = $this->html->getSecureURL('tool/message_manager');

This means add this line in an empty line to execute it by opening a web browser and logging into the admin account ONCE. Then log out, and remove the file AND the line reference?

"include('/yourpathtofile/upgrade.php'); 

Load admin page once! This will execute PHP update script and will run commands from the upgrade.php file"

Perfect. I found the text files in the database, cleared the cache and all is working properly. I suspect that the PHP and XML files just configure the database on installation and don't affect the working information afterwards.

I found that it wasn't the real solution. After further work, I found that the PHP in use was v7. When I changed it to v5.6 and the mail subsytem worked properly, although I never got smtp.gmail.com to work.

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?

What exactly is meant by a manual upgrade? Is there a step by step guide, that isn't vague?

I noticed from the demo install that the prefix to the table entries are different from the working database. Does the "upgrade" change that prefix, so if it hasn't been changed, the database has not been upgraded?

Does anyone know?

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 built a test server and found that the ssl gmail settings would not work. I tried the generic mail and it did!

I reset the permissions on the working server, set the mail subsystem to generic WITHOUT any email address modifications, line 2 and it appears to work. The AbanteCart instructions are far too vague and lack screen print examples.

So the takeaway is to reset all of the folders permissions to 0755 and do not bother with gmail, in instance. I'm not sure if there was a permissions issue since I was throwing multiple possible solutions as nothing was working and it worked, without the email modifiers.

Thanks a lot for your ideas. You pointed me in the right direction.