EP5 database setup issues

Xenocide21 · 12/02/2011, 03:26

I managed to figure out how to attach the EP5 DB files from the ElitePvPers1.rar and attach them to my EP4.5 server that is stable and running (thanks to gods i have it backed up in multiple places) however there seems to be an error, when i open the ps_userdata>dbo.users_master there is no accounts, and i cannot create an account, administer mode and all. tells me the value 0 or 1 in the "admin" table is not a valid arguement, or something to the effect of that. the PS_gamedefs is however full for spells 1-9 and etc. (Cryptic the immortal is really hard to kill even with a modded level 70 in 4.5 with goddess hermit linked with level 7's, that and level 3 spells) has anyone an idea why this could be and a possible fix for this? I am using SQL Server 2008 R2 on Windows Seven 32 bit. Thanks in advance to you guys, ive read up a lot on this forum and its gotten me far in my server configuration and maintenance.

JohnHeatz · 12/02/2011, 03:37

If you attached the PS_UserData from that .rar that is your problem as you don't have to do that, because you need to keep your userdata... simply use the backup from it and restore it (dettach the one that doesn't have any accounts first though)

#Moved to the right section

Xenocide21 · 12/02/2011, 07:07

do i keep the PS_Gamedata too being that it contains my chars tables, or must i use a new gamedata

p.s. sorry for wrong forum section

JohnHeatz · 12/03/2011, 12:53

mostly what you need are the gamedefs, but you should check out what does each database contain, and think what is it that you need and what you don't

·Tyler· · 12/03/2011, 18:51

New Query:

--Selects CTI from the Mobs Table
Select *
From PS_GameDefs.dbo.Mobs
Where MobID in (1716, 1816)

This will tell you why CTI is hard to kill.

Tyler

Xenocide21 · 12/05/2011, 23:22

Quote:

Originally Posted by ·Tyler·

New Query:

--Selects CTI from the Mobs Table
Select *
From PS_GameDefs.dbo.Mobs
Where MobID in (1716, 1816)

This will tell you why CTI is hard to kill.

Tyler

yah i figured that out while trying to make some custom mods. In the process i managed to damage my char data, i cant load my account anymore says something about cant load character data or something to that effect, the change i had made prior to that was reguarding a custom ring i made on the SQL database and item.sdata which i imported to my client. I was using ShaiyaStudio to make these changes. I had also modified KB to 600 second recharge time 90% chance of success and 20ft radius. those two modifications were done in SQL and skill/item.sdata. after restarting my server and SQL DB's i got the error. this is still the EP4.5 config, i can revert back to an earlier backup but id like to know what may have gone wrong and what i can do to fix it so im not constantly making backups. any advice?

Xenocide21 · 12/14/2011, 03:36

bump.. please help with latest issue

JohnHeatz · 12/14/2011, 14:59

When you are working on a live server, it is a must to keep making backups every time you change something, so, if something goes wrong you can simply go back to your latest backup; because you would need to check which of those changes altered something that is what is getting conflict and giving you this error, so you would need to revert those changes