Show Posts


Messages - ehon

Pages: [1]
1
Upgrade / Re: Upgrade from 1.2.13 to 1.2.14 error
« on: November 15, 2019, 11:59:10 AM »
I installed new abantecart and transfer files I need.
So far it looks working.
Hope no more issue...

2
Upgrade / Re: Upgrade from 1.2.13 to 1.2.14 error
« on: November 13, 2019, 02:45:47 PM »
I downloaded again 1.2.14 files and did upload files. This time I got failed files only 2.
I tried to sql file run in phpmyAdmin and get error message...

ERROR 1054 (42S22) at line 1: Unknown column 'title' in 'store_descriptions'

Then I added column by manually.
Then I got this messages.

 Warning: #1101 BLOB, TEXT, GEOMETRY or JSON column 'description' can't have a default value

I don't know why so many problem...
Since I didn't do manually from 1.2.12 to 1.2.13, so it should be easily upgrade from link...
Please someone give some advices...

Thank you.

3
Upgrade / Upgrade from 1.2.13 to 1.2.14 error
« on: November 12, 2019, 09:22:54 AM »
Hi, I wanted upgrade my website from 1.2.13 to 1.2.14. auto upgrade from link didn't work (but I could do from 1.2.12 to 1.2.13),
I got this error log.

database error: AbanteCart core v.1.2.13 SQL Error: Table 'ehoncana_v1.reviews' doesn't exist
Error No: 1146
SQL: SELECT DISTINCT *,
pd.name AS name,
m.name AS manufacturer,
ss.name AS stock_status,
stock_checkout,
lcd.unit as length_class_name, ( SELECT AVG(r.rating)
FROM reviews r
WHERE p.product_id = r.product_id AND status = 1
GROUP BY r.product_id
) AS rating , COALESCE( ( SELECT p2sp.price
FROM product_specials p2sp
WHERE p2sp.product_id = p.product_id
AND p2sp.customer_group_id = '1'
AND ((p2sp.date_start = '0000-00-00' OR p2sp.date_start < NOW())
AND (p2sp.date_end = '0000-00-00' OR p2sp.date_end > NOW()))
ORDER BY p2sp.priority ASC, p2sp.price ASC LIMIT 1
) , p.price) as final_price FROM products p
LEFT JOIN product_descriptions pd
ON (p.product_id = pd.product_id
AND pd.language_id = '1')
LEFT JOIN products_to_stores p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturers m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN stock_statuses ss
ON (p.stock_status_id = ss.stock_status_id
AND ss.language_id = '1') LEFT JOIN length_class_descriptions lcd
ON (p.length_class_id = lcd.length_class_id
AND lcd.language_id = '1')
WHERE p.product_id = '553'
AND p2s.store_id = '0'
AND p.date_available <= NOW() AND p.status = '1' in <b>/home/ehoncana/public_html/core/database/amysqli.php</b> on line <b>109</b>

So I tried by manually.
some files couldn't transfer (always same 107 files)

For example:
Error: Failed to open "C:\Users\Yuko\Downloads\abantecart_1.2.14_upgrade_only.tar\abantecart_1.2.14_upgrade_only\abantecart_1.2.14_upgrade_only\code\extensions\default_authorizenet\vendor\authorizenet\authorizenet\lib\net\authorize\api\controller\CreateCustomerPaymentProfileController.php" for reading
Error: File transfer failed

then I asked my host server, then they said they have this problem below.

[ehoncana@nw3 public_html]$ mysql -uehoncana_v1 -p ehoncana_v1 < upgrade.sql
Enter password:
ERROR 1054 (42S22) at line 1: Unknown column 'title' in 'store_descriptions'

I thought to replace "ac_" to empty, but it wasn't the problem...
Please give me some advice...
Thank you.

4
SOLVED!!
I had some error in Cpanel error log.
I contacted my host server and they did...
”According to the error log the application files was not with correct permissions. I have now set 644 permissions for the files and 755 permissions for the folders”

Now I can send message to customers.
I hope it help someone has same issue.

Thank you.

5
I tried both, manually selected customers and Subscribers.
Both failed.
I can see error log is this,
2018-10-23 0:12:32 - database error: AbanteCart core v.1.2.13 SQL Error: Unknown column 'last_login' in 'field list'
Error No: 1054
SQL: UPDATE `customers`
SET `last_login` = NOW()
WHERE customer_id = 52 in <b>/home/ehoncana/public_html/core/database/amysqli.php</b> on line <b>109</b>

I'm not very knowledge person about code or programming, so I;m not sure this help to solve the problem.

6
I got reply from host server. They said

"I have increased the SMTP timeout setting to 60 from 5.

Additionally, I also removed the SPF record for the sake of testing."

