Author Topic: Cannot see products of category from front page  (Read 2329 times)

zhivko

  • Beginner
  • *
  • Posts: 7
  • Skype Name: klemenzivkovic
Cannot see products of category from front page
« on: May 15, 2013, 02:26:52 am »

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

  • Beginner
  • *
  • Posts: 7
  • Skype Name: klemenzivkovic
Re: Cannot see products of category from front page
« Reply #1 on: May 16, 2013, 12:30:40 pm »
Can somebody take a look at this or give me any pointer suggestion how to try to troubleshoot this by myselve?

zhivko

  • Beginner
  • *
  • Posts: 7
  • Skype Name: klemenzivkovic
Re: Cannot see products of category from front page
« Reply #2 on: May 16, 2013, 12:57:23 pm »
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

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28224
  • Always on vacation
    • Jenkin Hill Internet
Re: Cannot see products of category from front page
« Reply #3 on: May 16, 2013, 15:07:53 pm »
[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.

Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.9.10473 on Joomla 3.9.28 PHP 7.4.14

zhivko

  • Beginner
  • *
  • Posts: 7
  • Skype Name: klemenzivkovic
Re: Cannot see products of category from front page
« Reply #4 on: May 16, 2013, 18:58:36 pm »
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

  • Beginner
  • *
  • Posts: 7
  • Skype Name: klemenzivkovic
Re: Cannot see products of category from front page
« Reply #5 on: May 16, 2013, 20:27:31 pm »
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.