Catalog Directory Indexing Error
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4779
Printed Date: 06-March-2025 at 12:30pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Catalog Directory Indexing Error
Posted By: bcrabtree
Subject: Catalog Directory Indexing Error
Date 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. |
Replies:
Posted By: bcrabtree
Date Posted: 06-October-2011 at 3:17pm
| Anyone? |