Database

[Sizaro]

1. I downloaded a brand new theforgottenserver-v0.2.9-win32gui
2. I configured;

-- MySQL
	mysqlHost = "localhost"
	mysqlUser = "root"
	mysqlPass = "da"
	mysqlDatabase = "theforgottenserver"
	mysqlPort = 3306

3. I created a database named theforgottenserver and changed the password for phpmyadmin to da
4. I created account with the account manager and logged into tibia
5. I restarted the server and logged into tibia

And still, there is no character in my players@theforgottenserver database <_<
???
I can still walk around and then restart, and i'm still at the same spot, so where the fk is my character stored LOL?!

 

[Chris]

Change the SQL type from sqlite to mysql.

sqlType = "xxx"

 

[Sizaro]

Worked, just wondering how my character could still be ingame if it wasn't stored in the database? x.x

 

[Jockiboi]

sqlite?

 

[Chris]

Yeah, it was stored within the SQLite database (which is a file located within your schema folder or something like that).

 

[Williameads]

I changed mine to mysql and when i did it starts up but than it says
[05/10/2015 08:33:25] >> Starting SQL connection

than it says the forgotten server has stopped working.

 

[Codex NG]

I changed mine to mysql and when i did it starts up but than it says
[05/10/2015 08:33:25] >> Starting SQL connection

than it says the forgotten server has stopped working.

You need to launch whatever server host emulator your using e.g. xampp when that is running then you launch the game server, you also need to make sure you imported the schema into the server host emulator into whatever database is labeled in the config file.

 

[Awpolo]

im having this same issue and cant seem to fix it