[Skip to main content](#vessel-content)

#   SQL error on unpublishing payment plugin

##

- **[ximbo](/forum/user/25614-ximbo "View ximbo's Profile")**
- [![ximbo's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/25614-ximbo "View ximbo's Profile") Topic Author
- [ Offline](/forum/user/25614-ximbo)

Less More

- Posts: 34
- Thank you received: 1
-
-

13 years 3 months ago [\#119234](#119234) by [ximbo](/forum/user/25614-ximbo "View ximbo's Profile")  *[SQL error on unpublishing payment plugin](/forum/3-bug-report/861159-sql-error-on-unpublishing-payment-plugin#119234 "-- HikaShop version -- : 2.2 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0 WHERE IN ( 3 )' at line 1 SQL=UPDATE pahcw&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 3 )  I get the above error when unpublishing a payment module (sagepay) from the system &gt; payments screen.")* was created by *[ximbo](/forum/user/25614-ximbo "View ximbo's Profile")*

-- HikaShop version -- : 2.2
-- Joomla version -- : 3.1.5
-- PHP version -- : 5.3
-- Browser(s) name and version -- : XXXXX x.x.x
-- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0 WHERE IN ( 3 )' at line 1 SQL=UPDATE pahcw_hikashop_plugins SET = 0 WHERE IN ( 3 )

I get the above error when unpublishing a payment module (sagepay) from the system &gt; payments screen.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjExNTktc3FsLWVycm9yLW9uLXVucHVibGlzaGluZy1wYXltZW50LXBsdWdpbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86564
- Thank you received: 14311
-
-

13 years 3 months ago [\#119239](#119239) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[SQL error on unpublishing payment plugin](/forum/3-bug-report/861159-sql-error-on-unpublishing-payment-plugin#119239 "-- HikaShop version -- : 2.2 -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3 -- Browser(s) name and version -- : XXXXX x.x.x -- Error-message(debug-mod must be tuned on) -- : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 0 WHERE IN ( 3 )' at line 1 SQL=UPDATE pahcw&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 3 )  I get the above error when unpublishing a payment module (sagepay) from the system &gt; payments screen.")*

Hi,

We don't have the problem on our end. Can you download again the 2.2 on our website and install it again on yours to see if that fixes the issue ? If not, we'll need a backend access to your website to be able to look at the issue.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC84NjExNTktc3FsLWVycm9yLW9uLXVucHVibGlzaGluZy1wYXltZW50LXBsdWdpbj90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.047 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
