• 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!

Problems loading sqlite files...

jaxNtrigs

New Member
Joined
Nov 3, 2013
Messages
31
Reaction score
1
I keep getting connection issues with sqlite or something, not really sure.

OT_SYS_SQLITE3_PREPARE<>: SQLITE ERROR: no such table: z_ots_communcation (SELECT * FROM z_ots_communication where 'type' = 'login';)

Ive posted my config.lua file below. If someone could help me out and lemme know whats going on that would be great. I am not using mySQL, ask my computer has issues with the root logon so I am just using SQLite right now.


accountManager = true
namelockManager = false
newPlayerChooseVoc = true
newPlayerSpawnPosX = 1002
newPlayerSpawnPosY = 903
newPlayerSpawnPosZ = 7
newPlayerTownId = 1
newPlayerLevel = 100
newPlayerMagicLevel = 1
generateAccountNumber = false


redSkullLength = 4 * 15 * 30 * 30
blackSkullLength = 10 * 20 * 40 * 40
dailyFragsToRedSkull = 25
weeklyFragsToRedSkull = 50
monthlyFragsToRedSkull = 100
dailyFragsToBlackSkull = 30
weeklyFragsToBlackSkull = 60
monthlyFragsToBlackSkull = 120
dailyFragsToBanishment = 1000000
weeklyFragsToBanishment = 1000000
monthlyFragsToBanishment = 1000000
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
useFragHandler = true
advancedFragList = false


notationsToBan = 4
warningsToFinalBan = 5
warningsToDeletion = 6
banLength = 7 * 24 * 60 * 60
killsBanLength = 1 * 2 * 3 * 3
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false


worldType = "open"
protectionLevel = 250000
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 60 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = false
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = false
whiteSkullTime = 1 * 1 * 1
noDamageToSameLookfeet = false
showHealingDamage = false
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 2 * 1000
deathContainerId = 1987
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true


worldId = 0
ip = "127.0.0.1"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7172
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 1000
motd = "FruitLoop 8.6"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = false
allowClones = false
serverName = "FL"
loginMessage = "Welcome to FL HIGHEXP!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false


sqlType = "sqlite"
sqlHost = ""
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "otserver"
sqlFile = "theforgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 0
mysqlWriteTimeout = 0
encryptionType = "plain"


deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5


ingameGuildManagement = true
levelToFormGuild = 5000
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20


highscoreDisplayPlayers = 10
updateHighscoresAfterMinutes = 60


buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 300000
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 10000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false


timeBetweenActions = 500
timeBetweenExActions = 500
hotkeyAimbotEnabled = true


mapName = "AOD.otbm"
mapAuthor = "Amiroslo"
randomizeTiles = true
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"


defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"


optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false


formulaLevel = 1.0
formulaMagic = 1.0
bufferMutedOnSpellFailure = false
spellNameInsteadOfWords = false
emoteSpells = true


allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
addonsOnlyPremium = true


dataDirectory = "data/"
bankSystem = true
displaySkillLevelOnAdvance = false
promptExceptionTracerErrorBox = true
separateViplistPerCharacter = false
maximumDoorLevel = 500
maxMessageBuffer = 4


saveGlobalStorage = true
useHouseDataStorage = false
storePlayerDirection = false


checkCorpseOwner = true
monsterLootMessage = 3
monsterLootMessageType = 25


ghostModeInvisibleEffect = false
ghostModeSpellEffects = true


idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0


freePremium = true
premiumForPromotion = true


blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8


experienceStages = false
rateExperience = 1000000.0
rateExperienceFromPlayers = 0
rateSkill = 7.0
rateMagic = 5.0
rateLoot = 3.0
rateSpawn = 1000


rateMonsterHealth = 10.0
rateMonsterMana = 4.0
rateMonsterAttack = 15.0
rateMonsterDefense = 6.0


minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1


rateStaminaLoss = 1
rateStaminaGain = 3
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.5
rateStaminaUnderNormal = 0.5
staminaThresholdOnlyPremium = true


experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 5
experienceShareActivity = 2 * 60 * 1000


globalSaveEnabled = false
globalSaveHour = 8
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = false


deSpawnRange = 2
deSpawnRadius = 50


maxPlayerSummons = 2
teleportAllSummons = false
teleportPlayerSummons = false


ownerName = "Admin Amir"
ownerEmail = "[email protected]"
url = "http://paradiseot.hopto.org/"
location = "Europe"
displayGamemastersWithOnlineCommand = false


adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false
 
Code:
CREATE TABLE `z_ots_comunication` (
    `id` INTEGER(11) NOT NULL,
    `name` VARCHAR(255) NOT NULL,
    `type` VARCHAR(255) NOT NULL,
    `action` VARCHAR(255) NOT NULL,
    `param1` VARCHAR(255) NOT NULL,
    `param2` VARCHAR(255) NOT NULL,
    `param3` VARCHAR(255) NOT NULL,
    `param4` VARCHAR(255) NOT NULL,
    `param5` VARCHAR(255) NOT NULL,
    `param6` VARCHAR(255) NOT NULL,
    `param7` VARCHAR(255) NOT NULL,
    `delete_it` INTEGER(2) NOT NULL DEFAULT '1',
    PRIMARY KEY (`id`)
)
 
Back
Top