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

Hi,

First, try clicking on the "check database" button of the HikaShop configuration. That should help if it's a database issue.
Otherwise, please do that modification :
www.hikashop.com/support/forum/2-general...ror-1054.html#287524
and 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.

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

Hi,

That's a bug from your payment plugin. I've reported the issue to the developer here:
github.com/ECPay/HikaShop_PHP/issues/1
As a quick fix, you can remove the line :
hikashop_addACLFilters($where, 'payment_access');
in the file plugins/hikashop/ecpay/ecpay.php on line 320.
And then reinstall the payment plugin when the developer provides a new version with a proper patch.

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

HI,

I don't see how you can get that same MySQL error with that modification.
However, you should check directly with the developer of that plugin.

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

Hi,

Do you still have that MySQL error ?
If so did you contact the support at techsupport@ecpay.com.tw ?
That's the email address mentioned on the github of that payment plugin. I don't see why they would put an email address if they don't answer about issues of the plugin.

If not, then you mean that you have a new problem I guess. What do you mean by "will receive a blank email" ? Who ? Your client ? You ? Can you do a screenshot of that email ? Can you provide precise steps of what you do to reach that with screenshots of the different steps ?

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 techsupport@ecpay.com.tw
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

Hi,

To request old versions of HikaShop, please use our contact form:
www.hikashop.com/support/contact-us.html
Please provide a link to this thread, the version number and the edition you want and we will send it to you.
Please note that the MySQL error in the plugin is something you will have regardless of the version of HikaShop. So as far as I can see, the current version of their plugin has never been tested with any version of HikaShop Business. And even if we give you HikaShop Business 3.2.1, I expect it will break in the same way. But still, it's worth giving it a try.