Script errors on every page

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello. After attempting to modify my include-metatags.asp file, making a mistake and then restoring the file back to its original form, all my store pages are giving errors like this:My Site: http://www.barkleigh.com/store/pc/home.asp

------------------------------------------------------
* Error At 1/17/2015 11:59:34 AM
* CustomerRefID: 345758610-115934
* Session ID: 345758610
* Error Number: 13
* Error Source: Microsoft VBScript runtime error
* Error Description: Type mismatch
* Last Query: SELECT distinct products.idProduct,products.sku,products.description,products.smallImageUrl FROM products,categories_products,categories WHERE products.active=-1 AND products.hotdeal=-1 AND products.configOnly=0 AND products.removed=0 AND formQuantity=0 AND categories_products.idProduct=products.idProduct AND categories.idCategory=categories_products.idCategory AND categories.iBTOhide=0 AND categories.pccats_RetailHide=0 ORDER BY products.description Asc
* RequestMethod: GET
* ServerPort: 80
* HTTPS: off
* LocalAddr: 66.216.170.72
* HostAddress :75.151.181.198
* UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2050.0 Iron/38.0.2150.0 Safari/537.36
* URL: /store/pc/home.asp
* FormData: 
* HTTP Headers: 
*****************************
HTTP_CONNECTION:keep-alive
HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_ACCEPT_ENCODING:gzip,deflate,sdch
HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.8
HTTP_COOKIE:SavedCartGUID=66BD7EBA%2D3B03%2D4582%2DBB5D%2D7DA30877CEDA; _ga=GA1.2.34278784.1357852281; PHPSESSID=f337b2f1ab16b7707563009eb3cd4ec1; ASPSESSIONIDCADSSQCA=NEIIACKBGBIMLOMFJIILLLNP; ASPSESSIONIDASARSSDA=FFMHKOJBIDOEMGLBHONMEMDD; ASPSESSIONIDCQCATQSB=JMHLOFDCCMBAAJMDBHEBGDFN; ASPSESSIONIDASABRRQD=AMAJNNGCOMAAOJPDDMDMMBJH; ASPSESSIONIDAQSSTRTC=NPMPEKKACLECLDEICEJDMFHG; ASPSESSIONIDQSBADRRR=HMJFDBLCCKPCAIFOILDOAHEH; ASPSESSIONIDAARRRQRB=JLPFKLODDADOHCJOOGHCHNNA; ASPSESSIONIDACSQRQSC=PDGFDIMDHDIIFBAMEHKMKPNB; ASPSESSIONIDSAQRSTQC=OOKDBENBHGBCDINKEHFNHIFL; ASPSESSIONIDAQQRRQRA=ECLPGNBBENCDAPLCKJNIKECC; pcfront%5FvisitedPrds=%2A1893%2A60%2A56%2A129%2A128%2A; ASPSESSIONIDACQBCTQR=FOBMGAPDDLHKACCHNHFMDNMK; __utma=25362222.34278784.1357852281.1421367329.1421510856.673; __utmc=25362222; __utmz=25362222.1421367329.672.288.utmcsr=Listrak|utmccn=Read%20Pet%20Boarding%20and%20Daycare%20Online%20-%20Jan/Feb|utmcmd=Email|utmctr=http://www.petboardinganddaycare.com; ASPSESSIONIDCCTBBTSQ=IJGHIGEBKJPBCBMAJOHEFAIO; ASPSESSIONIDACTCATTR=CJLNLJEBJMHLIPIJLAABLDPN
HTTP_HOST:www.barkleigh.com
HTTP_REFERER:http://www.barkleigh.com/store/pc/viewCategories.asp?idCategory=194
HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2050.0 Iron/38.0.2150.0 Safari/537.36
*****************************
------------------------------------------------------

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
bp_travis Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-June-2008 Status: Offline Points: 8	Post Options Post Reply Quote bp_travis Report Post Thanks(0) Quote Reply Topic: Script errors on every page Posted: 17-January-2015 at 12:00pm
	Hello. After attempting to modify my include-metatags.asp file, making a mistake and then restoring the file back to its original form, all my store pages are giving errors like this: My Site: http://www.barkleigh.com/store/pc/home.asp ------------------------------------------------------ * Error At 1/17/2015 11:59:34 AM * CustomerRefID: 345758610-115934 * Session ID: 345758610 * Error Number: 13 * Error Source: Microsoft VBScript runtime error * Error Description: Type mismatch * Last Query: SELECT distinct products.idProduct,products.sku,products.description,products.smallImageUrl FROM products,categories_products,categories WHERE products.active=-1 AND products.hotdeal=-1 AND products.configOnly=0 AND products.removed=0 AND formQuantity=0 AND categories_products.idProduct=products.idProduct AND categories.idCategory=categories_products.idCategory AND categories.iBTOhide=0 AND categories.pccats_RetailHide=0 ORDER BY products.description Asc * RequestMethod: GET * ServerPort: 80 * HTTPS: off * LocalAddr: 66.216.170.72 * HostAddress :75.151.181.198 * UserAgent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2050.0 Iron/38.0.2150.0 Safari/537.36 * URL: /store/pc/home.asp * FormData: * HTTP Headers: ***************************** HTTP_CONNECTION:keep-alive HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,/;q=0.8 HTTP_ACCEPT_ENCODING:gzip,deflate,sdch HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.8 HTTP_COOKIE:SavedCartGUID=66BD7EBA%2D3B03%2D4582%2DBB5D%2D7DA30877CEDA; _ga=GA1.2.34278784.1357852281; PHPSESSID=f337b2f1ab16b7707563009eb3cd4ec1; ASPSESSIONIDCADSSQCA=NEIIACKBGBIMLOMFJIILLLNP; ASPSESSIONIDASARSSDA=FFMHKOJBIDOEMGLBHONMEMDD; ASPSESSIONIDCQCATQSB=JMHLOFDCCMBAAJMDBHEBGDFN; ASPSESSIONIDASABRRQD=AMAJNNGCOMAAOJPDDMDMMBJH; ASPSESSIONIDAQSSTRTC=NPMPEKKACLECLDEICEJDMFHG; ASPSESSIONIDQSBADRRR=HMJFDBLCCKPCAIFOILDOAHEH; ASPSESSIONIDAARRRQRB=JLPFKLODDADOHCJOOGHCHNNA; ASPSESSIONIDACSQRQSC=PDGFDIMDHDIIFBAMEHKMKPNB; ASPSESSIONIDSAQRSTQC=OOKDBENBHGBCDINKEHFNHIFL; ASPSESSIONIDAQQRRQRA=ECLPGNBBENCDAPLCKJNIKECC; pcfront%5FvisitedPrds=%2A1893%2A60%2A56%2A129%2A128%2A; ASPSESSIONIDACQBCTQR=FOBMGAPDDLHKACCHNHFMDNMK; __utma=25362222.34278784.1357852281.1421367329.1421510856.673; __utmc=25362222; __utmz=25362222.1421367329.672.288.utmcsr=Listrak\|utmccn=Read%20Pet%20Boarding%20and%20Daycare%20Online%20-%20Jan/Feb\|utmcmd=Email\|utmctr=http://www.petboardinganddaycare.com; ASPSESSIONIDCCTBBTSQ=IJGHIGEBKJPBCBMAJOHEFAIO; ASPSESSIONIDACTCATTR=CJLNLJEBJMHLIPIJLAABLDPN HTTP_HOST:www.barkleigh.com HTTP_REFERER:http://www.barkleigh.com/store/pc/viewCategories.asp?idCategory=194 HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/38.0.2050.0 Iron/38.0.2150.0 Safari/537.36 ***************************** ------------------------------------------------------

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 17-January-2015 at 12:15pm
	Well, I'm going to speculate that you either didn't get the file restored as you think you did, or that something else got changed. You need to follow this procedure to get the raw error messages to display http://wiki.productcart.com/how_to/show_raw_errors With the raw errors, you might be able to see what's causing this.

