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

#   Problem with "Pay" the Vendors

##

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

Less More

- Posts: 58
- Thank you received: 2
-
-

8 years 11 months ago [\#283010](#283010) by [woidl](/forum/user/39777-woidl "View woidl's Profile")  *[Problem with "Pay" the Vendors](/forum/22-market-bug-report/892877-problem-with-pay-the-vendors#283010 "-- HikaShop version -- : 3.2.1 -- HikaMarket version -- : 2.0.0 -- Joomla version -- : 3.8.2 -- PHP version -- : 7  Hi  when I try to PAY my vendors in Hikamarket (selcting a vendor, then selecting the orders, Manual method) I always get this error:  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 '= 'vendor&#95;payment&#95;notification' LIMIT 0, 1' at line 1  The vendor payment notofication settings are on: MARKET&#95;VENDOR&#95;PAYMENT&#95;NOTIFICATION : active vendor&#95;payment&#95;notification: active in Market settings  What is causing this problem? thanks")* was created by *[woidl](/forum/user/39777-woidl "View woidl's Profile")*

-- HikaShop version -- : 3.2.1
-- HikaMarket version -- : 2.0.0
-- Joomla version -- : 3.8.2
-- PHP version -- : 7

Hi

when I try to PAY my vendors in Hikamarket (selcting a vendor, then selecting the orders, Manual method)
I always get this error:

*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 '= 'vendor\_payment\_notification' LIMIT 0, 1' at line 1*

The vendor payment notofication settings are on:
MARKET_VENDOR_PAYMENT_NOTIFICATION : active
vendor_payment_notification: active in Market settings

What is causing this problem?
thanks

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5Mjg3Ny1wcm9ibGVtLXdpdGgtcGF5LXRoZS12ZW5kb3JzP3RtcGw9bWFya2Rvd24=) 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: 4081
-
- [](http://obsi.dev)
-

8 years 11 months ago [\#283012](#283012) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Problem with "Pay" the Vendors](/forum/22-market-bug-report/892877-problem-with-pay-the-vendors#283012 "-- HikaShop version -- : 3.2.1 -- HikaMarket version -- : 2.0.0 -- Joomla version -- : 3.8.2 -- PHP version -- : 7  Hi  when I try to PAY my vendors in Hikamarket (selcting a vendor, then selecting the orders, Manual method) I always get this error:  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 '= 'vendor&#95;payment&#95;notification' LIMIT 0, 1' at line 1  The vendor payment notofication settings are on: MARKET&#95;VENDOR&#95;PAYMENT&#95;NOTIFICATION : active vendor&#95;payment&#95;notification: active in Market settings  What is causing this problem? thanks")*

Hello,

Please re-download HikaMarket 2.0.0 in order to get the fix.

Regards,

---

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

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

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

Less More

- Posts: 58
- Thank you received: 2
-
-

8 years 11 months ago -  8 years 11 months ago [\#283130](#283130) by [woidl](/forum/user/39777-woidl "View woidl's Profile")  Replied by *[woidl](/forum/user/39777-woidl "View woidl's Profile")* on topic *[Problem with "Pay" the Vendors](/forum/22-market-bug-report/892877-problem-with-pay-the-vendors#283130 "-- HikaShop version -- : 3.2.1 -- HikaMarket version -- : 2.0.0 -- Joomla version -- : 3.8.2 -- PHP version -- : 7  Hi  when I try to PAY my vendors in Hikamarket (selcting a vendor, then selecting the orders, Manual method) I always get this error:  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 '= 'vendor&#95;payment&#95;notification' LIMIT 0, 1' at line 1  The vendor payment notofication settings are on: MARKET&#95;VENDOR&#95;PAYMENT&#95;NOTIFICATION : active vendor&#95;payment&#95;notification: active in Market settings  What is causing this problem? thanks")*

Hi,

**Installation**

installing 2.0.0 did not work without error - error message of Joomla:
WARNING: Duplicate entry '1-1-Vendors-*' for key 'idx_client_id_parent_id_alias_language'

Then I did it again and it worked, no error message anymore.

Did the installation a third time:
WARNING: Duplicate entry '1-1-Vendors-*' for key 'idx_client_id_parent_id_alias_language'

**Using Pay function**

I can do the "Pay", send an "You have been paid" Email with the correct amount to the correct vendor. So far so good.
But the email has errors, one in the head of the mail one in the content.
Please see screenshot
Code:

Warning: Creating default object from empty value in /media/com_hikamarket/mail/vendor_payment_notification.preload.php on line 41 Warning: Invalid argument supplied for foreach() in media/com_hikamarket/mail/vendor_payment_notification.preload.php on line 106 Warning: Invalid argument supplied for foreach() in media/com_hikamarket/mail/vendor_payment_notification.preload.php on line 116

Code:

Warning: Creating default object from empty value in /media/com_hikamarket/mail/vendor_payment_notification.preload.php on line 41 Warning: Invalid argument supplied for foreach() in /media/com_hikamarket/mail/vendor_payment_notification.preload.php on line 106 Warning: Invalid argument supplied for foreach() in /media/com_hikamarket/mail/vendor_payment_notification.preload.php on line 116

thanks for help

- [ ![You-have-been-paid.jpg](/forum/attachment/41463) ](/forum/attachment/41463 "...-been-paid.jpg") [ ](/forum/attachment/41463?download=1 "...-been-paid.jpg")

Last edit: 8 years 11 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile"). Reason: removing private stuff

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzIyLW1hcmtldC1idWctcmVwb3J0Lzg5Mjg3Ny1wcm9ibGVtLXdpdGgtcGF5LXRoZS12ZW5kb3JzP3RtcGw9bWFya2Rvd24=) 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: 4081
-
- [](http://obsi.dev)
-

8 years 11 months ago [\#283146](#283146) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Problem with "Pay" the Vendors](/forum/22-market-bug-report/892877-problem-with-pay-the-vendors#283146 "-- HikaShop version -- : 3.2.1 -- HikaMarket version -- : 2.0.0 -- Joomla version -- : 3.8.2 -- PHP version -- : 7  Hi  when I try to PAY my vendors in Hikamarket (selcting a vendor, then selecting the orders, Manual method) I always get this error:  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 '= 'vendor&#95;payment&#95;notification' LIMIT 0, 1' at line 1  The vendor payment notofication settings are on: MARKET&#95;VENDOR&#95;PAYMENT&#95;NOTIFICATION : active vendor&#95;payment&#95;notification: active in Market settings  What is causing this problem? thanks")*

Hello,

The error regarding the duplicate entry is not related to HikaMarket directly (Because I do not have any mention of "idx" in HikaMarket.) but it might be related to the Joomla installation system ; and I think it's regarding the menus (which should be added via the install XML).
I'll have a look and try to reproduce it in a local website.

Regarding the vendor pay ; please re-download HikaMarket 2.0.0 in order to get a patch to improve the data in the object passed in the function which generate the email.

Regards,

---

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

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

Moderators: [Obsidev](/forum/user/7040-obsidev "View Obsidev's Profile")

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

Time to create page: 0.049 seconds

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