|
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.
|