|
You last visited: Today at 06:03
Advertisement
How to fix this database error?
Discussion on How to fix this database error? within the Flyff Private Server forum part of the Flyff category.
09/17/2016, 08:08
|
#1
|
elite*gold: 0 
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
How to fix this database error?
CQuery-LogFile_20160916
2016/09/16 22:32:12
query:uspLoggingTrade @pFlag=2, @  deID=1474083128, @ ndex='01', @ Player='0000045', @ mIndex='26536', @ mSerialNum=-664269262, @ mCnt=1, @ lityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=634903659985505280
SQLSTATE:22003 error:[Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type int.
2016/09/16 22:32:12
query:uspLoggingTrade @pFlag=2, @ deID=1474083128, @ ndex='01', @ Player='0000045', @ mIndex='26536', @ mSerialNum=-664269262, @ mCnt=1, @ lityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=634903659985505280
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]The statement has been terminated.
2016/09/16 22:32:12
query:LOG_ITEM_STR @im_szName='SharpShooter' @ rindex='01',@im_GetszName='CelestialBeing',@idwWor ldID=1,@im_dwGold=287924244,@im_nRemainGold=287924 244 @ em_UniqueNo=-1862750433 @ em_Name='23044' @ em_durability=50000,@im_nAbilityOption=0,@Im_Getdw Gold=683423550 @ em_count=1 @ te='T',@im_nSlot0=100,@im_nSlot1=100,@im_bItemResi st=0,@im_nResistAbilityOption=0,@im_bCharged=0,@im _dwKeepTime=0,@im_nRandomOptItemId=0,@inPiercedSiz e=0 @ wItemId0=0 @ wItemId1=0 @ wItemId2=0 @ wItemId3=0 @ wItemId4=0 @ Durability=0,@inPetKind=0,@inPetLevel=0,@idwPetExp =0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D=0,@inPet AL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_S=0 @ wItemId5=0 @ wItemId6=0 @ wItemId7=0 @ wItemId8=0 @ wItemId9=0 @ PiercedSize=0 @ wUMItemId0=0 @ wUMItemId1=0 @ wUMItemId2=0 @ wUMItemId3=0 @ wUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Native Client]Invalid cursor state
error_20160916
2016/ 9/16 22:32:12
\FLYFF FILES\Source\_Database\DbManagerLog.cpp, 1116: uspLoggingTrade @pFlag=2, @ deID=1474083128, @ ndex='01', @ Player='0000045', @ mIndex='26536', @ mSerialNum=-664269262, @ mCnt=1, @ lityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=634903659985505280
or anyone can share the link on how to fix this error
thanks in advance
|
|
|
|
09/17/2016, 14:27
|
#2
|
elite*gold: 18
Join Date: Sep 2009
Posts: 20,174
Received Thanks: 14,475
|
This is a bug with the datatype of RandomOpt in tblTradeItemLog.
Execute this once to fix it:
Code:
USE [LOGGING_01_DBF]
GO
ALTER TABLE [tblTradeItemLog] DROP CONSTRAINT [DF_tblTradeItemLog_RandomOpt]
GO
ALTER TABLE [tblTradeItemLog]
ALTER COLUMN [RandomOpt] BIGINT NOT NULL
GO
ALTER TABLE [dbo].[tblTradeItemLog] ADD CONSTRAINT [DF_tblTradeItemLog_RandomOpt] DEFAULT ((0)) FOR [RandomOpt]
GO
|
|
|
|
|
05/01/2018, 16:38
|
#3
|
elite*gold: 0
Join Date: Jan 2013
Posts: 24
Received Thanks: 0
|
i got the same error too cause the trans not working .
can someone help me
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22448', @ mSerialNum=421617161, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=1353719344679130624
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22448', @ mSerialNum=421617161, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=1353719344679130624
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2018/04/30 14:30:26
query:LOG_ITEM_STR @im_szName='',@iserverindex='01',@im_GetszName='As dfgh',@idwWorldID=1,@im_dwGold=1003594113,@im_nRem ainGold=1003594113,@iItem_UniqueNo=-506333170,@iItem_Name='22449',@iItem_durability=0, @im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count= 1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bI temResist=0,@im_nResistAbilityOption=0,@im_bCharge d=0,@im_dwKeepTime=0,@im_nRandomOptItemId=20079797 7511761408,@inPiercedSize=0,@iadwItemId0=0,@iadwIt emId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4 =0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@i dwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D= 0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_ S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@ iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@i adwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@ iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22449', @ mSerialNum=-506333170, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=200797977511761408
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22449', @ mSerialNum=-506333170, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=200797977511761408
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2018/04/30 14:30:26
query:LOG_ITEM_STR @im_szName='',@iserverindex='01',@im_GetszName='As dfgh',@idwWorldID=1,@im_dwGold=1003594113,@im_nRem ainGold=1003594113,@iItem_UniqueNo=-629865712,@iItem_Name='22447',@iItem_durability=0, @im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count= 1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bI temResist=0,@im_nResistAbilityOption=0,@im_bCharge d=0,@im_dwKeepTime=0,@im_nRandomOptItemId=11905388 99836933632,@inPiercedSize=0,@iadwItemId0=0,@iadwI temId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId 4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@ idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D =0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL _S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0, @iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@ iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0, @iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22447', @ mSerialNum=-629865712, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=1190538899836933632
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22447', @ mSerialNum=-629865712, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=1190538899836933632
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2018/04/30 14:30:26
query:LOG_ITEM_STR @im_szName='',@iserverindex='01',@im_GetszName='As dfgh',@idwWorldID=1,@im_dwGold=1003594113,@im_nRem ainGold=1003594113,@iItem_UniqueNo=-1392407597,@iItem_Name='22446',@iItem_durability=0 ,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count =1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_b ItemResist=0,@im_nResistAbilityOption=0,@im_bCharg ed=0,@im_dwKeepTime=0,@im_nRandomOptItemId=3866784 1150948864,@inPiercedSize=0,@iadwItemId0=0,@iadwIt emId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4 =0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@i dwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D= 0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_ S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@ iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@i adwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@ iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22446', @ mSerialNum=-1392407597, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=38667841150948864
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
|
|
|
|
|
05/04/2018, 14:14
|
#4
|
elite*gold: 0
Join Date: May 2018
Posts: 21
Received Thanks: 6
|
Quote:
Originally Posted by flyforall123
i got the same error too cause the trans not working .
can someone help me
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22448', @ mSerialNum=421617161, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=1353719344679130624
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22448', @ mSerialNum=421617161, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=1353719344679130624
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2018/04/30 14:30:26
query:LOG_ITEM_STR @im_szName='',@iserverindex='01',@im_GetszName='As dfgh',@idwWorldID=1,@im_dwGold=1003594113,@im_nRem ainGold=1003594113,@iItem_UniqueNo=-506333170,@iItem_Name='22449',@iItem_durability=0, @im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count= 1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bI temResist=0,@im_nResistAbilityOption=0,@im_bCharge d=0,@im_dwKeepTime=0,@im_nRandomOptItemId=20079797 7511761408,@inPiercedSize=0,@iadwItemId0=0,@iadwIt emId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4 =0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@i dwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D= 0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_ S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@ iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@i adwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@ iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22449', @ mSerialNum=-506333170, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=200797977511761408
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22449', @ mSerialNum=-506333170, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=200797977511761408
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2018/04/30 14:30:26
query:LOG_ITEM_STR @im_szName='',@iserverindex='01',@im_GetszName='As dfgh',@idwWorldID=1,@im_dwGold=1003594113,@im_nRem ainGold=1003594113,@iItem_UniqueNo=-629865712,@iItem_Name='22447',@iItem_durability=0, @im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count= 1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_bI temResist=0,@im_nResistAbilityOption=0,@im_bCharge d=0,@im_dwKeepTime=0,@im_nRandomOptItemId=11905388 99836933632,@inPiercedSize=0,@iadwItemId0=0,@iadwI temId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId 4=0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@ idwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D =0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL _S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0, @iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@ iadwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0, @iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22447', @ mSerialNum=-629865712, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=1190538899836933632
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22447', @ mSerialNum=-629865712, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=1190538899836933632
SQLSTATE:01000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]The statement has been terminated.
2018/04/30 14:30:26
query:LOG_ITEM_STR @im_szName='',@iserverindex='01',@im_GetszName='As dfgh',@idwWorldID=1,@im_dwGold=1003594113,@im_nRem ainGold=1003594113,@iItem_UniqueNo=-1392407597,@iItem_Name='22446',@iItem_durability=0 ,@im_nAbilityOption=0,@Im_GetdwGold=0,@iItem_count =1,@iState='T',@im_nSlot0=100,@im_nSlot1=100,@im_b ItemResist=0,@im_nResistAbilityOption=0,@im_bCharg ed=0,@im_dwKeepTime=0,@im_nRandomOptItemId=3866784 1150948864,@inPiercedSize=0,@iadwItemId0=0,@iadwIt emId1=0,@iadwItemId2=0,@iadwItemId3=0,@iadwItemId4 =0,@iMaxDurability=0,@inPetKind=0,@inPetLevel=0,@i dwPetExp=0,@iwPetEnergy=0,@iwPetLife=0,@inPetAL_D= 0,@inPetAL_C=0,@inPetAL_B=0,@inPetAL_A=0,@inPetAL_ S=0,@iadwItemId5=0,@iadwItemId6=0,@iadwItemId7=0,@ iadwItemId8=0,@iadwItemId9=0,@inUMPiercedSize=0,@i adwUMItemId0=0,@iadwUMItemId1=0,@iadwUMItemId2=0,@ iadwUMItemId3=0,@iadwUMItemId4=0
SQLSTATE:24000 error:[Microsoft][SQL Server Native Client 10.0]Invalid cursor state
2018/04/30 14:30:26
query:uspLoggingTrade @pFlag=2, @ deID=1525123814, @ ndex='01', @pidPlayer='0000108', @ mIndex='22446', @ mSerialNum=-1392407597, @ mCnt=1, @pAbilityOpt=0, @ mResist=0, @ stAbilityOpt=0 @ mOpt=38667841150948864
SQLSTATE:22003 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Arithmetic overflow error converting expression to data type int.
2018/04/30 14:30:26 |
Change prandomOpt from int to bigint.
|
|
|
|
 |
