Xamp Error

[bomba]

I have an error on impot my database.s3db to xamp:

sqlType: Sqlite.

 

[EvulMastah]

You dont import sqlite database to XAMPP, you dont even need XAMPP while using SQLite... :O

SQLite Manager for FireFoX

 

[bomba]

Hum... how I can use MySql??

 

[EvulMastah]

Import schema.mysql

 

[bomba]

I have a forgotten.sql
I can import it?

 

[EvulMastah]

I have a forgotten.sql
I can import it?

Yea, you have to

 

[bomba]

Aff, an error:

 

[EvulMastah]

See if you have proper settings in config.lua, sql part (user, pass, database)

 

[bomba]

	-- Database
	-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
	-- To disable sqlKeepAlive use 0 value.
	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = ""
	sqlDatabase = "schema"
	sqlFile = "schema.mysql"
	sqlKeepAlive = 60
	passwordType = "plain"

 

[josejunior23]

	-- Database
	-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
	-- To disable sqlKeepAlive use 0 value.
	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = ""
	sqlDatabase = "schema"
	sqlFile = "schema.mysql"
	sqlKeepAlive = 60
	passwordType = "plain"

you have to change:
sqlPass = ""
sqlDatabase = "schema"


você precisa mudar:
sqlPass = ""
sqlDatabase = "schema"

 

[bomba]

Mudar: sqlDatabase = "schema"
...para qual?

 

[bomba]

I created a character in website but at the time that I connect to the server says there is invalid-account.
It seems that the server is not connecting with the website.

 

[Richi Garza]

	-- Database
	-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
	-- To disable sqlKeepAlive use 0 value.
	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = ""
	sqlDatabase = "schema"
	sqlFile = "schema.mysql"
	sqlKeepAlive = 60
	passwordType = "plain"

in sqlpass you put your php myadmin pass.
in sqlDatabase you put the name of the table your using example in my i use ot

this is an example of how config should look

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "[COLOR="Red"][B]your pass[/B][/COLOR]"
	sqlDatabase = "ot" <----- [B][COLOR="#ff0000"]your table base[/COLOR][/B]
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 60
	passwordType = "plain"

 

[bomba]

Don't work...
Test my website:

http://tenemur.servegame.com:8090/7172/login.php?redirect=account.php

tenemur.servegame.com
7172
Please look!

 

[bomba]

UP!

 

[Richi Garza]

Don't work...
Test my website:


tenemur.servegame.com
7172
Please look!

are you sure you used your database table name in database section..

you can use this tutorial click here

 

[bomba]

Don't work...
ps: I have 2 servers with website, the server 1 work but the server 2 no.
The server 2 I create an acc in website, I go enter in tibia with my acc and not exist.

 

[Zonet]

Yoru know what man... go learn tutorial for SQL cuz in the picture i see the you're importing a SQLITE Database

you must import a Mysql databse.

 

[bomba]

I was import the forgotten.SQL database...