Page 1 of 1
unknown dspdb database error
Posted: Fri Nov 28, 2014 12:07 pm
by Drexiom
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.
Re: unknown dspdb database error
Posted: Fri Nov 28, 2014 4:56 pm
by kjLotus
you (or whatever tool you used) didn't create the database
Re: unknown dspdb database error
Posted: Fri Nov 28, 2014 11:56 pm
by atom0s
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.
Re: unknown dspdb database error
Posted: Sat Nov 29, 2014 12:14 pm
by Drexiom
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.
Re: unknown dspdb database error
Posted: Sat Nov 29, 2014 2:03 pm
by atom0s
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
Re: unknown dspdb database error
Posted: Sat Nov 29, 2014 2:42 pm
by kjLotus
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
Re: unknown dspdb database error
Posted: Sat Nov 29, 2014 7:48 pm
by Drexiom
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.
Now i just have to figure out how to unlock all of the expansions. lol
Re: unknown dspdb database error
Posted: Sat Nov 29, 2014 9:47 pm
by Shadowmh
Unlock as in enable them?
Will find that in the settings.lua file in darkstar > scripts > globals
Re: unknown dspdb database error
Posted: Sat Nov 29, 2014 11:29 pm
by Drexiom
Sweet thanks alot Shadow!