metainfo returning error

Author	« Topic »
pdraper Advanced Member New Zealand 160 Posts Pre-sales questions only (More Details...)	Posted - 08/03/2018 : 19:33:43 Ok for some reason I have just started getting this Microsoft VBScript runtime error '800a005e' Invalid use of Null /vsadmin/inc/metainfo.asp, line 89 6.9.4 MSSQL Paul
pdraper Advanced Member New Zealand 160 Posts Pre-sales questions only (More Details...)	Posted - 08/03/2018 : 19:35:39 Seems to be only on proddetails page If I remove the metainfo page its ok with the exception that the pagetitle etc doesnt work Paul Edited by - pdraper on 08/03/2018 19:37:48
Vince Administrator 42874 Posts	Posted - 08/04/2018 : 03:23:05 Hi Paul To get that error on that line you would have to have a NULL value for the imageSrc column in the productimages table. In normal use this situation shouldn't arise as the imageSrc column does not allow NULL's. Is this something you can fix? Do you know how it might have got like this? If not, please let me know. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
pdraper Advanced Member New Zealand 160 Posts Pre-sales questions only (More Details...)	Posted - 08/04/2018 : 13:26:24 Hey Vince, Hope you are well. I have checked the db columns and this happens on products even with an image. In relation to null I cant find any in the db. However the omages are pointing to another site so the image links are http://imagesource...... Not sure if that makes any difference? Regards Paul Edited by - pdraper on 08/04/2018 15:04:51
Vince Administrator 42874 Posts	Posted - 08/04/2018 : 16:20:43 Hi Paul That's strange then as those lines in the metainfo.asp script just deal with the imageSrc column in the productimages database. Can you send the site FTP login to my email (vince AT ecommercetemplates DOT com) and I'll have a look. Please include details of how to reproduce if necessary. Vince Click Here for Shopping Cart Software Click Here to sign up for our newsletter Click Here for the latest updater
pdraper Advanced Member New Zealand 160 Posts Pre-sales questions only (More Details...)	Posted - 08/04/2018 : 18:05:31 Sent To reproduce just go to the prodetails page This one I know without a doubt has a picture nztdev.managemyweb.nz/proddetail.asp?prod=35110 Paul Edited by - pdraper on 08/04/2018 18:07:19
pdraper Advanced Member New Zealand 160 Posts Pre-sales questions only (More Details...)	Posted - 08/28/2018 : 17:00:42 So I have now narrowed down the offending bit of code. Line 87 to 90 if instr(detailpagelayout,"socialmedia")>0 then rs.open "SELECT "&IIfVs(NOT mysqlserver,"TOP 1 ")&"imageSrc FROM productimages WHERE imageProduct='" & mi_escape_string(productid) & "' AND imageType IN (0,1" & IIfVs(usegiantogimage,",2") & ") ORDER BY imageType DESC,imageNumber" & IIfVs(mysqlserver," LIMIT 0,1"),cnn,0,1 if NOT rs.EOF then metaogimage="<meta property=""og:image"" content=""" & IIfVs(instr(rs("imageSrc"),"://")=0,storeurl) & IIfVr(left(rs("imageSrc"),1)="/",right(rs("imageSrc"),len(rs("imageSrc"))-1),rs("imageSrc")) & """ />" else metaogimage="" end if Invalid use of Null If I remove this out the rest of it work perfectly. So I thought it might be because I didnt have a giant image. Placed one in and response still the same. Paul
	« Topic »