[Skip to main content](#vessel-content) # Hikashop doesn't show in Components drop-down menu ## - **[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")** - [![z_penn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4859-z-penn "View z_penn's Profile") Topic Author - [ Offline](/forum/user/4859-z-penn) Less More - Posts: 5 - Thank you received: 0 - - 14 years 11 months ago [\#31457](#31457) by [z\_penn](/forum/user/4859-z-penn "View z_penn's Profile") *[Hikashop doesn't show in Components drop-down menu](/forum/4-how-to/31457-hikashop-doesnt-show-in-components-drop-down-menu#31457 "I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything...")* was created by *[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")* I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything was successfully installed, but I can not find the Hikashop configuration area in my drop-down menu for Components. Should I un-install and try again, or is there something simple I am overlooking? Thanks Zac Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNDU3LWhpa2FzaG9wLWRvZXNudC1zaG93LWluLWNvbXBvbmVudHMtZHJvcC1kb3duLW1lbnU/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 11 months ago [\#31478](#31478) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Hikashop doesn't show in Components drop-down menu](/forum/4-how-to/31457-hikashop-doesnt-show-in-components-drop-down-menu#31478 "I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything...")* That something which can happen in some rare cases since joomla 1.6 when you install components. Here is another developer who posted the solution: [ forum.joomla.org/viewtopic.php?p=2415214#p2415214](http://forum.joomla.org/viewtopic.php?p=2415214#p2415214) For the query to run in your phpmyadmin, it should be > UPDATE `jos\_menu` > SET `published` = '1', > `component\_id` = ( SELECT extension\_id > FROM `jos\_extensions` > WHERE element = 'com\_hikashop' ) > WHERE `title` LIKE '%hikashop%'; Also don't forget to change the jos_ prefix to the prefix you're using for your tables. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNDU3LWhpa2FzaG9wLWRvZXNudC1zaG93LWluLWNvbXBvbmVudHMtZHJvcC1kb3duLW1lbnU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")** - [![z_penn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4859-z-penn "View z_penn's Profile") Topic Author - [ Offline](/forum/user/4859-z-penn) Less More - Posts: 5 - Thank you received: 0 - - 14 years 11 months ago [\#31548](#31548) by [z\_penn](/forum/user/4859-z-penn "View z_penn's Profile") Replied by *[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")* on topic *[Re: Hikashop doesn't show in Components drop-down menu](/forum/4-how-to/31457-hikashop-doesnt-show-in-components-drop-down-menu#31548 "I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything...")* Thanks for the reply, but I don't know how to run a sql query. Is there a way you can give me a dummies instruction list on how to do that? I know how to access phpmyadmin but I wouldn't know where to go from there. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNDU3LWhpa2FzaG9wLWRvZXNudC1zaG93LWluLWNvbXBvbmVudHMtZHJvcC1kb3duLW1lbnU/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 11 months ago [\#31573](#31573) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Hikashop doesn't show in Components drop-down menu](/forum/4-how-to/31457-hikashop-doesnt-show-in-components-drop-down-menu#31573 "I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything...")* It's, simple, just select your database and click on the SQL tab at the top. Then, you will be able to enter your query. Here is a some tutorial on PHPMyAdmin: [ www.reg.ca/faq/PhpMyAdminTutorial.html](http://www.reg.ca/faq/PhpMyAdminTutorial.html) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNDU3LWhpa2FzaG9wLWRvZXNudC1zaG93LWluLWNvbXBvbmVudHMtZHJvcC1kb3duLW1lbnU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")** - [![z_penn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4859-z-penn "View z_penn's Profile") Topic Author - [ Offline](/forum/user/4859-z-penn) Less More - Posts: 5 - Thank you received: 0 - - 14 years 10 months ago [\#31622](#31622) by [z\_penn](/forum/user/4859-z-penn "View z_penn's Profile") Replied by *[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")* on topic *[Re: Hikashop doesn't show in Components drop-down menu](/forum/4-how-to/31457-hikashop-doesnt-show-in-components-drop-down-menu#31622 "I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything...")* I did what you said and the Query returned back this result.... Affected rows: 0 (Query took 0.0008 sec) SQL query: UPDATE `jos_menu` SET `published` = '1', `component_id` = ( SELECT extension_id FROM `jos_extensions` WHERE element = 'com_hikashop' ) WHERE `title` LIKE '%hikashop%'; After the query I went to the back-end of the website and everything looks the same. I still can't see the Hikashop link. I have the dashboard Bookmarked so I can still access everything, but I would like to have the link as well. I don't think I have a prefix before my jos_menu table, unless you are referring to my database name? Thanks for helping Nicolas, Zac Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNDU3LWhpa2FzaG9wLWRvZXNudC1zaG93LWluLWNvbXBvbmVudHMtZHJvcC1kb3duLW1lbnU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[progreccor](/forum/user/4816-progreccor "View progreccor's Profile")** - [![progreccor's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4816.jpg)](/forum/user/4816-progreccor "View progreccor's Profile") - [ Offline](/forum/user/4816-progreccor "Москва") - SEO, webdesign Less More - Posts: 2293 - Thank you received: 314 - - - - [](http://www.d-dd.ru) - 14 years 10 months ago [\#31623](#31623) by [progreccor](/forum/user/4816-progreccor "View progreccor's Profile") Replied by *[progreccor](/forum/user/4816-progreccor "View progreccor's Profile")* on topic *[Re: Hikashop doesn't show in Components drop-down menu](/forum/4-how-to/31457-hikashop-doesnt-show-in-components-drop-down-menu#31623 "I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything...")* your sql query is wrong. in joomla 1.7 there is random prefix before any table. you can see it in your phpmyadmin like this: and so see your prefix and replace "jos_" in your query on your in to your prefix image missing http://www.hikashop.com/media/kunena/attachments/legacy/images/1-20111203.jpg --- Я не явлюсь официальной службой поддержки! Я здесь добровольно! Хочешь получить купон на скидку Hikashop? Спроси меня как! - [ ![1-20111203.jpg](/forum/attachment/2174) ](/forum/attachment/2174 "1-20111203.jpg") [ ](/forum/attachment/2174?download=1 "1-20111203.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNDU3LWhpa2FzaG9wLWRvZXNudC1zaG93LWluLWNvbXBvbmVudHMtZHJvcC1kb3duLW1lbnU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")** - [![z_penn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4859-z-penn "View z_penn's Profile") Topic Author - [ Offline](/forum/user/4859-z-penn) Less More - Posts: 5 - Thank you received: 0 - - 14 years 10 months ago [\#31627](#31627) by [z\_penn](/forum/user/4859-z-penn "View z_penn's Profile") Replied by *[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")* on topic *[Re: Hikashop doesn't show in Components drop-down menu](/forum/4-how-to/31457-hikashop-doesnt-show-in-components-drop-down-menu#31627 "I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything...")* **progreccor wrote:** > your sql query is wrong. > in joomla 1.7 there is random prefix before any table. > you can see it in your phpmyadmin like this: > > and so see your prefix and replace "jos\_" in your query on your in to your prefix image missing http://www.hikashop.com/media/kunena/attachments/legacy/images/1-20111203.jpg I went back and looked, and my prefix is actually "jos" instead of some random numbers. Here are some screen shots of my phpmyadmin... image missing http://www.hikashop.com/media/kunena/attachments/legacy/images/phpmyadmin_frontpage.PNG - [ ![phpmyadmin_frontpage.PNG](/forum/attachment/2176) ](/forum/attachment/2176 "..._frontpage.PNG") [ ](/forum/attachment/2176?download=1 "..._frontpage.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNDU3LWhpa2FzaG9wLWRvZXNudC1zaG93LWluLWNvbXBvbmVudHMtZHJvcC1kb3duLW1lbnU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")** - [![z_penn's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4859-z-penn "View z_penn's Profile") Topic Author - [ Offline](/forum/user/4859-z-penn) Less More - Posts: 5 - Thank you received: 0 - - 14 years 10 months ago [\#31628](#31628) by [z\_penn](/forum/user/4859-z-penn "View z_penn's Profile") Replied by *[z\_penn](/forum/user/4859-z-penn "View z_penn's Profile")* on topic *[Re: Hikashop doesn't show in Components drop-down menu](/forum/4-how-to/31457-hikashop-doesnt-show-in-components-drop-down-menu#31628 "I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything...")* and here is what is displayed when I click on my database table on the left... image missing http://www.hikashop.com/media/kunena/attachments/legacy/images/phpmyadmin_dwk_tables.PNG - [ ![phpmyadmin_dwk_tables.PNG](/forum/attachment/2177) ](/forum/attachment/2177 "...dwk_tables.PNG") [ ](/forum/attachment/2177?download=1 "...dwk_tables.PNG") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNDU3LWhpa2FzaG9wLWRvZXNudC1zaG93LWluLWNvbXBvbmVudHMtZHJvcC1kb3duLW1lbnU/dG1wbD1tYXJrZG93bg==) 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") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14279 - - 14 years 10 months ago [\#31649](#31649) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Hikashop doesn't show in Components drop-down menu](/forum/4-how-to/31457-hikashop-doesnt-show-in-components-drop-down-menu#31649 "I am using Joomla 1.7.3 and I just downloaded the Hikashop Starter component. I used the FTP install method and followed the instructions. After Joomla installed the component, it said everything...")* Please open the jos_menu table make a backup of it with the export tool. Then, look for any hikashop related menu and delete them. Then, reinstall HikaShop and you should have the menu. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQtaG93LXRvLzMxNDU3LWhpa2FzaG9wLWRvZXNudC1zaG93LWluLWNvbXBvbmVudHMtZHJvcC1kb3duLW1lbnU/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.527 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)