Cannot see products of category from front page

[zhivko]

I am new in joomla and virtuemart world, and I am using:
Joomla! 2.5.11
VM: 2.0.20b

I have weird problem. When I click on some categories list of product is not showing (it takes few seconds and frontpage is refreshed) - however on other categories products are showing just fine.

I filled mysql data from excel using VBA script but still - how come some of them are seen and others not? Can I enable some php logs or is there any other way to troubleshoot?

From live site (http://193.77.158.164/poolshop) you can see that category "WALL ENTRANCE" shows products, but for example category "MUFE" doesn't list them.

From administration for "MUFE" category all all "mufe" products are listed just fine.

admin user: admin
admin password: demo

Thank you guys for pointing me in right direction - thi issue is driving me mad...

Best regards,
Zhivko

[zhivko]

Can somebody take a look at this or give me any pointer suggestion how to try to troubleshoot this by myselve?

[zhivko]

I also noticed I have alot of 304 statuses in access.log of apache - is this OK ?

Like:
127.0.0.1 - - [16/May/2013:12:54:23 +0200] "GET /poolshop/components/com_virtuemart/assets/js/vmsite.js HTTP/1.1" 304 -
127.0.0.1 - - [16/May/2013:12:54:23 +0200] "GET /poolshop/media/system/js/modal-uncompressed.js HTTP/1.1" 200 13137
127.0.0.1 - - [16/May/2013:12:54:23 +0200] "GET /poolshop/media/system/js/mootools-core-uncompressed.js HTTP/1.1" 200 160494
127.0.0.1 - - [16/May/2013:12:54:23 +0200] "GET /poolshop/components/com_virtuemart/assets/js/facebox.js HTTP/1.1" 304 -
127.0.0.1 - - [16/May/2013:12:54:23 +0200] "GET /poolshop/components/com_virtuemart/assets/js/vmprices.js HTTP/1.1" 304 -
127.0.0.1 - - [16/May/2013:12:54:23 +0200] "GET /poolshop/media/system/js/mootools-more-uncompressed.js HTTP/1.1" 200 351401
127.0.0.1 - - [16/May/2013:12:54:24 +0200] "GET /poolshop/templates/beez_20/images/personal/bg2.png HTTP/1.1" 304 -
127.0.0.1 - - [16/May/2013:12:54:24 +0200] "GET /poolshop/templates/beez_20/images/personal/personal2.png HTTP/1.1" 304 -
127.0.0.1 - - [16/May/2013:12:54:24 +0200] "GET /poolshop/images/stories/virtuemart/product/resized/0201600004.jpg HTTP/1.1" 304 -
127.0.0.1 - - [16/May/2013:12:54:24 +0200] "GET /poolshop/templates/beez_20/images/nature/karo.gif HTTP/1.1" 304 -
127.0.0.1 - - [16/May/2013:12:54:24 +0200] "GET /poolshop/templates/beez_20/images/header-bg.gif HTTP/1.1" 304 -
127.0.0.1 - - [16/May/2013:12:54:24 +0200] "GET /poolshop/templates/beez_20/images/nature/arrow1.gif HTTP/1.1" 304 -

also in apache_error.log I have:

[Thu May 16 12:48:24 2013] [error] [client 66.249.78.196] client denied by server configuration: H:/wamp/www/reducing piece long 20 x 20mm
[Thu May 16 12:53:10 2013] [error] [client 66.249.76.178] client denied by server configuration: H:/wamp/www/reducing piece long 20 x 20mm
[Thu May 16 12:54:44 2013] [error] [client 66.249.78.196] client denied by server configuration: H:/wamp/www/reducing piece long 20 x 20mm

[jenkinhill]

[Thu May 16 12:48:24 2013] [error] [client 66.249.78.196] client denied by server configuration: H:/wamp/www/reducing piece long 20 x 20mm  - this refers to localhost....

Reasons for a cat products not displaying: no products assigned, incorrect assignment to shopper group

For me I had to wait a full minute for the first page to load.

[zhivko]

Found what the error was. The names of product contains "/" character.
If I urlencode it before I wrote it to database it doesn't appear right - it outputs %20 for space for example.
How can I enter 3/4" like 3quarter of inch to database? what should be / replaced with?

[zhivko]

Actually I found that problem is slug field in table zqldk_virtuemart_products_en_gb - this should contain no / characters neither " or quite possible some others... otherwise you get 404 error.