Help with my ot.

[prav]

Hey guys can some one help me fix this every time i try load my ot up it says ERROR Failed to connect to sqlit database file what do i do.

 

[Tarek]

Post your config.lua and i maybe can help you^^

 

[prav]

-- The Forgotten Server Config

   -- Account Manager
   accountManager = "yes"
   newPlayerChooseVoc = "no"
   newPlayerSpawnPosX = 95
   newPlayerSpawnPosY = 117
   newPlayerSpawnPosZ = 7
   newPlayerTownId = 1
   newPlayerLevel = 1
   newPlayerMagicLevel = 0
   generateAccountNumber = "yes"

   -- Banishments
   broadcastBanishments = "yes"
   banDays = 7
   finalBanDays = 30
   killsToBan = 5

   -- Battle
   worldType = "pvp"
   hotkeyAimbotEnabled = "yes"
   protectionLevel = 1
   killsToRedSkull = 3
   pzLocked = 60000
   deathLosePercent = 10
   criticalHitChance = 7
   removeAmmoWhenUsingDistanceWeapon = "yes"
   removeChargesFromRunes = "yes"
   removeChargesFromWeapons = "yes"
   timeToDecreaseFrags = 24 * 60 * 60 * 1000
   whiteSkullTime = 15 * 60 * 1000
   oldConditionAccuracy = "no"
   alternativeExhaust = 1000
   stairJumpExhaustion = 2000
   animationTextOnHeal = "yes"

   -- Commands
   displayGamemastersWithOnlineCommand = "no"

   -- Connection Config
   ip = "127.0.0.1"
   loginProtocolPort = 7171
   gameProtocolPort = 7172
   adminProtocolPort = 7171
   statusProtocolPort = 7171
   loginTries = 10
   retryTimeout = 5 * 1000
   loginTimeout = 60 * 1000
   maxPlayers = "1000"
   motd = "Welcome to the Forgotten Server!"
   onePlayerOnlinePerAccount = "yes"
   allowClones = "no"
   serverName = "Forgotten"
   loginMessage = "Welcome to the Forgotten Server!"
   adminLogsEnabled = "no"
   statusTimeout = 5 * 60 * 1000
   replaceKickOnLogin = "yes"

   -- Deathlist
   deathListEnabled = "yes"
   maxDeathRecords = 5

   -- Guilds
   ingameGuildSystem = "yes"
   levelToCreateGuild = 8

   -- Highscores
   highscoreDisplayPlayers = 15
   updateHighscoresAfterMinutes = 60

   -- Houses
   housePriceEachSQM = 1000
   houseRentPeriod = "never"

   -- Idle
   kickIdlePlayerAfterMinutes = 15

   -- Item Usage
   timeBetweenActions = 200
   timeBetweenExActions = 1000

   -- Map
   mapName = "forgotten"
   mapAuthor = "Komic"
   randomizeTiles = "yes"
   mapStorageType = "relational"

   -- Messaging
   maxMessageBuffer = 4

   -- MySQL
   mysqlHost = "localhost"
   mysqlUser = "root"
   mysqlPass = ""
   mysqlDatabase = "theforgottenserver"
   mysqlPort = 3306

   -- Premium Account
   freePremium = "no"

   -- PVP Server
   displayOnOrOffAtCharlist = "no"
   allowChangeOutfit = "yes"
   noDamageToSameLookfeet = "no"
   experienceByKillingPlayers = "no"

   -- Rates
   rateExp = 5
   rateSkill = 3
   rateLoot = 2
   rateMagic = 3
   rateSpawn = 1

   -- Real Server Save
   -- note: serverSaveHour means like 03:00, not that it will save every 3 hours,
   -- if you want such a system use autoSaveEachMinutes. this serversave method
   -- may be unstable, we recommend using otadmin if you want real serversaves.
   serverSaveEnabled = "no"
   serverSaveHour = 3
   shutdownAtServerSave = "yes"
   cleanMapAtServerSave = "yes"

   -- Server saving
   autoSaveEachMinutes = 15
   saveGlobalStorage = "no"

   -- Spawns
   deSpawnRange = 2
   deSpawnRadius = 50

   -- SqLite
   sqliteDatabase = "forgottenserver.s3db"

   -- SQL
   sqlType = "sqlite"
   passwordType = "plain"

   -- Startup
   defaultPriority = "high"

   -- Shutdown
   freeMemoryAtShutdown = "yes"

   -- Status
   ownerName = ""
   ownerEmail = "@otland.net"
   url = "http://otland.net/"
   location = "Europe"

 

[Tarek]

What TFS do you use? Because my 0.3.6 config doesn't look like this
@Limos

 

[Limos]

Am I supposed to guess his server version?
Looks like some TFS 0.2 version, probable 0.2.14 or 0.2.15.

@prav
Post the full error or a screenshot of your console and which server you use.

 

[prav]

Dont matter i got the ot working now but when i make a acc it dosent save so when i open it on the sqlitebrowser there is only the account manager there its a 8.62 ot.

 

[Limos]

TFS 0.2.8?

After you created an account and character, can you login with it again after restarting the server? If you can, make sure you open the right database.

 

[prav]

aa sweet i got it thank you 1 last problem when i try use the commands they dont work.

 

[Limos]

I assume you use TFS 0.2.8 then. Set type in accounts to 5.

 

[prav]

Ye i did that and it only went up to cm i cant use /attr and all them :/. sorry for all the question im new to making ots i just started 3h ago.

 

[Limos]

This command does not exist in TFS 0.2.8, you can find the commands in data/XML/commands.xml.

 

[prav]

Is there anyway i can add a few commands? and how do i make my self god also?

 

[Limos]

Use group_id 3 for a god. You can add talkaction scripts for new commands, however, TFS 0.2 is pretty limited when it comes to item attributes, so you can only set description, text and actionid (without source edits).
You can also use a 0.3/0.4 version instead which has this all by default or if you want to use a higher client version you can use TFS 1.0 or TFS 1.1.

 

[prav]

Is there a way i can make a 9.81 ot so i can get mounts. As this ot is very bad that i have created.

 

[Limos]

If you want mounts you can use the latest version, TFS 1.1, it's for client 10.76, so then you can use all the latest mounts aswell, like this one.

https://github.com/otland/forgottenserver

 

[prav]

I have that server but everytimei laod it p it says this [04/04/2015 18:46:07] > ERROR: Failed to connect to sqlite database file, make sure it exists and is readable, what do I do.

 

[Tarek]

If you want mounts you can use the latest version, TFS 1.1, it's for client 10.76, so then you can use all the latest mounts aswell, like this one.

https://github.com/otland/forgottenserver

I told you. You are good to guess server version XD

 

[Tarek]

I have that server but everytimei laod it p it says this [04/04/2015 18:46:07] > ERROR: Failed to connect to sqlite database file, make sure it exists and is readable, what do I do.

And, did you that the s3db file has same name as in the config.lua? Maybe that option doesn't exist in tfs 1.0.. idk

 

[Limos]

I have that server but everytimei laod it p it says this [04/04/2015 18:46:07] > ERROR: Failed to connect to sqlite database file, make sure it exists and is readable, what do I do.

TFS 1.1 doesn't have SQLite.

Tutorial to setup MySQL.
https://otland.net/threads/video-tu...ing-ot-server-website-and-shop-system.166818/

 

[prav]

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "mysql.sql"
mysqlPass = ""
mysqlDatabase = "forgottenserver.s3db"
mysqlPort = 3306
mysqlSock = ""

This is what is in the lua.