OMG_Gameweb

04/08/2014 12:20 Aleni#1

anyone can give me this file,I clambered whole site can not find anywhere, Thanks.

04/08/2014 12:49 MaikenNub#2

haven't heard of this file, where did u see it or for what you need it?

04/08/2014 13:01 Aleni#3

DB File

04/09/2014 02:08 sominus#4

That file is from an old DB release, you don't need it to run a server. Just edit the install file, remove the lines where it calls that file.

04/09/2014 08:23 Aleni#5

When I remove that it still give me an error.

Msg 4701, Level 16, State 1, Line 9
Cannot find the object "GameAccountTBL" because it does not exist or you do not have permissions.

plus this gives a lot of errors

04/10/2014 22:41 Blober#6

Can you post your logs? To know more about the error.

04/11/2014 17:48 sominus#7

Remove this line:

Code:

TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;

Remove also this entire block:

Code:

IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
	INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
	(UserUID,GameAccount,OneTimePassword,OTPExpireDate,DelCharPWD,CreateDate)
	VALUES (1,'gmlight','gmlight123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END

Instead of removing you could also put '-- ' before each line
Eg:

Code:

-- TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;

04/12/2014 11:11 Aleni#8

new error Message 544, Level 16, State 1, Line 23
Can not insert explicit value for identity column in table "Users_Master", when setting IDENTITY_INSERT is set to OFF.