VirtueMart Forum

VirtueMart 2 + 3 + 4 => Virtuemart Development and bug reports => Topic started by: doc_denis on March 14, 2015, 13:06:45 PM

Title: [solved] add image to categories not working in my VM 3.0.6.2
Post by: doc_denis on March 14, 2015, 13:06:45 PM
joomla 3 and vm 3.0.6.2
when creating a new product category: adding picture does not work, the site looks good adding the image folder images / stories / virtuemart / category
but the image is not displayed in the back office.
I can not replace either (because it is not added).

found only technique, take a picture of the demo categories with "+16" button and i replace this picture :(
I have no more than 1 or 2 in advance.

Another practical question:

is there a technique to duplicate categories as for products?
this function back office virtuemart would be very useful to move faster.
with and / or without copying subcategories
Title: Re: add image to categories not working in my VM 3.0.6.2
Post by: doc_denis on March 14, 2015, 14:58:15 PM
adding image categories works on another site for my tests.

my question
is there a way to repair the VM tables without risky to overwrite the existing catalog?

CSV export the catalog, may be the solution.
to use a "clean" backup and re-import additional items ...
Title: Re: add image to categories not working in my VM 3.0.6.2
Post by: jenkinhill on March 14, 2015, 15:51:04 PM
Tools/Install or if necessary update tables    - fixes tables,  does not overwrite any data
Title: Re: add image to categories not working in my VM 3.0.6.2
Post by: doc_denis on March 14, 2015, 16:18:54 PM
thank you Jenkinhill,
i have a error message :

Incorrect table definition; there can be only one auto column and it must be defined as a key SQL=ALTER TABLE `joswz_virtuemart_medias` CHANGE COLUMN `virtuemart_media_id` `virtuemart_media_id` INT(1) UNSIGNED NOT NULL AUTO_INCREMENT FIRST
Title: Re: add image to categories not working in my VM 3.0.6.2
Post by: doc_denis on March 14, 2015, 17:28:40 PM
hello, to solved the problem of the previous post,
I imported the table structure  "virtuemart_medias" of my test site.

then exported the data only "without the structure" of my table virtuemart_media the production site.

then i delete the table "virtuemart_media" on my website "production".
i recreate table with the exported structure

and then import the data from the table "virtuemart_media" of prodution site.

Now, the function "add an image" works well !

thank you for the idea that brought me the solution!

thank you again jenkinhill.   :)
Title: Re: [solved] add image to categories not working in my VM 3.0.6.2
Post by: doc_denis on March 14, 2015, 18:43:12 PM
hello,

I also review the tables : virtuemart_products , virtuemart_product_medias, virtuemart_product_prices:

return the primary key and add auto increment with phpmyadmin.
Once done, the "update table" system to function and announced: "Database updated"

great!