PlaneShift

Support => Linux Specific Issues => Topic started by: Debci on February 21, 2009, 07:22:34 pm

Title: Problem at start the game server
Post by: Debci on February 21, 2009, 07:22:34 pm

I dumped all databses to my sql,and i executed ./psserver and the console say this:

Code: [Select]

Could not initialize database cache.
error while initializing server!
What are the problem?

Regards

Title: Re: Problem at start the game server
Post by: weltall on February 21, 2009, 07:58:29 pm

Quote from: Debci on February 21, 2009, 07:22:34 pm

I dumped all databses to my sql,and i executed ./psserver and the console say this:

Code: [Select]

Could not initialize database cache.
error while initializing server!
What are the problem?

Regards

you should check what was the last part successfully loaded. anyway the issue lies in your db (missing tables?)

Title: Re: Problem at start the game server
Post by: Debci on February 22, 2009, 02:13:57 pm

re-dump the tables to the db? are one on one and this are very hard work, i go to test your solution.

regards and thanks

Title: Re: Problem at start the game server
Post by: weltall on February 22, 2009, 06:37:10 pm

Quote from: Debci on February 22, 2009, 02:13:57 pm

re-dump the tables to the db? are one on one and this are very hard work, i go to test your solution.

regards and thanks

create_all.sql should work. in case try enabling logging support in mysql so you can review errors. some old versions of mysql servers have issues with certain sql syntax

Title: Re: Problem at start the game server
Post by: Debci on February 28, 2009, 02:30:10 pm

i executed create_all.sql and it out an error with the line "source namtable.sql" the mysql dont know source command.

regards

Title: Re: Problem at start the game server
Post by: weltall on February 28, 2009, 02:43:57 pm

Quote from: Debci on February 28, 2009, 02:30:10 pm

i executed create_all.sql and it out an error with the line "source namtable.sql" the mysql dont know source command.

regards

strange what version of mysql are you using you should at least update to mysql 5 and run the create_all.sql with source (source create_all.sql from the mysql folder of the server codebase)

Title: Re: Problem at start the game server
Post by: Debci on February 28, 2009, 05:11:03 pm

my sql are 5.0  :(

regards

Title: Re: Problem at start the game server
Post by: weltall on February 28, 2009, 06:42:22 pm

can you post the error output then?
 this is what i use
 mysql --version
mysql  Ver 14.12 Distrib 5.0.67, for debian-linux-gnu (i486) using readline 5.2

Title: Re: Problem at start the game server
Post by: Debci on February 28, 2009, 06:52:34 pm

yee in the error log file i see this:

Code: [Select]

Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'source accounts.sql' at line 1
Regards

Title: Re: Problem at start the game server
Post by: novacadian on December 23, 2010, 01:19:08 am

Bumped this thread as it was the first link that appeared on google when having a similar problem and searching on "source create_all.sql". What was needed in my case was to "use planeshift". Once positioned in the database then the command worked fine. When simply following through the steps in the compiling guide the same error occurred for me too. It is an obvious step when one is used to MySQL yet may be worth a mention in the guide for those less familiar with MySQL.

- Nova