Show Posts


Topics - ehon

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

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

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

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

5
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