Help TFS 0.4

[konieczko123]

What's the problem?? Vote system ??

[Warning - ConfigManager::getString] 53

Next problem No have column cast You have sql cast ??

[7/8/2014 10:41:16] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1407400700, `lastip` = 4069304878, `level` = 1, `group_id` = 6, `health` = 150, `healthmax` = 150, `experience` = 0, `lookbody` = 0, `lookfeet` = 0, `lookhead` = 0, `looklegs` = 0, `looktype` = 302, `lookaddons` = 0, `maglevel` = 0, `mana` = 0, `manamax` = 0, `manaspent` = 0, `soul` = 0, `town_id` = 2, `posx` = 32346, `posy` = 32226, `posz` = 7, `cap` = 400, `sex` = 1, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1407400876, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 8 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)
[7/8/2014 10:41:16] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1407400700, `lastip` = 4069304878, `level` = 1, `group_id` = 6, `health` = 150, `healthmax` = 150, `experience` = 0, `lookbody` = 0, `lookfeet` = 0, `lookhead` = 0, `looklegs` = 0, `looktype` = 302, `lookaddons` = 0, `maglevel` = 0, `mana` = 0, `manamax` = 0, `manaspent` = 0, `soul` = 0, `town_id` = 2, `posx` = 32346, `posy` = 32226, `posz` = 7, `cap` = 400, `sex` = 1, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1407400876, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 8 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)
[7/8/2014 10:41:16] mysql_real_query(): UPDATE `players` SET `lastlogin` = 1407400700, `lastip` = 4069304878, `level` = 1, `group_id` = 6, `health` = 150, `healthmax` = 150, `experience` = 0, `lookbody` = 0, `lookfeet` = 0, `lookhead` = 0, `looklegs` = 0, `looktype` = 302, `lookaddons` = 0, `maglevel` = 0, `mana` = 0, `manamax` = 0, `manaspent` = 0, `soul` = 0, `town_id` = 2, `posx` = 32346, `posy` = 32226, `posz` = 7, `cap` = 400, `sex` = 1, `balance` = 0, `stamina` = 151200000, `cast` = 0, `castViewers` = 0, `castDescription` = '', `skull` = 0, `skulltime` = 0, `promotion` = 0, `conditions` = '', `loss_experience` = 100, `loss_mana` = 100, `loss_skills` = 100, `loss_containers` = 100, `loss_items` = 100, `lastlogout` = 1407400876, `blessings` = 0, `marriage` = 0, `vocation` = 2 WHERE `id` = 8 LIMIT 1; - MYSQL ERROR: Unknown column 'cast' in 'field list' (1054)
Error while saving player: test

 

[HeberPcL]

Maybe work:

ALTER TABLE `players` ADD `cast` INT( 11 ) NOT NULL DEFAULT '0';

 

[konieczko123]

Ok, thanks

next problem

[Warning - ConfigManager::getString] 53

 

[HeberPcL]

Post your config.lua

 

