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

Windows 7.6 server problems

E

Eazy M

Developer
Joined
Oct 17, 2010
Messages
911
Reaction score
61
Location
.
Hey, something is wrong with my 7.6 server.
Maybe my database or something, btw i am not using site.
I am using 1/1 to create char,accs.

This is the log when i started the server and created a account,char and logged in.
But when i log out my character dont saves.

Btw, Here you got the log;

Code: 
[31/12/2010  16:18:37] The Forgotten Server - Version 0.3 (Crying Damson).

[31/12/2010  16:18:37] >> Loading config
[31/12/2010  16:18:37] > Using plaintext passwords
[31/12/2010  16:18:37] >> Starting SQL connection
[31/12/2010  16:18:37] >> Loading vocations
[31/12/2010  16:18:37] >> Loading commands
[31/12/2010  16:18:37] >> Loading items
[31/12/2010  16:18:37] >> Loading script systems
[31/12/2010  16:18:37] >> Loading monsters
[31/12/2010  16:18:37] >> Loading experience stages
[31/12/2010  16:18:37] >> Checking world type... PVP
[31/12/2010  16:18:37] >> Loading map
[31/12/2010  16:18:37] > Map size: 65535x65535.
[31/12/2010  16:18:38] > Map loading time: 0.885 seconds.
[31/12/2010  16:18:38] >> Setting initialization gamestate modules.
[31/12/2010  16:18:38] OTS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: server_motd
[31/12/2010  16:18:38] > ERROR: Failed to load motd!
[31/12/2010  16:18:38] OTS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: server_record
[31/12/2010  16:18:38] > ERROR: Failed to load online record!
[31/12/2010  16:18:38] >> All modules has been loaded, server starting up...
[31/12/2010  16:18:38] >> Forgotten Server Online!

