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

#   Error message AUP

##

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

Less More

- Posts: 3
- Thank you received: 0
-
-

12 years 2 weeks ago [\#177430](#177430) by [support](/forum/user/34775-support "View support's Profile")  *[Error message AUP](/forum/27-checkout/872664-error-message-aup#177430 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.5 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : Chrome, Firefox, Safari -- Error-message(debug-mod must be tuned on) -- : When paying for an item using AlphaUser points  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 '' at line 1 SQL=SELECT points FROM k5h&#95;alpha&#95;userpoints where userid=  I get this error page when I try using AlphaUser Points to pay for an item.  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 '' at line 1 SQL=SELECT points FROM k5h&#95;alpha&#95;userpoints where userid=")* was created by *[support](/forum/user/34775-support "View support's Profile")*

-- HikaShop version -- : 2.3.4
-- Joomla version -- : 3.3.5
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : Chrome, Firefox, Safari
-- Error-message(debug-mod must be tuned on) -- : When paying for an item using AlphaUser points

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 '' at line 1 SQL=SELECT points FROM k5h_alpha_userpoints where userid=

I get this error page when I try using AlphaUser Points to pay for an item.

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 '' at line 1 SQL=SELECT points FROM k5h_alpha_userpoints where userid=

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MjY2NC1lcnJvci1tZXNzYWdlLWF1cD90bXBsPW1hcmtkb3du) 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
-
-

12 years 2 weeks ago [\#177433](#177433) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error message AUP](/forum/27-checkout/872664-error-message-aup#177433 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.5 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : Chrome, Firefox, Safari -- Error-message(debug-mod must be tuned on) -- : When paying for an item using AlphaUser points  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 '' at line 1 SQL=SELECT points FROM k5h&#95;alpha&#95;userpoints where userid=  I get this error page when I try using AlphaUser Points to pay for an item.  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 '' at line 1 SQL=SELECT points FROM k5h&#95;alpha&#95;userpoints where userid=")*

Hi,

It seems that you're trying to use the AlphaUserPoints plugin provided by TechJoomla.
Please deactivate it and instead use the HikaShop user points payment plugin which is installed by default with HikaShop.
It should hopefully work better.

The following user(s) said Thank You: [support](/forum/user/34775-support "View support's Profile")

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

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

Less More

- Posts: 3
- Thank you received: 0
-
-

12 years 2 weeks ago [\#177557](#177557) by [support](/forum/user/34775-support "View support's Profile")  Replied by *[support](/forum/user/34775-support "View support's Profile")* on topic *[Error message AUP](/forum/27-checkout/872664-error-message-aup#177557 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.5 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : Chrome, Firefox, Safari -- Error-message(debug-mod must be tuned on) -- : When paying for an item using AlphaUser points  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 '' at line 1 SQL=SELECT points FROM k5h&#95;alpha&#95;userpoints where userid=  I get this error page when I try using AlphaUser Points to pay for an item.  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 '' at line 1 SQL=SELECT points FROM k5h&#95;alpha&#95;userpoints where userid=")*

I can't seem to find anywhere a HikaShop user points plugin, is that what it's called?
AUP uses the Hikashop Common Joomla Payment API integration.

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

- **[Jerome](/forum/user/80-jerome "View Jerome's Profile")**
- [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile")
- [ Offline](/forum/user/80-jerome)
- HikaShop core developer

Less More

- Posts: 26401
- Thank you received: 4080
-
- [](http://obsi.dev)
-

12 years 2 weeks ago [\#177558](#177558) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Error message AUP](/forum/27-checkout/872664-error-message-aup#177558 "-- HikaShop version -- : 2.3.4 -- Joomla version -- : 3.3.5 -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : Chrome, Firefox, Safari -- Error-message(debug-mod must be tuned on) -- : When paying for an item using AlphaUser points  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 '' at line 1 SQL=SELECT points FROM k5h&#95;alpha&#95;userpoints where userid=  I get this error page when I try using AlphaUser Points to pay for an item.  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 '' at line 1 SQL=SELECT points FROM k5h&#95;alpha&#95;userpoints where userid=")*

Hi,

You can see the documentation page:
[ www.hikashop.com/support/support/documen...57-using-points.html](https://www.hikashop.com/support/support/documentation/257-using-points.html)

The plugins "user points" (the hikashop and the hikashoppayment) are include in the commercial editions of HikaShop (essential and business) ; like the older (and deprecated) plugin "HikaShop AlphaUserPoints".

Regards,

---

Jerome - Obsidev.com
HikaMarket &amp; HikaSerial developer / HikaShop core dev team.

The following user(s) said Thank You: [support](/forum/user/34775-support "View support's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg3MjY2NC1lcnJvci1tZXNzYWdlLWF1cD90bXBsPW1hcmtkb3du) 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.050 seconds

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