SQL error installation

  • Posts: 24
  • Thank you received: 0
11 years 3 months ago #116880

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

Hikashop Essential 2.2.3
Joomla 3.2.0

www.Fair4Pets.eu

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

  • Posts: 12953
  • Thank you received: 1778
11 years 3 months ago #116897

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

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

  • Posts: 24
  • Thank you received: 0
11 years 3 months ago #116980

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.

Hikashop Essential 2.2.3
Joomla 3.2.0

www.Fair4Pets.eu

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
11 years 3 months ago #117002

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.

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

  • Posts: 24
  • Thank you received: 0
11 years 3 months ago #117079

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

Hikashop Essential 2.2.3
Joomla 3.2.0

www.Fair4Pets.eu

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

  • Posts: 24
  • Thank you received: 0
11 years 3 months ago #117871

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?

Hikashop Essential 2.2.3
Joomla 3.2.0

www.Fair4Pets.eu

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

  • Posts: 13201
  • Thank you received: 2322
11 years 3 months ago #117891

Hi,

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

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

  • Posts: 24
  • Thank you received: 0
11 years 3 months ago #117902

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

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

Hikashop Essential 2.2.3
Joomla 3.2.0

www.Fair4Pets.eu

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

  • Posts: 13201
  • Thank you received: 2322
11 years 3 months ago #117982

Hi,

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

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

  • Posts: 24
  • Thank you received: 0
11 years 3 months ago #119029

Hi,

We do have de hikashop entry.

Hikashop Essential 2.2.3
Joomla 3.2.0

www.Fair4Pets.eu

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

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
11 years 3 months ago #119071

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,

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

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 24
  • Thank you received: 0
11 years 2 months ago #122268

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.

Hikashop Essential 2.2.3
Joomla 3.2.0

www.Fair4Pets.eu

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

  • Posts: 1
  • Thank you received: 0
11 years 2 months ago #122292

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

Last edit: 11 years 2 months ago by Smoosher. Reason: More ISsues

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

  • Posts: 82906
  • Thank you received: 13378
  • MODERATOR
11 years 2 months ago #122410

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

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

  • Posts: 24
  • Thank you received: 0
11 years 2 months ago #124182

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

Hikashop Essential 2.2.3
Joomla 3.2.0

www.Fair4Pets.eu

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

  • Posts: 13201
  • Thank you received: 2322
11 years 2 months ago #124246

Hi,

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

File Attachment:

File Name: h82986f4.zip
File Size:3 KB

Attachments:
The following user(s) said Thank You: F4P

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

  • Posts: 24
  • Thank you received: 0
11 years 2 months ago #124249

It does work know. Thanks!

Hikashop Essential 2.2.3
Joomla 3.2.0

www.Fair4Pets.eu

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

Time to create page: 0.076 seconds
Powered by Kunena Forum