DWMartin Posted January 10, 2013 Share Posted January 10, 2013 I've upgraded a copy of our shop from 1.4.4.0 to 1.5.3, and I've found that the category pages display a seemingly correct number of products (e.g. "There are 458 products") but display only a few products from the category. This seems to be a problem with the SQL query (I var_dump'd it & manually executed it for men's t-shirts & only got two rows back out of 458 products). Additionally, I've found the prices displayed in places other than the product pages is often incorrect, usually displayed as £0.00- although I didn't have a chance to investigate the cause of this yesterday. Link to comment Share on other sites More sharing options...
DWMartin Posted January 11, 2013 Author Share Posted January 11, 2013 Just as a follow-up, I've re-uploaded the classes, controller & override directories from the 1.5.3.1 zip file in case there was any junk left over from the 1.4.4.0 install that was triggering the issue. The issue still persists. Link to comment Share on other sites More sharing options...
Site Posted January 11, 2013 Share Posted January 11, 2013 Did you use the Auto-Upgrade or manually do it ? Link to comment Share on other sites More sharing options...
DWMartin Posted January 11, 2013 Author Share Posted January 11, 2013 I used the auto-upgrade. Link to comment Share on other sites More sharing options...
tdr170 Posted January 11, 2013 Share Posted January 11, 2013 Try rolling back to 1.4.4 then upgrade to 1.4.9 then to 1.5.3. Link to comment Share on other sites More sharing options...
DWMartin Posted January 11, 2013 Author Share Posted January 11, 2013 Thanks for the suggestion, I shall try this on monday Link to comment Share on other sites More sharing options...
DWMartin Posted January 14, 2013 Author Share Posted January 14, 2013 Started the upgrade, I get this error message: [Ajax / Server Error] textStatus: "error" errorThrown:"Internal Server Error" jqXHR: "" Link to comment Share on other sites More sharing options...
DWMartin Posted January 14, 2013 Author Share Posted January 14, 2013 Found a workaround for that. Link to comment Share on other sites More sharing options...
DWMartin Posted January 15, 2013 Author Share Posted January 15, 2013 Upgrading from 1.4.4 to 1.4.9 to 1.5.3 still produces the problem. Link to comment Share on other sites More sharing options...
ieftin-net Posted January 20, 2013 Share Posted January 20, 2013 Found a workaround for that. how did you fix the ajax error while upgrading? Link to comment Share on other sites More sharing options...
DWMartin Posted January 21, 2013 Author Share Posted January 21, 2013 I'm afraid I don't recall. It wasn't anything particularly fiddly though. Link to comment Share on other sites More sharing options...
DWMartin Posted January 22, 2013 Author Share Posted January 22, 2013 I've performed a manual upgrade and the problem persists Link to comment Share on other sites More sharing options...
DWMartin Posted February 5, 2013 Author Share Posted February 5, 2013 I've manually migrated the data over, seems to have stripped out any cruft that was causing the automatic & manual upgrades from borking, now I'm only left with the issue of category pages showing a price of zero. Link to comment Share on other sites More sharing options...
rossdavidh Posted February 18, 2013 Share Posted February 18, 2013 We just performed a similar upgrade, and it appears to only be a problem for items with a Sale price (i.e. discount). For ordinary items (no discount/sale) it shows ok. Is this similar to your situation? Link to comment Share on other sites More sharing options...
DWMartin Posted February 19, 2013 Author Share Posted February 19, 2013 It appears that our upgrade issues were caused by data left over from a previous upgrade attempt. I've manually ported the data over to a clean install that's about 99% complete. It does bother me that the prestashop upgrade isn't more resilient to database borkage :s Link to comment Share on other sites More sharing options...
xapinc Posted March 2, 2013 Share Posted March 2, 2013 Were you able to fix this problem? I also have my On Sale prices displaying 0.00 with tax and without tax. Link to comment Share on other sites More sharing options...
xapinc Posted March 2, 2013 Share Posted March 2, 2013 After hours trying to solve this problem I noticed that the following code <span id="our_price_display">{convertPrice price=$productPrice}</span> inside yourTheme/products.tpl aroud line 255, has a problem with span id="our_price_display". I deleted "our_price_display" and left it as <span id="">{convertPrice price=$productPrice}</span> and this solved the problem. Now I have to find that "our_price_display" and see how I can fix it so I can leave it the way it was. I will update tomorrow if possible. Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts