https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 06:01:16 +0000 Thu, 06 Oct 2011 15:17:16 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=4779 https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ https://forum.productcart.com/catalog-directory-indexing-error_topic4779_post18452.html#18452 Author: bcrabtree
Subject: 4779
Posted: 06-October-2011 at 3:17pm

Anyone?]]> Thu, 06 Oct 2011 15:17:16 +0000 https://forum.productcart.com/catalog-directory-indexing-error_topic4779_post18452.html#18452 https://forum.productcart.com/catalog-directory-indexing-error_topic4779_post18442.html#18442 Author: bcrabtree
Subject: 4779
Posted: 05-October-2011 at 9:43pm

Hi,

I'm getting the following error when I try to index my catalog folder:
Source: Microsoft SQL Server Native Client 10.0
Description: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
query=INSERT INTO pcImageDirectory (pcImgDir_Name,pcImgDir_Type,pcImgDir_Size,pcImgDir_DateUploaded,pcImgDir_DateIndexed) VALUES('BBOOB-ISSO-AVC_LI.jpg','JPEG image',92468,'26/8/2011 6:50:07 PM','5/10/2011 6:50:07 PM')
Request Method: GET
URL: /shop/pc/imageDir.asp


I recently transferred my site to a new host, so I thought it might be related, but I tried the same thing on the old host which is still up and running and I received the same error.

I haven't touched any files on the old host in probably six months, besides uploading the security update that was released last month...


Here is what my current host had to say about the error:
The database column is set to (datetime , null) the varchar is being converted to the datatime datatype,
The issue might stem from the inclusion of the 'PM' chars in the string,
The MS documentation for the datatype indicates that times that are specific to the second need to be in 24 hour format,

The error that you are receiving is due to a datatype mismatch, this is inherent in the definition of the database tables and not something that is a server variable.
I have attached a screen shot of the table in question so that you can check and ensure that the data types that are in the table are the ones that you have intended.



Can anyone help me out with this?

Thanks.

]]> Wed, 05 Oct 2011 21:43:27 +0000 https://forum.productcart.com/catalog-directory-indexing-error_topic4779_post18442.html#18442