Erro Sql [Erro] sql xampp

[icaro2507 2]

alguém pode me ajuda com o erro a abaixo???? 

meu ot e 10.41 global.

 

https://imageshack.com/i/p2ipyyvYp

[KekezitoLHP 135]

alguma parte do sql ta errado pega original ou de algum outro ot 

[icaro2507 2]

Pohh... ja troquei de sql  mais da outro erro você não poderia me dizer que sql usar? to usando o ot do tópico http://www.tibiaking.com/forum/topic/36111-1037-at%C3%A9-1041-global-completo-o-melhor/

[Sociopata 505]

tenta ake

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL,
  `salt` varchar(40) NOT NULL DEFAULT '',
  `premdays` int(11) NOT NULL DEFAULT '0',
  `lastday` int(10) unsigned NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `key` varchar(20) NOT NULL DEFAULT '0',
  `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',
  `warnings` int(11) NOT NULL DEFAULT '0',
  `group_id` int(11) NOT NULL DEFAULT '1',
  `viptime` int(15) NOT NULL DEFAULT '0',
  `page_lastday` int(11) NOT NULL,
  `email_new` varchar(255) NOT NULL,
  `email_new_time` int(15) NOT NULL,
  `created` int(11) NOT NULL DEFAULT '0',
  `rlname` varchar(255) NOT NULL DEFAULT '',
  `location` varchar(255) NOT NULL DEFAULT '',
  `page_access` int(11) NOT NULL DEFAULT '0',
  `email_code` varchar(255) NOT NULL DEFAULT '0',
  `next_email` int(11) NOT NULL DEFAULT '0',
  `premium_points` int(11) NOT NULL DEFAULT '0',
  `vote` int(11) NOT NULL,
  `last_post` int(11) NOT NULL DEFAULT '0',
  `flag` varchar(255) NOT NULL,
  `vip_time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6741028 ;

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `viptime`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`) VALUES
(1, '1', '1', '', 65535, 1315745304, '', 'b6589fc6ab0dc82cf120', 0, 0, 1, 0, 1315749556, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, '', 0),
(6741027, '123456', '123456', '', 0, 1315745228, '[email protected]', '', 0, 0, 1, 0, 1314314775, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br', 0);

DROP TRIGGER IF EXISTS `ondelete_accounts`;
DELIMITER //
CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`
 FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`; END
//
DELIMITER ;

[icaro2507 2]

 

tenta ake

CREATE TABLE IF NOT EXISTS `accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL DEFAULT '',
  `password` varchar(255) NOT NULL,
  `salt` varchar(40) NOT NULL DEFAULT '',
  `premdays` int(11) NOT NULL DEFAULT '0',
  `lastday` int(10) unsigned NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT '',
  `key` varchar(20) NOT NULL DEFAULT '0',
  `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage',
  `warnings` int(11) NOT NULL DEFAULT '0',
  `group_id` int(11) NOT NULL DEFAULT '1',
  `viptime` int(15) NOT NULL DEFAULT '0',
  `page_lastday` int(11) NOT NULL,
  `email_new` varchar(255) NOT NULL,
  `email_new_time` int(15) NOT NULL,
  `created` int(11) NOT NULL DEFAULT '0',
  `rlname` varchar(255) NOT NULL DEFAULT '',
  `location` varchar(255) NOT NULL DEFAULT '',
  `page_access` int(11) NOT NULL DEFAULT '0',
  `email_code` varchar(255) NOT NULL DEFAULT '0',
  `next_email` int(11) NOT NULL DEFAULT '0',
  `premium_points` int(11) NOT NULL DEFAULT '0',
  `vote` int(11) NOT NULL,
  `last_post` int(11) NOT NULL DEFAULT '0',
  `flag` varchar(255) NOT NULL,
  `vip_time` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6741028 ;

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `viptime`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`) VALUES
(1, '1', '1', '', 65535, 1315745304, '', 'b6589fc6ab0dc82cf120', 0, 0, 1, 0, 1315749556, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, '', 0),
(6741027, '123456', '123456', '', 0, 1315745228, '[email protected]', '', 0, 0, 1, 0, 1314314775, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br', 0);

DROP TRIGGER IF EXISTS `ondelete_accounts`;
DELIMITER //
CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts`
 FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`; END
//
DELIMITER ;

Deu o mesmo erro só que menor 

 

https://imageshack.com/i/exSlv816p

[PriisioneR 136]

tenta limpar a sua tabela account. 

ta super lotada ou usar uma database limpa e nova 

[Sociopata 505]

suspeito q vc importou a database errada amigo, tente importar outra para ver o que ocorre

[icaro2507 2]

Troquei de Database mas agr quando o site funciona o ot não abre...

quando eu coloco no config.lua
 

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "macaco123"
sqlDatabase = "global2"
sqlFile = "global2.s3db"
mysqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
mysqlReconnectionAttempts = 3
encryptionType = "sha1"

O site funciona mas o ot da esse erro quando abre

https://imageshack.com/i/exVry9Bnp


quando mudo no config.lua para

mysqlType = "mysql"

mysqlHost = "localhost"
mysqlPort = 3306
mysqlUser = "root"
mysqlPass = "macaco123"
mysqlDatabase = "global2"
mysqlFile = "global2.s3db"
mysqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
mysqlReconnectionAttempts = 3
encryptionType = "sha1"

o site nao reconece a config.lua

https://imageshack.com/i/pbQdyc6lp

mas o ot carrega

 

https://imageshack.com/i/iq3pG2a7p

Editado Setembro 28, 2014 por icaro2507 (veja o histórico de edições)

[Sociopata 505]

posta o config.lua inteira

[icaro2507 2]

posta o config.lua inteira

 

[spoiler*]

accountManager = false

namelockManager = true

newPlayerChooseVoc = true

newPlayerSpawnPosX = 100

newPlayerSpawnPosY = 40

newPlayerSpawnPosZ = 6

newPlayerTownId = 1

newPlayerLevel = 10

newPlayerMagicLevel = 0

generateAccountNumber = false

generateAccountSalt = false

 

 

useRookSystem = false

rookTownId = 1

rookLevelToGetRooked = 5

rookLevelToLeaveRook = 8

 

 

useFragHandler = true

redSkullLength = 1 * 24 * 60 * 60

blackSkullLength = 2 * 24 * 60 * 60

fragsLimit = 24 * 60 * 60

fragsSecondLimit = 7 * 24 * 60 * 60

fragsThirdLimit = 30 * 24 * 60 * 60

fragsToRedSkull = 6

fragsSecondToRedSkull = 8

fragsThirdToRedSkull = 10

fragsToBlackSkull = 8

fragsSecondToBlackSkull = 10

fragsThirdToBlackSkull = 12

fragsToBanishment = fragsToRedSkull

fragsSecondToBanishment = fragsSecondToRedSkull

fragsThirdToBanishment = fragsThirdToRedSkull

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = true

advancedFragList = false

 

 

notationsToBan = 3

warningsToFinalBan = 4

warningsToDeletion = 5

banLength = 7 * 24 * 60 * 60

killsBanLength = 7 * 24 * 60 * 60

finalBanLength = 30 * 24 * 60 * 60

ipBanLength = 1 * 24 * 60 * 60

allowedMaxSizePackets = 20

 

 

worldType = "pvp"

protectionLevel = 50

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 60 * 1000

huntingDuration = 60 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = true

removeWeaponCharges = true

removeRuneCharges = true

whiteSkullTime = 15 * 60 * 1000

noDamageToSameLookfeet = false

showHealthChange = false

showManaChange = false

showHealthChangeForMonsters = false

showManaChangeForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

loginProtectionPeriod = 10 * 1000

deathLostPercent = 10

stairhopDelay = 2 * 1000

pushCreatureDelay = 2 * 1000

deathContainerId = 1987

gainExperienceColor = 215

addManaSpentInPvPZone = true

recoverManaAfterDeathInPvPZone = false

squareColor = 0

allowFightback = true

fistBaseAttack = 7

useFairfightReduction = true

optionalWarAttackableAlly = false

 

worldId = 0

ip = "localhost"

bindOnlyGlobalAddress = false

oginPort = 7171

gamePort = "7172"

loginTries = 3

retryTimeout = 5 * 1000

loginTimeout = 60 * 1000

maxPlayers = 1000

spoofPlayers = 0

otd = "Welcome to the Tibia!"

displayOnOrOffAtCharlist = false

onePlayerOnlinePerAccount = true

allowClones = 0

serverName = "Tibia"

serverPreview = true

loginMessage = "Welcome to the Tibia"

statusTimeout = 5 * 60 * 1000

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = true

packetsPerSecond = 50

 

rsaPrime1 = "14299623962416399520070177382898895550795403345466153217470516082934737582776038882967213386204600674145392845853859217990626450972452084065728686565928113"

rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101"

rsaPublic = "65537"

rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413"

rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073"

 

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "macaco123"

sqlDatabase = "global2"

sqlFile = "global2.s3db"

mysqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

mysqlReconnectionAttempts = 3

encryptionType = "sha1"

 

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

multipleNames = false

 

ingameGuildManagement = false

levelToFormGuild = 75

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

 

buyableAndSellableHouses = true

houseNeedPremium = false

bedsRequirePremium = true

levelToBuyHouse = 50

housesPerAccount = 0

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 1000

houseSkipInitialRent = true

houseRentPeriod = "never"

houseCleanOld = 0

guildHalls = true

houseProtection = true

levelToOfflineInBed = 8

 

timeBetweenActions = 200

timeBetweenExActions = 1000

timeBetweenCustomActions = 500

hotkeyAimbotEnabled = true

tibiaClassicSlots = true

canOnlyRopePlayers = true

 

mapName = "realmap"

mapAuthor = ""

randomizeTiles = true

storeTrash = true

cleanProtectedZones = true

 

mailboxDisabledTowns = ""

mailMaxAttempts = 20

mailBlockPeriod = 60 * 60 * 1000

mailAttemptsFadeTime = 10 * 60 * 1000

 

marketEnabled = true

marketOfferDuration = 30 * 24 * 60 * 60

premiumToCreateMarketOffer = false

checkExpiredMarketOffersEachMinutes = 60

maxMarketOffersAtATimePerPlayer = 100

 

daemonize = false

defaultPriority = "high"

niceLevel = 5

serviceThreads = 1

coresUsed = "-1"

 

startupDatabaseOptimization = true

updatePremiumStateAtStartup = true

confirmOutdatedVersion = false

skipItemsVersionCheck = true

 

formulaLevel = 5.0

formulaMagic = 1.0

bufferMutedOnSpellFailure = false

spellNameInsteadOfWords = false

emoteSpells = false

unifiedSpells = true

enableCooldowns = true

 

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

addonsOnlyPremium = false

 

dataDirectory = "data/"

logsDirectory = "data/logs/"

bankSystem = true

promptExceptionTracerErrorBox = true

maximumDoorLevel = 500

maxMessageBuffer = 4

logPlayersStatements = false

tradeLimit = 100

useCapacity = true

playerFollowExhaust = 2000

 

defaultDepotSizePremium = 2000

defaultDepotSize = 100

 

useMounts = true

unmountPlayerInPz = true

 

separateVipListPerCharacter = false

vipListDefaultLimit = 20

vipListDefaultPremiumLimit = 100

 

houseDataStorage = "binary"

saveGlobalStorage = true

storePlayerDirection = false

savePlayerData = true

 

checkCorpseOwner = true

monsterLootMessage = 3

monsterLootMessageType = 21

 

ghostModeInvisibleEffect = false

ghostModeSpellEffects = true

 

idleWarningTime = 14 * 60 * 1000

idleKickTime = 15 * 60 * 1000

reportsExpirationAfterReads = 1

playerQueryDeepness = -1

tileLimit = 0

protectionTileLimit = 0

houseTileLimit = 0

 

freePremium = false

premiumForPromotion = false

 

blessings = true

blessingOnlyPremium = false

blessingReductionBase = 30

blessingReductionDecrement = 5

eachBlessReduction = 8

pvpBlessingThreshold = 40

fairFightTimeRange = 60

 

experienceStages = true

rateExperience = 400.0

rateExperienceFromPlayers = 10.0

rateSkill = 30.0

rateMagic = 10.0

rateLoot = 3.0

rateSpawnMin = 1

rateSpawnMax = 3

 

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

staminaRatingLimitBottom = 14 * 60

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

globalSaveMinute = 0

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

closeInstanceOnShutdown = true

 

deSpawnRange = 2

deSpawnRadius = 50

monsterSpawnWalkback = true

allowBlockSpawn = true

 

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

 

statusPort = 7171

ownerName = "Icaro"

ownerEmail = ""

url = "http://www.lnetworks.com.br"

location = "Brazil"

displayGamemastersWithOnlineCommand = false

 

disableLuaErrors = false

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outputLog = ""

truncateLogOnStartup = false

 

managerPort = 7171

managerLogs = true

managerPassword = ""

managerLocalhostOnly = true

managerConnectionsLimit = 1

 

adminPort = 7171

adminLogs = true

adminPassword = ""

adminLocalhostOnly = true

adminConnectionsLimit = 1

adminRequireLogin = true

adminEncryption = ""

adminEncryptionData = ""

[/spoiler*] 

 

 

 não sei bota aquelas paradinha pra diminuir o tamanho mas vai assim mesmo

Editado Setembro 28, 2014 por icaro2507 (veja o histórico de edições)

[Sociopata 505]

ip = "localhost"

 

coloca 127.0.0.1

 

qualquer coisa me add no skype q te ajudo e posto a solução aqui

[icaro2507 2]

ip = "localhost"

 

coloca 127.0.0.1

 

qualquer coisa me add no skype q te ajudo e posto a solução aqui

mudei mas n adianta nd, vou ligar o skype aqui

Editado Setembro 28, 2014 por icaro2507 (veja o histórico de edições)