[FIX] SQL Error to convert Varchar in Datetime

01/31/2014 10:28 julianinou#1

Hi many guys asked me why they were getting in their log, the SQL error: error to convert "Varchar in Datetime", so i took a look on EPvPers and i didn't see (maybe i'm wrong o.o) any post with the problem solved.

It happens with Warehouse dcing when trying to store items or the notice board !

It's not really a Fix but more a specific attention to pay on SQL configurations.

SQL maybe tried to save the datas in a wrong date format !

To check if you're in this case, run the next query:

Code:

SELECT 'dateformat: ' + date_format FROM sys.dm_exec_sessions WHERE session_id = @@spid

If the result is :

Code:

1 . Dateformat: mdy

then everything is good if the result is :

Code:

1. Dateformat: dmy

Wrong format, just follow the instructions.

1: Go to your Database properties
2: Advenced page
3: Check your "default language" and select : us_english or English but not British_english

Found it by my self and i hope it'll help you in your development !

*Greetings*

04/16/2014 23:25 sony65#2

The error stay, because i have install french SQL 2005 version and when i change in advanced, 0 result, my error 0 stay ..

08/27/2015 10:49 [Dev]Viking#3

Thanks you!! Work to me!!! this was unique solution for me Error 0 from Item mall!!
Me server working 2 month fine,but I change anything and before had error 0 buying in item mall!

01/19/2016 05:50 julianinou#4

I'm a bit late to reply, i was just taking a look around there and i forgot to say if the errors still appear you just have to uninstall your french version of MSSQL 2005 and install an english version ;)

01/22/2016 21:40 AgustinWoW#5

doesnt work for me :V

01/23/2016 01:54 julianinou#6

English version and keep the same format? Or Date format won't change?

01/23/2016 02:05 AgustinWoW#7

my date is ok but i still geting error convert varchar in datetime :VV

01/23/2016 19:37 julianinou#8

Well my knowledge is a bit low to help more bro :/ But what are you trying to do or what did you do before getting that error? Items stored in warehouse? Item mall? Item stored in Notice Board?

01/24/2016 02:29 AgustinWoW#9

i have item mall error 10053 in ep 6.3 (is like error 0) and when i saw the logs i see error to converter varchar to datetame so i think that it is the problem =P
sorry for my bad english

and yes my date format is dmy

01/24/2016 03:20 st.jimmy998#10

Quote:

Originally Posted by AgustinWoW

i have item mall error 10053 in ep 6.3 (is like error 0) and when i saw the logs i see error to converter varchar to datetame so i think that it is the problem =P
sorry for my bad english

and yes my date format is dmy

you're using SQL in Spanish? If you do, install English version

01/24/2016 18:34 AgustinWoW#11

yes im using the spanish and i�ve used it before to do a ep 6.3 and item mall works before ... and recently idk i have error 10053 item mall ....
i will go to try with the english version

01/27/2016 19:32 julianinou#12

Yeah better try the english version sometimes it seems like to be different on 2 Servers with same stuff and same config

04/11/2016 17:59 AgustinWoW#13

i installed english version and i have wrong format
the lenguage is in english

04/12/2016 09:33 Raziel166#14

Quote:

Originally Posted by AgustinWoW

i installed english version and i have wrong format
the lenguage is in english

that happens because your pc or where you're setting up your server.
It is in the language and format in Spanish so I advise you to install your windows in English otherwise your will continue with error

also you can try this with the sql in Spanish
[Only registered and activated users can see links. Click Here To Register...]
a thank you would be enough xD :D
I'm kidding! aaa!!!