Cabal Database Problem

**jetlastora** · 14-02-09

Hi all fren,

i just want to ask about Cabal Database Error

I am using SQL 2005 Express

I am tryin to test to build a cabal server for my own.

I got al l from Chumpy Collection

I Tried to following the guide, but when i try to restore teh data ACCOUNT

there is error something like this :

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'JETLASTORA'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

The code page 936 is not supported by the server. (Microsoft SQL Server, Error: 2775)

For help, click: http://go.microsoft.com/fwlink?ProdN...5&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Could Anyone help me with this.

Thx

**MentaL**

**cypher** · 14-02-09

well best solution for beginers are to use mssql 2000. as i do not have any idea how to solve this error (i`m using mssql 2000) so i cannot help you.

**jetlastora** · 14-02-09

Anyone can help?

Like ur suggestion cypher,

i try to install MSSQL Server 2000

And try to restore, but there is still problem to restore it

Error Saiys:
Code page 936 is not supported by the operating system.
RESTORE DATABASE database is terminating abnormally.

thx

**cypher** · 15-02-09

what os you have, is it updated?

**chumpywumpy** · 16-02-09

Code page 936 is a Chinese code page (the databases are Chinese collation). I know that it is supported on 2005 express as i have used 2005 on more than one server. Try installing the East Asian language packs and code pages under "Regional and language options" on your control panel as that is how my server is set up language-wise.

http://newton.uor.edu/Departments&Pr...lation_XP.html

The code pages are all the tickboxes on the Advanced tab.

**XvarelaX** · 12-09-10

Sorry post here but I think here is the appropriate place to it.
I'm having problems with database restoration =/, I'm having the error "code page 936" of SQL 2000 SP4. I had installed the language pack and in the advanced tab is already marked the 936 code page, but appears that the SQL don't recognize =/.Can someone help me? Thanks.

-http://img689.imageshack.us/img689/6553/errosql.png
-http://h.imagehost.org/download/0947/Erro_no_SQL

**chumpywumpy** · 14-09-10

Try installing all of the codepages (this is how i had my XP set up back when i still used it). There is also a dropdown that is the language for windows to use for non-unicode applications under those panels, try setting that to Chinese PRC as it might help. I can't remember my exact XP config now :/

I would post some non-Chinese databases but the cabalcash db is moaning about dependencies and i'll have to solve that before i can convert it.

**fredsterj** · 15-09-10

I have the same problem connot restore my DB... Pls. help

**chumpywumpy** · 15-09-10

Actually you have a very different (and easier to solve) problem. See the filename it has in there (c:\program files\microsoft sql server\...)? It is trying to save account.mdf to a folder that does not exist.

Before you click Ok to restore click the Options bit on the top left of the panel. Here you can see the folder it is trying to save to. Create a folder called c:\SQLDatabases\ and then change the path of the .mdf and .ldf file (remember to leave the filename on the end) and then restore.

Another way is to create c:\SQLDatabases\ and then right-click the server name on the left of the sql management window. Select Properties and look under Database Settings. Change the Data and Log folder paths at the bottom to c:\SQLDatabases\ and then restore normally.

My only real guess at the original error is that the language your OS is can't use codepage 936 for some reason. The only real solution i have for that isn't pretty :/

EDIT: I thought of something that might work. Create 3 databases, account, cabalcash and gamedb. Run each of these query files in the right databases and it should hopefully create the database without collation problems.
cabal_dbs_txt.7z

**fredsterj** · 16-09-10

Originally Posted by chumpywumpy

Actually you have a very different (and easier to solve) problem. See the filename it has in there (c:\program files\microsoft sql server\...)? It is trying to save account.mdf to a folder that does not exist.

Before you click Ok to restore click the Options bit on the top left of the panel. Here you can see the folder it is trying to save to. Create a folder called c:\SQLDatabases\ and then change the path of the .mdf and .ldf file (remember to leave the filename on the end) and then restore.

Another way is to create c:\SQLDatabases\ and then right-click the server name on the left of the sql management window. Select Properties and look under Database Settings. Change the Data and Log folder paths at the bottom to c:\SQLDatabases\ and then restore normally.

My only real guess at the original error is that the language your OS is can't use codepage 936 for some reason. The only real solution i have for that isn't pretty :/

EDIT: I thought of something that might work. Create 3 databases, account, cabalcash and gamedb. Run each of these query files in the right databases and it should hopefully create the database without collation problems.
cabal_dbs_txt.7z

Thanks for your help!!! it work's!!! But lastly i have this problem restoring GameDB hope you help me on this agan!!!

**chumpywumpy** · 16-09-10

This is because the database exists and something is using it. Delete the gamedb in the SQL explorer on the left and restore in exactly the same way, a new db will be created as you restore. I always delete old dbs before restoring ;)

**XvarelaX** · 17-09-10

Hi, I solved the problems of code pages =D.But the only code page that don't work is the 874 (thai).Then the only one DB that I can't restore is the "account" DB =/, If you solve it, my problems will be solved.Have you the converted account DB?

Imageshack - erro874.png
Imageshack - dbworking.png

Thanks

**fredsterj** · 17-09-10

All is fine now, centOS. SQL is set my winSCP is ok and my server is running but my problem is i cant connect my client.
MY LOG FILE:

Spoiler:

/var/log/cabal
varlogcabal.rar

**allocen** · 17-09-10

are you really so noob?? Did u chekm in options if if overwrite the database and check it?

**Yamachi** · 17-09-10

Originally Posted by allocen

are you really so noob?? ...

Do you have to talk to people like this? ¬_¬

**fredsterj** · 17-09-10

Originally Posted by allocen

are you really so noob?? Did u chekm in options if if overwrite the database and check it?

Yup im a noob!!! cause im not pretending to be good as you!!! Regarding to your opinion yes i have check all the database to overwrite the data, so how can you help?

Another thing when i create a account with chumpy's GM tool's here's the LOG file,

---- 9/18/2010 1:52:57 AM
SQL error 80040E21
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
DB address: 192.168.100.3 (1433, false)
DB user: sa

**chumpywumpy** · 17-09-10

Originally Posted by XvarelaX

Hi, I solved the problems of code pages =D.But the only code page that don't work is the 874 (thai).Then the only one DB that I can't restore is the "account" DB =/, If you solve it, my problems will be solved.Have you the converted account DB?

Imageshack - erro874.png
Imageshack - dbworking.png

Thanks

Did you try running the queries i added to my last post? These should be able to create the database regardless of the server language settings (it will use the server's language). This is a good idea because your players can name chars in your own language (as long as the cabalmain exe supports it) as not all accents and symbols work on the old databases.

Originally Posted by allocen

are you really so noob?? Did u chekm in options if if overwrite the database and check it?

Calling another person a noob only works if you give the correct answer. If not (like here) you just look stupid ;) This problem is that not all computers can use the collation the databases currently use (936 Chinese PRC + some tables using other Asian languages).

Originally Posted by fredsterj

Yup im a noob!!! cause im not pretending to be good as you!!! Regarding to your opinion yes i have check all the database to overwrite the data, so how can you help?

Another thing when i create a account with chumpy's GM tool's here's the LOG file,

---- 9/18/2010 1:52:57 AM
SQL error 80040E21
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
DB address: 192.168.100.3 (1433, false)
DB user: sa

Your game client is crashing because of bad patch files. This happens to more people using the 2.81 patch than i would like (but it works for me!). Look at www.mediafire.com/chumpy for the updated version based on LostSpirit's patch which is much better.

What action are you performing when the gm tools error appears (loading, new account, giving items etc)? This error is usually because of trying to add too many characters into a text field in SQL but it does have a few other meanings and i can't tell from that log :/

**XvarelaX** · 18-09-10

I ran the query but I had some mistakes look:
http://img810.imageshack.us/img810/1106/myaccount.png
http://img822.imageshack.us/img822/4056/erroaccount.png
thanks

**fredsterj** · 18-09-10

Im trying to find my name but it say's user not found in account database,
again my error log:

---- 9/18/2010 12:14:50 PM
SQL error 80040E21
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
DB address: 192.168.100.3 (1433, false)
DB user: sa

**chumpywumpy** · 18-09-10

Originally Posted by XvarelaX

I ran the query but I had some mistakes look:
http://img810.imageshack.us/img810/1106/myaccount.png
http://img822.imageshack.us/img822/4056/erroaccount.png
thanks

The items the script is trying to create already exist. Delete/rename the account db, create a new empty one and run the script again.

I specifically didn't set the script to overwrite existing tables just in case ;)

Originally Posted by fredsterj

Im trying to find my name but it say's user not found in account database,
again my error log:

---- 9/18/2010 12:14:50 PM
SQL error 80040E21
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
DB address: 192.168.100.3 (1433, false)
DB user: sa

That's and odd one. Try running the query below on your account db after adding your account name and see what shows up:

select * from account.dbo.cabal_auth_table where id='<username>'

Also try the gm tools v2 alpha at Index of /gmtools2 and see if that works (v2 is far better than 0.6x).

**skincelcret** · 19-09-10

Hey chumpy, with cabal tools I created a account and its work fine, but the character creation no =/. Here is the putty log to see the conection with DB :

Spoiler:

what i need to tray pls help me

**chumpywumpy** · 20-09-10

Hmmmm, that is a new error. When you log into sql using the sql management studio does the server name have \SQLEXPRESS in it?

**XvarelaX** · 20-09-10

Hey chumpy, where is this management studio?! if it is the enterprise manager, the server is with name: "(local) windows NT".and the name on service manager is \\computador-01. Edit: and in the query analyzer don't have a named server, I put my login and my password and go for my sarver with name (local) windows NT.

Thanks =]

**skincelcret** · 21-09-10

done fixed its work great thx chupy

**XvarelaX** · 22-09-10

hi chumpy, here the SS from SQL query manager with name of server:

Imageshack - myserver.png
Imageshack - myservers.png

Thanks =]

Cabal Database Problem

Thread Tools

Search Thread

Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Re: Cabal Database Problem

Advertisement