Messages

I installed new abantecart and transfer files I need.
So far it looks working.
Hope no more issue...

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.

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.

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.

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.

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.

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

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!

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.

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.

Thank you for your advice.
My host server helped me to fix the problem, and now error is gone.

I added the line in php.ini, but I still get same message...

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?

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!