Similar Threads
|
Database Error!
07/18/2016 - Flyff Private Server - 0 Replies
Was isn das für ein Error beim starten der DatabaseServer.exe
Die exe startet ganz normal.
|
Database error
10/30/2012 - Flyff Private Server - 3 Replies
Hello,
After succesfully compiling the source I logged in and selected the server. After that it keeps frozen at "Connecting please wait..". To clear things up: IT'S NOT A FAILURE IN THE INI's.
This is the error I'm getting:
2012/10/29 22:12:40
C:\Source\Official Source\_Database\DbManager.cpp, 485 CHARACTER_STR...
|
V17 Database Error
06/06/2011 - Flyff Private Server - 8 Replies
Hey,
ich wollte n P-server nach Mr.Helper´s v17 TuT machen.
Es lief eigentlich alles super, doch als ich den Database server starten wollte kam die bekannte Fehlmeldung "FAIL read ini" usw.....
Bei anderen Threads hab ich bis jetzt noch keine antwort gefunden.
kann mir jemand helfen?
|
Database.cs Error
06/17/2010 - CO2 Private Server - 6 Replies
Can someone help me fix this error in red?
public double ReadDouble(string Section, string Key)
{
string section = "";
IniSectionStructure ISS = null;
Sections.TryGetValue(section, out ISS);
if (ISS != null)
{
IniValueStructure IVS = null;
|
[HELP] DataBase Error
09/12/2008 - CO2 Private Server - 1 Replies
http://img261.imageshack.us/img261/739/databaseerr ortw9.png
İ use Steals Server Pack
What is wrong here ??
-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
|
All times are GMT +1. The time now is 06:04.
|
|