Now I can receive contact message from customers, but I still can't send messages to customers...
I still get task error 500.
Also when I use 'schedule tasks' to send the message. I get this message "App Error Forbidden To restart!”

Is there any solution?

Thank you.
Thank you.

7
Thank you for your reply. I contacted my host server.
I hope I can solve the problem.

8
Hi, my Abantecart ver. is 1.2.13 (I just upgrade from 1.2.10, 1.2.11 and 1.2.12 ) When Iwas using 1.2.10, it was fine I didn't have any problem.
After I upgrade, and when I try to send message to my customers. I get task error 500.
Also i tried to send myself using 'contact form', I don't receive it. (but I can see it on top of my admin area)
In error log said

2018-10-21 21:08:27 - Error: EHLO not accepted from server!
2018-10-21 21:08:27 - Error: AUTH LOGIN not accepted from server!
2018-10-21 21:08:27 - Error: Username not accepted from server!
2018-10-21 21:08:27 - Error: Password not accepted from server!
2018-10-21 21:08:27 - Error: MAIL FROM not accepted from server!
2018-10-21 21:08:27 - Error: RCPT TO not accepted from server!
2018-10-21 21:08:27 - Error: DATA not accepted from server!
2018-10-21 21:08:27 - Error: DATA not accepted from server!
2018-10-21 21:08:27 - Error: QUIT not accepted from server!
2018-10-21 21:10:43 - Error: EHLO not accepted from server!
2018-10-21 21:10:43 - Error: AUTH LOGIN not accepted from server!
2018-10-21 21:10:43 - Error: Username not accepted from server!
2018-10-21 21:10:43 - Error: Password not accepted from server!
2018-10-21 21:10:43 - Error: MAIL FROM not accepted from server!
2018-10-21 21:10:43 - Error: RCPT TO not accepted from server!
2018-10-21 21:10:43 - Error: DATA not accepted from server!
2018-10-21 21:10:43 - Error: DATA not accepted from server!
2018-10-21 21:10:43 - Error: QUIT not accepted from server!

I contacted my server but they said it is not server's problem...
Please help!

9
General Support / Can't send email to customers
« on: August 26, 2017, 10:44:32 AM »
I just upgrade to Ver. 1.2.9. Before that, I didn't have any problem to send email. Now when I want to send a message to my customers, I get this message "Please set up Task API Key in the settings!"

What do I need to do to fix the problem?

Thank you.

10
Upgrade / upgrade from 1.2.7 to 1.2.8 images not showing
« on: August 21, 2016, 08:35:38 PM »
I just did upgrade from 1.2.7 to 1.2.8 with the link from abantecart, then now I can't see products images anymore.
I asked host server, and they say the link is broken and I have www front of my image's link. It should be (my site name).com. The image's link are www.(my site name).com

Is there any way to fix the problem?
One thing i can think about it is restore backup file before I upgrade to 1.2.8 and upgrade manually.
But if someone know easier way to fix the problem,please help me.

Thank you.

11
Development Help Needed / Re: Deprecated error for php.ini
« on: June 15, 2016, 11:44:39 AM »
Thank you for your advice.
My host server helped me to fix the problem, and now error is gone.

12
Development Help Needed / Re: Deprecated error for php.ini
« on: June 14, 2016, 03:14:55 PM »
I added the line in php.ini, but I still get same message...

13
Development Help Needed / Re: Deprecated error for php.ini
« on: June 14, 2016, 09:50:55 AM »
Thank you for your reply.
I upgraded to 1.2.7 by manually. I'm not sure it is done or still I'm 1.2.6...
I did what I need to do for the upgrade, (I follow the manual step by step) and I don't see any error message except the one I posted.
So if I get this message now,does it mean my upgrade was failed?

14
Development Help Needed / Deprecated error for php.ini
« on: June 14, 2016, 07:54:25 AM »
I get this message these days.
"Deprecated: Automatically populating $HTTP_RAW_POST_DATA is deprecated and will be removed in a future version. To avoid this warning set 'always_populate_raw_post_data' to '-1' in php.ini and use the php://input stream instead. in Unknown on line 0
{"success":true}   "

I checked my php.ini file, but I don't know what I should do...
My php.ini file is
;Use this file for specific PHP settings on your server required for AbanteCart.

output_buffering = 4096;
magic_quotes_gpc = Off;
register_globals = Off;
default_charset   = UTF-8;
memory_limit = 128M;
max_execution_time = 18000;
upload_max_filesize = 100M;
safe_mode = Off;
mysql.connect_timeout = 20;
session.use_cookies = On;
session.use_trans_sid = Off;
session.gc_maxlifetime = 12000000;
apc.enabled = 0;

The file type said "UNKNOWN file", so I believe I need to rename it. What file name I should use it?

Thank you for reading my message and I hope I can fix the problem soon!

Pages: [1]

Powered by SMFPacks Social Login Mod