error when Attaching Database (PS_GameData_Data.MDF)
Iv'e fallowed the tutorials fully when installing and configuring SQL 2008
But i'm getting an error when Attaching Database (PS_GameData_Data.MDF)
I got the [Release]Full EP6 Shaiya Server Files from
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)
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.
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
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
Here's a screenshot of all my .ini files in C:\Users\EcLiPz\Documents\ShaiyaServer\PSM_Client\ Bin\Config
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
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
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.
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 :/
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..
And i didn't check your logs, cuz they are a real pain to read like that. In future, put them in Spoiler tags
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. <-- For those not sure of this toy, or not as old as I am..
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..
And i didn't check your logs, cuz they are a real pain to read like that. In future, put them in Spoiler tags
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. <-- 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 ..
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..
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.
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 for your edits, it's "harder" to use to a degree, but much easier and quicker. (simple csv in excel)
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
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...
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
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 :/
Help Where the Error at My Database 02/11/2012 - CO2 Private Server - 14 Replies ----Exception message----
Fatal error encountered during command execution.
----End of exception message----
----Stack trace----
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader( CommandBehavior behavior)
at Conquer_Online_Server.Database.MySqlReader.TryFill (MySqlCommand command) in C:\Users\WarCraft\Desktop\Joseph - Copy\Source (Warcraftsco)\Database\MySql\MySqlReader.cs:line 26
at Conquer_Online_Server.Database.MySqlReader..ctor(M ySqlCommand command) in...
V17 Database Error 06/06/2011 - Flyff Private Server - 8 Replies Hey,
ich wollte n P-server nach Mr.Helperīs v17 TuT machen.
Es lief eigentlich alles super, doch als ich den Database server starten wollte kam die bekannte Fehlmeldung "FAIL read ini" usw.....
Bei anderen Threads hab ich bis jetzt noch keine antwort gefunden.
kann mir jemand helfen?
Error when Attaching Databases 05/10/2010 - Shaiya Private Server - 4 Replies Whenever I try attaching the EP4 files to my Database in SMSE, they all fail. Any idea why?
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Attach database failed for Server 'KERC'. (Microsoft.SqlServer.Express.Smo)
For help, click: Source: ID: ( ) - Events And Errors Message Center: Message Details
------------------------------
Database.cs Error? 12/13/2009 - CO2 Private Server - 2 Replies Well I get my friends playing my server and I'm getting this alot. This therefore isn't saving them. They also DC alot but maybe thats more to do with my conenction.
http://img704.imageshack.us/img704/2858/error1n.p ng
and inside line 1183 is the save char region.
public static void SaveCharacter(Game.Character C, string Acc)
{
try
{
FileStream FS = new FileStream(@"C:\OldCODB\Users\Characters\&quo t; + C.Name + ".chr", FileMode.Open);
...
[HELP] DataBase Error 09/12/2008 - CO2 Private Server - 1 Replies http://img261.imageshack.us/img261/739/databaseerr ortw9.png
İ use Steals Server Pack
What is wrong here ??
-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
error when Attaching Database (PS_GameData_Data.MDF)