[konieczko123]

    tasksPerSecondMaxHard = 50
    tasksPerSecondMaxSoft = 50
    autoWalkMaxSteps = 50
    tasksPerSecondAction = 3
    tasksPerSecondActionTime = 10

    avivable_reports_per_day = 50
    where_going_reports = "log"

    spoof = 180

    goThroughPlayers = true
    mysqlReconnectionAttempts = 3
    optionalWarAttackableAlly = true
    fistBaseAttack = 7
    criticalHitChance = 7
    noDamageToGuildMates = false
    noDamageToPartyMembers = false

    rookLevelTo = 6
    rookTownId = 1
    rookSystem = false

    useCapSystem = true
    useMultiClient = false

    houseSkipInitialRent = true
    houseProtection = true
    depotItemsFreeLimit = 500
    depotItemstPremiumLimit = 1000
    enableProtectionQuestForGM = true
    cleanItemsInMap = false

    monsterSpawnWalkback = true
    tibiaClassicSlots = false
    healPlayersOnLevelAdvance = true

    NoDisableBlockRespawn = true

    NoShareExpSummonMonster = false

    enableCast = true

    accountManager = false
    namelockManager = true
    newPlayerChooseVoc = false
    newPlayerSpawnPosX = 32369
    newPlayerSpawnPosY = 32241
    newPlayerSpawnPosZ = 7
    newPlayerTownId = 2
    newPlayerLevel = 15
    newPlayerMagicLevel = 0
    generateAccountNumber = false
    generateAccountSalt = false
    paralyzeDelay = 1500

    useFragHandler = true
    redSkullLength = 1 * 24 * 60 * 60
    blackSkullLength = 5 * 24 * 60 * 60
    dailyFragsToRedSkull = 32
    weeklyFragsToRedSkull = 900
    monthlyFragsToRedSkull = 900
    dailyFragsToBlackSkull = 34
    weeklyFragsToBlackSkull = 999
    monthlyFragsToBlackSkull = 999
    dailyFragsToBanishment = 9999
    weeklyFragsToBanishment = 9999
    monthlyFragsToBanishment = 9999
    blackSkulledDeathHealth = 40
    blackSkulledDeathMana = 0
    useBlackSkull = true
    advancedFragList = false

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

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

    worldId = 0
    ip =
    bindOnlyConfiguredIpAddress = true
    loginPort = 7171
    gamePort = 7172
    loginTries = 10
    retryTimeout = 10 * 1000
    loginTimeout = 0
    maxPlayers = 600
    motd = "Totemsflare"
    displayOnOrOffAtCharlist = false
    onePlayerOnlinePerAccount = true
    allowClones = false
    serverName = "Totemsflare"
    loginMessage = "Welcome to the Totemsflare!"
    statusTimeout = 3 * 60 * 1000
    replaceKickOnLogin = true
    forceSlowConnectionsToDisconnect = false
    loginOnlyWithLoginServer = false
    premiumPlayerSkipWaitList = false


    sqlType =
    sqlHost
    sqlPort =
    sqlUser =
    sqlPass =
    sqlDatabase =
    sqlFile =
    sqlKeepAlive = 0
    mysqlReadTimeout = 10
    mysqlWriteTimeout = 10
    encryptionType =

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

    ingameGuildManagement = false
    levelToFormGuild = 1
    premiumDaysToFormGuild = 0
    guildNameMinLength = 3
    guildNameMaxLength = 20

    highscoreDisplayPlayers = 15
    updateHighscoresAfterMinutes = 60

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

    timeBetweenActions = 200
    timeBetweenExActions = 1000
    hotkeyAimbotEnabled = true

    mapName =
    mapAuthor =
    randomizeTiles = true
    storeTrash = true
    cleanProtectedZones = true
    mailboxDisabledTowns = ""

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

    startupDatabaseOptimization = false
    updatePremiumStateAtStartup = true
    confirmOutdatedVersion = false

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

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

    dataDirectory = "data/"
    logsDirectory = "data/logs/"
    bankSystem = false
    displaySkillLevelOnAdvance = false
    promptExceptionTracerErrorBox = true
    maximumDoorLevel = 500
    maxMessageBuffer = 7
    tradeLimit = 100

    separateVipListPerCharacter = false
    vipListDefaultLimit = 20
    vipListDefaultPremiumLimit = 100

    saveGlobalStorage = true
    useHouseDataStorage = false
    storePlayerDirection = false

    checkCorpseOwner = true
    monsterLootMessage = 0
    monsterLootMessageType = 25

    ghostModeInvisibleEffect = false
    ghostModeSpellEffects = true

    idleWarningTime = 24 * 60 * 1000
    idleKickTime = 25 * 60 * 1000
    reportsExpirationAfterReads = 1
    playerQueryDeepness = 2
    tileLimit = 20
    protectionTileLimit = 10
    houseTileLimit = 5

    freePremium = true
    premiumForPromotion = true

    blessings = true
    blessingOnlyPremium = true
    blessingReductionBase = 30
    blessingReductionDecrement = 5
    eachBlessReduction = 8

    experienceStages = true
    rateExperience = 5.0
    rateExperienceFromPlayers = 0.1
    rateSkill = 1.0
    rateMagic = 1.0
    rateLoot = 4.0
    rateSpawn = 2

    rateMonsterHealth = 1.0
    rateMonsterMana = 1.0
    rateMonsterAttack = 1.0
    rateMonsterDefense = 1.0

    minLevelThresholdForKilledPlayer = 0.9
    maxLevelThresholdForKilledPlayer = 1.1

    rateStaminaLoss = 1
    rateStaminaGain = 3
    rateStaminaThresholdGain = 12
    staminaRatingLimitTop = 40 * 60
    staminaRatingLimitBottom = 14 * 60
    staminaLootLimit = 14 * 60
    rateStaminaAboveNormal = 1.0
    rateStaminaUnderNormal = 1.0
    staminaThresholdOnlyPremium = true

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

    globalSaveEnabled = false
    globalSaveHour = 4
    globalSaveDays = 3
    globalSaveMinute = 10
    shutdownAtGlobalSave = true
    cleanMapAtGlobalSave = false

    deSpawnRange = 2
    deSpawnRadius = 50

    maxPlayerSummons = 2
    teleportAllSummons = false
    teleportPlayerSummons = false

    statusPort = 7171
    ownerName = "Collocorpusek"
    ownerEmail = ""
    url = "
    location = "Europe"
    displayGamemastersWithOnlineCommand = false

    displayPlayersLogging = true
    prefixChannelLogs = ""
    runFile = ""
    outputLog = ""
    truncateLogOnStartup = true

    managerPort = 7171
    managerLogs = true
    managerPassword = ""
    managerLocalhostOnly = true
    managerConnectionsLimit = 1

    adminPort = 7179
    adminLogs = true
    adminPassword = "xxxxxxxxxxxxx"
    adminLocalhostOnly = true
    adminConnectionsLimit = 1
    adminRequireLogin = true
    adminEncryption = ""
    adminEncryptionData = ""

 

[HeberPcL]

I can't see any problem.