Fabsh Posted April 30, 2013 Share Posted April 30, 2013 Hello guys. My English ist not that good but i dont get an answer at the german board so i hope you can help me with this problem I updated my prestashop from version 1.5.3.1 to version 1.5.4.1. Now i have the problem that modul block viewed dont shows any pictures any more. But with version 1.5.3.1 it worked perfect. Hopefully someone can help me. Link to comment Share on other sites More sharing options...
benjamin utterback Posted April 30, 2013 Share Posted April 30, 2013 Hello, a community member tdr170 has posted a solution about this. Make sure to confirm a working backup and try this in your blockviewed.php "Changing line 108 from this: LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product)'. To this: LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. Fixes the image issue." Link to comment Share on other sites More sharing options...
Fabsh Posted April 30, 2013 Author Share Posted April 30, 2013 Hello , i tryed your fix but now there is no box at all anymore Maybe you can look at the attachmet if i did anything wrong! blockviewed.php 1 Link to comment Share on other sites More sharing options...
gvillem Posted May 1, 2013 Share Posted May 1, 2013 Not work Link to comment Share on other sites More sharing options...
benjamin utterback Posted May 1, 2013 Share Posted May 1, 2013 Hello all, thank you for the update. Please report this bug to http://forge.prestashop.com This is the best way to report suspected bugs. Link to comment Share on other sites More sharing options...
lubosl Posted May 18, 2013 Share Posted May 18, 2013 Hello, a community member tdr170 has posted a solution about this. Make sure to confirm a working backup and try this in your blockviewed.php "Changing line 108 from this: LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product)'. To this: LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. Fixes the image issue." For me is working! problem seems fixed. Thank you! Link to comment Share on other sites More sharing options...
MrC8 Posted May 22, 2013 Share Posted May 22, 2013 Works for me too ! thank you ! Link to comment Share on other sites More sharing options...
vekia Posted May 22, 2013 Share Posted May 22, 2013 thanks community for informations, that it works i marked this thread as solved regards Link to comment Share on other sites More sharing options...
erikmlb Posted May 28, 2013 Share Posted May 28, 2013 Hello, a community member tdr170 has posted a solution about this. Make sure to confirm a working backup and try this in your blockviewed.php "Changing line 108 from this: LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product)'. To this: LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. Fixes the image issue." Hello greating to all ... i have the problema and make a copy of blockviewed.php then modify that Benjamin says and now dont shows the block module of products viewed... i undone the changes and stay the same. Then copy the saved file and still dont show it. What can i do ? Hope you can understand this english Please thanks for all. Link to comment Share on other sites More sharing options...
vekia Posted May 28, 2013 Share Posted May 28, 2013 Hello greating to all ... i have the problema and make a copy of blockviewed.php then modify that Benjamin says and now dont shows the block module of products viewed... i undone the changes and stay the same. Then copy the saved file and still dont show it. What can i do ? Hope you can understand this english Please thanks for all. for the first you should turn on error reporting in your prestashop, maybe some error will appear instead the blockviewed products Link to comment Share on other sites More sharing options...
erikmlb Posted May 28, 2013 Share Posted May 28, 2013 for the first you should turn on error reporting in your prestashop, maybe some error will appear instead the blockviewed products Hello thanks for be here. Im a real Newbie and dont know how to set ON the error report. i use presta 1.5.4.1 Sorry for dont know that. How can i do that ? Please and Thanks. Link to comment Share on other sites More sharing options...
vekia Posted May 28, 2013 Share Posted May 28, 2013 if you aren't familiar with prestashop debugging - read how to turn error reporting Link to comment Share on other sites More sharing options...
Pabloladen Posted June 27, 2013 Share Posted June 27, 2013 Hello , i tryed your fix but now there is no box at all anymore Maybe you can look at the attachmet if i did anything wrong! me too :/ Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 27, 2013 Share Posted June 27, 2013 Hi Pabloladen, were you in the same situation? (upgrade to 1.5.4.1 from 1.5.3.1) Link to comment Share on other sites More sharing options...
Pabloladen Posted June 27, 2013 Share Posted June 27, 2013 no :/ i have 1.5.4.1 all the time i have the same that "i have the problema and make a copy of blockviewed.php then modify that Benjamin says and now dont shows the block module of products viewed... i undone the changes and stay the same. Then copy the saved file and still dont show it." Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 27, 2013 Share Posted June 27, 2013 Could you post a link to your site. Also, can you turn error reporting on. See post #12 1 Link to comment Share on other sites More sharing options...
Pabloladen Posted June 27, 2013 Share Posted June 27, 2013 Could you post a link to your site. Also, can you turn error reporting on. See post #12 i fix my problem with this file: https://github.com/PrestaShop/PrestaShop/blob/development/modules/blockviewed/blockviewed.php Link to comment Share on other sites More sharing options...
benjamin utterback Posted June 27, 2013 Share Posted June 27, 2013 Hi, thanks for the confirmation and link. Happy Selling! Link to comment Share on other sites More sharing options...
Nuno Loureiro Posted August 7, 2013 Share Posted August 7, 2013 (edited) Hi, for those who have used this code and failed one of the reasons may be: This is wrong: LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. You should use: LEFT JOIN '._DB_PREFIX_.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. use: '._DB_PREFIX_.' not: '.DB_PREFIX.' (v.1.541) Edited August 7, 2013 by Nuno Loureiro (see edit history) Link to comment Share on other sites More sharing options...
djhovo09 Posted August 19, 2013 Share Posted August 19, 2013 Hello, a community member tdr170 has posted a solution about this. Make sure to confirm a working backup and try this in your blockviewed.php "Changing line 108 from this: LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product)'. To this: LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. Fixes the image issue." in line 108 change to ` LEFT JOIN '._DB_PREFIX_.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. Link to comment Share on other sites More sharing options...
vekia Posted August 19, 2013 Share Posted August 19, 2013 in line 108 change to ` LEFT JOIN '._DB_PREFIX_.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. this is what Benjamin said... you've got still some problems? or what? Link to comment Share on other sites More sharing options...
piboss Posted August 29, 2013 Share Posted August 29, 2013 Hi all, the solution is this: Blockviewed.php Online 109 replace: Shop::addSqlAssociation('image', 'i', false, 'image_shop.cover=1').' by Shop::addSqlAssociation('image', 'i', true, 'image_shop.cover=1').' Regards! Link to comment Share on other sites More sharing options...
massmusculos Posted July 31, 2014 Share Posted July 31, 2014 Hello all, I have a problem with the blockviewed module of my prestashop store which is driving me nuts! it is v.1.5.6.2 (using Chrome) When I set the store I made an error by setting the store under two spanish language: Spanish and Argentinean.. Three months later, I decided to remove the Argentina idiom. After this, the blockviewed got frozen with a product. By trying to solve the problem I unable that product, then the blockviewed module dissappear for ever!.. I ran "LiveEdit" and passed the module to the right column, then it appeared again, but just showing only one product, the latest seen, even having set the module for showing 10 products. When I change its position the module, it gone missing again! .. very rare behavior any idea to find a solution? Thanks in advance Cesar Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now