Related Categories and Products not working [SOLVED]

[dsidir]

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 ?

[dsidir]

Also , the website is multilingual

[Milbo]

Update to vm2.9.8a

[dsidir]

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','')

[dsidir]

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]

[dsidir]

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.

[Milbo]

Yeh you broke somehow your installation with the multivendor stuff.

[dsidir]

Yeh you broke somehow your installation with the multivendor stuff.

any ideas how to fix the related product stuff?

[Milbo]

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.

[dsidir]

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.

[dsidir]

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

[Milbo]

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?

[dsidir]

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.

[slammy]

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

[dsidir]

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.