|
You last visited: Today at 01:56
Advertisement
Error Convert varchar in datetime
Discussion on Error Convert varchar in datetime within the Shaiya PServer Development forum part of the Shaiya Private Server category.
03/19/2015, 12:49
|
#1
|
elite*gold: 0 
Join Date: Aug 2009
Posts: 13
Received Thanks: 0
|
Error Convert varchar in datetime
Bonjour
Error Log (query=EXEC usp_Insert_Action_Log_E):
Code:
2015-03-19 12:39:14 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Erreur de conversion du type de données varchar en int., SQL STATE: 42000, NATIVE ERROR: 8114 (0x1FB2)
2015-03-19 12:39:14 DBWrite::LogGame: err=-1, query=EXEC usp_Insert_Action_Log_E 'test',1,1,'test', 70,390007982,0, 1873.809692,14.679998,351.206665, '2015-03-19 12:39:14' ,114, 4388416769224671232,36196,0,1,62100,1993293200,NULL,NULL,NULL,NULL,'Chaussures Syrons','0,0,0,0,0,0 (Option:00000000000000000000)','2015-03-19 12:39:13','bag=1,slot=0'
Insert manual OK:
Code:
'test',1,1,'test', 70,390007982,0, 1873.809692,14.679998,351.206665, '20150319 11:45:44' ,114, 4388400955155087360,36196,0,1,62100,1996087700,NULL,NULL,NULL,NULL,'Chaussures Syrons','0,0,0,0,0,0 (Option:00000000000000000000)','2015-03-19 11:45:43','bag=1,slot=0'
When insert var Actiontime without - its ok.
How to fix that please?
|
|
|
|
03/24/2015, 01:46
|
#2
|
elite*gold: 0
Join Date: Aug 2009
Posts: 13
Received Thanks: 0
|
install sql server in english
|
|
|
|
|
03/24/2015, 10:20
|
#3
|
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,455
|
Check the date time format in the control panel.
|
|
|
|
 |
Similar Threads
|
[FIX] SQL Error to convert Varchar in Datetime
04/12/2016 - Shaiya PServer Guides & Releases - 13 Replies
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:
|
Varchar to datetime error
06/19/2013 - Shaiya PServer Development - 5 Replies
Hi, everyone... to the point.... I'm having some problems with mi warehouse and item mall, all the problems are because varchar cannot convert into datetime (I THINK) and I'm getting sick of searching in others post because anything works :( so... here are my logs.
Hope somebody could help me... please please :handsdown:
If somebody knows how to fix this, I'll be grateful if he explains me detailed and sloooooooowly please :p
PS_GAME__system log start (Game01)
2013-06-18 22:30:05...
|
[Error]Cannot convert to INT from Edited
02/10/2011 - Dekaron Private Server - 2 Replies
Hey,i've been trying to do a test server for me to learn a little dev things...but i got the next error :
http://img641.imageshack.us/img641/743/error1a.jp g
I dont know what to do...can someone give me a tip or something?
|
[ERROR]Can't convert to int
02/28/2010 - Dekaron Private Server - 3 Replies
I have been trying to edit the exp in the monster.csv file but now I keep getting this error :
http://img3.imageshack.us/img3/6346/errorkw.th.jp g
any idea what could be wrong?
here is the monster.csv if you want to see it...monster.csv
|
[HELP] Datetime error
06/23/2009 - CO2 Private Server - 0 Replies
Ok im geting this error when i try to load 10 expballs per day here it is http://img188.imageshack.us/img188/8279/erroryfn.p ng
|
All times are GMT +1. The time now is 01:57.
|
|