bp_travis Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-June-2008 Status: Offline Points: 8	Post Options Post Reply Quote bp_travis Report Post Thanks(0) Quote Reply Posted: 17-January-2015 at 12:24pm
	Commented out on error resume next in the opendb file and the same errors persist: http://www.barkleigh.com/store/pc/home.asp Could it be a server-side issue? It's IIS 7.5

bp_travis Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-June-2008 Status: Offline Points: 8	Post Options Post Reply Quote bp_travis Report Post Thanks(0) Quote Reply Posted: 17-January-2015 at 12:25pm
	I should also add I removed include-metatags.asp from the include in header.asp, so that file may not be the culprit?

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 17-January-2015 at 5:49pm
	Why would you remove include-metatags.asp from the header? Yes, put it back in there.

bp_travis Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-June-2008 Status: Offline Points: 8	Post Options Post Reply Quote bp_travis Report Post Thanks(0) Quote Reply Posted: 17-January-2015 at 6:11pm
	I simply removed it to test since that was the last file I edited (include-metatags.asp) before the problem started. I plan on putting it back in. Regardless, after removing it from the header, the problem still exists.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 19-January-2015 at 10:57am
	You need to do as I suggested above, and alter the settings to reveal raw errors. Or submit a support ticket or hire a developer. Nothing else can happen here in the forum without knowing the actual error.

bp_travis Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-June-2008 Status: Offline Points: 8	Post Options Post Reply Quote bp_travis Report Post Thanks(0) Quote Reply Posted: 19-January-2015 at 11:20am
	I did turn on raw errors like the article describes (opendb.asp file) and I see no difference in the error that is shown on the pages. I even added a On error goto 0 section to home.asp, but then it just gives a 500 server error. What am I missing to turn on raw errors? I also misspoke before - I'm using IIS 8.5, not 7.5.

bp_travis Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27-June-2008 Status: Offline Points: 8	Post Options Post Reply Quote bp_travis Report Post Thanks(0) Quote Reply Posted: 19-January-2015 at 11:41am
	Ok. Small update. I was editing the wrong section of opendb.asp. However, after I commented out the correct on error resume next, I get a 500 internal server error and it doesn't show anything else.

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 19-January-2015 at 11:45am
	Work with your host to temporarily alter the following setting to TRUE. See if that works. http://my.jetscreenshot.com/22490/20150119-nejy-45kb It's probably going to be a lot easier/faster if you engage me, become a client, and give me access to the site and to your host. I have a file that can be introduced to the site, with the appropriate IIS settings, that will force the system to display errors. Once that done, I have the application knowledge to push this to a hasty conclusion.