Help with Mir2 Server SQL and Item Loss

[crazylegs]

I'll explain evrything step by step.
First a little information.

Specs: QuadCore 2,4 - 4GB Ram - 512MB Videocard
OS: Windows Vista Ultimate x68
SQL: Sql Server Management Studio Express 2005
Serverfiles: TD's Server files

Problem:
--- 1 ---

- I Open SQL Server Management Studio Express
- Logging in...
- Then i select Databases -> mir2 -> Tables ->
- I right-click TBL_MONGEN and select Open Table
- I Add a spawn correctly
- I Now close the table. (Assuming it should automaticly save)
- I Re-open the table, and the spawn i just added is gone.

Problem:
--- 2 ---

- Starting server...
- I log on to my gamemaster
- Get startkit from npc or @make any item,
- Then i just go back to the character selection screen.
- I select same character and go back in-game
- And all the items i wear, or the items i had in my bag are gone.

Problem:
--- 3 ---
- I Open SQL Server Management Studio Express
- Logging in...
- Then i select Databases -> mir2 -> Tables ->
- I right-click TBL_MERCHANT and select Open Table
- Now it says 4 all merchants that Cell is locked in FLD_INDEX

I hope this will give people a more clear perspective at my problems.

 

[Tatsunuko]

Problem 1 + 2
--------------

Your Database isnt added correctly.
You can check which database your M2 is reading by looking in:

M2Server/!Setup.txt

E.G

[SQL]
UseSQL=TRUE
SQLHost=(local)
SQLUsername=sa
SQLPassword=mirserver
SQLDatabase=mir2
SQLType=mssql
SQLPort=3306
SQLCharDatabase=mir2

DBServer/dbsrc.txt

[SQL]
SQLType=mssql
SQLHost=(local)
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=mirserver

Make sure both of those ini's match up together.
If your SQL is reading this wrong, then fully un-install SQL and start again to make sure that the details are entered correct.

Problem 3
---------

Find FLD_Index, Right click, press 'Design Table'
Drag that to a side so you can see it ready to open the next thing.

Right Click Empty Space > New Table > Call it FLD_Index1.
Now copy all of the things from your old FLD_Index and Save.

Rename FLD_Index to FLD_OldIndex
Rename FLD_Index1 to FLD_Index

Right click > Refresh.

That should fix the problem and automatically fill its-self up with the data specified for the table to be accessed.



Hope this helps