[31/12/2010  16:19:02] OTS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: server_motd
[31/12/2010  16:19:02] Error during getDataLong(customflags).
[31/12/2010  16:19:02] Error during getDataLong(balance).
[31/12/2010  16:19:02] Error during getDataInt(marriage).
[31/12/2010  16:19:02] Error during getDataInt(loss_items).
[31/12/2010  16:19:56] Error during getDataLong(balance).
[31/12/2010  16:19:56] Error during getDataInt(marriage).
[31/12/2010  16:19:56] Error during getDataInt(loss_items).
[31/12/2010  16:20:23] Error during getDataLong(balance).
[31/12/2010  16:20:23] Error during getDataInt(marriage).
[31/12/2010  16:20:23] Error during getDataInt(loss_items).
[31/12/2010  16:20:23] Account Manager has logged in.
[31/12/2010  16:20:23] OTS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: server_record
[31/12/2010  16:20:23] > Broadcasted message: "New record: 1 players are logged in.".
[31/12/2010  16:20:33] Error during getDataLong(balance).
[31/12/2010  16:20:33] Error during getDataInt(marriage).
[31/12/2010  16:20:33] Error during getDataInt(loss_items).
[31/12/2010  16:20:33] Account Manager has logged in.
[31/12/2010  16:20:33] OTS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: server_record
[31/12/2010  16:20:33] > Broadcasted message: "New record: 2 players are logged in.".
[31/12/2010  16:20:36] Account Manager has logged out.
[31/12/2010  16:20:43] Error during getDataLong(balance).
[31/12/2010  16:20:43] Error during getDataInt(marriage).
[31/12/2010  16:20:43] Error during getDataInt(loss_items).
[31/12/2010  16:20:43] Account Manager has logged in.
[31/12/2010  16:20:49] Account Manager has logged out.
[31/12/2010  16:20:50] Account Manager has logged out.
[31/12/2010  16:20:55] Error during getDataLong(balance).
[31/12/2010  16:20:55] Error during getDataInt(marriage).
[31/12/2010  16:20:55] Error during getDataInt(loss_items).
[31/12/2010  16:20:55] Rasmus has logged in.
[31/12/2010  16:21:02] Error during getDataLong(balance).
[31/12/2010  16:21:02] Error during getDataInt(marriage).
[31/12/2010  16:21:02] Error during getDataInt(loss_items).
[31/12/2010  16:21:02] Account Manager has logged in.
[31/12/2010  16:21:25] Account Manager has logged out.
[31/12/2010  16:21:36] Error during getDataLong(balance).
[31/12/2010  16:21:36] Error during getDataInt(marriage).
[31/12/2010  16:21:36] Error during getDataInt(loss_items).
[31/12/2010  16:21:36] Skipn has logged in.
[31/12/2010  16:22:43] Rasmus has logged out.
[31/12/2010  16:22:43] OTS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: balance
[31/12/2010  16:22:43] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:43] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:43] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:43] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:43] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:43] Error while saving player: Rasmus
[31/12/2010  16:22:43] Error during getDataLong(balance).
[31/12/2010  16:22:43] Error during getDataInt(marriage).
[31/12/2010  16:22:43] Error during getDataInt(loss_items).
[31/12/2010  16:22:43] Account Manager has logged in.
[31/12/2010  16:22:45] Account Manager has logged out.
[31/12/2010  16:22:45] Error during getDataLong(balance).
[31/12/2010  16:22:45] Error during getDataInt(marriage).
[31/12/2010  16:22:45] Error during getDataInt(loss_items).
[31/12/2010  16:22:45] Rasmus has logged in.
[31/12/2010  16:22:47] Skipn has logged out.
[31/12/2010  16:22:47] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:47] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:47] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:47] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:47] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:47] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:47] Error while saving player: Skipn
[31/12/2010  16:22:48] Error during getDataLong(balance).
[31/12/2010  16:22:48] Error during getDataInt(marriage).
[31/12/2010  16:22:48] Error during getDataInt(loss_items).
[31/12/2010  16:22:48] Skipn has logged in.
[31/12/2010  16:22:53] Rasmus has logged out.
[31/12/2010  16:22:53] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:53] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:53] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:53] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:53] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:53] sqlite3_step(): SQLITE ERROR: SQL logic error or missing database
[31/12/2010  16:22:53] Error while saving player: Rasmus
[31/12/2010  16:22:54] Error during getDataLong(balance).
[31/12/2010  16:22:54] Error during getDataInt(marriage).
[31/12/2010  16:22:54] Error during getDataInt(loss_items).
[31/12/2010  16:22:54] Rasmus has logged in.


[31/12/2010  16:36:42] sqlite3_step(): SQLITE ERROR: constraint failed

Ill hope someone could help me, rep++
 
Last edited:
Sort by date Sort by votes
[31/12/2010 16:18:37] > Map size: 65535x65535.
-.- real map

also, did we even use sqlite in 7.6 distros? thought it was mySQL and XML back then?
 
Upvote 0 Downvote
@tosuxo

When i use mySQL i get this.

Code: 
[31/12/2010  17:13:08] >> Loading config
[31/12/2010  17:13:08] > Using plaintext passwords
[31/12/2010  17:13:08] >> Starting SQL connection
[31/12/2010  17:13:09] Failed to connect to database. MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061)
[31/12/2010  17:13:09] > ERROR: Couldn't estabilish connection to SQL database!



-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = "theforgottenserver"
mysqlPort = 3306
 
Upvote 0 Downvote
@Zysen

No i didnt.
I did now lol
But wtf,

[31/12/2010 17:22:24] >> Loading config
[31/12/2010 17:22:24] > ERROR: Unable to load config.lua!

Nothing wrong with it, i have looked at it 5 times now.

