error when Attaching Database (PS_GameData_Data.MDF)

Page 1 of 2

12/07/2012 17:44 eclipz13#1

Iv'e fallowed the tutorials fully when installing and configuring SQL 2008
[Only registered and activated users can see links. Click Here To Register...]

But i'm getting an error when Attaching Database (PS_GameData_Data.MDF)
I got the [Release]Full EP6 Shaiya Server Files from [Only registered and activated users can see links. Click Here To Register...]

The error says
"Attach database failed for Server '127.0.0.1' (Microsoft.SqlServer.Smo)

Additional information:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The Database 'PS_GameDefs11' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
Coud not open new database 'PS_GameDefs11' CREATE DATABASE is aborted (Microsoft SQL Server, Error:948)

Any advice?:confused:

12/07/2012 19:37 Sh1nra#2

I think your mssql is 2005 and the PS_GameData based on 2008 + :(

12/07/2012 19:47 eclipz13#3

Quote:

Originally Posted by Sh1nra

I think your mssql is 2005 and the PS_GameData based on 2008 + :(

nope, i fallowed it exactly as described in the tutorial, it's surly 100% MSSQL 2008

12/07/2012 21:58 JohnHeatz#4

This has to do with the SQL Version, or so it seems, so, the two steps I'd personally take would be, one, check that you are logging into SQL Server with an account that has all the privileges (such as "sa" user, as per default) and try again -this might require you logging into SQL server with the sa user-

Another option would be for you to either reinstall your SQL 2008, or even upgrade it to 2012.

12/07/2012 23:27 eclipz13#5

Quote:

Originally Posted by JohnHeatz

This has to do with the SQL Version, or so it seems, so, the two steps I'd personally take would be, one, check that you are logging into SQL Server with an account that has all the privileges (such as "sa" user, as per default) and try again -this might require you logging into SQL server with the sa user-

Another option would be for you to either reinstall your SQL 2008, or even upgrade it to 2012.

Quote:

Originally Posted by peripher

Please provide logs.
PSM_Client/bin/logs

Express worked but you have to try it over and over.
No, because version 661 is only needed for the new-server files that you have.

All other files working with SQL 2008

I went into my registry and deleted everything and did a fresh start:

1: Installed MSSQL 2008 R2 Express
Selected "Default Instance"
SQL Server Database Engine = "PC User account / Password"
Selected "Mixed mode" then "Add Current User"
entered the passwords = "PC User Password"
--- Success

2: Opened SQL Server Network Configuration
Opened "Protocols for MSSQLSERVER" Then Enabled TCP/IP
Went into Properties and changed and Enabled all IP1 through IP9 adding/replacing IP Address to 127.0.0.1
"NOTE: I AM CURRENTLY ONLINE USING MY WIRELESS EITHERNET ADAPTER..
I AM SHARING INTERNET TO ANOTHER DESKTOP USING ANOTHER EITHERNET CARD W/CABLE SO THAT'S WHY THERE ARE IP1 through IP9"

Enabled and opened "Named Pipes"
Renamed to \\.\pipe\sql\query
Restarted SQL...

3:Installed SQL Management Studio
Selected New SQL Server stand-alone installation
All 6 Passed hit next and All 11 passed
Selected "Perform a new installation of SQL Server 2008"
Selected "Select All" Shared Features
Installed...

4: Opened SQL Management Studio
Change the Server-Name to 127.0.0.1
Selected "Windows Authentication"
Connected successfully..

Created new login name = Shaiya
Selected "SQL Server Authentication" Shaiya123
Unchecked "Enforce password expiration"

Selected "Server Roles"
Checked sysadmin and Public only

5: Extracted [Release]Full EP6 Shaiya Server Files to C:\Users\EcLiPz\Documents\ShaiyaServer

Attached all the .MDF to "Database"
from C:\Users\EcLiPz\Documents\ShaiyaServer\DATABASE

Opened New SQL Installation.sql
Changed 'your-db-username', 'your-db-userpassword' to 'Shaiya', 'Shaiya123'
Executed successfully

6: Opened open ps_passwordENC.exe "As admin"
Typed in "Shaiya123"
Copied Enc and pasted it in every .ini in PSM_Client / bin / config

Opened SM_Client and selected PSM_ServiceMgr and executed it "as admin" and Installed everything

Opened PSM_AgentInstall Ran "as Admin" Installed Successfully then after i hit ok i receive a random pop up
(Apply windows registry (apply only ps_game/war, ps_login, need restart window)
Clicked it.. Nothing happend after waiting a few min so i hit close...

Opened CMD "As Admin"
Ran cd C:\Users\EcLiPz\Documents\ShaiyaServer
Ran shaiya_svc_register.bat successfully

RESTARTED COMPUTER

Opened PSMServer_Mgr "As admin"
Typed in Username = Shaiya
Typed in Password = Shaiya123
Clicked "Apply All DB Account + Passwd(if equal all db)
Clicked "Apply All Account"
Clicked "Apply All Passwd"

Selected "Control Service"
Selected "Start All Services"

All unpaused accept "Game"
Checked the logs

Code:

2012-12-07 17:16:55 PS_GAME__system log start (Game01) [GERMANY] 2012-12-07 17:16:56 DB gamedef connect error 2012-12-07 17:16:56 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2012-12-07 17:16:56 Call save all waiting... 2012-12-07 17:16:56 Call save all failed dbagent disconnected(user count = 0)... 2012-12-07 17:16:56 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0 2012-12-07 17:16:56 PS_GAME__system log end (Game01) 2012-12-07 17:16:56 3 1 SService::ServiceCtrlDispatcher(): service shutdown

I already have a E6 game.exe that's IP bound to 127.0.0.1
But can't log in with Username=Shaiya PW=Shaiya123

12/08/2012 10:54 nephren#6

I answered you in the tutorial topic in german. If you do not understand German, please let me know.

(Game01) [GERMANY] 2012-12-07 17:16:56

12/08/2012 22:14 eclipz13#7

So here's my current issue/progress in hopes that someone can assist me or even point me in the right direction...

Firstly.. I must note that in this release when you attach the DB files using MSSQL SMS,
the PS_GameDefs gets renamed to PS_GameDefs11 for some reason "I SWEAR I DIDN'T DO IT!! and that caused issues...

Iv'e fallowed the tutorial from [Only registered and activated users can see links. Click Here To Register...]

Here's a screenshot of all my .ini files in C:\Users\EcLiPz\Documents\ShaiyaServer\PSM_Client\ Bin\Config
[Only registered and activated users can see links. Click Here To Register...]
Where i am stuck at now is: When i start all services, everything goes green arrow,
but then when i try to connect using client from [Only registered and activated users can see links. Click Here To Register...]

It says "Account Doesn't exist"
I've tried editing the game.exe with ShaiyaPatcher to bind to ip 127.0.0.1 or 192.168.0.1 and still have no luck

I can however log in fine with Username: gmlight Password: gmlight123
It shows the server..
I click on it, Shaiya crashes....

Why doesn't this game like me??

So yeah!, here's me begging for someone to help me in my battle and eagerness to host my own shaiya "Semi E6 Pserver for LAN usage"

Perhaps in time "so i don't join in on the (destruction of shaiya pservers necause of my lack of exp) I will put more time into learning how to properly modify data/items and even missions once my knowledge advances to that point..
But one step at a time...
Either way, i need some help walking the path lol

12/09/2012 11:55 Truth1010#8

It could be that the files in use by your installed server don't match those of the client you are trying to connect with.

I would say it's not your "connection" because you can actually log into an account that exists, so the IP's are all right there.

You have to have matching client (the data.saf/data.sah) files and server files (c:\Users\EcLiPz\Documents\PSM_Client\Bin\Data) or you'll get data errors like it sounds you have.

Make sure you update your database and server files (npcquest.sdata is usually a main culprit) to match your client files. You can use 2 different tools to upgrade your server files from client. (ShStudio / Shay Data Edit) The former being easier to use as it has a GUI, the latter being generally better and bug free.

12/09/2012 22:59 eclipz13#9

hmm. ShStudio won't even open the npcquest.sdata :/
I opened it up and went into setting and picked the shaiya folder but it won't actually open anything :/

Here are my logs

PS_GAME__system.log__20121209_175446.log

Code:

2012-12-09 17:54:46 PS_GAME__system log start (Game01) [GERMANY] 2012-12-09 17:54:47 RandomOption Error : ItemID=24070, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24111, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24112, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24118, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24119, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24125, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24126, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24154, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24240, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24249, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24250, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24251, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24252, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24253, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=24254, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=39070, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=39111, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=39112, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=39118, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=39119, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=39125, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=39126, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=39154, byServer=2, Wis=0 2012-12-09 17:54:47 RandomOption Error : ItemID=39240, byServer=2, Wis=0 2012-12-09 17:54:50 connect mgr 996 2012-12-09 17:54:50 Server Version : 11093000 2012-12-09 17:54:50 connect dbagent 1000 2012-12-09 17:54:50 connect gamelog 1012 2012-12-09 17:54:52 Market End ----------------------- 2012-12-09 17:54:52 Start CWorldSendThread=2948 Module list: C:\Users\EcLiPz\Documents\ShaiyaServer\PSM_Client\bin\ps_game.exe, loaded at 0x00400000 - 11/09/14 17:10:08 2012-12-09 20:50:00 3 1 SERVICE_CONTROL_STOP 2012-12-09 20:50:00 Call save all waiting... 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (3, 1236) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=27,RCS=0, RB=126,RBS=0, SC=35,SCS=0, SB=205,SBS=0 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (3, 1236) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=33,RCS=0, RB=4523,RBS=0, SC=54,SCS=0, SB=497,SBS=0 2012-12-09 20:50:00 discon mgr ((3,1236, 126,205) 2012-12-09 20:50:00 mgr Connection Lost INFO : T=002:55:00:000, RC=27,RCS=0, RB=126,RBS=0, SC=35,SCS=0, SB=205,SBS=0 2012-12-09 20:50:00 mgr server disconnection 2012-12-09 20:50:00 discon dbagent ((3,1236, 4523,497) 2012-12-09 20:50:00 dbagent Connection Lost INFO : T=002:55:00:000, RC=33,RCS=0, RB=4523,RBS=0, SC=54,SCS=0, SB=497,SBS=0 2012-12-09 20:50:00 db agent server disconnected... 2012-12-09 20:50:00 call disconnectAll... 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (3, 1236) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=24,RCS=0, RB=96,RBS=0, SC=34,SCS=0, SB=233,SBS=0 2012-12-09 20:50:00 discon userlog ((3,1236, 96,233) 2012-12-09 20:50:00 userlog Connection Lost INFO : T=002:55:00:000, RC=24,RCS=0, RB=96,RBS=0, SC=34,SCS=0, SB=233,SBS=0 2012-12-09 20:50:00 userlog log server disconnection 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (3, 1236) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=23,RCS=0, RB=92,RBS=0, SC=33,SCS=0, SB=165,SBS=0 2012-12-09 20:50:00 discon gamelog ((3,1236, 92,165) 2012-12-09 20:50:00 gamelog Connection Lost INFO : T=002:55:00:000, RC=23,RCS=0, RB=92,RBS=0, SC=33,SCS=0, SB=165,SBS=0 2012-12-09 20:50:00 game log server disconnection 2012-12-09 20:50:00 server shutdown Connection INFO : T=002:55:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0 2012-12-09 20:50:00 PS_GAME__system log end (Game01) 2012-12-09 20:50:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_DBAGENT__charsave.log__20121209_175444.log

Code:

//PS_DBAGENT__charsave log start (DBAgent01) //PS_DBAGENT__charsave log start (DBAgent01)

PS_LOGIN__system.log__20121209_175448.log

Code:

2012-12-09 17:54:48 PS_LOGIN__system log start (Login01) 2012-12-09 18:54:59 cmd_auto server info log  user = 0 (0/3000) 2012-12-09 18:54:59 T=001:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0 2012-12-09 18:54:59 SContext=2(1022/1024) SContextSend=0(1024/1024) SContextAccept=0(0/0) SPacketBufferSendS=1(1023/1024) SPacketBufferSendM=0(1024/1024) SPacketBufferSendB=2(1022/1024) SSyncQueueBufferSend::SQueueSendNode=1(1023/1024) SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0) SSyncQueueStatus::SQueueStatusNode=0(0/0) 2012-12-09 19:54:59 cmd_auto server info log  user = 0 (0/3000) 2012-12-09 19:54:59 T=002:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0 2012-12-09 19:54:59 SContext=2(1022/1024) SContextSend=0(1024/1024) SContextAccept=0(0/0) SPacketBufferSendS=1(1023/1024) SPacketBufferSendM=0(1024/1024) SPacketBufferSendB=2(1022/1024) SSyncQueueBufferSend::SQueueSendNode=1(1023/1024) SSyncQueueBufferPriority::SQueuePrioritySendNode=0(0/0) SSyncQueueStatus::SQueueStatusNode=0(0/0) 2012-12-09 20:50:00 3 1 SERVICE_CONTROL_STOP 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (3, 1236) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=28,RCS=0, RB=211,RBS=0, SC=1085,SCS=0, SB=8601,SBS=0 2012-12-09 20:50:00 mgr server disconnection 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (3, 1236) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=24,RCS=0, RB=96,RBS=0, SC=33,SCS=0, SB=165,SBS=0 2012-12-09 20:50:00 log system server disconnection 2012-12-09 20:50:00 PS_LOGIN__system log end (Login01) 2012-12-09 20:50:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_DBAGENT__system.log__20121209_175444.log

Code:

2012-12-09 17:54:44 PS_DBAGENT__system log start (DBAgent01) Module list: C:\Users\EcLiPz\Documents\ShaiyaServer\PSM_Client\bin\ps_dbAgent.exe, loaded at 0x00400000 - 11/09/14 16:20:57 2012-12-09 17:54:50 ### Connect[4172] : Game[?][0x00891978], Addr=127.0.0.1, DBJobEnd=1 2012-12-09 17:54:51 ### DB_SYSTEM_CONNECT[6584] :Game[1][0x00891978], Name=Game01, Addr=127.0.0.1 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (4, 64) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=54,RCS=0, RB=497,RBS=0, SC=33,SCS=0, SB=4523,SBS=0 2012-12-09 20:50:00 ### Disconnect[6584] : Game[1][0x00891978], Name=Game01, Addr=127.0.0.1, DBJobEnd=0 2012-12-09 20:50:00 ### PostDispatchDB[6584] : DB_DISPATCHER_EXIT Game[1][0x00891978] 2012-12-09 20:50:00 ### OnDispatchDB[3860] : => DB_DISPATCHER_EXIT Game[1][0x00891978] 2012-12-09 20:50:00 ### Save[3860] : Game[1][0x00891978] 2012-12-09 20:50:00 ### OnDispatchDB[3860] : <= DB_DISPATCHER_EXIT Game[1][0x00891978] 2012-12-09 20:50:00 3 1 SERVICE_CONTROL_STOP 2012-12-09 20:50:00 PS_DBAGENT__system log end (DBAgent01)
 2012-12-09 20:50:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAMELOG__system.log__20121209_175444.log

Code:

2012-12-09 17:54:44 PS_GAMELOG__system log start (GameLog01) Module list: C:\Users\EcLiPz\Documents\ShaiyaServer\PSM_Client\bin\ps_gameLog.exe, loaded at 0x00400000 - 10/10/18 16:33:52 2012-12-09 17:54:50 connect game 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (4, 64) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=33,RCS=0, RB=165,RBS=0, SC=23,SCS=0, SB=92,SBS=0 2012-12-09 20:50:00 disconnect game 2012-12-09 20:50:00 3 1 SERVICE_CONTROL_STOP 2012-12-09 20:50:00 PS_GAMELOG__system log end (GameLog01) 2012-12-09 20:50:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_SESSION__system.log__20121209_175444.log

Code:

2012-12-09 17:54:44 PS_SESSION__system log start (Session) Module list: C:\Users\EcLiPz\Documents\ShaiyaServer\PSM_Client\bin\ps_session.exe, loaded at 0x00400000 - 11/09/14 16:30:56 2012-12-09 17:54:49 connect login 2012-12-09 17:54:51 connect game 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (4, 64) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=1085,RCS=0, RB=8601,RBS=0, SC=28,SCS=0, SB=211,SBS=0 2012-12-09 20:50:00 disconnect login 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (4, 64) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=35,RCS=0, RB=205,RBS=0, SC=27,SCS=0, SB=126,SBS=0 2012-12-09 20:50:00 disconnect game 2012-12-09 20:50:00 3 1 SERVICE_CONTROL_STOP 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (3, 1236) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=24,RCS=0, RB=96,RBS=0, SC=25,SCS=0, SB=133,SBS=0 2012-12-09 20:50:00 log system server disconnection 2012-12-09 20:50:00 PS_SESSION__system log end (Session) 2012-12-09 20:50:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_USERLOG__system.log__20121209_175442.log

Code:

2012-12-09 17:54:42 PS_USERLOG__system log start (UserLog) 2012-12-09 17:54:44 connect 2012-12-09 17:54:49 connect 2012-12-09 17:54:50 connect 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (4, 64) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=33,RCS=0, RB=165,RBS=0, SC=24,SCS=0, SB=96,SBS=0 2012-12-09 20:50:00 disconnect 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (4, 64) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=34,RCS=0, RB=233,RBS=0, SC=24,SCS=0, SB=96,SBS=0 2012-12-09 20:50:00 disconnect 2012-12-09 20:50:00 1 1 SAgent::Disconnect: (4, 64) 2012-12-09 20:50:00 1 1 T=002:55:00:000, RC=25,RCS=0, RB=133,RBS=0, SC=24,SCS=0, SB=96,SBS=0 2012-12-09 20:50:00 disconnect 2012-12-09 20:50:00 3 1 SERVICE_CONTROL_STOP 2012-12-09 20:50:00 PS_USERLOG__system log end (UserLog) 2012-12-09 20:50:00 3 1 SService::ServiceCtrlDispatcher(): service shutdown

12/10/2012 12:42 Truth1010#10

Are you by any chance trying to use the latest "EP6" official version of your client?

That might be a reason why you can't open the Sdata's with ShStudio. Because their are more rows of data allocated per "item" meaning it no longer "fits" into the structure of ShStudio. The only way to work with those files yourself, is to open them with a Hex editor, and manually grab out each "item's" data values 1 by 1, placing them into a csv formatted file, and then using another extremely useful tool (Shay Data Edit) to produce a .sdata that works.

I would suggest using an ep4 or an ep5 client available from here.. or just don't update your official server to it's latest patch.. :D

And i didn't check your logs, cuz they are a real pain to read like that. In future, put them in Spoiler tags

Spoiler

And a quick Edit to try help you and others understand something.

When you were a kid, did you ever have one of those "block shape" toys?
Think of the server files and the client as this toy.
The Server files are the main "house" with the holes cut out.
And your client files are the shapes that must fit into those holes.
If your client and server matches (same ep/version etc) then the shape will fit.
If your client and server dont match (ep4 server with ep6 client, etc) then the shape wont fit.
[Only registered and activated users can see links. Click Here To Register...]<-- For those not sure of this toy, or not as old as I am.. :)

12/10/2012 22:08 eclipz13#11

Quote:

Originally Posted by Truth1010

Are you by any chance trying to use the latest "EP6" official version of your client?

That might be a reason why you can't open the Sdata's with ShStudio. Because their are more rows of data allocated per "item" meaning it no longer "fits" into the structure of ShStudio. The only way to work with those files yourself, is to open them with a Hex editor, and manually grab out each "item's" data values 1 by 1, placing them into a csv formatted file, and then using another extremely useful tool (Shay Data Edit) to produce a .sdata that works.

I would suggest using an ep4 or an ep5 client available from here.. or just don't update your official server to it's latest patch.. :D

And i didn't check your logs, cuz they are a real pain to read like that. In future, put them in Spoiler tags

Spoiler

[ spoiler ]

And a quick Edit to try help you and others understand something.

When you were a kid, did you ever have one of those "block shape" toys?
Think of the server files and the client as this toy.
The Server files are the main "house" with the holes cut out.
And your client files are the shapes that must fit into those holes.
If your client and server matches (same ep/version etc) then the shape will fit.
If your client and server dont match (ep4 server with ep6 client, etc) then the shape wont fit.
[Only registered and activated users can see links. Click Here To Register...]<-- For those not sure of this toy, or not as old as I am.. :)

Well put, and totally understandable, I'm not in my 20's no more so i'm old enough to know the toy you're talking about :D..

But i'm just fallowing a tutorial really, and becoming really misdirected, "Kinda like that toy you would see in doctors offices with the beads on the pipes like a roller coaster" lol
The client files i got were stated to be "Full EP6 Shaiya Server Files" iv'e only recently re-downloaded shaiya and i now see that the full E6 seems to be a lie, or at least full of bugs..

SO honestly is my best bet just getting the E5 server setup? using an updated MSSQL 2012?

And if so how would i downgrade my game to be able to play on it?
Is that as simple as changing the Game.exe to an E5 client?
or is there more to it than that when downgrading?

In the first place i used the Shaiya server light, all worked perfect until i went to connect and it said wrong version..

12/11/2012 00:07 Truth1010#12

I do love those roller-coaster bead toys, my local dentist has one.. I find it hard to these days to not play with it. :)

Yes, as you stated the EP6 clients/servers here, are not EP6. They are fake customised ep4/5 files that have been made to appear as EP6, so full of numerous bugs that wont be fixed any time soon.

[Only registered and activated users can see links. Click Here To Register...] I'd recommend this if your just getting started up and follow the mini guide in the first post. I would suggest to re-install US (make a copy of your folder if you want to keep the ep6 files etc) and then NOT update the client when it installs. This will make it a version of EP5, and use the EP5 game.exe in that thread for things to work.

You may still need to update your files for it to work (just open in ShStudio and then save) If your going along that path. Although I suggest to learn how to use [Only registered and activated users can see links. Click Here To Register...] for your edits, it's "harder" to use to a degree, but much easier and quicker. (simple csv in excel)

12/11/2012 07:03 eclipz13#13

Alright.
So i still have the file "shaiya_us_installer_20121016sfx.exe" and plenty of extra space on a second drive...

Iv'e copied everything form C:\AeriaGames\Downloader to D:\AeriaGames\Downloader
Ran shaiya_us_installer_20121016sfx.exe and it all extracted fine but when i start the game.exe it automatically updates it :/

How do i bypass that?

also the exe in that forum doesn't exist no more :/ so i got another one from [Only registered and activated users can see links. Click Here To Register...]

I'm tired now @ 4am...
I will post more of my progress tomorrow with screenshots and logs and such..
I feel that i'm REALLY close now lol All arrows were green, but when i tried to log in it said the account couldn't be found...

Either way tomorrow i will update my progress..

Thank you for all the help so far!! :D

12/11/2012 16:01 Truth1010#14

Simply don't use that game.exe supplied with the official. I think the one your using will open without the updater, which is good enough until you choose to make your own updater, making it take patches that you upload, rather than those from the Official servers.

All arrows green is a good start, and for accounts.. are you sure you have them in the UsersMaster table in your Database. I think the default login for those files are
User - admin
Pass - admin123

But I may be wrong.

12/11/2012 21:23 eclipz13#15

I have the dob.User_Master in the database PS_UserData/Tables
But i can't see any user information :/
I have tried
user - admin
pass - admin123

user - gmlight
pass - gmlight123

user - Shaiya
pass - Shaiya123

I just don't get it :/
I also will need to learn how to add additional log in's because i wan't to be able to play this with my gf and brother once i get it up and running..

I am going to yet again start fresh, removing all the databases and searching in regedit for anything shaiya and removing it
then doing a full re install of mssql and fallowing the tut again i guess :/

Page 1 of 2