Problem at start the game server

[Debci]

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

[weltall]

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?)

[Debci]

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

[weltall]

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

[Debci]

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

regards

[weltall]

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)

[Debci]

my sql are 5.0 

regards

[weltall]

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

[Debci]

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

[novacadian]

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