Problem with pcImageDirectory table

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

   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: -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://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?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
genclik Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 12-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote genclik Report Post Thanks(0) Quote Reply Topic: Problem with pcImageDirectory table Posted: 06-October-2011 at 5:30pm
	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: -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://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?

genclik Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 12-November-2008 Status: Offline Points: 0	Post Options Post Reply Quote genclik Report Post Thanks(0) Quote Reply Posted: 06-October-2011 at 5:30pm
	enabling email notify