ECPAY have SQL syntax error

-- url of the page with the problem -- : gohousen.com/
-- HikaShop version -- : 3.5

Payment Method: Credit. Paid Failed, Exception(Unknown column 'payment_access' in 'where clause').


I using "AllPay" that is 8rd product for payment plugin in Taiwan
www.ecpay.com.tw/Service/Appcntr_Shpcar

Order will change two
Set up an order
a blank order
The contents of the blank order are:
Payment Method: Credit. Paid Failed, Exception(Unknown column 'payment_access' in 'where clause').

Use another payment method
Will also produce the same problem
www.spgateway.com/website/Page/content/download_api#2

Just tested again
After the order is established
Display a bunch of blank orders

I reinstalled the payment kit
After successful payment
The blank order is: Payment Method: Credit. Paid Failed, Exception(Unknown column 'payment_access' in 'where clause' SELECT order_id FROM `nyt1n_hikashop_order` WHERE order_payment_method='ecpay' AND order_number='D7J7' AND (payment_access = 'all' OR Payment_access LIKE '%,2,%') limit 1).

---

OK Table "hikashop_address" checked

OK Table "hikashop_badge" checked

OK Table "hikashop_banner" checked

OK Table "hikashop_cart" checked

OK Table "hikashop_cart_product" checked

OK Table "hikashop_category" checked

OK Table "hikashop_characteristic" checked

OK Table "hikashop_click" checked

OK Table "hikashop_config" checked

OK Table "hikashop_currency" checked

OK Table "hikashop_discount" checked

OK Table "hikashop_download" checked

OK Table "hikashop_entry" checked

OK Table "hikashop_field" checked

OK Table "hikashop_file" checked

OK Table "hikashop_filter" checked

OK Table "hikashop_geolocation" checked

OK Table "hikashop_history" checked

OK Table "hikashop_limit" checked

OK Table "hikashop_massaction" checked

OK Table "hikashop_order" checked

OK Table "hikashop_orderstatus" checked

OK Table "hikashop_order_product" checked

OK Table "hikashop_payment" checked

OK Table "hikashop_price" checked

OK Table "hikashop_product" checked

OK Table "hikashop_product_category" checked

OK Table "hikashop_product_related" checked

OK Table "hikashop_plugin" checked

OK Table "hikashop_shipping" checked

OK Table "hikashop_shipping_price" checked

OK Table "hikashop_tax" checked

OK Table "hikashop_taxation" checked

OK Table "hikashop_user" checked

OK Table "hikashop_variant" checked

OK Table "hikashop_vote" checked

OK Table "hikashop_vote_user" checked

OK Table "hikashop_waitlist" checked

OK Table "hikashop_widget" checked

OK Table "hikashop_zone" checked

OK Table "hikashop_zone_link" checked

OK Table "hikashop_warehouse" checked

OK Table "hikashop_email_log" checked

OK Product categories checked

OK Variants orphan links cleaned

OK Joomla users synchronized

OK User email addresses synchronized

---

activate the "error reporting" and "debug mode" settings of the Joomla configuration and try again. That error should now have a lot more information (at least the MySQL query causing the issue) which would help us better understand why you have that error.

Attached screenshot screen：
www.gohousen.com/123/000-02.pdf

Thank you for your reply
I tested it.
Thank you

One hour ago
Deleted
hikashop_addACLFilters($where, 'payment_access');
in the file plugins/hikashop/ecpay/ecpay.php on line 320.

but...
Just received again

Thanks for the reply, I tried to find other people, can I solve it?

Payment developers, they only target the free hikashop version

Payment for hikashop, they are not responsible

Can someone else solve it?
Developer only for free version
If you want to charge
Please tell me about it.
How much to collect

They reply to me
Payment kit is only available for free hikashop
There is no compatibility adjustment for the paid professional version.
To target a paid version
Please ask other people

---

This is their reply in Chinese:
請問這是為付費專業版嗎?，
若是的話，我方在開發時是以免費版進行開發，如網址
並沒有針對付費專業版做相容性調整，
若貴司需要此功能，建議諮詢資訊外包商來優化您的需求
造成您的不便，敬請見諒，謝謝。

---

Thank you
I have notified This email address is being protected from spambots. You need JavaScript enabled to view it.
The same is the old problem
Modify plugins / hikashop / ecpay / ecpay.php
after that...
There will be a blank order
Order display
From:
Payment Method: Credit. Paid Failed, Exception(Unknown column 'payment_access' in 'where clause' SELECT order_id FROM `nyt1n_hikashop_order` WHERE order_payment_method='ecpay' AND order_number='D7J7' AND (payment_access = 'all' OR Payment_access LIKE '% , 2,%') limit 1).

change

Payment Method: Credit. Paid Failed, Exception(Amount error.)

---

Currently in order not to generate a blank order
Have deleted the previously successful order
Will no longer receive blank order notifications and create

Today, their customer service has a telephone contact.
Please use hikashop 3.1.1/.3.2.1
test
I would like to ask
The old version is going to download