Sql Datbase error

[el-king]

Hi Otland I downlaod alot of ots from otland but cant open the ot because the databse can anyone give me database and sqlite studio .

 

[WibbenZ]

The reason it isen't working is since 1.x only has support for MySQL as you can see in the error.
Reason for not using TFS? This forum mainly has support for TFS, if you want support for that server - do as it says, go to xtibia.com.

 

[el-king]

Thx!!

 

[Limos]

Change localhost to 127.0.0.1 in config.lua.

 

[el-king]

Change localhost to 127.0.0.1 in config.lua.

Limos I want Sqllite editor
to give my account admin
i downloaded another sqllite and it cant open it i dont know why

 

[Limos]

I'm not familiar with SQLiteStudio, I would recommend to use SQLite Manager (Firefox add-ons) instead if you want to use SQLite, it's alot more easy to understand.
You can also just use MySQL btw, also when you use scripts here that require extra tables/columns, the queries are usually made for MySQL.

 

[el-king]

I'm not familiar with SQLiteStudio, I would recommend to use SQLite Manager (Firefox add-ons) instead if you want to use SQLite, it's alot more easy to understand.
You can also just use MySQL btw, also when you use scripts here that require extra tables/columns, the queries are usually made for MySQL.

Thank You limos i will test it.

 

[Lordfire]

Your server seems to support both MySQL and SQLite, and you have to change the setting to use SQLite file instead of MySQL server on config.lua. I think it's called "sqlType" and defaults to mysql, use sqlite instead.

 

[el-king]

Your server seems to support both MySQL and SQLite, and you have to change the setting to use SQLite file instead of MySQL server on config.lua. I think it's called "sqlType" and defaults to mysql, use sqlite instead.

sqlType = "sqlite"
change it to sqlType = "mysql"
?

lord fire i change it to mysql and the ot bugged and closed

 

[Limos]

If you use MySQL you have to setup a MySQL database.
https://otland.net/threads/video-tu...ing-ot-server-website-and-shop-system.166818/
The first part is for MySQL.

 

[el-king]

If you use MySQL you have to setup a MySQL database.
https://otland.net/threads/video-tu...ing-ot-server-website-and-shop-system.166818/
The first part is for MySQL.

Thank You Limos This Video Helped Me Very Much

 

[Lordfire]

No, man, if you want SQLITE then use SQLITE. Be reasonable.

 

[el-king]

Limos i watched video and tested what he do but i cant open phpmyadmin i tested 127.0.01 and cant open

 

[tanii]

go to config.lua search mysql change to sqlite!

 

[el-king]

go to config.lua search mysql change to sqlite!

Tani Open FAcebook to message you