type mismatch error on viewcategories

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

We are migrating our ProductCart store from a GoDaddy virtual dedicated server to a dedicated hardware server at another provider. I copied all the site folders. I backed up the database on GoDaddy, transferred the BAK file to the new one, and restored it. Recreated the SQL login on the new server and assigned its permissions. I can access the control panel fine, and the home page displays fine, as do individual products when clicked from the home page. But if I click on the left-column navigation to view by category, I get the following:

* Error At 8/11/2009 10:33:18 AM
* CustomerRefID: 209320041-103318
* Session ID: 209320041
* Error Number: 13
* Error Source: Microsoft VBScript runtime error
* Error Description: Type mismatch
* Last Query: Select POrder from categories_products where idCategory=1;
* RequestMethod: GET
* ServerPort: 80
* HTTPS: off
* LocalAddr: 74.86.175.237
* HostAddress :98.23.104.113
* UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)
* URL: /cart/pc/viewCategories.asp
* FormData: 
* HTTP Headers: 
*****************************
HTTP_CONNECTION:Keep-Alive
HTTP_ACCEPT:*/*
HTTP_ACCEPT_ENCODING:gzip, deflate
HTTP_ACCEPT_LANGUAGE:en-us
HTTP_COOKIE:__utmc=247316761; __utma=247316761.1021540808.1204376273.1249999825.1250000138.409; __utmz=247316761.1250000138.409.9.utmcsr=softlayer.leisureartslibrary.com|utmccn=(referral)|utmcmd=referral|utmcct=/cart/pc/home.asp; ASPSESSIONIDCARCQSDQ=DEPFIHLAJAJKLEDPGGCAPOGA; __utma=210458135.3870723172161608700.1249915978.1249915978.1249998041.2; __utmz=210458135.1249915978.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); ASPSESSIONIDAASAQTDQ=GPBDGKLAKAPIOEBKEBCMDGHJ; __utmc=210458135; ASPSESSIONIDACQCQSDQ=DDIHFLLALIFJENACHBMGHAJP; ASPSESSIONIDCASCSQDQ=BCOJDMLABPOFAKKHNPJMJCEB; pcfront%5FvisitedPrds=%2A1260%2A; ASPSESSIONIDAATDSQDR=CDIDCFMABCJCGFGCANIIDMHC; ASPSESSIONIDACSBQTCQ=LKNLPFMACFGKECNBEAIEDNFN
HTTP_HOST:softlayer.leisureartslibrary.com
HTTP_REFERER:http://softlayer.leisureartslibrary.com/cart/pc/viewCategories.asp?idCategory=4
HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1)
HTTP_UA_CPU:x86
*****************************

I can go into SQL Server Management Studio on the web server and run the query directly without issue. I added some response.write statments in the 

'Query order 
query="Select POrder from categories_products where idCategory="& pIdCategory &";"

set rs=Server.CreateObject("ADODB.Recordset") 

set rs=connTemp.execute(query)

if err.number<>0 then

call LogErrorToDatabase()
set rs=nothing

call closedb()
response.redirect "techErr.asp?err="&pcStrCustRefID

end if

UONum=0
do while not rs.eof

if rs("POrder")<>"" then

UONum=UONum+CLng(rs("POrder"))

end if

rs.MoveNext
loop
SET rs=nothing

code block, and the error is coming up on the set rs=connTemp.execute(query) line.

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply Topic: type mismatch error on viewcategories Posted: 11-August-2009 at 11:50am
	We are migrating our ProductCart store from a GoDaddy virtual dedicated server to a dedicated hardware server at another provider. I copied all the site folders. I backed up the database on GoDaddy, transferred the BAK file to the new one, and restored it. Recreated the SQL login on the new server and assigned its permissions. I can access the control panel fine, and the home page displays fine, as do individual products when clicked from the home page. But if I click on the left-column navigation to view by category, I get the following: * Error At 8/11/2009 10:33:18 AM * CustomerRefID: 209320041-103318 * Session ID: 209320041 * Error Number: 13 * Error Source: Microsoft VBScript runtime error * Error Description: Type mismatch * Last Query: Select POrder from categories_products where idCategory=1; * RequestMethod: GET * ServerPort: 80 * HTTPS: off * LocalAddr: 74.86.175.237 * HostAddress :98.23.104.113 * UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) * URL: /cart/pc/viewCategories.asp * FormData: * HTTP Headers: ***************************** HTTP_CONNECTION:Keep-Alive HTTP_ACCEPT:/ HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:en-us HTTP_COOKIE:__utmc=247316761; __utma=247316761.1021540808.1204376273.1249999825.1250000138.409; __utmz=247316761.1250000138.409.9.utmcsr=softlayer.leisureartslibrary.com\|utmccn=(referral)\|utmcmd=referral\|utmcct=/cart/pc/home.asp; ASPSESSIONIDCARCQSDQ=DEPFIHLAJAJKLEDPGGCAPOGA; __utma=210458135.3870723172161608700.1249915978.1249915978.1249998041.2; __utmz=210458135.1249915978.1.1.utmcsr=(direct)\|utmccn=(direct)\|utmcmd=(none); ASPSESSIONIDAASAQTDQ=GPBDGKLAKAPIOEBKEBCMDGHJ; __utmc=210458135; ASPSESSIONIDACQCQSDQ=DDIHFLLALIFJENACHBMGHAJP; ASPSESSIONIDCASCSQDQ=BCOJDMLABPOFAKKHNPJMJCEB; pcfront%5FvisitedPrds=%2A1260%2A; ASPSESSIONIDAATDSQDR=CDIDCFMABCJCGFGCANIIDMHC; ASPSESSIONIDACSBQTCQ=LKNLPFMACFGKECNBEAIEDNFN HTTP_HOST:softlayer.leisureartslibrary.com HTTP_REFERER:http://softlayer.leisureartslibrary.com/cart/pc/viewCategories.asp?idCategory=4 HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) HTTP_UA_CPU:x86 ***************************** I can go into SQL Server Management Studio on the web server and run the query directly without issue. I added some response.write statments in the 'Query order query="Select POrder from categories_products where idCategory="& pIdCategory &";" set rs=Server.CreateObject("ADODB.Recordset") set rs=connTemp.execute(query) if err.number<>0 then call LogErrorToDatabase() set rs=nothing call closedb() response.redirect "techErr.asp?err="&pcStrCustRefID end if UONum=0 do while not rs.eof if rs("POrder")<>"" then UONum=UONum+CLng(rs("POrder")) end if rs.MoveNext loop SET rs=nothing code block, and the error is coming up on the set rs=connTemp.execute(query) line.

BrianRoden Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 07-September-2007 Status: Offline Points: 0	Post Options Post Reply Quote BrianRoden Report Post Thanks(0) Quote Reply Posted: 14-August-2009 at 12:08pm
	Figured it out. On the old server, other apps using adovb.inc were causing multiple definition of constants, so we had a zero-length stub file with this name. When we replaced it with the regular file, the error went away.