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: Mon Sep 22, 2008 4:15 pm
Location: Kladno, Czech republic

Missing SQL tables - how to create them

Post by igneus » Mon Sep 29, 2008 1:12 pm

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: Thu Aug 25, 2005 5:08 pm
Location: Germany

Re: Missing SQL tables - how to create them

Post by Crush » Mon Sep 29, 2008 1:44 pm

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: Mon Sep 22, 2008 4:15 pm
Location: Kladno, Czech republic

Re: Missing SQL tables - how to create them

Post by igneus » Mon Sep 29, 2008 2:02 pm

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: Thu Nov 01, 2007 6:35 pm
Location: Internet

Re: Missing SQL tables - how to create them

Post by Jaxad0127 » Mon Sep 29, 2008 2:16 pm

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: Thu Aug 25, 2005 5:08 pm
Location: Germany

Re: Missing SQL tables - how to create them

Post by Crush » Mon Sep 29, 2008 2:23 pm

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: Thu Nov 01, 2007 6:35 pm
Location: Internet

Re: Missing SQL tables - how to create them

Post by Jaxad0127 » Mon Sep 29, 2008 2:40 pm

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: Sun Jul 20, 2008 4:46 pm
Location: Germany
Contact:

Re: Missing SQL tables - how to create them

Post by Exceptionfault » Wed Oct 01, 2008 10:36 am

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