Print Page | Close Window

Script errors on every page

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=5973
Printed Date: 29-June-2024 at 12:11pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com


Topic: Script errors on every page
Posted By: bp_travis
Subject: Script errors on every page
Date 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
*****************************
------------------------------------------------------



Replies:
Posted By: Greg Dinger
Date 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" rel="nofollow - http://wiki.productcart.com/how_to/show_raw_errors

With the raw errors, you might be able to see what's causing this.




-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |


Posted By: bp_travis
Date 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


Posted By: bp_travis
Date 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?


Posted By: Greg Dinger
Date Posted: 17-January-2015 at 5:49pm
Why would you remove include-metatags.asp from the header?  Yes, put it back in there. 

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |


Posted By: bp_travis
Date 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. 


Posted By: Greg Dinger
Date 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.

-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |


Posted By: bp_travis
Date 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. 


Posted By: bp_travis
Date 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. 


Posted By: Greg Dinger
Date 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" rel="nofollow - 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.



-------------
GreyBeard Design Group

Certified ProductCart Developer

Web Design/Development/Hosting

http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |


Posted By: bp_travis
Date Posted: 19-January-2015 at 4:13pm
Thanks for your assistance. I figured out the problem. It helps if you use the correct version of the file for the version of ProductCart you are using. 



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.04 - http://www.webwizforums.com
Copyright ©2001-2021 Web Wiz Ltd. - https://www.webwiz.net