unknown dspdb database error

Post Reply
Drexiom
Posts: 5
Joined: Sun Nov 16, 2014 2:35 am

unknown dspdb database error

Post by Drexiom » Fri Nov 28, 2014 12:07 pm

Hey guys I'm new to all of this but I'm trying to figure it all out. I followed the wiki server guide step by step and I keep getting this "1049 unknown dspdb database" error every time I try to start the servers. I can even see it when I run the .bat file in the darkstar/sql folder. I know this is probably a real noobish question and I'm sorry if it is. Any help would be much appreciated Thanks.

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: unknown dspdb database error

Post by kjLotus » Fri Nov 28, 2014 4:56 pm

you (or whatever tool you used) didn't create the database

User avatar
atom0s
Developer
Posts: 537
Joined: Thu Oct 25, 2012 9:52 am

Re: unknown dspdb database error

Post by atom0s » Fri Nov 28, 2014 11:56 pm

The batch file that is posted on the forums here for easy setup assumes you have MySQL added to your environment variables so that you can access the MySQL binaries from anywhere on your system. Without it, the batch will just spew a bunch of errors saying it has no idea what mysql means.

Drexiom
Posts: 5
Joined: Sun Nov 16, 2014 2:35 am

Re: unknown dspdb database error

Post by Drexiom » Sat Nov 29, 2014 12:14 pm

Thanks for the quick responses. I downloaded the files with the git clone method on the wiki into the server folder. I thought the .bat file creates the database with those files? I'm really sorry for my lack of knowledge. I guess I'm missing a step or something. I've looked through many forum post to find something that was related to no avail. I downloaded and installed Mysql like the wiki explained. I'm not sure how to implement it into the environment though.

User avatar
atom0s
Developer
Posts: 537
Joined: Thu Oct 25, 2012 9:52 am

Re: unknown dspdb database error

Post by atom0s » Sat Nov 29, 2014 2:03 pm

Drexiom wrote:Thanks for the quick responses. I downloaded the files with the git clone method on the wiki into the server folder. I thought the .bat file creates the database with those files? I'm really sorry for my lack of knowledge. I guess I'm missing a step or something. I've looked through many forum post to find something that was related to no avail. I downloaded and installed Mysql like the wiki explained. I'm not sure how to implement it into the environment though.
As I said, the batch file assumes you already have MySQL added to your environment variables. If not it will just throw errors for every file it tries to run.

Read this on how to add MySQL to your PATH variable:
http://dev.mysql.com/doc/mysql-windows- ... -path.html

User avatar
kjLotus
Special Guest
Posts: 1813
Joined: Sun Jul 22, 2012 2:16 pm

Re: unknown dspdb database error

Post by kjLotus » Sat Nov 29, 2014 2:42 pm

Drexiom wrote:Thanks for the quick responses. I downloaded the files with the git clone method on the wiki into the server folder. I thought the .bat file creates the database with those files? I'm really sorry for my lack of knowledge. I guess I'm missing a step or something. I've looked through many forum post to find something that was related to no avail. I downloaded and installed Mysql like the wiki explained. I'm not sure how to implement it into the environment though.
yeah, it does, but there's probably an error. if you paste the CREATE DATABASE line into cmd from the .bat file, you can see what it says. only things I can really think of is mysql not part of PATH, or you forgot to replace the username/password in the bat file

Drexiom
Posts: 5
Joined: Sun Nov 16, 2014 2:35 am

Re: unknown dspdb database error

Post by Drexiom » Sat Nov 29, 2014 7:48 pm

Thank you soo much KjLotus and Atom0s! You guys have been an amazing help. It's working now i followed the guide to set the path. Now it works like a charm. :D Now i just have to figure out how to unlock all of the expansions. lol

User avatar
Shadowmh
Posts: 60
Joined: Fri Nov 29, 2013 1:26 am

Re: unknown dspdb database error

Post by Shadowmh » Sat Nov 29, 2014 9:47 pm

Unlock as in enable them?

Will find that in the settings.lua file in darkstar > scripts > globals

Drexiom
Posts: 5
Joined: Sun Nov 16, 2014 2:35 am

Re: unknown dspdb database error

Post by Drexiom » Sat Nov 29, 2014 11:29 pm

Sweet thanks alot Shadow!

Post Reply