Import virtuemart products and categories in hikashop error

  • Posts: 78
  • Thank you received: 1
  • Hikashop Business
6 years 1 month ago #288075

-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.5

Hi there
For first time i tried to import from virtuemart products and categories in hikashop with succes.
For somereason i unistall the hikashop and install again! (also i deleted the database row) when i itried second time to import again virtuemart products and categories in hikashop i had the follow error : 1060 Duplicate column name 'level'

So i cant import the products and categories.
may do you know why happened and how to fix becuse is 1000 products!

thanks!!!

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

  • Posts: 25994
  • Thank you received: 4004
  • MODERATOR
6 years 1 month ago #288093

Hello,

It would be best to activate your Joomla debug mode so you can provide us the full SQL query or at least the call-stack so we can know what it is exactly.
Unfortunately, with the current details we are not able to know from where the error is coming from with precision.

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: 78
  • Thank you received: 1
  • Hikashop Business
6 years 1 month ago #288124

Thank you very much for your reply.
i attached an print screen may it help you!. It seems some errors in php lines.

thanks

Attachments:
Last edit: 6 years 1 month ago by oxygenvisual.

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

  • Posts: 81361
  • Thank you received: 13036
  • MODERATOR
6 years 1 month ago #288235

Hi,

That's not a real error. It means that the column level was already added and shouldn't be added a second time (probably because the import was done several times).
Change the line:
$this->db->query();
to:
try{ $this->db->query(); }catch(Exception $e){}
on line 943 of the file administrator/components/com_hikashop/helpers/import/vm2.php and that will avoid the problem.
We'll add that change on our end too.

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

  • Posts: 78
  • Thank you received: 1
  • Hikashop Business
6 years 1 month ago #288239

Great!!

Works perfect!
Thanks a lot!!

Last edit: 6 years 1 month ago by oxygenvisual.

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

Time to create page: 0.061 seconds
Powered by Kunena Forum