mysql

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...

Hello guys I have problem,I use tfs 0.4and when I turn on my server is error in console How I can fix it?Be cause I can not find how I can do it

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...

this error is occurring when logging out the player. [Error - mysql_real_query] Query: UPDATE players SET level = 1,group_id = 1,vocation = 0,health = 150,healthmax = 150,experience = 0,lookbody = 106,lookfeet = 95,lookhead = 78,looklegs = 116,looktype = 128,lookaddons = 0,maglevel = 0,mana =...

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...

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'bought' in 'order clause'' in C:\xampp\htdocs\shopsystem.php:170 Stack trace: #0 C:\xampp\htdocs\shopsystem.php(170): PDO->query('SELECT * FROM `...') #1...

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...

Hello friends, I would like to know if someone on the forum knows or is more involved in this area of OTS, although we know YurOTS 7.6 xml is obsolete. but my server has been online for more than 11 years and I need my database, I would like to know if it is possible that my XML database can be...

Hello guys! I would like to know if there is a talkaction script so that I can remove certain storage from a player. Something like that: /storage "player_name", storage, nill or 1 or -1 On the other hand I would like to know the command line to be able to execute this same function to...