Hikashop doesn't show in Components drop-down menu

  • Posts: 5
  • Thank you received: 0
12 years 10 months ago #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 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 or Create an account to join the conversation.

  • Posts: 82683
  • Thank you received: 13337
  • MODERATOR
12 years 10 months ago #31478

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
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 or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
12 years 10 months ago #31548

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 or Create an account to join the conversation.

  • Posts: 82683
  • Thank you received: 13337
  • MODERATOR
12 years 10 months ago #31573

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

Please Log in or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
12 years 10 months ago #31622

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 or Create an account to join the conversation.

  • Posts: 2293
  • Thank you received: 315
12 years 10 months ago #31623

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


Я не явлюсь официальной службой поддержки!
Я здесь добровольно!

Хочешь получить купон на скидку Hikashop? Спроси меня как!
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
12 years 10 months ago #31627

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



I went back and looked, and my prefix is actually "jos" instead of some random numbers. Here are some screen shots of my phpmyadmin...

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 5
  • Thank you received: 0
12 years 10 months ago #31628

and here is what is displayed when I click on my database table on the left...

Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 82683
  • Thank you received: 13337
  • MODERATOR
12 years 10 months ago #31649

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 or Create an account to join the conversation.

Time to create page: 0.082 seconds
Powered by Kunena Forum