KA

[Encerrado] Erro com SQL.

Por kaldito, 06 de mai. de 2013 em Tópicos Sem Resposta

otserv
tibia
22
4.5k
kalditoK
06 de maio de 2013 às 23:27

baixe o server d aqi

 

http://www.xtibia.com/forum/topic/206460-servidor-pokemon-com-cooldown-bar-e-icon-system-download/page__hl__%2Bcooldown+%2Bbar+%2Bpokemon__fromsearch__1

 

mais tnho um error na hra de correr ot

algum pode ajudar'

 

130507043651587994.png

LuckinhaSanL
06 de maio de 2013 às 23:28

Passe seu config.lua

kalditoK
06 de maio de 2013 às 23:33

http://rapidshare.com/files/3917157175/config.rar

 

My config.lua

AlphaLoveA
06 de maio de 2013 às 23:41

Procure essas linhas e deixe seu config.lua assim:

 

sqlType = "sqlite" <- caso esteja "mysql", coloque sqlite como esta alí (entre as aspas)

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = ""

sqlDatabase = "nomedadatabase" <- aqui coloque o nome da tua database sem o .s3db no fim do nome dela (entre as aspas)

sqlFile = "nomedadatabase.s3db" <- aqui coloque o nome da tua database com o .s3db no fim do nome dela (entre as aspas)

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "plain"

 

 

Se eu ajudei, da um Rep + :)

Editado Maio 6 por N4K4MUR4

kalditoK
06 de maio de 2013 às 23:45

sqlDatabase = "nomedadatabase" <- aqui coloque o nome da tua database sem o .s3db no fim do nome dela (entre as aspas)

sqlFile = "nomedadatabase.s3db" <- aqui coloque o nome da tua database com o .s3db no fim do nome dela (entre as aspas)

 

qual e meu date base????

AlphaLoveA
06 de maio de 2013 às 23:48

é o arquivo em formato s3db que ta na pasta do seu ot. Posta print da pasta do teu server que eu te digo qual é :)

kalditoK
07 de maio de 2013 às 00:01

130507051041283239.png

 

 

agora nao posso entrar na ot, marca ese error -_-

Luquinh4L
07 de maio de 2013 às 00:04

o ot era mysql, era só ele instala um site e ja era

AlphaLoveA
07 de maio de 2013 às 00:09

@kaldito

 

véi,posta a foto dos ARQUIVOS da PASTA do teu server.. não do console do teu server :s

quero com os arquivos da pasta...

 

@Lukinh4

 

o cara não ta conseguindo nem ligar o server sqlite mano, magina ligar site que é mais complicadinho '-'

Editado Maio 7 por N4K4MUR4

kalditoK
07 de maio de 2013 às 00:12

130507052151481731.png

 

faltarom

data

doc

carpeta

AlphaLoveA
07 de maio de 2013 às 00:18

vai no teu config.lua, apaga TUDO o que tem la dentro e cola isso..

 

 

accountManager = true
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 1143
newPlayerSpawnPosY = 1140
newPlayerSpawnPosZ = 5
newPlayerTownId = 1
newPlayerLevel = 1
newPlayerMagicLevel = 1
generateAccountNumber = false
redSkullLength = 30 * 24 * 60 * 60
blackSkullLength = 45 * 24 * 60 * 60
dailyFragsToRedSkull = 3
weeklyFragsToRedSkull = 5
monthlyFragsToRedSkull = 10
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
useFragHandler = true
advancedFragList = false
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
killsBanLength = 7 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false
worldType = "pvp"
protectionLevel = 1000
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 20 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = false
removeWeaponAmmunition = true
removeWeaponCharges = true
removeRuneCharges = true
whiteSkullTime = 15 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = false
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 1
stairhopDelay = 0 * 1000
pushCreatureDelay = 1 * 1000
deathContainerId = 19870
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
worldId = 0
ip = "127.0.0.1"
bindOnlyConfiguredIpAddress = false
loginPort = 7213
gamePort = 7573
adminPort = 7213
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 1000
motd = "BAIXE A VERSÃO 3.0 NO SITE http://pokevicio.no-ip.biz"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "PokeVicio Anime Ot"
loginMessage = "Seja Bem Vindo(a) ao PokeVicio!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = true
sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "forgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5
ingameGuildManagement = false
levelToFormGuild = 8
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
highscoreDisplayPlayers = 30
updateHighscoresAfterMinutes = 1
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 60
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 1000
houseRentPeriod = "monthly"
houseCleanOld = 0
guildHalls = false
timeBetweenActions = 200
timeBetweenExActions = 1000
hotkeyAimbotEnabled = true
mapName = "or11"
mapAuthor = "JeanCassio"
randomizeTiles = true
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"
defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"

