I never resolved the issue of why when updating from 7.4.6 to 7.4.7 the site was getting 500 errors (see https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=114645), so I just left it on 7.4.6.
While updating to 7.4.8, I ran into the same problem, product page throwing 500 error as were a couple of static category pages. Everything else worked fine, cart, proddetail, and so on, as did adding items to cart. After double and triple checking that there were no modifications to the site, I compared the 7.4.6 incproducts.asp file to the 7.4.7 and 7.4.8 versions and found this difference.
In 7.4.6 from line 562 to 565 there is this:
wantmanufacturer=instr(productpagelayout&quickbuylayout,"manufacturer")>0 OR (useproductbodyformat=3 AND instr(cpdcolumns, "manufacturer")>0) OR ((NOT usecsslayout OR useproductbodyformat<>2) AND xxManLab<>"") OR googletagid<>""
sSQL="SELECT pId,pSKU,"&getlangid("pName",1)&","&WSP&"pPrice,pListPrice,pSection,pSell,pStockByOpts,pStaticPage,pStaticURL,pInStock,pExemptions,pTax,pTotRating,pNumRatings,pBackOrder,pCustomCSS,pCustom1,pCustom2,pCustom3,pDateAdded,pMinQuant,pSchemaType,"&IIfVr(wantmanufacturer,getlangid("scName",131072)&",","")&IIfVr(shortdescriptionlimit<>"" AND shortdescriptionlimit=0,"'' AS ","")&getlangid("pDescription",2)&","&getlangid("pLongDescription",4)&" FROM products "&IIfVr(wantmanufacturer,"LEFT OUTER JOIN searchcriteria on products.pManufacturer=searchcriteria.scID ","")&"WHERE pId IN (" & prodlist & ")" & sSortBy
rs.open sSQL, cnn, 0, 1
end if
In 7.4.7 and 7.4.8, it is now this, lines 562 to 570:
wantmanufacturer=instr(productpagelayout&quickbuylayout,"manufacturer")>0 OR (useproductbodyformat=3 AND instr(cpdcolumns, "manufacturer")>0) OR ((NOT usecsslayout OR useproductbodyformat<>2) AND xxManLab<>"") OR googletagid<>""
sSQL="SELECT pId,pSKU,"&getlangid("pName",1)&","&WSP&"pPrice,pListPrice,pSection,pSell,pStockByOpts,pStaticPage,"&getaltlang("pStaticURL",8388608)&",pInStock,pExemptions,pTax,pTotRating,pNumRatings,pBackOrder,pCustomCSS,"
templayoutarray=split(lcase(productpagelayout),",")
for each layoutoption in templayoutarray
if left(trim(layoutoption),6)="custom" then sSQL=sSQL&replace(layoutoption,"custom","pCustom")&","
next
sSQL=sSQL&"pDateAdded,pMinQuant,pSchemaType,"&IIfVr(wantmanufacturer,getlangid("scName",131072)&",","")&IIfVr(shortdescriptionlimit<>"" AND shortdescriptionlimit=0,"'' AS ","")&getlangid("pDescription",2)&","&getlangid("pLongDescription",4)&" FROM products "&IIfVr(wantmanufacturer,"LEFT OUTER JOIN searchcriteria on products.pManufacturer=searchcriteria.scID ","")&"WHERE pId IN (" & prodlist & ")" & sSortBy
rs.open sSQL, cnn, 0, 1
end if
I replaced the 7.4.8 inc/incproducts.asp with the 7.4.6 version and everything works fine. Since I uploaded all new files, I am not sure what could possibly be missing that would be affected by the addition five lines of code in v7.4.7 and 7.4.8. Also, I did not have this problem with the PHP version.
Thoughts?
Just discovered having same problem with search.asp when doing search. It returns a 500 error. Checked incsearch.asp and found difference in version 7.4.6 lines 327-331
rs.close
wantmanufacturer=(instr(productpagelayout&quickbuylayout,"manufacturer")>0 OR (useproductbodyformat=3 AND instr(cpdcolumns, "manufacturer")>0) OR (NOT usecsslayout AND xxManLab<>""))
sSQL="SELECT "&IIfVs(NOT nosearchrelevance,"0 AS relevanceorder,")&"pId,pSKU,"&getlangid("pName",1)&","&WSP&"pPrice,pListPrice,pSection,pSell,pStockByOpts,pStaticPage,pStaticURL,pInStock,pExemptions,pTax,pTotRating,pNumRatings,pBackOrder,pDateAdded,pMinQuant,pSchemaType,pCustomCSS,pCustom1,pCustom2,pCustom3,"&IIfVr(wantmanufacturer,getlangid("scName",131072)&",","")&IIfVr(shortdescriptionlimit<>"" AND shortdescriptionlimit=0,"'' AS ","")&getlangid("pDescription",2)&","&getlangid("pLongDescription",4)&" FROM products "&IIfVr(wantmanufacturer,"LEFT OUTER JOIN searchcriteria on products.pManufacturer=searchcriteria.scID ","")&"WHERE pId IN (" & prodlist & ")" & sSortBy
rs.open sSQL, cnn, 0, 1
end if
versus version 7.4.8 lines 327-336
rs.close
wantmanufacturer=(instr(productpagelayout&quickbuylayout,"manufacturer")>0 OR (useproductbodyformat=3 AND instr(cpdcolumns, "manufacturer")>0) OR (NOT usecsslayout AND xxManLab<>""))
sSQL="SELECT "&IIfVs(NOT nosearchrelevance,"0 AS relevanceorder,")&"pId,pSKU,"&getlangid("pName",1)&","&WSP&"pPrice,pListPrice,pSection,pSell,pStockByOpts,pStaticPage,"&getaltlang("pStaticURL",8388608)&",pInStock,pExemptions,pTax,pTotRating,pNumRatings,pBackOrder,pDateAdded,pMinQuant,pSchemaType,pCustomCSS,"
templayoutarray=split(lcase(productpagelayout),",")
for each layoutoption in templayoutarray
if left(trim(layoutoption),6)="custom" then sSQL=sSQL&replace(layoutoption,"custom","pCustom")&","
next
sSQL=sSQL&IIfVr(wantmanufacturer,getlangid("scName",131072)&",","")&IIfVr(shortdescriptionlimit<>"" AND shortdescriptionlimit=0,"'' AS ","")&getlangid("pDescription",2)&","&getlangid("pLongDescription",4)&" FROM products "&IIfVr(wantmanufacturer,"LEFT OUTER JOIN searchcriteria on products.pManufacturer=searchcriteria.scID ","")&"WHERE pId IN (" & prodlist & ")" & sSortBy
rs.open sSQL, cnn, 0, 1
end if
As with the incpoducts.asp files, I replaced the incsearch.asp file with version 7.4.6 and all works fine.
MarshallCENLYT Productions - ms designs
Affordable Web Design
Custom Ecommerce Designs
Responsive Websites
Cenlyt.com
Update 7.4.8 causing 500 error, same as 7.4.7
Posted - 04/17/2022 : 14:59:32
