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

#   Edit Variants The access to this page is forbidden

##

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

Less More

- Posts: 57
- Thank you received: 1
-
-

11 years 9 months ago [\#190063](#190063) by [888](/forum/user/32855-888 "View 888's Profile")  *[Edit Variants The access to this page is forbidden](/forum/22-market-bug-report/874859-edit-variants-the-access-to-this-page-is-forbidden#190063 "-- HikaShop version -- : 2.3.5 -- HikaMarket version -- : 1.5.1 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.14-1  Hi Edit Variants on front end i get: The access to this page is forbidden in admin, default store access checkbox value is on")* was created by *[888](/forum/user/32855-888 "View 888's Profile")*

-- HikaShop version -- : 2.3.5
-- HikaMarket version -- : 1.5.1
-- Joomla version -- : 3.3.6
-- PHP version -- : 5.5.14-1

Hi
Edit Variants on front end i get: The access to this page is forbidden
in admin, default store access checkbox value is on

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

11 years 9 months ago [\#190067](#190067) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Edit Variants The access to this page is forbidden](/forum/22-market-bug-report/874859-edit-variants-the-access-to-this-page-is-forbidden#190067 "-- HikaShop version -- : 2.3.5 -- HikaMarket version -- : 1.5.1 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.14-1  Hi Edit Variants on front end i get: The access to this page is forbidden in admin, default store access checkbox value is on")*

Hi,

Would it be possible to have more details about the issue ?
So I will be able to reproduce your configuration and reproduce the issue in my local website.

Thanks

---

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

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

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

Less More

- Posts: 57
- Thank you received: 1
-
-

11 years 9 months ago [\#190074](#190074) by [888](/forum/user/32855-888 "View 888's Profile")  Replied by *[888](/forum/user/32855-888 "View 888's Profile")* on topic *[Edit Variants The access to this page is forbidden](/forum/22-market-bug-report/874859-edit-variants-the-access-to-this-page-is-forbidden#190074 "-- HikaShop version -- : 2.3.5 -- HikaMarket version -- : 1.5.1 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.14-1  Hi Edit Variants on front end i get: The access to this page is forbidden in admin, default store access checkbox value is on")*

Same bug is on your demo site : [ demo.hikashop.com/index.php/en/hikamarke...product/edit/cid-127](http://demo.hikashop.com/index.php/en/hikamarket/vendor-control-panel/product/edit/cid-127)
test add Characteristic on Product in demo site and add and edit Variants you get Error The access to this page is forbidden

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

11 years 9 months ago [\#190080](#190080) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Edit Variants The access to this page is forbidden](/forum/22-market-bug-report/874859-edit-variants-the-access-to-this-page-is-forbidden#190080 "-- HikaShop version -- : 2.3.5 -- HikaMarket version -- : 1.5.1 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.14-1  Hi Edit Variants on front end i get: The access to this page is forbidden in admin, default store access checkbox value is on")*

Hi,

Please provide a full explanation.
The link you gave does not point to an existing product ; so I don't know if there is a bug or if the demo website has been reset.
I'm not able to understand your process or reproduce it.

Regards,

---

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

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

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

Less More

- Posts: 57
- Thank you received: 1
-
-

11 years 9 months ago [\#190107](#190107) by [888](/forum/user/32855-888 "View 888's Profile")  Replied by *[888](/forum/user/32855-888 "View 888's Profile")* on topic *[Edit Variants The access to this page is forbidden](/forum/22-market-bug-report/874859-edit-variants-the-access-to-this-page-is-forbidden#190107 "-- HikaShop version -- : 2.3.5 -- HikaMarket version -- : 1.5.1 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.14-1  Hi Edit Variants on front end i get: The access to this page is forbidden in admin, default store access checkbox value is on")*

1. in front end login as vendor I start to go to vendor-control-panel and hit Characteristics - new name test ADD VALUE 1 ADD VALUE 2 ADD VALUE 3 save.
2. go to product - &gt; new and make one name it test_Characteristics add the new Characteristics - test save
3. open product test_Characteristics hit Variants add Variants name 1 add Variants name 2 add Variants name 3 save
4. hit edit (pencils) get Error The access to this page is forbidden

- [ ![test1.jpg](/forum/attachment/22281) ](/forum/attachment/22281 "test1.jpg") [ ](/forum/attachment/22281?download=1 "test1.jpg")
- [ ![test2.jpg](/forum/attachment/22282) ](/forum/attachment/22282 "test2.jpg") [ ](/forum/attachment/22282?download=1 "test2.jpg")
- [ ![test3.jpg](/forum/attachment/22283) ](/forum/attachment/22283 "test3.jpg") [ ](/forum/attachment/22283?download=1 "test3.jpg")

The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile")

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

11 years 9 months ago -  11 years 9 months ago [\#190120](#190120) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Edit Variants The access to this page is forbidden](/forum/22-market-bug-report/874859-edit-variants-the-access-to-this-page-is-forbidden#190120 "-- HikaShop version -- : 2.3.5 -- HikaMarket version -- : 1.5.1 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.14-1  Hi Edit Variants on front end i get: The access to this page is forbidden in admin, default store access checkbox value is on")*

Hi,

Thanks, I finally got it.

It is something I already fix for HikaMarket 1.6.0 so that's why I couldn't reproduce it in my local websites.
You have to edit the file "administrator/components/com_hikamarket/helpers/helper.php" and replace the line Code:

$query = 'SELECT count(a.product_id) FROM ' . hikamarket::table('shop.product') . ' AS a WHERE a.product_id = '. (int)$product_id . ' AND a.product_vendor_id = ' . (int)$vendor_id;

By Code:

$query = 'SELECT count(pr.product_id) '. ' FROM ' . hikamarket::table('shop.product') . ' AS pr '. ' LEFT JOIN ' . hikamarket::table('shop.product') . ' AS pa ON (pr.product_type = ' . $db-&gt;Quote('variant') . ' AND pa.product_id = pr.product_parent_id) '. ' WHERE pr.product_id = '. (int)$product_id . ' AND (pr.product_vendor_id = ' . (int)$vendor_id . ' OR (pr.product_vendor_id = 0 AND pa.product_vendor_id = ' . (int)$vendor_id . '))';

and it will fix the issue.

Regards,

---

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

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

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

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

Less More

- Posts: 57
- Thank you received: 1
-
-

11 years 9 months ago [\#190121](#190121) by [888](/forum/user/32855-888 "View 888's Profile")  Replied by *[888](/forum/user/32855-888 "View 888's Profile")* on topic *[Edit Variants The access to this page is forbidden](/forum/22-market-bug-report/874859-edit-variants-the-access-to-this-page-is-forbidden#190121 "-- HikaShop version -- : 2.3.5 -- HikaMarket version -- : 1.5.1 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.14-1  Hi Edit Variants on front end i get: The access to this page is forbidden in admin, default store access checkbox value is on")*

is HikaMarket 1.6.0 out ?

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

11 years 9 months ago [\#190122](#190122) by [Jerome](/forum/user/80-jerome "View Jerome's Profile")  Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Edit Variants The access to this page is forbidden](/forum/22-market-bug-report/874859-edit-variants-the-access-to-this-page-is-forbidden#190122 "-- HikaShop version -- : 2.3.5 -- HikaMarket version -- : 1.5.1 -- Joomla version -- : 3.3.6 -- PHP version -- : 5.5.14-1  Hi Edit Variants on front end i get: The access to this page is forbidden in admin, default store access checkbox value is on")*

Hi,

Not yet ; I'm still working on it (but the release is close).

Regards,

---

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

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

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