Tenho varias duvidas Vou Por Em 1 Topico só Meu config.lua ta em mysql Mas ta dando erro
 

 
Meu config.lua

	accountManager = "yes"
	namelockManager = "yes"
	newPlayerChooseVoc = "yes"
	newPlayerSpawnPosX = 139
	newPlayerSpawnPosY = 1296
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 1
	newPlayerLevel = 15
	newPlayerMagicLevel = 1
	generateAccountNumber = "no"

	redSkullLength = 60 * 100 * 120
	blackSkullLength = 90 * 130 * 150
	dailyFragsToRedSkull = 7
	weeklyFragsToRedSkull = 30
	monthlyFragsToRedSkull = 70
	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 = 1 * 24 * 60 * 60
	killsBanLength = 1 * 24 * 60 * 60
	finalBanLength = 1 * 24 * 60 * 60
	ipBanishmentLength = 1 * 24 * 60 * 60
	broadcastBanishments = true
	maxViolationCommentSize = 200
	violationNameReportActionType = 2
	autoBanishUnknownBytes = false

	worldType = "open"
	protectionLevel = 70
	pvpTileIgnoreLevelAndVocationProtection = true
	pzLocked = 1 * 30 * 1000
	huntingDuration = 1 * 60 * 1000
	criticalHitChance = 11
	criticalHitMultiplier = 1
	displayCriticalHitNotify = true
	removeWeaponAmmunition = false
	removeWeaponCharges = true
	removeRuneCharges = false
	whiteSkullTime = 3 * 60 * 1000
	noDamageToSameLookfeet = false
	showHealingDamage = true
	showHealingDamageForMonsters = false
	fieldOwnershipDuration = 5 * 1000
	stopAttackingAtExit = false
	oldConditionAccuracy = false
	loginProtectionPeriod = 10 * 1000
	deathLostPercent = 10
	stairhopDelay = 2 * 1000
	pushCreatureDelay = 1 * 205
	deathContainerId = 1987
	gainExperienceColor = 215
	addManaSpentInPvPZone = true
	squareColor = 0
	allowFightback = true

        enableCast = true

        healthHealingColor = COLOR_BLUE

	worldId = 0
	ip = "devilbaiak.sytes.net"
	bindOnlyConfiguredIpAddress = false
	loginPort = 7171
	gamePort = 7172
	adminPort = 7171
	statusPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = 109
	motd = "Bem Vindo ao Baiak Devil!!"
	displayOnOrOffAtCharlist = false
	onePlayerOnlinePerAccount = true
	allowClones = false
	serverName = "Baiak Cartoon"
	loginMessage = "Bem Vindo ao Baiak Devil!!"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = true
	forceSlowConnectionsToDisconnect = false
	loginOnlyWithLoginServer = false
	premiumPlayerSkipWaitList = false

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "senha"
	sqlDatabase = "ot"
	sqlFile = "BaiakRox.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

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

	ingameGuildManagement = true
	levelToFormGuild = 8
	premiumDaysToFormGuild = 0
	guildNameMinLength = 4
	guildNameMaxLength = 20


	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 2


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


	timeBetweenActions = 200
	timeBetweenExActions = 1000
	checkCorpseOwner = true
	hotkeyAimbotEnabled = true
	maximumDoorLevel = 500


	mapName = "Baiak Yurots.otbm"
	mapAuthor = "Diego"
	randomizeTiles = true
	useHouseDataStorage = false
	storeTrash = true
	cleanProtectedZones = true
	mailboxDisabledTowns = "-1"


	defaultPriority = "high"
	niceLevel = 5
	coresUsed = "-1"
	optimizeDatabaseAtStartup = true
	removePremiumOnInit = true
	confirmOutdatedVersion = false


	maxMessageBuffer = 4
	bufferMutedOnSpellFailure = false


	dataDirectory = "data/"
	allowChangeOutfit = true
	allowChangeColors = true
	allowChangeAddons = true
	disableOutfitsForPrivilegedPlayers = false
	bankSystem = true
	saveGlobalStorage = true
	displaySkillLevelOnAdvance = false
	spellNameInsteadOfWords = false
	emoteSpells = true
	promptExceptionTracerErrorBox = true
	storePlayerDirection = false
	monsterLootMessage = 3
	monsterLootMessageType = 25
	separateViplistPerCharacter = false


	ghostModeInvisibleEffect = false
	ghostModeSpellEffects = true


	idleWarningTime = 14 * 60 * 1000
	idleKickTime = 15 * 60 * 1000
	expireReportsAfterReads = 1
	playerQueryDeepness = 2
	maxItemsPerPZTile = 0
	maxItemsPerHouseTile = 0


	freePremium = true
	premiumForPromotion = true


	blessingOnlyPremium = true
	blessingReductionBase = 30
	blessingReductionDecreament = 5
	eachBlessReduction = 8


	experienceStages = "yes"
	rateExperience = 45
	rateExperienceFromPlayers = 5
	rateSkill = 30
	rateMagic = 15
	rateLoot = 3
	rateSpawn = 1


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

	-- Experience from players
	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 = 1
	shutdownAtGlobalSave = false
	cleanMapAtGlobalSave = false


	deSpawnRange = 2
	deSpawnRadius = 50


	maxPlayerSummons = 2
	teleportAllSummons = false
	teleportPlayerSummons = false


	ownerName = "Diego"
	ownerEmail = "[email protected]"
	url = ""
	location = "Brasil-Campinas-sp"
	displayGamemastersWithOnlineCommand = false


	adminLogsEnabled = false
	displayPlayersLogging = true
	prefixChannelLogs = ""
	runFile = ""
	outLogName = ""
	errorLogName = ""
	truncateLogsOnStartup = false

Meu site está dando erro

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g.logo_gfx_name' in 'field list'' in C:\xampp\htdocs\latestnews.php:63 Stack trace: #0 C:\xampp\htdocs\latestnews.php(63): PDO->query('SELECT `g`.`id`...') #1 C:\xampp\htdocs\index.php(64): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 63

Ajuda?

Valendo rep +

Editado Março 6, 2015 10 anos por iErrorzz (veja o histórico de edições)

        sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "senha"
	sqlDatabase = "ot"
	sqlFile = "BaiakRox.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

aqui:

sqlPass = "senha"

    sqlDatabase = "ot"

 

você tem que por a senha do seu phpmyadmin e o nome da database

        sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "senha"
	sqlDatabase = "ot"
	sqlFile = "BaiakRox.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "sha1"

aqui:

sqlPass = "senha"

    sqlDatabase = "ot"

 

você tem que por a senha do seu phpmyadmin e o nome da database

 

 

Ja fis isso a database e ot a senha e diferente, Botei senha ai so pra ngn saber a senha pois Tem membros daki q sabem o site do meu server

De acordo com o que te passei funcionou né?

Ja fis isso a database e ot a senha e diferente, Botei senha ai so pra ngn saber a senha pois Tem membros daki q sabem o site do meu server

caso tenha sido resolvido reporte para que o memso seja movido para a seção correta!

 

sobre o topico coisas que geram esse tipo de erro sao o que ja foi citado e voce respondeu e ja passei por erros parecidos por colocar o nome da db diferente no phpmyadmin do da db extraida!