Missing SQL tables - how to create them

Ask for help regarding any technical issue or report any bug or OS independent issues.
Post Reply
User avatar
igneus
Peon
Peon
Posts: 75
Joined: 22 Sep 2008, 16:15
Location: Kladno, Czech republic

Missing SQL tables - how to create them

Post by igneus » 29 Sep 2008, 13:12

I downloaded Elven Programmer's nightly builds of tmwserv and 0.1 client for Windows and started both account server and game server. The client can connect to them, but it is impossible to register - client always says that the chosen nick is already used, but according to account server log it is due to another problem - table tmw_accounts doesn't exist. Could anyone tell me how to create this table (and possibly other ones which I need to have my own experimental TMW server)?
main TMW character: nguma
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: 25 Aug 2005, 17:08
Location: Germany

Re: Missing SQL tables - how to create them

Post by Crush » 29 Sep 2008, 13:44

You will find a precreated database file in src/sql/sqlite/tmw.db. Just copy it into the same folder where you have the accountserver executable.

Yes, we are aware that this is not the best solution and we are currently working on a more comfortable one.
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
User avatar
igneus
Peon
Peon
Posts: 75
Joined: 22 Sep 2008, 16:15
Location: Kladno, Czech republic

Re: Missing SQL tables - how to create them

Post by igneus » 29 Sep 2008, 14:02

Thank you. The Elven's nighly build doesn't contain src/ directory, but I copied the database from the SVN repository and it works.
main TMW character: nguma
User avatar
Jaxad0127
TMW Adviser
TMW Adviser
Posts: 4209
Joined: 01 Nov 2007, 18:35
Location: Internet

Re: Missing SQL tables - how to create them

Post by Jaxad0127 » 29 Sep 2008, 14:16

Best not to use the included DB, as its out of date. If you have sqlite installed, you can use the script in the same folder as that db to create a new one.
Image
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: 25 Aug 2005, 17:08
Location: Germany

Re: Missing SQL tables - how to create them

Post by Crush » 29 Sep 2008, 14:23

Are you sure that it is out of date? The last revision which updated the script also updated the tmw.db.
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
User avatar
Jaxad0127
TMW Adviser
TMW Adviser
Posts: 4209
Joined: 01 Nov 2007, 18:35
Location: Internet

Re: Missing SQL tables - how to create them

Post by Jaxad0127 » 29 Sep 2008, 14:40

Didn't notice that part. When I set up a 0.1 server two weeks ago, I was told to ignore the pre-built one.
Image
Exceptionfault
Peon
Peon
Posts: 21
Joined: 20 Jul 2008, 16:46
Location: Germany
Contact:

Re: Missing SQL tables - how to create them

Post by Exceptionfault » 01 Oct 2008, 10:36

The pre-built one is up to date and is nothing more or less than the executed createTables.sql script. It is just another option for e.g. windows users that don't have an sqlite3 executable available.

btw. have a look at the wiki page for setting up a new server:
http://wiki.themanaworld.org/index.php/ ... p_a_server
or especially for database configuration:
http://wiki.themanaworld.org/index.php/ ... stallation
Never say: "Always"! Always say: "Never say never"! - Tom Kyte @ Ask Tom Live in Berlin 2008

Image
Post Reply