SQL error installation

-- HikaShop version -- : essential 2.2.0
-- Joomla version -- : 3.1.4
-- PHP version -- :5.3.3-22.el6
-- Browser(s) name and version -- : chrome 28.0.1500.72 m
-- Error-message(debug-mod must be tuned on) -- : 0 SQL=SELECT * FROM jos_hikashop_config

When I try to install this extension I get this message and no tables are made in the database. Why is this happening and how can I prevent this?

Hi,
We'll need more information about the error that you are having, also following the " installation documentation " will probably help you.

What information do you want? The only thing I can tell you that I followed the installation procedure from your documents, tried the extension manager and ftp, and after uploading this is what I get, So I already followed the installation guide.

Hi,

This error means that joomla was not able to insert the tables of HikaShop in the database and thus the configuration table is not accessible for HikaShop to insert the default settings in it.

So I invite you to try two things:

1. Rename the folders administrator/components/com_hikashop and components/com_hikashop via FTP and do an install again.

2. If that still doesn't help, extract the install package on your local computer and open the file back/tables.sql with a text editor. Then, change the #__ table prefix to your website table prefix and import the sql file in your database via PHPMyAdmin. That will add all the HikaShop tables in the database. Then, run the install of HikaShop again and you won't get that error.

Thx! Option 2 worked. thought already that this was the solution was but I couldn't find the tables.

Hi,

We finished the installation, but we can not find the HikaShop dashboard at the control panel of Joomla. The dashboard does work via a link, but it can not be found in the menu. How can we fix this problem?

Hi,

The dashboard of HikaShop is reachable via the menu Component > HikaShop, it will redirect to the HikaShop DashBoard.

That is the problem, there is no HikaShop in our component menu.

Printscreen: img208.imageshack.us/img208/664/o2tp.jpg

Hi,

Thanks to check in the table #__extensions if you have the hikashop entry. (via phpMyAdmin)

Hi,

We do have de hikashop entry.

Hi,

I don't know if your have the rights to insert data in the joomla database. But it seems that HikaShop is not in the #__menu table.
By reinstalling HikaShop, the menu should be re-create but you have to be sure that you have to right to insert elements in the #__menu table.

It looks like you had some database troubles looking at the different errors you had.

Regards,

The only trouble we have is with the installation of hikashop. Other components and plugins install fine. The Hikashop entry is present in the table #__menu. If I add 'index.php?option=com_hikashop' to the link of the admin the hikashop opens. And this is the same link which is present in the database. It seems that somewhere between database and the config of joomla component menu is something missing.

Reinstall is not an option because of the products already in the database. Oh and I have all rights to the database.

Just to mention that i am having the same issues that F4P is having

Wouldnt install straight from the zip had to upload to FTP
Then had to edit the tables.sql (However this still didnt work)
Manually added the tables to the database to get install to work.

After install there is no Hikka Shop in the component Menu J3.1.5

Edit: Rather than reinstall i just installed it again (Over the top) from Extension Manager, this then populated the Components list and kept all my settings including added products.

Edit2: However it seems still pretty broken alot of other items dont seem to function correctly and im constantly getting sql errors, mostly because there is no data there, Things like adding registerd users payment methods etc

Hi,

Regarding the HikaShop menu missing, that's something which happens when you have an issue with the menu/asset tables.
As explained here www.akeebabackup.com/support/akeeba-back...in-menus.html#p51024 you can edit the table _extensions and _menus of joomla in the database, clean the hikashop entries and do an install again on top to put back the data of the menu properly. Please make sure that you do a backup before doing that, in case you do something wrong.
Alternatively, if you don't mind missing the menu, you can use instead a joomla dashboard module to display the HikaShop menus:
www.hikashop.com/support/documentation/9...oomla-dashboard.html

@Smoosher what kind of SQL errors ? If it's columns missing in the database (you can see the SQL error if you turn on the debug mode of the joomla configuration), I invite you to check that to add the columns you're missing:
www.hikashop.com/support/documentation/6...lity-issues.html#SQL

nicolas wrote: Alternatively, if you don't mind missing the menu, you can use instead a joomla dashboard module to display the HikaShop menus:
www.hikashop.com/support/documentation/9...oomla-dashboard.html

Is this one compatible with joomla 3.1.5? I get the following error: JInstaller: :Install: Cannot find Joomla XML setup file

Hi,

There is maybe some changes to do in the XML file.
Thanks to try with the following plugin:

It does work know. Thanks!