Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
MariaDB is one of the most popular choices for databases. It was created by the same developers of MySQL with the goal to make it better in terms of security and performance. So if you're still using MySQL in 2024, it's time to update to MariaDB. This tutorial will guide you through the process...
Hello guys I make char bazzar in myacc and when I add char to auction is error
Exception class: PDOException()
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to...
I get these errors on console every few days. Can someone explain what they are and how to fix them?
Should I be concerned about any of them?
[Error - mysql_real_query] Query: SELECT `reason`, `expires_at`, (SELECT `name` FROM `players` WHERE `id` = `banned_by`) AS `name` FROM `ip_bans` WHERE...
Hello, can anyone help me to fix it. When i start the server all is good and work. After 4 - 48 hours it come this error. Whats wrong. All local adresses 127.0.0.1 and localhost....
internet kick isnt ,because if i restart uniserv msql all will work. But only for some hours...
I use a windows...
I've seen way too many tutorials showing how to setup MySQL server on a VPS.
Please stop using mysql-server. Instead, use MariaDB.
It is the exact same as MySQL (meaning: the same developers, the same features [and many more]).
But MariaDB is much more secure, much faster (2-3x in most cases)...
Hey guys,
Recently, I've been thinking about starting a 4fun TibiaFun server and I've started working on it on Linux since I couldn't find a Windows version with the source code. After a few hours of refactoring the code, I was able to compile it on Ubuntu 20.04.
However, I'm now facing an...
hello, i can't make my own tibia server, the engine compilation went without a problem, only I have a problem with specifying the destination path, acc maker does not detect my config.lua folder.
I have clean Debian 11, what do I need to install to make it work?
Hello everyone,
i got the error "no tables were optimized" after i compiling tfs 1.2 8.0, do someone know how to fix it?
befor the compilign the databse were normally connected, after source change and new compiling displayed this error...
i created an new db it doesnt help.
thanks for help...
Hi guys, I'm new here. Are you okay?
I'm having trouble splitting my otserv and site on separate machines. Something strange happened.
The machine that is the server is a ubuntu 14.04 and the site is hosted on another ubuntu 20 machine.
I did the configuration, the server connected to the...
Hello guys, good morning.
Today after some hours running my server, this error appeared:
[error - mysql_real_query] query: select reason, expires_at, (select name from players where id = banned_by) as name from ip_bans where ip = 1076197311
Any idea how can be fixed and how it happens...
Hello everyone, everything good?
A few days ago I have noticed that my server has been giving errors in some tables (which I always repair in PHPMyAdmin), but they come back. Another thing that caught my attention is the error when reading communication packets, apparently it doesn't affect the...
I'm testing the server and re-learning how to use everything on linux after a few years...
I've read the wiki
https://github.com/DevelopersPL/otshosting-provisioning/wiki/Where-is-what-important-files-and-directories
But on my server there's no file .my.cnf with MySQL client config that...
Sorry about my English!
I have a 7.6 server I wanted to move it from Sqlite to Mysql, is this exchange possible?
I'm trying to put a website on that server and I'm not getting!
It fits that I'm using:
Hello everyone, that's a classic server files based on YurOTS version 0.94d.
Has been added:
new monsters,
weapons attributes,
shared experience,
tasks,
daily monsters event,
ammunition quiver,
monsters conditions,
quests,
arena and more!
Download and Tutorial
Since all other Database Backup Tutorials on this forum are either bad, not working reliable or out of date, I thought I'd just quickly make a new one.
I personally use logrotate to manage my backups. This has the advantage, that I can tell my server how long I want him to save the backup file...
Yo! im working with this function, its suppose to add points to guild when they do X activities:
function doGuildAddPoints(guild_id, value)
local func = db.executeQuery or db.query
return func("UPDATE guilds SET points = ("..value.." + (SELECT points FROM guilds WHERE id = "..guild_id.."))...
Hello there, Im new on OTLAND, and my problem is the next...
I try doing this SET GLOBAL max_allowed_packet = 16776192; but the problem still persists....
Also modify the xampp / mysql / bin / my.ini file and change 16M to 64M and I still have that error, it happens every time in the console...