Import Open cart to Hikashop

  • Posts: 7
  • Thank you received: 0
9 years 8 months ago #193647

-- url of the page with the problem -- : www.breister.nl
-- HikaShop version -- : 2.3.5
-- Joomla version -- : 3.4.0
-- Error-message(debug-mod must be tuned on) -- : Opencart has not been found in the database you specified

I get the message "Opencart has not been found in the database you specified"
I have set the asked options correct

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

  • Posts: 12953
  • Thank you received: 1778
9 years 8 months ago #193870

Hello,

I have set the asked options correct

Can you check again the values that you have set through the "Database's name where your Opencart's datas are hosted " and "Opencart's website root path" options ?
Thanks.

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

  • Posts: 7
  • Thank you received: 0
9 years 8 months ago #193888

I have checked the values but it's not working.
The values i use are correct, i think. I use the correct name of the Open cart database and the full path where open cart is installed.

Any suggestions?

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 8 months ago #193979

Hi,

Can you try to change the line:
$query = 'SHOW TABLES FROM '.$this->opencDatabase.' LIKE '.$database->Quote(substr(hikashop_table('oc_product',false),3)).';';

to:
$query = 'SHOW TABLES FROM '.$this->opencDatabase.' LIKE '.$database->Quote('oc_product').';';

in the file administrator/components/com_hikashop/helpers/import/openc.php and see if that helps ?

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

  • Posts: 7
  • Thank you received: 0
9 years 8 months ago #194021

Sorry, this gives the same result.

"Opencart has not been found in the database you specified"

Is it possible that there is something changed in the database structure of open cart?
I use open cart version 1.5.6

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 8 months ago #194027

Hi,

It's possible. Can you check the tables of the OpenCart database ? Do you have a table called oc_product ?

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

  • Posts: 7
  • Thank you received: 0
9 years 8 months ago #194410

I have found the problem, the table prefix was not oc_ because i changed this during the installation of open cart in another prefix.
The import is now completed but without the images and incorrect prices. The categories and products are succesfully imported.

Thanx for your help so far.

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

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 8 months ago #194419

Ah ok ! Thank you for the information. We didn't know that it was possible to change the prefix of the tables in OpenCart.
We'll have to do something handle that then !

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

Time to create page: 0.078 seconds
Powered by Kunena Forum