Worldpay / Worldpay-Magento2-CG

Worldpay Magento 2 Plugin for Worldpay Corporate Gateway
Other
17 stars 35 forks source link

Database tables with prefixes cause exception in My Account area #110

Closed samcleathero closed 1 year ago

samcleathero commented 1 year ago

If database tables have a prefix, an exception is thrown when trying to access the My Account area, as shown in the screenshot below.

This is caused by a database join in Model/ResourceModel/Recurring/Subscription/Collection.php on line 114 which references the raw table name (worldpay_recurring_plans) and does not account for any table prefix which might be configured.

Database prefix issue screenshot

I will submit a pull request shortly to rectify this.

elavarasann commented 1 year ago

Thanks for this update. We will check our end and let you know.

elavarasann commented 1 year ago

We have checked in our side but we are not able to reproduce this issue.

samcleathero commented 1 year ago

Please check again and review my pull request #111 as this is still definitely an issue. This is a critical site-breaking issue for anyone who uses database prefixes.

elavarasann commented 1 year ago

Can you send us the version details of our plugin and Magento that you are using. We will re check it again. And did you checked this issue in Vanilla version of Magento ?