optimizeDatabaseAtStartup = false
removePremiumOnInit = true
confirmOutdatedVersion = false
formulaLevel = 5.0
formulaMagic = 1.0
bufferMutedOnSpellFailure = false
spellNameInsteadOfWords = false
emoteSpells = false
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 = 22
ghostModeInvisibleEffect = false
ghostModeSpellEffects = true
idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0
freePremium = no
premiumForPromotion = true
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8
experienceStages = false
rateExperience = 3
rateExperienceFromPlayers = 1
rateSkill = 1
rateMagic = 1
rateLoot = 1
rateSpawn = 25
rateMonsterHealth = 1.0
rateMonsterMana = 1.0
rateMonsterAttack = 2.0
rateMonsterDefense = 2.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 = 25
maxPlayerSummons = 1
teleportAllSummons = true
teleportPlayerSummons = true
ownerName = "Pokevicio"
ownerEmail = "@otland.net"
url = "http://www.pokevicio.com/"
location = "Brazil"
displayGamemastersWithOnlineCommand = false
-- Logs
-- NOTE: This kind of logging does not work in GUI version.
-- For such, please compile the software with __GUI_LOGS__ flag.
adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false

 

 

Ajudei ? Rep +

Editado Maio 7 por N4K4MUR4

Luquinh4L
07 de maio de 2013 às 00:21

vai no teu config.lua, apaga TUDO o que tem la dentro e cola isso..

 

 

accountManager = true
namelockManager = true
newPlayerChooseVoc = true
newPlayerSpawnPosX = 1143
newPlayerSpawnPosY = 1140
newPlayerSpawnPosZ = 5
newPlayerTownId = 1
newPlayerLevel = 1
newPlayerMagicLevel = 1
generateAccountNumber = false
redSkullLength = 30 * 24 * 60 * 60
blackSkullLength = 45 * 24 * 60 * 60
dailyFragsToRedSkull = 3
weeklyFragsToRedSkull = 5
monthlyFragsToRedSkull = 10
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = true
useFragHandler = true
advancedFragList = false
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
killsBanLength = 7 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = true
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false
worldType = "pvp"
protectionLevel = 1000
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 20 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 7
criticalHitMultiplier = 1
displayCriticalHitNotify = false
removeWeaponAmmunition = true
removeWeaponCharges = true
removeRuneCharges = true
whiteSkullTime = 15 * 60 * 1000
noDamageToSameLookfeet = false
showHealingDamage = false
showHealingDamageForMonsters = false
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 10 * 1000
deathLostPercent = 1
stairhopDelay = 0 * 1000
pushCreatureDelay = 1 * 1000
deathContainerId = 19870
gainExperienceColor = 215
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
worldId = 0
ip = "127.0.0.1"
bindOnlyConfiguredIpAddress = false
loginPort = 7213
gamePort = 7573
adminPort = 7213
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 1000
motd = "BAIXE A VERSÃO 3.0 NO SITE http://pokevicio.no-ip.biz"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = true
allowClones = false
serverName = "PokeVicio Anime Ot"
loginMessage = "Seja Bem Vindo(a) ao PokeVicio!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = true
sqlType = "sqlite"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "forgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5
ingameGuildManagement = false
levelToFormGuild = 8
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
highscoreDisplayPlayers = 30
updateHighscoresAfterMinutes = 1
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 60
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 1000
houseRentPeriod = "monthly"
houseCleanOld = 0
guildHalls = false
timeBetweenActions = 200
timeBetweenExActions = 1000
hotkeyAimbotEnabled = true
mapName = "or11"
mapAuthor = "JeanCassio"
randomizeTiles = true
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"
defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"

optimizeDatabaseAtStartup = false
removePremiumOnInit = true
confirmOutdatedVersion = false
formulaLevel = 5.0
formulaMagic = 1.0
bufferMutedOnSpellFailure = false
spellNameInsteadOfWords = false
emoteSpells = false
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 = 22
ghostModeInvisibleEffect = false
ghostModeSpellEffects = true
idleWarningTime = 14 * 60 * 1000
idleKickTime = 15 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0
freePremium = no
premiumForPromotion = true
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8
experienceStages = false
rateExperience = 3
rateExperienceFromPlayers = 1
rateSkill = 1
rateMagic = 1
rateLoot = 1
rateSpawn = 25
rateMonsterHealth = 1.0
rateMonsterMana = 1.0
rateMonsterAttack = 2.0
rateMonsterDefense = 2.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 = 25
maxPlayerSummons = 1
teleportAllSummons = true
teleportPlayerSummons = true
ownerName = "Pokevicio"
ownerEmail = "@otland.net"
url = "http://www.pokevicio.com/"
location = "Brazil"
displayGamemastersWithOnlineCommand = false
-- Logs
-- NOTE: This kind of logging does not work in GUI version.
-- For such, please compile the software with __GUI_LOGS__ flag.
adminLogsEnabled = false
displayPlayersLogging = true
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false

 

 

Ajudei ? Rep +

@off

LOL VEI TU AJUNTO TUDO KKK

 

mas seila se der certo

AlphaLoveA
07 de maio de 2013 às 00:24

mas seila se der certo

 

Não juntei nada lek, apenas peguei o config.lua dele e configurei de acordo com o server dele e simplesmente pra funcionar em sqlite.

kalditoK
07 de maio de 2013 às 00:35

continua mesmo error

 

[06/05/2013 22:30:57] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: shop_history (SELECT * FROM shop_history WHERE "processed" = 0;)

LuckinhaSanL
07 de maio de 2013 às 00:38
continua mesmo error [06/05/2013 22:30:57] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: shop_history (SELECT * FROM shop_history WHERE "processed" = 0;)

 

Aconselho você a usar outro servidor, este servidor é apenas

uma base para edição.