config.lua:
Code: 
-- The Forgotten Server Config

	-- Account manager
	accountManager = true
	namelockManager = true
	newPlayerChooseVoc = true
	newPlayerSpawnPosX = 1013
	newPlayerSpawnPosY = 1023
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 1
	newPlayerLevel = 10
	newPlayerMagicLevel = 0
	generateAccountNumber = false

	-- Banishments
	notationsToBan = 3
	warningsToFinalBan = 4
	warningsToDeletion = 5
	banLength = 7 * 24 * 60 * 60
	finalBanLength = 30 * 24 * 60 * 60
	ipBanishmentLength = 1 * 24 * 60 * 60
	killsToBan = 5
	maxViolationCommentSize = 200

	-- Battle
	worldType = "pvp"
	protectionLevel = 30
	pvpTileIgnoreLevelAndVocationProtection = true
	killsToRedSkull = 20
	pzLocked = 40 * 1000
	criticalHitChance = 7
	criticalHitMultiplier = 1
	displayCriticalHitNotify = false
	removeWeaponAmmunition = false
	removeWeaponCharges = false
	removeRuneCharges = false
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 10 * 60 * 1000
	noDamageToSameLookfeet = false
	experienceByKillingPlayers = false
	showHealingDamage = false
	showHealingDamageForMonsters = false

	-- Connection config
	ip = "XXXXXXXXXX"
	port = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "1000"
	motd = "Rasmus"
	displayOnOrOffAtCharlist = false
	onePlayerOnlinePerAccount = true
	allowClones = 0
	serverName = "Rasmus"
	loginMessage = "Rasmus"	
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = true

	-- Database
	-- NOTE: sqlFile is used only by sqlite database
	sqlType = "mysqlpass"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = ""
	sqlDatabase = "theforgottenserver"
	sqlFile = "forgottenserver.s3db"
	passwordType = "plain"

	-- Deathlist
	deathListEnabled = true
	maxDeathRecords = 20

	-- Guilds
	inGameGuildManagement = true
	levelToFormGuild = 60
	guildNameMinLength = 4
	guildNameMaxLength = 20

	-- Highscores
	highscoreDisplayPlayers = 20
	updateHighscoresAfterMinutes = 60

	-- Houses
	buyableAndSellableHouses = true
	housesPerAccount = 1
	levelToBuyHouse = 60
	houseRentAsPrice = false
	housePriceAsRent = false
	housePriceEachSQM = 1000
	houseRentPeriod = "never"
	houseNeedPremiumAccount = true
	bedsRequirePremium = true

	-- Item usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000

	-- Map
	mapName = "test_evo"
	cleanProtectedZones = true

	-- Miscellaneous
	-- NOTE: defaultPriority works only on Windows
	dataDirectory = "data/"
	kickIdlePlayerAfterMinutes = 15
	allowChangeOutfit = true
	maxMessageBuffer = 4
	displayGamemastersWithOnlineCommand = false
	defaultPriority = "high"
	saveGlobalStorage = true
	bankSystem = true
	displaySkillLevelOnAdvance = false

	-- Premium account
	freePremium = false
	premiumForPromotion = true
	removePremiumOnInit = true

	-- Rates
	rateExp = 30
	rateSkill = 50
	rateLoot = 4
	rateMagic = 25
	rateSpawn = 1

	-- Global save
	-- NOTE: globalSaveHour means like 03:00, not that it will save every 3 hours,
	-- if you want such a system use autoSaveEachMinutes. This save method
	-- may be unstable, we recommend using OTAdmin if you want real saves.
	globalSaveEnabled = false
	globalSaveHour = 8
	shutdownAtGlobalSave = true
	cleanMapAtGlobalSave = false

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- Summons
	maxPlayerSummons = 2

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

Similar threads

H
  • Question
TFS 1.2 Getting dispatcher_very_slow is it fine or its not?
Replies
0
Views
284
henkas
H
J
  • Question
events timer
Replies
1
Views
428
Mateus Robeerto
Mateus Robeerto
H
  • Question
TFS 1.X+ SQL considered slow? 10-17ms range for tile_store
Replies
0
Views
164
henkas
H
potinho
  • Question
TFS 0.X Unexpected Crash
Replies
8
Views
1K
maxumic
maxumic
Back
Top