kmxorbit Posted April 30, 2013 Share Posted April 30, 2013 (edited) Hi, I'm running PS 1.5.4.1, and I just bumped into a strange problem. If I upload 2 or more pictures per product, then for some products (not all of them) they show a question mark in the module. I cleaned smarty cache already and img temp. regenerated the .htaccess file (by switching multistore on and off) But still no luck. I have the impression that certain pictures dimensions cause this problem, but i can be totally wrong here. Strange part is, when I switch both pictures (from cover priority) then it works properly, but if I switch back I get the question mark back. Deleting and reloading pictures does not help either. Problem is, I'm talking about a lot of products that suffer this problem. Anyone an idea how to resolve this? See attached files: Edited May 8, 2013 by kmxorbit (see edit history) Link to comment Share on other sites More sharing options...
PascalVG Posted April 30, 2013 Share Posted April 30, 2013 Can you check where the missing image points to? (I.e what is the URL of the missing picture?) Also, when you change the order of the pictures as you mentioned above and the picture shows correctly, what is then the URL of the shown picture? You site isn't live yet, right? If it is, please provide link. pascal Link to comment Share on other sites More sharing options...
kmxorbit Posted April 30, 2013 Author Share Posted April 30, 2013 (edited) Hi, It's a live site for a client and he discovered it just now. I also have a test site (on subdomain of it) which encounters the same problem. http://test.beyoujew.../en/6-kettingen Please visit some products, then check the viewed products. Some will show question marks. The strange part is, although all pictures are squares, they did not have the same pixel size. Can that be a reason for this behaviour? The links for each picture seem to show the correct links. I just don't get it... Edited April 30, 2013 by kmxorbit (see edit history) Link to comment Share on other sites More sharing options...
PascalVG Posted May 1, 2013 Share Posted May 1, 2013 Hi orbit, Can you add my IP address to the list of allowed IP's to your test site. It's in maintenance and cannot get in now... 171.98.5.204 Do I see correctly that you disabled the module on the original site?? Thx Link to comment Share on other sites More sharing options...
kmxorbit Posted May 1, 2013 Author Share Posted May 1, 2013 Hi PascalVG, I Added your IP address to the test site. You should be able to see it now. Correct, I disabled the module on the original site. But client is not happy, it doesn't work :-/ Is there anything else you need to investigate this problem? Best regards, Kmx Orbit. Link to comment Share on other sites More sharing options...
gkorolkov Posted May 7, 2013 Share Posted May 7, 2013 I have the same problem. Would appreciate if you could share the solution if you have ever found one. Link to comment Share on other sites More sharing options...
gkorolkov Posted May 7, 2013 Share Posted May 7, 2013 (edited) Actually I just found a solution on Issue Tracker (http://forge.prestas...owse/PSCFV-8973). If you have the same issue try changing line 108 of blockviewed.php from LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product)'. to LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. Edited May 7, 2013 by gkorolkov (see edit history) 3 Link to comment Share on other sites More sharing options...
kmxorbit Posted May 7, 2013 Author Share Posted May 7, 2013 Did that work for you? because for me it didn't? My whole block with viewed products disappear when I change to this code. Any other suggestion that might help? Link to comment Share on other sites More sharing options...
vekia Posted May 7, 2013 Share Posted May 7, 2013 Did that work for you? because for me it didn't? My whole block with viewed products disappear when I change to this code. Any other suggestion that might help? hey this should work for you. This is solution for your issue. Are you sure that you inserted this code well? To be sure, please paste the code here, we will try to debug it 1 Link to comment Share on other sites More sharing options...
kmxorbit Posted May 7, 2013 Author Share Posted May 7, 2013 Just to make sure I changed line 108 in file root folder > modules > blockviewed > blockviewed.php That is the correct file? Please confirm. Link to comment Share on other sites More sharing options...
vekia Posted May 7, 2013 Share Posted May 7, 2013 yes it is correct file 1 Link to comment Share on other sites More sharing options...
wakaka Posted May 8, 2013 Share Posted May 8, 2013 using this code fix it. LEFT JOIN '._DB_PREFIX_.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. 5 Link to comment Share on other sites More sharing options...
kmxorbit Posted May 8, 2013 Author Share Posted May 8, 2013 Wakaka, you saved the day. Problem is [solved]. Link to comment Share on other sites More sharing options...
vekia Posted May 8, 2013 Share Posted May 8, 2013 Wakaka, you saved the day. Problem is [solved]. Im so happy to hear that :-) so you pasted the code that wakaka mentioned above? Link to comment Share on other sites More sharing options...
kmxorbit Posted May 8, 2013 Author Share Posted May 8, 2013 Yes, that was the correct one. thank you all for your support. Link to comment Share on other sites More sharing options...
vekia Posted May 8, 2013 Share Posted May 8, 2013 You're welcome :-) If you've got any other questions related to this issue - feel free to continue discussion here have a nice evening Link to comment Share on other sites More sharing options...
leonidnk Posted May 22, 2013 Share Posted May 22, 2013 using this code fix it. LEFT JOIN '._DB_PREFIX_.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. Unfortunately, it is not so easy. I did it, and blockviewed dissapiered. However, when I substituted blockviewed 1.5.4.1 with 1.5.4.0, blockviewed came back and works as it should. Link to comment Share on other sites More sharing options...
vekia Posted May 22, 2013 Share Posted May 22, 2013 as i said in other thread this probably because parse error in the code you pasted. You have to be sure that your php code is without bug. you can turn on error reporting in your prestashop, and then the parse error will appear (and you will see where exactly) Link to comment Share on other sites More sharing options...
powerpig Posted June 6, 2013 Share Posted June 6, 2013 Hi 2 all of you! Ok... My code is in line 295 and not in line 108 but that doesn't matter (I think). As I can se i have ...AND i.cover = 1)... but it's not working. PLUS! In BO/Modules/Floating viewed.../Configuration - works only number of products to display. Enable/disable and Position is not working/no effect. - Float Enable - in LiveEdit I can move block only up/down on left side of column (if I chose position - nothing) - Float Disable - I choose position - nothing. HELP? Link to comment Share on other sites More sharing options...
deepee Posted June 12, 2013 Share Posted June 12, 2013 Actually I just found a solution on Issue Tracker (http://forge.prestas...owse/PSCFV-8973). If you have the same issue try changing line 108 of blockviewed.php from LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product)'. to LEFT JOIN '.DB_PREFIX.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. Thanks, worked for me! Link to comment Share on other sites More sharing options...
Diakro Posted July 16, 2013 Share Posted July 16, 2013 #7 @gkorolkov Thanks! It's work. Link to comment Share on other sites More sharing options...
androkot33 Posted July 16, 2013 Share Posted July 16, 2013 Hi powerpig! Do you have '. characters at the end of line? Link to comment Share on other sites More sharing options...
NOSaint Posted July 22, 2013 Share Posted July 22, 2013 using this code fix it. LEFT JOIN '._DB_PREFIX_.'image i ON (i.id_product = p.id_product AND i.cover = 1)'. Worked for me also! Thanks Wakaka! Link to comment Share on other sites More sharing options...
safede Posted August 12, 2013 Share Posted August 12, 2013 Thank you for the posts....This was my last error to correct after a marathon three days doing an upgrade. The solution worked great!!! Link to comment Share on other sites More sharing options...
hoatbui Posted August 12, 2013 Share Posted August 12, 2013 (edited) I changed the code to the suggested one but it still doesnt work for me (( the URL of the missing picture: http://hoatbui.com/30-home_default/life-fitness-95ti-treadmill.jpg the URL of the picture on product page: http://hoatbui.com/30-large_default/life-fitness-95ti-treadmill.jpg Edited August 12, 2013 by hoatbui (see edit history) Link to comment Share on other sites More sharing options...
vekia Posted August 13, 2013 Share Posted August 13, 2013 I changed the code to the suggested one but it still doesnt work for me (( the URL of the missing picture: http://hoatbui.com/3...i-treadmill.jpg the URL of the picture on product page: http://hoatbui.com/3...i-treadmill.jpg you're talkin about different module. we are talkin here about "viewed products" module, you want to fix other one - home featured. in this case i suggest you to create new thread thanks in advance Link to comment Share on other sites More sharing options...
enlaceptolosa Posted August 25, 2013 Share Posted August 25, 2013 greate! it fix my problem to Link to comment Share on other sites More sharing options...
skrikis Posted October 9, 2013 Share Posted October 9, 2013 How can i remove it from here? Thought that was last viewed problem, but when i deleted that module, it stayed the same. Please help Link to comment Share on other sites More sharing options...
vekia Posted October 9, 2013 Share Posted October 9, 2013 How can i remove it from here? Thought that was last viewed problem, but when i deleted that module, it stayed the same. Please help http://www.prestashop.com/forums/topic/280552-help-please/?do=findComment&comment=1410530 Link to comment Share on other sites More sharing options...
Recommended Posts