-
2026 staff recruitment is open! Check it out and consider applying!
Search results
-
R
Items dont save
Thank you. I pasted what Ninja told me to in my schemas, and when I went to paste it into my DB as well I get: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"tile_items" ( "tile_id" INT UNSIGNED NOT... -
R
Items dont save
Oh, okay - Thank you. That helped a lot. "#1146 - Table 'tibia.tile_items' doesn't exist" I still can't seem to find tibia.tile_items, and I have no idea where it could be. I tried going into my OT files and "doc", but I see nothing. I also tried making a new one to see if I could find the file... -
R
Items dont save
Ah, I feel silly, but I can't follow the help that you guys are trying to give me. I'm trying to find out where to put the SQL Code, and I'm in my database, and I paste that code into the section that says "SQL query on database DBname" But I get the error: "You have to choose at least one... -
R
Items dont save
I'm using TFS (9.60), Melillandia map, and REM map editor. I'm having a problem with items on the house floor disappearing after I shut down the server. Almost like they're not "houses" and just outside or something. The error I get is: [15/05/2013 16:12:11] mysql_real_query(): SELECT * FROM... -
R
Common SQL error
-- The Forgotten Server Config -- Account Manager accountManager = "yes" newPlayerChooseVoc = "yes" newPlayerSpawnPosX = 95 newPlayerSpawnPosY = 117 newPlayerSpawnPosZ = 7 newPlayerTownId = 1 newPlayerLevel = 1 newPlayerMagicLevel = 0 generateAccountNumber = "no" -- Banishments... -
R
Common SQL error
I followed this tutorial and managed to get to the point of hosting it with the config changed. The issue I'm having is I have to change "Localhost" to "127.0.0.1" or the server will give me an SQL error and shut down. I know the solution is to just change "localhost" to "127.0.0.1" because... -
R
SQL, SQLite...wait
My config.lua looks: -- Connection Config ip = "24.141.***.**" bindOnlyGlobalAddress = "no" loginProtocolPort = 7171 gameProtocolPort = 7172 adminProtocolPort = 7171 statusProtocolPort = 7171 No random spaces or anything like that. Firewall is down, and I added port 7171, 7172 and 80 to... -
R
SQL, SQLite...wait
Yes. I've tried most of the 192.168.0.### IPs (my host IPv4 and my laptop IPv4 on the IPchanger), my global IP, localhost and 127.0.0.1. The only one that "works" is the 192.168.0.100, which brings me to the character log in screen, lets my choose a character and finally gives me the... -
R
SQL, SQLite...wait
That's the portforwarding configuration. -- Connection Config ip = "24.141.***.**" Other people are able to log in, and I'm able to log in on my host computer so I don't think it's an issue of portforwarding. I'm just not able to log on with my laptop (that shares the same network as my host... -
R
SQL, SQLite...wait
@Evan: When I put in the 192.168.x.x IP, it brings me to the character page and when I try to log in it gives me the connection time out screen. If I use the "localhost", it jumps right to "connection timeout". @Limos: Yeah, I used the IPv4 address to open all of the ports. Edit: I'm able to... -
R
SQL, SQLite...wait
Well, my config.lua looks like: -- Connection Config ip = "IP I got from what is my ip" bindOnlyGlobalAddress = "no" loginProtocolPort = 7171 gameProtocolPort = 7172 adminProtocolPort = 7171 statusProtocolPort = 7171 And: -- MySQL mysqlHost = "127.0.0.1" mysqlUser = "myservername"... -
R
SQL, SQLite...wait
Thank you for all the help :) I'm following the tutorial now, and I ran into a problem with the OT shutting off because of the SQL change, but I changed "localhost" into the 127. IP. Everything seems to be working and I can log on from this computer, but I'm having one more issue. I'm not... -
R
SQL, SQLite...wait
I've been out of the OT world for awhile, and I just recently tried to host again ... But I've run into many problems. First problem: Everything works fine, I can log in and my friend can log in. The server we're using (FTS) has the AM start off on a solo island - with no way to get off...