ECPAY have SQL syntax error

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 1 week ago #295010

-- 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').

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 1 week ago #295011

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

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 1 week ago #295017

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

Attachments:
Last Edit: 4 months 1 week ago by wwwopptwcom.
The following user(s) said Thank You: Jerome

Please Log in or Create an account to join the conversation.

  • Posts: 63971
  • Thank you received: 9221
  • MODERATOR
4 months 1 week ago #295034

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.

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 6 days ago #295097

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

Attachments:
Last Edit: 4 months 6 days ago by wwwopptwcom.

Please Log in or Create an account to join the conversation.

  • Posts: 63971
  • Thank you received: 9221
  • MODERATOR
4 months 6 days ago #295108

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.

The following user(s) said Thank You: wwwopptwcom

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 6 days ago #295112

Thank you for your reply
I tested it.
Thank you

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 6 days ago #295125

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

but...
Just received again

Attachments:
Last Edit: 4 months 6 days ago by wwwopptwcom.

Please Log in or Create an account to join the conversation.

  • Posts: 63971
  • Thank you received: 9221
  • MODERATOR
4 months 5 days ago #295127

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.

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 5 days ago #295177

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

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 5 days ago #295203

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

Last Edit: 4 months 4 days ago by wwwopptwcom.

Please Log in or Create an account to join the conversation.

  • Posts: 63971
  • Thank you received: 9221
  • MODERATOR
4 months 4 days ago #295180

Hi,

Do you still have that MySQL error ?
If so did you contact the support at This email address is being protected from spambots. You need JavaScript enabled to view it. ?
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 ?

Last Edit: 4 months 5 days ago by nicolas.

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 4 days ago #295241

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

Last Edit: 4 months 4 days ago by wwwopptwcom.

Please Log in or Create an account to join the conversation.

  • Posts: 24
  • Thank you received: 1
  • Hikashop Business
4 months 4 days ago #295249

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

Please Log in or Create an account to join the conversation.

  • Posts: 63971
  • Thank you received: 9221
  • MODERATOR
4 months 4 days ago #295259

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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.148 seconds
Powered by Kunena Forum