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

#   jos\_hikamarket\_category' doesn't exist

##

- **[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")**
- [![trevsmiff's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar9214.jpg)](/forum/user/9214-trevsmiff "View trevsmiff's Profile") Topic Author
- [ Offline](/forum/user/9214-trevsmiff)

Less More

- Posts: 306
- Thank you received: 42
-
-

13 years 2 months ago -  13 years 2 months ago [\#122661](#122661) by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")  *[jos\_hikamarket\_category' doesn't exist](/forum/22-market-bug-report/861843-jos-hikamarket-category-doesnt-exist#122661 "-- HikaMarket -- : 1.3.0&#95;2013-09-01 -- HikaShop version -- : 2.2.1 Business -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.13 -- Browser(s) name and version -- : Firefox 23.0.1 -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  If there is a discount set for a product category then when selecting Discounts from the Hikamarket vendors control panel I get the following error: Error: 1146 - Table 'trevnali&#95;jmo3kz2sbp.jos&#95;hikamarket&#95;category' doesn't exist SQL=SELECT &#42; FROM jos&#95;hikamarket&#95;category WHERE category&#95;id IN (21) If I set the discount by product it workks OK.  Regards Trevor")* was created by *[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")*

-- HikaMarket -- : 1.3.0_2013-09-01
-- HikaShop version -- : 2.2.1 Business
-- Joomla version -- : 3.1.5
-- PHP version -- : 5.3.13
-- Browser(s) name and version -- : Firefox 23.0.1
-- Error-message(debug-mod must be tuned on) -- : Error_message

If there is a discount set for a product category then when selecting Discounts from the Hikamarket vendors control panel I get the following error:
*Error: 1146 - Table 'trevnali\_jmo3kz2sbp.jos\_hikamarket\_category' doesn't exist SQL=SELECT \* FROM jos\_hikamarket\_category WHERE category\_id IN (21)*
If I set the discount by product it workks OK.

Regards
Trevor

Last edit: 13 years 2 months ago by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile"). Reason: HikaMarket version added

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

13 years 2 months ago [\#122667](#122667) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[jos\_hikamarket\_category' doesn't exist](/forum/22-market-bug-report/861843-jos-hikamarket-category-doesnt-exist#122667 "-- HikaMarket -- : 1.3.0&#95;2013-09-01 -- HikaShop version -- : 2.2.1 Business -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.13 -- Browser(s) name and version -- : Firefox 23.0.1 -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  If there is a discount set for a product category then when selecting Discounts from the Hikamarket vendors control panel I get the following error: Error: 1146 - Table 'trevnali&#95;jmo3kz2sbp.jos&#95;hikamarket&#95;category' doesn't exist SQL=SELECT &#42; FROM jos&#95;hikamarket&#95;category WHERE category&#95;id IN (21) If I set the discount by product it workks OK.  Regards Trevor")*

Hi,

Yes, I made a fix three days ago but I can't create a new package for the moment, I have too untested features.
You can edit the file "components/com_hikamarket/discountmarket/view.html.php" and replace Code:

hikamarket::table('category')

By Code:

hikamarket::table('shop.category')

Regards,

---

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

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

- **[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")**
- [![trevsmiff's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar9214.jpg)](/forum/user/9214-trevsmiff "View trevsmiff's Profile") Topic Author
- [ Offline](/forum/user/9214-trevsmiff)

Less More

- Posts: 306
- Thank you received: 42
-
-

13 years 2 months ago [\#122698](#122698) by [trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")  Replied by *[trevsmiff](/forum/user/9214-trevsmiff "View trevsmiff's Profile")* on topic *[jos\_hikamarket\_category' doesn't exist](/forum/22-market-bug-report/861843-jos-hikamarket-category-doesnt-exist#122698 "-- HikaMarket -- : 1.3.0&#95;2013-09-01 -- HikaShop version -- : 2.2.1 Business -- Joomla version -- : 3.1.5 -- PHP version -- : 5.3.13 -- Browser(s) name and version -- : Firefox 23.0.1 -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  If there is a discount set for a product category then when selecting Discounts from the Hikamarket vendors control panel I get the following error: Error: 1146 - Table 'trevnali&#95;jmo3kz2sbp.jos&#95;hikamarket&#95;category' doesn't exist SQL=SELECT &#42; FROM jos&#95;hikamarket&#95;category WHERE category&#95;id IN (21) If I set the discount by product it workks OK.  Regards Trevor")*

Thanks Jerome, it is working OK now.

Thanks
Trevor

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

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

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

Time to create page: 0.044 seconds

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