Hikashop doesn't show in Components drop-down menu

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

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.

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.

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

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

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

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...

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

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.