[Help] unknow MuDB ID

[shadowvzs]

i tryed 1.02n server and i changed ip to my ip, i changed sql pass, i created mu2003_event_data and mu2003_event database, muonline(i found file and i restore data), ranking(i found ranking file), mu2003 batabases dont found file what i can restore in sql server enterprice manager

when starting the start up have probleme with dataserver1 and cannot continue the startuping and write me "unknown MuDB ID" and in background running data server.exe
and every some minutes fill the log with this (every second log file raise with 1 mb aprox)

05:43:59p [ANTI-HACKING][IP LIST] IP : [89.89.89.89] Length : 89
05:43:59p [ANTI-HACKING][IP LIST] IP : [89.89.89.89] Length : 89
05:43:59p [ANTI-HACKING][IP LIST] IP : [89.89.89.89] Length : 89
05:43:59p [ANTI-HACKING][IP LIST] IP : [89.89.89.89] Length : 89
05:43:59p [ANTI-HACKING][IP LIST] IP : [89.89.89.89] Length : 89

somebody have a tipp where i can found the problem?

 

[flyba]

Re: [HELP] unknow MuDB ID

Go enterprise manager/database/muonline/tables/MU_DBID rigth click opentable/return all rows click and put 1234 under DESC

 

[shadowvzs]

Re: [HELP] unknow MuDB ID

Go enterprise manager/database/muonline/tables/MU_DBID rigth click opentable/return all rows click and put 1234 under DESC

i dont have MU_DBID te problem when i create a new table then i need column name / data type / lenght / allow nulls
name is MU_DBID but data type and others? what can i write to other 3 stuff?

 

[flyba]

Re: [HELP] unknow MuDB ID

i dont have MU_DBID te problem when i create a new table then i need column name / data type / lenght / allow nulls
name is MU_DBID but data type and others? what can i write to other 3 stuff?

try to run this in SQL QUERY choose MuOnline

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mu_DBID]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mu_DBID]
GO

CREATE TABLE [dbo].[Mu_DBID] (
[DESC] [varchar] (20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO

 

[shadowvzs]

Re: [HELP] unknow MuDB ID

try to run this in SQL QUERY choose MuOnline

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mu_DBID]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mu_DBID]
GO

CREATE TABLE [dbo].[Mu_DBID] (
[DESC] [varchar] (20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
GO

sql query analyzer? and there when i select muonline then where i can write this? sry i am noob in sql i use first time, pls write me where can i access this place where i can write this...

(select * from dbo.sysobjects where id = object_id(N'[dbo].[Mu_DBID]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mu_DBID]
GO

CREATE TABLE [dbo].[Mu_DBID] (
[DESC] [varchar] (20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]

the this script create me automatical a table? after when i will use this script then i must remove the scipt?

 

[flyba]

Re: [HELP] unknow MuDB ID

Go Enterprise Manager/tools SQL QUERY ANALYZER after sone running the script close sone save anything,that script will make new table[MU_DBID] on your database muonline

 

[shadowvzs]

Re: [HELP] unknow MuDB ID

Go Enterprise Manager/tools SQL QUERY ANALYZER after sone running the script close sone save anything,that script will make new table[MU_DBID] on your database muonline

done and when running startup then long time running data server 1 but will be ready but data server 2 not will be ready and running forever.

secondary things my startup running 1min and created me 1gb log file and now i dont know where but every second decrease something my space in hard disc (startup was shut down)

now i was inside muonline a MUDB_ID table with 1234 but same problem

flyba thanks very much but i dont have ideea why work 1.02q and 1.02n always have probleme and i have near give uping ((


same unknow MuDB ID error but continue running and again never willbe rady the data server 1 and again create a huge log file ...................... extremly bad thing becuase sometimes if running start up 2min then create me 2gigabyte log :/