[FIX] SQL Error to convert Varchar in Datetime

[julianinou]

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:

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

If the result is :

1 . Dateformat: mdy

then everything is good if the result is :

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*

[sony65]

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

[[Dev]Viking]

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!

[julianinou]

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

[AgustinWoW]

doesnt work for me :V

[julianinou]

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

[AgustinWoW]

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

[julianinou]

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?

[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

[st.jimmy998]

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

[AgustinWoW]

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

[julianinou]

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

[AgustinWoW]

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

[Raziel166]

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

a thank you would be enough xD
I'm kidding! aaa!!!