Hello,
I have a PC 4.0 PPD install.
Recently I have an issue when I go to index the images. the pcImageDirectory deletes all the content.
The error message is the following when I hit the index now button.
------------------------------------------------------
* Error At 10/4/2011 11:13:02 AM
* CustomerRefID: 419945523-11132
* Session ID: 419945523
* Error Number: - tel:2147217900" rel="nofollow - 2147217900
* Error Source: Microsoft OLE DB Provider for SQL Server
* Error Description: Incorrect syntax near ':'.
*
Last Query: INSERT INTO pcImageDirectory
(pcImgDir_Name,pcImgDir_Type,pcImgDir_Size,pcImgDir_DateUploaded,pcImgDir_DateIndexed)
VALUES(''from rcgt 2010.jpg'',''JPEG Image'',13356,''10-02-2011
20:55:00'',''10-04-2011 11:13:02'')
* RequestMethod: GET
* ServerPort: 80
* HTTPS: off
* LocalAddr: 64.254.158.58
* HostAddress :208.85.113.171
*
UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.2.23)
Gecko/20110920 Firefox/3.6.23 ( .NET CLR 3.5.30729; .NET4.0E)
* URL: /catalogue/pc/imageDir.asp
* FormData:
* HTTP Headers:
*****************************
HTTP_CONNECTION:keep-alive
HTTP_KEEP_ALIVE:115
HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING:gzip,deflate
HTTP_ACCEPT_LANGUAGE:en-us,en;q=0.5
HTTP_COOKIE:__ptca=48262649.PIFJFZXYDVoY.1315503878.1317334647.1317342400.13;
__ptv_0M64xC=PIFJFZXYDVoY; __pti_0M64xC=id:48323;
__ptcz=48262649.1309199381.1.0.ptmcsr=(direct)|ptmcmd=(none)|ptmccn=(direct);
cem_profile=user_id=0eccfb02acf74524a3af55a634a6b;
pcfront%5FvisitedPrdsCP=%2A69%2A68%2A67%2A16%2A;
pcfront%5FvisitedPrds=%2A68%2A67%2A16%2A; __ptcc=1;
ASPSESSIONIDCARARRAT=GOEJHKIBEGAICOKMFOBEJJAI;
multiplewidgets=true,true,true,true; sifrFetch=true;
ASPSESSIONIDACTCTTDR=DDMNHAJBIJMCBFANHICFFHDB
HTTP_HOST:xxx.xxx.xxx
HTTP_REFERER: http://spasso.genclik.ca/catalogue/pc/imageDir.asp?ffid=smallImageUrl&fid=hForm" rel="nofollow - http:// - xxx.xxx.xxxcatalogue/pc/imageDir.asp?ffid=smallImageUrl&fid=hForm
HTTP_USER_AGENT:Mozilla/5.0
(Windows; U; Windows NT 6.0; en-US; rv:1.9.2.23) Gecko/20110920
Firefox/3.6.23 ( .NET CLR 3.5.30729; .NET4.0E)
Any ideas?
|