Author Topic: Virtuemart store manager - images  (Read 772 times)

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3481
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Virtuemart store manager - images
« Reply #15 on: April 08, 2021, 12:34:32 pm »
I think this falls back to the store manager, ask them for help regarding this.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

marvays

  • Jr. Member
  • **
  • Posts: 400
    • richta.cz
  • Skype Name: marvays
Re: Virtuemart store manager - images
« Reply #16 on: April 08, 2021, 13:09:03 pm »
_virtuemart_medias column file_lang . . . . what is it?

manager fills me in this field "
when I delete them, everything works.

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3481
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Virtuemart store manager - images
« Reply #17 on: April 08, 2021, 13:13:37 pm »
Not sure, but as you can have different image for each language it could be important to have either empty or correct language code.

Nice that You have got it working.

Jörgen

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1133
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Virtuemart store manager - images
« Reply #18 on: April 08, 2021, 13:46:54 pm »
yep, setup right language is basic option in our app Import product for Virtuemart too :)
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

marvays

  • Jr. Member
  • **
  • Posts: 400
    • richta.cz
  • Skype Name: marvays
Re: Virtuemart store manager - images
« Reply #19 on: April 09, 2021, 06:01:20 am »
Solved.
If someone has a problem after importing images with this tool, it is caused by inserting the value "" into the file_lang column in the virtuemart_medias table.

Repair:
Code: [Select]
UPDATE j3_virtuemart_medias SET file_lang = NULL;
Because the quotation marks are meaninglessly inserted into multiple columns, I added another fix:
Code: [Select]
UPDATE j3_virtuemart_medias SET file_params = NULL;
UPDATE j3_virtuemart_medias SET file_class = NULL;
UPDATE j3_virtuemart_medias SET file_meta = NULL;
UPDATE j3_virtuemart_medias SET file_description = NULL;

I'm not a programmer and I helped myself with the MySQL manual. He would definitely come up with a nicer notation.

pinochico

  • 3rd party VirtueMart Developer
  • Full Member
  • *
  • Posts: 1133
    • MiniJoomla
  • Skype Name: support-easysoftware
  • VirtueMart Version: 3
Re: Virtuemart store manager - images
« Reply #20 on: April 09, 2021, 08:45:33 am »
For other:
This fix break functional for multilanguage shop with multilanguage images - use it carefoul or hire right developer for right fix.
www.minijoomla.org  - new portal for Joomla!, Virtuemart and other extensions
XML Easy Feeder - feeds from products, orders and database table
Virtuemart Email Manager - customs email templates

marvays

  • Jr. Member
  • **
  • Posts: 400
    • richta.cz
  • Skype Name: marvays
Re: Virtuemart store manager - images
« Reply #21 on: April 09, 2021, 10:55:13 am »
This is just a fix for the eMagicOne Store Manager for Virtuemart bug, which you can now download and use for free. The company has completed further development of this program, so I asked about the forum here. Because I found a solution, I will write it here without further unnecessary comments so that others can know.

I wrote about the problem above. The solution is to replace the values that the program incorrectly created. This modification changes all items in the table. If you want to modify only some, you must use the WHERE parameter.
More here: http://dev.mysql.com/doc/refman/5.1/en/update.html

Thank you for your cooperation