Your Cart

Shopping Cart Items: 0   Sub-Total : $0.00    View Cart    Checkout
Welcome, Guest ( Customer Panel | Login )


Home | Profile | Register | Active Topics | Members | Search | FAQ


Forgot your Password?
 All Forums
 VPCart Forum
 Problems and bugs
 TIME error in Tracking & RMA (MySQL)		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AftrBrnr
Starting Member

32 Posts
Posted - November 12 2008 :  11:57:56  Show Profile  Reply with Quote
I get this error when trying to add an RMA or respond to Tracking when logged in as a Customer (via 'Account'):


Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]Incorrect time value: '11:27:07 AM' for column 'tracktime' at row 1 

/shop/shopcusttracking.asp, line 178



Thanks in advance for any help you can offer!
AftrBrnr

AftrBrnr
Starting Member

32 Posts
Posted - November 12 2008 :  15:00:12  Show Profile  Reply with Quote
I managed to fix this myself.

I replaced this line:


sql= sql & "," & timedelimit(time())


with this one


sql= sql & "," & timedelimit(formatdatetime(time(),vbshorttime))


..in the following files:

shopa_rma.asp
shopa_trackingorder.asp
shopcusttracking.asp
shoprma.asp

-AftrBrnr
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000
0 Item(s)
$0.00
  • Your Cart Is Empty