[ERRO] Erro SQL Datebase.

Postado Junho 22, 2014 10 anos

/*Database information*/

$config['database']['host'] = "localhost";

$config['database']['login'] = "root";

$config['database']['password'] = "";

$config['database']['database'] = "pokemonnoia";

$config['database']['password'] = "";

Coloca teu password e vê se funciona.. outra coisa pra você estar colocando senha no root quer dizer que você ja foi na aba privilegios e colocou senha certo?

Se não fez retire o password do config.lua e muda o sqlhost para localhost ou 127.0.0.1

Citar

Mention

Postado Junho 22, 2014 10 anos

Autor

Em 22/06/2014 em 20:37, MarcosFraga disse:
/*Database information*/

$config['database']['host'] = "localhost";

$config['database']['login'] = "root";

$config['database']['password'] = "";

$config['database']['database'] = "pokemonnoia";
$config['database']['password'] = "";
Coloca teu password e vê se funciona.. outra coisa pra você estar colocando senha no root quer dizer que você ja foi na aba privilegios e colocou senha certo?

Se não fez retire o password do config.lua e muda o sqlhost para localhost ou 127.0.0.1

A senha está correta até agora também já tentei de tudo e fiz o que você me pediu e não foi .

accountManager = false

namelockManager = true

newPlayerChooseVoc = false

newPlayerSpawnPosX = 207

newPlayerSpawnPosY = 78

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 40

newPlayerMagicLevel = 0

generateAccountNumber = false

generateAccountSalt = false

lightInterval = 7500

lightChange = 1

startupTime = 351

startupLight = 40

limitPokeballs = 6

happyDropTime = 12

minHappinessEffectDelay = 25

maxHappinessEffectDelay = 40

PokemonStageVeryHappy = 215

PokemonStageHappy = 160

PokemonStageOK = 110

PokemonStageSad = 50

PokemonStageMad = 0

maximumHunger = 120

stateHunger = 100

increaseHunger = 7

decreaseHappy = 1

decreaseHungryHappy = 4

useTeleportWithFly = false

dropHappyDuringBattles = true

allowBlockSpawn = 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 = 18 * 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 = 0

gainExperienceColor = 215

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

worldId = 0

ip = "177.183.**.**"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 100

motd = "Bem vindo ao Poke Noia"

onePlayerOnlinePerAccount = false

allowClones = true

serverName = "Poke Noia"

loginMessage = "Bem vindo ao Poke Noia."

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = true

sqlType = "mysql"

sqlHost = "127.0.0.1"

sqlPort = 3306

sqlUser = "root"

sqlPass = "pokenoia24staff"

sqlDatabase = "pokemonnoia"

sqlFile = ""

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

encryptionType = "sha1"

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 10

ingameGuildManagement = true

levelToFormGuild = 40

premiumDaysToFormGuild = 0

guildNameMinLength = 2

guildNameMaxLength = 25

highscoreDisplayPlayers = 15

updateHighscoresAfterMinutes = 5

buyableAndSellableHouses = true

houseNeedPremium = true

bedsRequirePremium = true

levelToBuyHouse = 1

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 2975

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = false

timeBetweenActions = 500

timeBetweenExActions = 500

hotkeyAimbotEnabled = true

mapName = "mastermap.otbm"

mapAuthor = "Deep Kill"

randomizeTiles = true

storeTrash = false

cleanProtectedZones = true

mailboxDisabledTowns = "1"

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

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 = false

dataDirectory = "data/"

bankSystem = true

displaySkillLevelOnAdvance = true

promptExceptionTracerErrorBox = true

separateViplistPerCharacter = false

maximumDoorLevel = 500

maxMessageBuffer = 4

saveGlobalStorage = false

useHouseDataStorage = false

storePlayerDirection = false

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 22

ghostModeInvisibleEffect = true

ghostModeSpellEffects = false

idleWarningTime = 14 * 60 * 1000

idleKickTime = 15 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

freePremium = false

premiumForPromotion = true

blessingOnlyPremium = true

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

experienceStages = false

rateExperience = 600

rateExperienceFromPlayers = 600

rateSkill = 200

rateMagic = 600

rateLoot = 600

rateSpawn = 600

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 = 41 * 60

staminaRatingLimitBottom = 14 * 60

rateStaminaAboveNormal = 1.0

rateStaminaUnderNormal = 1.0

staminaThresholdOnlyPremium = true

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 200 * 200

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 20

experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = false

globalSaveHour = 8

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

deSpawnRange = 15

deSpawnRadius = 25

maxPlayerSummons = 1

teleportAllSummons = true

teleportPlayerSummons = true

ownerName = "Centurion V8"

ownerEmail = "doodoby_007@hotmail.com"

url = "..."

location = "Brazil"

displayGamemastersWithOnlineCommand = false

adminLogsEnabled = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

Editado Junho 22, 2014 10 anos por pauliinho157 (veja o histórico de edições)

Citar

Mention

Postado Junho 22, 2014 10 anos

O seu erro é de Mysql Host desconhecido pela imagem não deu pra ler tudo mas esta escrito : localhost então o certo seria mudar no config.lua o sqlhost para 127.0.0.1 e no config.php do site também... só que você esta dizendo que não funcionou.. e mesmo colocando a senha certa no config.php também não funcionou tá meio estranho.

Citar

Mention