Show Posts


Messages - alevene

Pages: [1] 2 3 ... 7
1
Upgrade / Re: Error running 1.2.13 PHPMyAdmin command
« on: October 15, 2018, 08:43:52 AM »
I will try that, but I installed a demo version and checked that table. It didn't have a column either.

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

3
Upgrade / Re: Failed upgrade?
« on: October 10, 2018, 09:00:55 AM »
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,

4
Upgrade / Re: Failed upgrade?
« on: October 09, 2018, 08:42:48 AM »
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?

5
Configuration / Re: Email system fails using gmail account
« on: October 09, 2018, 08:27:56 AM »
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.

6
Upgrade / Re: Failed upgrade?
« on: October 08, 2018, 06:24:00 PM »
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"

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

8
Configuration / Re: Email system fails using gmail account
« on: October 08, 2018, 11:47:19 AM »
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.

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

10
Upgrade / Re: Failed upgrade?
« on: October 05, 2018, 11:15:35 AM »
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?

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

12
Configuration / Re: Email system fails using gmail account
« on: October 03, 2018, 02:56:08 PM »
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.

13
Upgrade / Re: Failed upgrade?
« on: October 03, 2018, 02:21:05 PM »
The error logs are blank!

So can I do it again, manually just to make sure that it installed properly?

The email system doesn't send emails, so it may be an incomplete installation.

14
Configuration / Re: Email system fails using gmail account
« on: October 02, 2018, 10:26:58 AM »
After each and every fiddle with the settings, I sent a test email to myself from the sales section of the Admin menu. It always fails, and unfortunately AbanteCart doesn't have a test system button on the configuration page to make the configuration process easier. I've never had problems with other web programs, just this one.

Is there information about NON SMTP sending anywhere?

15
Configuration / Re: Email system fails using gmail account
« on: October 02, 2018, 10:09:12 AM »
Sadly IMAP and POP3 are both turned on in the gmaail settings section and also to allow for non-secure applications is allowed.

I still get the Step 1 - failed. (Connection error occurred. HTTP-status:500) message and have tried SSL StartTLS, differennt outbound ports but nothing changes.

Any other ideas?

Pages: [1] 2 3 ... 7

Powered by SMFPacks Social Login Mod