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

Need help with mysql..

Ates.tr

Im back
Joined
Nov 11, 2007
Messages
1,046
Reaction score
2
Location
Sweden
Im tryin to install gesior aac but got a problem...

Code:
STEP 1
Check server configuration

Warning: syntax error, unexpected ':' in C:/Users/Ates/Desktop/OTserv/config.lua on line 28 in C:\xampp\htdocs\install.php on line 150
File config.lua loaded from C:/Users/Ates/Desktop/OTserv/config.lua and it's not valid TFS config.lua file. Go to STEP 1 - select other directory. If it's your config.lua file from TFS contact with acc. maker author

If you guys understand the problem please help.

Thanks!
 
Surely you have a .lua with lot of -- (comments) =)

a tip will be if you post your .lua file, give info about what release are you using, etc. (just get care of doesnt give mysql details)
 
Code:
-- OTserv Config

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

	-- Banishments
	notationsToBan = 3
	warningsToFinalBan = 10
	warningsToDeletion = 10
	banLength = 1 * 24 * 60 * 60
	finalBanLength = 1 * 24 * 60 * 60
	ipBanishmentLength = 1 * 24 * 60 * 60
	broadcastBanishments = "yes"
	killsToBan = 5
	maxViolationCommentSize = 200
	autoBanishUnknownBytes = "no"

	-- Battle
	-- NOTE: loginProtectionPeriod is the famous Tibia anti-magebomb system.
	-- deathLostPercent set to nil enables manual mode.
	-- showHealingDamageForMonsters inheritates from showHealingDamage.
	worldType = "pvp"
	protectionLevel = 50
	pvpTileIgnoreLevelAndVocationProtection = "yes"
	killsToRedSkull = 3
	pzLocked = 30 * 1000
	criticalHitChance = 8
	criticalHitMultiplier = 1
	displayCriticalHitNotify = "yes"
	removeWeaponAmmunition = "no"
	removeWeaponCharges = "no"
	removeRuneCharges = "yes"
	timeToDecreaseFrags = 35 * 60 * 1000
	whiteSkullTime = 7 * 60 * 1000
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"
	showHealingDamage = "yes"
	showHealingDamageForMonsters = "yes"
	fieldOwnershipDuration = 5 * 1000
	stopAttackingAtExit = "yes"
	oldConditionAccuracy = "no"
	loginProtectionPeriod = 10 * 1000
	deathLostPercent = 10
	stairhopDelay = 1 * 1000
	pushCreatureDelay = 2 * 1000
	deathContainerId = 1987
	gainExperienceColor = 215

	-- Connection config
	worldId = 0
	ip = "85.225.35.26"
	loginPort = 7171
	gamePort = 7172
	adminPort = 7171
	statusPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = 1000
	motd = "Welcome to Nitena RPG-PVP Server!"
	displayOnOrOffAtCharlist = "no"
	onePlayerOnlinePerAccount = "yes"
	allowClones = 0
	serverName = "Nitena Server"
	loginMessage = "Welcome to Nitena RPG-PVP Server!"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = "yes"
	forceSlowConnectionsToDisconnect = "no"
	loginOnlyWithLoginServer = "no"
	premiumPlayerSkipWaitList = "yes"

	-- Database
	-- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database.
	-- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value.
	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = ""
	sqlDatabase = ""
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTImeout = 10
	passwordType = "plain"

	-- Deathlist
	deathListEnabled = "yes"
	maxDeathRecords = 5

	-- Guilds
	ingameGuildManagement = "no"
	levelToFormGuild = 8
	premiumDaysToFormGuild = 0
	guildNameMinLength = 4
	guildNameMaxLength = 20

	-- Highscores
	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	-- Houses
	buyableAndSellableHouses = "yes"
	houseNeedPremium = "no"
	bedsRequirePremium = "no"
	levelToBuyHouse = 50
	housesPerAccount = 1
	houseRentAsPrice = "no"
	housePriceAsRent = "no"
	housePriceEachSquare = 1000
	houseRentPeriod = "never"

	-- Item usage
	timeBetweenActions = 200
	timeBetweenExActions = 1000
	checkCorpseOwner = "yes"
	hotkeyAimbotEnabled = "yes"
	maximumDoorLevel = 500

	-- Map
	-- NOTE: storeTrash costs more memory, but will perform alot faster cleaning.
	-- useHouseDataStorage usage may be found at README.
	mapName = "world"
	mapAuthor = "Ates"
	randomizeTiles = "yes"
	useHouseDataStorage = "no"
	storeTrash = "yes"
	cleanProtectedZones = "yes"

	-- Startup
	-- NOTE: defaultPriority works only on Windows and niceLevel on *nix
	-- coresUsed are seperated by comma cores ids used by server process,
	-- default is -1, so it stays untouched (automaticaly assigned by OS).
	defaultPriority = "high"
	niceLevel = 5
	coresUsed = "-1"
	optimizeDatabaseAtStartup = "yes"
	removePremiumOnInit = "yes"
	confirmOutdatedVersion = "yes"

	-- Muted buffer
	maxMessageBuffer = 20
	bufferMutedOnSpellFailure = "no"

	-- Miscellaneous
	-- NOTE: promptExceptionTracerErrorBox works only with precompiled support feature,
	-- called "exception tracer" (__EXCEPTION_TRACER__ flag).
	dataDirectory = "data/"
	kickIdlePlayerAfterMinutes = 15
	allowChangeOutfit = "yes"
	allowChangeColors = "yes"
	allowChangeAddons = "yes"
	disableOutfitsForPrivilegedPlayers = "no"
	bankSystem = "yes"
	saveGlobalStorage = "yes"
	ghostModeInvisibleEffect = "no"
	displaySkillLevelOnAdvance = "no"
	spellNameInsteadOfWords = "yes"
	emoteSpells = "no"
	expireReportsAfterReads = 1
	promptExceptionTracerErrorBox = "yes"
	storePlayerDirection = "no"
	playerQueryDeepness = 2

	-- Premium-related
	freePremium = "yes"
	premiumForPromotion = "yes"

	-- Blessings
	-- NOTE: blessingReduction* regards items/containers loss.
	-- eachBlessReduction is how much each bless reduces the experience/magic/skills loss.
	blessingsOnlyPremium = "yes"
	blessingReductionBase = 30
	blessingReductionDecreament = 0
	eachBlessReduction = 5

	-- Rates
	-- NOTE: experienceStages configuration is located in data/XML/stages.xml.
	experienceStages = "yes"
	rateExperience = 150
	rateSkill = 65
	rateMagic = 13
	rateLoot = 3
	rateSpawn = 100

	-- Stamina
	-- NOTE: Stamina is stored in miliseconds, so seconds are multiplied by 1000.
	-- rateStaminaHits multiplies every hit done a creature, which are later
	-- multiplied by player attack speed.
	-- rateStaminaGain is multiplying every second of logged out time, eg:
	-- 60 * 1000 / 3 = 20 seconds, what gives 1 stamina minute for 3 being logged off.
	-- rateStaminaThresholdGain is dividing in case the normal gain (that is
	-- multiplied by rateStaminaGain, btw.) passed above threshold, eg:
	-- 60 * 1000 / 3 = 20 / 4 = 5 seconds (3 * 4 = 12 minutes for 1 stamina minute).
	-- staminaRatingLimit* is in minutes.
	rateStaminaLoss = 0
	rateStaminaGain = 1000 / 3
	rateStaminaThresholdGain = 4
	staminaRatingLimitTop = 41 * 60
	staminaRatingLimitBottom = 14 * 60
	rateStaminaAboveNormal = 1.5
	rateStaminaUnderNormal = 0.5
	staminaThresholdOnlyPremium = "yes"

	-- Party
	-- NOTE: experienceShareLevelDifference is float number.
	-- experienceShareLevelDifference is highestLevel * value
	experienceShareRadiusX = 30
	experienceShareRadiusY = 30
	experienceShareRadiusZ = 1
	experienceShareLevelDifference = 2 / 3
	extraPartyExperienceLimit = 20
	extraPartyExperiencePercent = 5

	-- Global save
	-- NOTE: globalSaveHour means like 03:00, not that it will save every 3 hours,
	-- if you want such a system please check out data/globalevents/globalevents.xml.
	globalSaveEnabled = "yes"
	globalSaveHour = 8
	shutdownAtGlobalSave = "no"
	cleanMapAtGlobalSave = "yes"

	-- Spawns
	deSpawnRange = 2
	deSpawnRadius = 50

	-- Summons
	maxPlayerSummons = 2
	teleportAllSummons = "no"
	teleportPlayerSummons = "no"

	-- Status
	ownerName = "Ates"
	ownerEmail = ""
	url = "http://127.0.0.1"
	location = "Europe"
	displayGamemastersWithOnlineCommand = "no"

	-- Logs
	-- NOTE: This kind of logging does not work in GUI version.
	-- For such, please compile the software with __GUI_LOGS__ flag.
	adminLogsEnabled = "no"
	displayPlayersLogging = "yes"
	prefixChannelLogs = ""
	runeFile = ""
	outLogName = ""
	errorLogName = ""
	truncateLogsOnStartup = "no"

Edit: thanks for helping :)
 
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "YOURUSERNAME"
sqlPass = "YOURPASS"
sqlDatabase = "YOURDB"

Your username is normally root, not that i advise to even use a root acc, but your choice :)
 
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "YOURUSERNAME"
sqlPass = "YOURPASS"
sqlDatabase = "YOURDB"

Your username is normally root, not that i advise to even use a root acc, but your choice :)

that's a copy but i removed user and pw and database..
 
line 28 of your .lua file:

Code:
	-- NOTE: loginProtectionPeriod is the famous Tibia anti-magebomb system.
	-- deathLostPercent set to nil enables manual mode.
	-- showHealingDamageForMonsters inheritates from showHealingDamage.

I think that this comments are from your distro. You need to remove then =)

Try to remove it and run the install again.
 
line 28 of your .lua file:

Code:
	-- NOTE: loginProtectionPeriod is the famous Tibia anti-magebomb system.
	-- deathLostPercent set to nil enables manual mode.
	-- showHealingDamageForMonsters inheritates from showHealingDamage.

I think that this comments are from your distro. You need to remove then =)

Try to remove it and run the install again.

ye thanks cuz it' saids line something and was that text :) thanks...
 
Back
Top