Hello, Using Joomla 3.3.3 and virtuemart 2.9 , I am having a problem with related products and categories. More specifically when I try to search a related product, it shows blank thumbnais, however if you choose it , you can see the product title but not the thumbnail. Also if you try to save the related product , it says that the products is saved, however the related product is not saved.
Any ideas solving this ?
Also , the website is multilingual
Update to vm2.9.8a
Still having the same problem.
Also when clicking cmponents - virtuemart - aio I amgetting 404 Component not found
and also when trying to add a new product I am getting
1062 Duplicate entry '122-0' for key 'i_virtuemart_product_id' SQL=INSERT INTO `jos_virtuemart_product_manufacturers` (`virtuemart_product_id`,`virtuemart_manufacturer_id`) VALUES ('122','')
I dont know of the specific problem is connected with ther others I write before. However at virtuemart-manufacturer I get - see image
It sounds like a database issue ?
[attachment cleanup by admin]
okay. the problem with the manufacturers and the new product adding solved by changing the default language and then deleting all manufacturers. Then change again the default language and everything is ok. Tha means that some records were deleted from the database.
However I still have the problem with the related products even if I updated to the latest version 2.9.8a. Also the Virtuemart AIO component doesnt exist as I described before, even if I installed the latest one.
Any help will be very valuable. Thanx in adnvance.
Yeh you broke somehow your installation with the multivendor stuff.
Quote from: Milbo on August 12, 2014, 09:14:40 AM
Yeh you broke somehow your installation with the multivendor stuff.
any ideas how to fix the related product stuff?
Quote from: dsidir on August 11, 2014, 16:39:46 PM
okay. the problem with the manufacturers and the new product adding solved by changing the default language and then deleting all manufacturers. Then change again the default language and everything is ok. Tha means that some records were deleted from the database.
No, no records are deleted. You assumingly installed vm while joomla was set to english. Then you changed your joomla language, but vm is still using the english tables, then you entered all in your language and it got stored in english tables, then you changed the vm language and now it tries to load the manufacturer with the new language.
Solution is again to use vm2.9.9 http://dev.virtuemart.net/attachments/download/764/com_virtuemart.2.9.9_extract_first.zip
It has a language fallback. In your case not really good, cause you would lose performance for being all the time in fallback mode.
Milbo, you mean tha updating again to newer version could solve the problem with the related products?
Actually first I installed the version of joomla together with VM and the template as a combo package.
Is there anything that I sould check or change to the database since the site works with 2 languages ? Still cant find a solution to this problem with the related products - blank images
Any ideas are very welcome
Quote from: dsidir on August 19, 2014, 12:51:42 PM
Actually first I installed the version of joomla together with VM and the template as a combo package.
a vm3? Do you mean our fullinstaller?
No, Inspire template from virtuemart templates includes joomla 3.3 , vm 2.9 and the template of course. However if I remember correctly , when I first installed this package the related products worked. I believe the problem started when I made the site multilingual. Thats why I am asking if I have to change some records maybe in the database or check something in there. Now I am running joomla 3.3.3 , vm 2.9.9 and the rpoblem still exists. I still get blank images when search a product. It seems that it finds the product when writing its name but with blank image, no title. And when you try to save this, it saves nothing, The products that set as related dissapear and not saved.
hi dsidir,
I am not sure, nor on vm 3.3 yet but I can remember a similiar issue with related products some time ago with vm 2.0.X?, something regarding the vm custom tables, there were some entries missing, 'COM_VIRTUEMART_RELATED_PRODUCTS' AND 'COM_VIRTUEMART_RELATED_CATEGORIES' ...
check this thread therefore:
http://forum.virtuemart.net/index.php?topic=111618.msg379813#msg379813
regards jens
I have already see this post. However my table vm_customs is not completely empty. I am going to take a backup and try this solution and I will inform you.
It is no problem if it´s nearly empty (it means only you do not have edited self-defined fields) but it needs the two lines I have marked you in my xls-export from the virtuemart_customs table/db - maybe it helps. Important are two fields there, named "custom_title" and "field_type" (case sensitive!!!) ...
I remember I had the issue too. These two entries were missing in my table/installation. After I edited them manually, selecting of related products and categories and saving them did function properly again.
best regards
jens
[attachment cleanup by admin]
Finally , after too many efforts, the related products worked. The problem was the 2 lines missing from the database. Adding actually the 2 lines that slammy marked on the file now I can add and save related products.
thank u all ;)
ah good to hear that it worked :)
Pls could you mark your first post in this thread "solved" like the way you did it with your last post, then everybody can see the "solved-tick" in the thread-headline ...
regards jens
In vm3, we show this customfields normally, so people can just readd it by using the GUI
Quote from: Milbo on August 27, 2014, 10:01:29 AM
In vm3, we show this customfields normally, so people can just readd it by using the GUI
hi max, hope you´re doing fine. Nice to hear that vm 3 handles this within the gui.
best regards jens
vm2 did it also
the problem was just that people often deleted this fields and claimed than that vm2 does not support it.
Hi guys.
i know this is an old post but i have the same issue in VM 3.2.4 which i cannot fix.
related products just shows title and no images and nothing saves when i add it.
I have the two lines mentioned above in my db have tried disabling mootools and plugins/components with no joy
Just wonder if you have any ideas as now desperate to get it working
https://easyhit.temp-gingerweb.com
many thanks
Did you enter the customprototype one time, checked and stored it? Because you can enable/disable the images now.
I dont know what this is, i havent intentionally changed anything to do with this, where are the settings please?
Hello
Check under Custom Fields. There You should find two fields that are a bit special.
Related Categories
and
Related Products
Check into these and see that they look correct. You can choose if title, image etc should be shown. In my site I seem to have a Related Products field that is used for Related categories. Maybe You have a similar issue? If they look alright to You, then just save them once and see if that changes anything.
regards
Jörgen @ Kreativ Fotografi
I am using 2 custom fields both Generic child variant and i cant see anything on either of them mentioning related products or categories.
I get the same issue in related products even on a product that doesnt have any custom fields applied.
thanks for trying to help but im not any further with this.
If you look at the VM demo on http://demo.virtuemart.net/administrator/index.php?option=com_virtuemart&view=custom you will see the setup for related categories and related products. I think that is where Jörgen suggests you look.
Wow progress thanks both of you i didnt realise that related products was in the custom fields too. that gives me the images and sets them in the product page but with only having "ontop" or "addtocart" as a layout position it isnt displayed very well. If i use "related_products" they dont show up. Is there a way of making them display in the correct way as before. ie line across below description and in the pop up add to cart which is the main place i want them ?
thanks for progress so far !
Hello
The layout positions related_category and related_products should work. They work for me. Have they been removed from Your template ?
regards
Jörgen @ Kreativ Fotografi
Mmm not sure possibly its a Yootheme template, i will investigate thanks for bringing this to my attention anyway