A few product pages have gone blank!

[Paul_gpvr]

Hi,

 

The website has been running fine however i noticed the other day that when i view some of the products the actual page is blank, not good!! Other products are fine it just seems some are not showing any information.

 

For example if you look at the Weber Q120 / Weber Baby Q category http://www.bbqs2u.co...weber-q120-bbqs

 

http://www.bbqs2u.co.uk/8-weber-q-bbqs

 

http://www.bbqs2u.co.uk/23-weber-q220-bbqs

 

Then drill into one of the products (the bundle product works ok )eg:-

 

http://www.bbqs2u.co...bbq-511574.html

 

or

 

http://www.bbqs2u.co...and-511874.html

 

I've no idea what has caused this, anyhelp whatseover would be really appreciated.

 

Thanks.

 

Paul

Edited June 30, 2013 by Paul_gpvr (see edit history)

[vekia]

it looks really weird

 

turn error reporting on (if it is possible) then refresh these pages.

you can also check PHP error log.

 

it looks like script / parse error (right column also disappears)

[Paul_gpvr]

it looks really weird

 

turn error reporting on (if it is possible) then refresh these pages.

you can also check PHP error log.

 

it looks like script / parse error (right column also disappears)

 

Thanks - i think i know where to turn on the debugging but not sure where the PHP error log is?

[vekia]

PHP offers simple but effective solution to log all errors to a log fiie. Shared hosts are often storing log files in your root directory /log subfolder. Everything depends on your hosting configuration

[Paul_gpvr]

Ok i've enabled debugging by setting this define('_PS_MODE_DEV_', true); to true in the defines.inc.php file - is that all i need to do to show error reporting? As i cant see any errors on those blank product pages.

 

I have a log folder in the root but nothing in there really.

[Paul_gpvr]

Ok now more and more product pages are blank.

 

Please can someone help?

 

Can i log this with prestashop support?

[vekia]

it looks like RAM memory issue, to be sure, please ask your hoster for ram usage raport from your account

[tomerg3]

Have you created a lot (1,000-3,000+) combinations for these products?

 

If so, that is your issue, as PS can only handle about that amount of combinations per product, before running into out of memory issues.

[vekia]

it's related to the sql queries, am I right? i think that you can run slow queries log (it's a mysql default feature)

moreover, try to run _PS_DEBUG_PROFILING_

[Paul_gpvr]

Have you created a lot (1,000-3,000+) combinations for these products? If so, that is your issue, as PS can only handle about that amount of combinations per product, before running into out of memory issues.

 

Hi Tomer,

 

Not not at all we only have 283 products, about 6 of them are packs/bundles that have 4/5 items associated to them.

 

Any other ideas?

 

Thanks for your help.

 

Paul

[vekia]

hey, please turn _PS_DEBUG_PROFILING_ on

[Paul_gpvr]

Hey guys good news.

 

I found the problem - I have a module called "video product block v1.2 by hfModules" which shows youtube clips within the product page.

However i spotted in the error logs a PHP Fatal Error which is due to one of the YouTube videos being made "private" on youtube therefore the module failed and crashed the Product page!! Not good.

 

I've also found a few other errors whilst looking into the error log:-

 

[error] [client 66.249.75.148] PHP Notice: Undefined index: reference in /var/www/vhosts/bbqs2u.co.uk/httpdocs/classes/ProductSale.php on line 149

 

Line 149 is

$row['link'] = $link->getProductLink($row['id_product'], $row['link_rewrite'], $row['category'], $row['reference']);

 

Which is used within this for loop:-

 

foreach ($result AS &$row)
 {
   $row['link'] = $link->getProductLink($row['id_product'], $row['link_rewrite'], $row['category'], $row['reference']);
   $row['id_image'] = Product::defineProductImage($row, $id_lang);
 }

 

Any ideas how to fix?

 

Thanks a lot.

[vekia]

So you haven't checked it before? :| (php log)

 

well, notices aren't bugs, they aren't warnings also, ther are just notifications - in this case - related to the $row['reference'] variable.

Notification mean that in $row array 'reference' field isn't exist