m2server error [RESOLVED]

[CandyMan]

m2server error

Hi,


Ive converted ragezone 1.9 files into 2.3, just finished a few minutes ago
Ive imported mobs,items, written up all of the maps, door coords etc.

Renamed Old STD_ITEMS to: STD_ITEMSs
Renamed New Items to: STD_ITEMS

the m2server is giving me an error saying:

Loaded client version information and server table...
Loading StdItem.DB...
[21/06/2008 18:44:55] StartTimer exception: '0 ' is not a valid integer value


Other gates say:

Dbserver
--------
Server Started...
Gate connected
-- SQL KeepAlive

Rungate
--------
[13:31:07] Service started...
[13:31:07] Loading Config...
[13:31:07] Config Loaded...
[13:31:07] Loading abuse file...
[13:31:07] Abuse file loaded...
[13:31:07] Loading block ip file...
[13:31:07] Block ip file loaded...
[13:31:07] Socket Opened...

Logingate
---------
[13:31:14] Service started...
[13:31:14] Socket Opened...

Loginsrv
--------
1) Server initializing...
2) Waiting for server connection...
3) Server started...

Selgate
-------
[13:31:26] Service started...
[13:31:26] Socket Opened...

Any ideas?
Im confused :mooned:

 

[Fire]

Re: m2server error

you cant change the table names, the server has certain ones it is expecting...

 

[CandyMan]

Re: m2server error

Yeah ive removed the old STD_ITEMS table
and renamed my new table as STD_ITEMS

So the table is still there :S

 

[Fire]

Re: m2server error

Invalid object name 'TBL_STDITEMS'... yours is called STD_ITEMS....

 

[Omen_lom]

Re: m2server error

lol mistake easily made

 

[CandyMan]

Re: m2server error

(I've edited this post so it's viewed on the first post.)

Okay, i typed it wrong lol.

The name was accidently TLB_STDITEMS
instead of TBL_STDITEMS

haha.

Anyways, the m2server is now giving me a new error saying:

Loaded client version information and server table...
Loading StdItem.DB...
[21/06/2008 18:44:55] StartTimer exception: '0 ' is not a valid integer value

 

[Fire]

Re: m2server error

you have a space on the end....
READ the error messages... it told you the exact problem...

 

[CandyMan]

There is no space on the end of TBL_STDITEMS

Ive renamed it 3 times to check.
Still giving me the error

 

[Fire]

the values in the tables... integers are numbers not text...

 

[Killmaster]

Do you have an item with the index number as 0 as well?

 

[CandyMan]

Right thats sorted.
I also forgot to rename the Fields lol.

Just completed that
and its saying:

'TBL_MONSTER' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '1MentaLtest10' to a column of data type int.

I've found the mob on the database but i dont know what to do with it lol.

 

[JealY]

A. It's a test mob probably don't need it, just remove it?

B. Rename it


Just some ideas i'd do.

 

[Fire]

check that row for variable types to ensure consistency...

 

[CandyMan]

Add me to msn please u2, I think ive totally messed up the table.

[email protected]

I have teamviewer.

In desperate need of help tbh