Help please.

[Supremesis]

RIght i create a guild with my gm character and it all goes well i log it off after playing then next time i load up my M2Server.exe this comes up "[10/11/2008 02:00:21] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildMemberList'
[10/11/2008 02:00:21] [LOADGUILDMEMBERS] loading memberlist failed for guild: APG
[10/11/2008 02:00:21] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_GuildItems'
[10/11/2008 02:00:21] [LoadGuildStorage] Guild: APG
[10/11/2008 02:00:21] Guilds: 1
[10/11/2008 02:00:21] Total Castles: 1
[10/11/2008 02:00:54] LoginServer Connected(127.0.0.1:5600)
[10/11/2008 02:00:55] Gate[0](127.0.0.1:2714) Opened...
[10/11/2008 02:00:57] DBServer Connected(127.0.0.1:6000)
[10/11/2008 02:01:26] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Tbl_GuildMemberList'
[10/11/2008 02:01:26] [SAVEGUILDMEMBERLIST] deleting old list failed
"
Then when i login my guild is not there anymore so i would kindly request if someone can help me out and make it stay and not go away.
Thanks in advance /Sup

 

[mStation]

search.. i think this has been answered about 20 times.. use TBL_GuildMemberList or TBL_GuildItems..

solution:
open enterprise manager and add a few tables under the mir2 database
- Tbl_GuildList (contains only one field: Fld_GuildName, data type: varchar, length: 20, allow nulls:false)
- Tbl_GuildItems(contains the same fields as tbl_useritems except instead of Fld_Charname it's Fld_Guildname here)
- Tbl_GuildMemberList, contains:
Fld_GuildName: varchar, length 20, allow null : false
Fld_GuildRank: int , length 4 , allow null: false
Fld_CharName: varchar , length20, allow null: false
Fld_Level : int , length 4 , allow null: false
Fld_RankName: varchar, length 50, allow null: false

 

[jasper]

updated DB by travisw in this post, also that db was added to the all in one files at time of that post.

http://www.lomcn.co.uk/forum/showthread.php?t=58749

 

[Supremesis]

So what do i do with the Db because now i've got a choice either i fix the problem of guilds and lose all my added mobs and items or i keep my added mobs or items/ (which took me a good 2 weeks work) and not have guilds working? or do i simply have to insert the tbl's in? if so please tell me how and which stuff needs insertin etc.

 

[Perrin]

i have a similar problem, everything was working fine and server was on line albeit very bare, i was adding a npc when it crashed and the DB for some reason messed up so as i hadnt done much i decided to restore the db again like you do when you initially set the server up. now on M2 i get this message

[23/11/2008 14:12:30] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Fld_GuildPoints'

anyidea what i need to do to rectify this pls

 

[TheBoss]

You dont lose anything, just add the tbls your self, check the update doc its all in there

 

[Perrin]

ty for the fast reply added Fld_GuildPoints and all works again now cheers