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

#   VID/UID Invalid

##

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

Less More

- Posts: 10
- Thank you received: 0
-
-

13 years 1 week ago -  13 years 1 week ago [\#128982](#128982) by [jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")  *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#128982 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")* was created by *[jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")*

[ www.secretheadquartersartstudio.com](http://www.secretheadquartersartstudio.com)
HikaShop Business: 2.2.1
Joomla 3.1.5
PHP 5.3.18
Firefox or Safari

I just now figured out how to turn on a debugger to get this error message:
633740webpage402797TrueCCSALEFalse**************10150.160.001***17Jim lastnamejimemailaddress@gmail.com Array ( [errorCode] =&gt; 4012 [errorName] =&gt; VID/UID Invalid [errorMessage] =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )

I've confirmed twice with Virtual Merchant my:
Merchant id:
User ID:
Pin:

I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.

Thank you for the assistance.

Jim

I just tried to disable the plugin and received this error message. Not sure if related or not:

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 ( 1 )' at line 1 SQL=UPDATE aaa_hikashop_plugins SET = 0 WHERE IN ( 1 )

Last edit: 13 years 1 week ago by [jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile"). Reason: Update error messages

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

- **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")**
- [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")
- [ Offline](/forum/user/6861-mohamed-thelji)

Less More

- Posts: 12953
- Thank you received: 1778
-
-
-

13 years 1 week ago [\#129016](#129016) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")  Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129016 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hi,
Can you download the last Hikashop version through our website, install it, and test it again ?

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

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

Less More

- Posts: 10
- Thank you received: 0
-
-

13 years 1 week ago [\#129020](#129020) by [jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")  Replied by *[jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129020 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hello,

Thank you for the assistance. I did download and update.

You have the latest stable version of HikaShop Business: 2.2.2

I received the same exact error message as posted previously.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2MzAxNy12aWQtdWlkLWludmFsaWQ/dG1wbD1tYXJrZG93bg==) 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: 26394
- Thank you received: 4078
-
- [](http://obsi.dev)
-

13 years 1 week ago [\#129119](#129119) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129119 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hi,

Can you check that there is no extra space in your plugin configuration for the Merchant Id and User Id ?
Your configuration seams to be in debug mode ; Does your account is a test account too ?

Regards,

---

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

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

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

Less More

- Posts: 10
- Thank you received: 0
-
-

13 years 1 week ago [\#129124](#129124) by [jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")  Replied by *[jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129124 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hello,

I was actually on the phone with virtual merchant earlier this morning and we:
1. Confirmed I had entered the correct merchant id, user id, and pin.
2. There were no spaces or extra characters.
3. The virtual merchant account is active and ready to accept orders - it's not a test account.

I have also tried creating a new virtual merchant plugin and entering the info.

The only part of the site that is in debug mode is the virtual merchant plugin. The rest of the site is in normal mode.

I have tried the cart with minimum configurations

Also, please a note a free product will go through the processes without any issue.

In the error message, it mentions an array - is there any possibility of a coding error?
Please let me know if there is anything I can do to assist.

Thanks for your help Jerome.

Jim

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2MzAxNy12aWQtdWlkLWludmFsaWQ/dG1wbD1tYXJrZG93bg==) 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: 26394
- Thank you received: 4078
-
- [](http://obsi.dev)
-

13 years 1 week ago [\#129126](#129126) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129126 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hi,

It looks like you didn't understand my last message : The debug mode in the plugin is the test mode.
So if you don't have a test account, you shouldn't use the "debug".

Regards,

---

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

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

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

Less More

- Posts: 10
- Thank you received: 0
-
-

13 years 1 week ago [\#129129](#129129) by [jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")  Replied by *[jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129129 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Ok. Thank you for the clarification.

Even with debugging mode turned off, I still get a message : Message - An error occurred.
Could SSL have anything to do with this type of an error?
I just had it setup, but it looks like they put my entire site as SSL, At least when in Firefox, all links show ssl?

Thank you for your continued assistance with this issue. It is greatly appreciated.

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

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

Less More

- Posts: 10
- Thank you received: 0
-
-

13 years 1 week ago [\#129175](#129175) by [jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")  Replied by *[jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129175 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hello,

I just installed HikaShop on one of my other domains - same hosting company - there is SSL setup for this domain. Also, the site is under development - meaning it's a pretty basic install of Joomla.

In Hika Shop - Minimal configuration - I added one product.

Same error message:

633740webpage402797TrueCCSALEFalse**************07140.100.001***3myname@debateme.com Array ( [errorCode] =&gt; 4012 [errorName] =&gt; VID/UID Invalid [errorMessage] =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )

I just checked the virtual merchant developers manual - states accepts information sent using HTTPS… Since the debateme.com domain doesn't have SSL setup - I might expect this type of error message….

I will check with hosting company to make sure there's no issues with HTTPS.

Thanks

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2MzAxNy12aWQtdWlkLWludmFsaWQ/dG1wbD1tYXJrZG93bg==) 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: 26394
- Thank you received: 4078
-
- [](http://obsi.dev)
-

13 years 1 week ago [\#129230](#129230) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129230 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hi,

It is not a SSL issue. It's a credential issue.

Debug mode =&gt; using test account credentials.
No debug mode =&gt; using production account credentials.

Regards,

---

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

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

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

Less More

- Posts: 10
- Thank you received: 0
-
-

13 years 6 days ago [\#129301](#129301) by [jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")  Replied by *[jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129301 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hello Jerome,

Thank you for your assistance.
I put the virtual merchant plugin in debug mode. The rest of the Joomla website is in normal mode.
I updated the virtual merchant plugin with the test account information I received.

Here is the error message I received:
I replaced the pin number with xxxxs since this is a public forum.
I also removed my address, but kept the replacement text in same format as error

001012webpage(xxxxxxxx)TrueCCSALEFalse**************10150.160.001***17FirstnameLastnamesetreet#+streetname+Ct.CityStateZipUnited+States+of+Americamyemailaddress@gmail.com Array ( [errorCode] =&gt; 4009 [errorName] =&gt; Required Field Not Supplied [errorMessage] =&gt; The field Name on Card (name_on_card) required but not supplied in the authorization request. )

In the cart, when I get to payments, it only asks for CC#, Expiration Data, and CVC.

Your assistance is greatly appreciated.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2MzAxNy12aWQtdWlkLWludmFsaWQ/dG1wbD1tYXJrZG93bg==) 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: 26394
- Thank you received: 4078
-
- [](http://obsi.dev)
-

13 years 5 days ago -  13 years 5 days ago [\#129435](#129435) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129435 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hi,

There is an option in the payment methods, the option is called "debug".
This option is to put the plugin in the "test mode", to use a "test account" in order to "test" the plugin.
It also have the feature to display some debugging information.

It is no more complicated than that.

So, if your account is not a test account, it is fully logical that the plugin in "debug" mode does not work and it will never work until you removed this option in the payment configuration.

Is that clear enough ?

Regards,

---

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

Last edit: 13 years 5 days ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile").

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2MzAxNy12aWQtdWlkLWludmFsaWQ/dG1wbD1tYXJrZG93bg==) 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: 26394
- Thank you received: 4078
-
- [](http://obsi.dev)
-

13 years 5 days ago [\#129577](#129577) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129577 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hi,

[ www.myvirtualmerchant.com/VirtualMerchan...d/developerGuide.pdf](https://www.myvirtualmerchant.com/VirtualMerchant/download/developerGuide.pdf)

As you can see in the official VirtualMerchant developper documentation, there is no "name_on_card" field.
Unless than virtualmerchant uses an API which is not documented, I am sorry but I won't be able to help you for this specific point.

I can't even fix a problem of a required field if that same field is not present in the official documentation.

I read several other VirtualMerchant implementation and I can't find more information.
There is a plugin made in Ruby which ask for the "name_on_card" but that variable is never used with the communication with the VirtualMerchant API.

So, unless VirtualMerchant give us more details about a required field that is not present in the documentation, I won't be able to fix the problem easily.
Passing an argument "name_on_card" to the API can be a "dirty" solution but I am not even sure that I could really fix the problem. If "name_on_card" is an unknown required field, what can say us that it is the only one ?

Regards,

---

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

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

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

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

Less More

- Posts: 10
- Thank you received: 0
-
-

13 years 4 days ago [\#129739](#129739) by [jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")  Replied by *[jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129739 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Jerome.

Thank you for your response. I'm working with a paid developer to sort this out, and received the same message from them today. I really do appreciated your assistance. I've spoken with Virtual Merchant several times, finally yesterday I received assistance from one there guys that pointed me in the right direction.

I really like Hika Shop. I love the support - Sorry to be a bother - I didn't expect it to be this difficult. But at least now I learning why. It would have been nice had Virtual Merchant mentioned something to me.

Regards

Jim

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

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

Less More

- Posts: 10
- Thank you received: 0
-
-

13 years 3 days ago [\#129741](#129741) by [jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")  Replied by *[jimmaroun](/forum/user/27858-jimmaroun "View jimmaroun's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129741 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

This issue is now resolved.

Thank you again for your assistance and patience.

Jim

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI3LWNoZWNrb3V0Lzg2MzAxNy12aWQtdWlkLWludmFsaWQ/dG1wbD1tYXJrZG93bg==) 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: 26394
- Thank you received: 4078
-
- [](http://obsi.dev)
-

13 years 3 days ago [\#129745](#129745) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[VID/UID Invalid](/forum/27-checkout/863017-vid-uid-invalid#129745 "  www.secretheadquartersartstudio.com  HikaShop Business: 2.2.1 Joomla 3.1.5 PHP 5.3.18 Firefox or Safari  I just now figured out how to turn on a debugger to get this error message: 633740webpage402797TrueCCSALEFalse&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;&#42;10150.160.001&#42;&#42;&#42;17Jim Array ( &#91;errorCode&#93; =&gt; 4012 &#91;errorName&#93; =&gt; VID/UID Invalid &#91;errorMessage&#93; =&gt; The VirtualMerchant ID and/or User ID supplied in the authorization request is invalid. )  I've confirmed twice with Virtual Merchant my: Merchant id: User ID: Pin:  I'm further than I was, at least I know what the error message is, but please advise how do I resolve this issue, or at least confirm it is not a coding or configuration issue.  Thank you for the assistance.  Jim  I just tried to disable the plugin and received this error message. Not sure if related or not:  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 ( 1 )' at line 1 SQL=UPDATE aaa&#95;hikashop&#95;plugins SET = 0 WHERE IN ( 1 )")*

Hi,

It is a good news !

I didn't think that it will be so difficult too. When I implement the virtualmerchant plugin I didn't have such problem that's why I was very surprised of this new required parameter.
If you want us to update the VirtualMerchant plugin with a fix, do not hesitate to mail us.

And sorry for the inconvenients.

Regards,

---

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

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

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

[](#top)
