Temat: [9.10][SQL][ACC] Can't connect to MySQL database.

	accountManager = "yes"
	newPlayerChooseVoc = "no"
	newPlayerSpawnPosX = 95
	newPlayerSpawnPosY = 117
	newPlayerSpawnPosZ = 7
	newPlayerTownId = 1
	newPlayerLevel = 1
	newPlayerMagicLevel = 0
	generateAccountNumber = "yes"

	broadcastBanishments = "yes"
	banDays = 7
	finalBanDays = 30
	killsToBan = 5


	worldType = "pvp"
	hotkeyAimbotEnabled = "yes"
	protectionLevel = 1
	killsToRedSkull = 3
	pzLocked = 60000
	deathLosePercent = 10
	criticalHitChance = 7
	removeAmmoWhenUsingDistanceWeapon = "yes"
	removeChargesFromRunes = "yes"
	removeChargesFromWeapons = "yes"
	timeToDecreaseFrags = 24 * 60 * 60 * 1000
	whiteSkullTime = 15 * 60 * 1000
	oldConditionAccuracy = "no"
	stairJumpExhaustion = 2000
	animationTextOnHeal = "yes"


	displayGamemastersWithOnlineCommand = "no"


	ip = "127.0.0.1"
	bindOnlyGlobalAddress = "no"
	loginProtocolPort = 7171
	gameProtocolPort = 7172
	adminProtocolPort = 7171
	statusProtocolPort = 7171
	loginTries = 10
	retryTimeout = 5 * 1000
	loginTimeout = 60 * 1000
	maxPlayers = "1000"
	motd = "Welcome to the Forgotten Server!"
	onePlayerOnlinePerAccount = "yes"
	allowClones = "no"
	serverName = "Forgotten"
	loginMessage = "Welcome to the Forgotten Server!"
	adminLogsEnabled = "no"
	statusTimeout = 5 * 60 * 1000
	replaceKickOnLogin = "yes"


	deathListEnabled = "yes"
	maxDeathRecords = 5


	ingameGuildSystem = "yes"
	levelToCreateGuild = 8


	highscoreDisplayPlayers = 15
	updateHighscoresAfterMinutes = 60

	housePriceEachSQM = 1000
	houseRentPeriod = "never"


	kickIdlePlayerAfterMinutes = 15


	timeBetweenActions = 200
	timeBetweenExActions = 1000


	mapName = "forgotten"
	mapAuthor = "Komic"
	randomizeTiles = "yes"
	mapStorageType = "relational"


	maxMessageBuffer = 4


	mysqlHost = "localhost"
	mysqlUser = "root"
	mysqlPass = "HASŁO" <-- Tutaj już dałem hasło, które jest takie same jak użytkownika Root
	mysqlDatabase = "theforgottenserver" <-- To zostawiłem, bo stworzyłem taką samą bazę w phpadmin i przez CMD importowałem.
	mysqlPort = 3306


	freePremium = "no"


	displayOnOrOffAtCharlist = "no"
	allowChangeOutfit = "yes"
	noDamageToSameLookfeet = "no"
	experienceByKillingPlayers = "no"


	rateExp = 5
	rateSkill = 3
	rateLoot = 2
	rateMagic = 3
	rateSpawn = 1

	serverSaveEnabled = "no"
	serverSaveHour = 3
	shutdownAtServerSave = "yes"
	cleanMapAtServerSave = "yes"


	autoSaveEachMinutes = 15
	saveGlobalStorage = "no"


	deSpawnRange = 2
	deSpawnRadius = 50


	sqliteDatabase = "forgottenserver.s3db"


	sqlType = "mysql"
	passwordType = "plain"


	defaultPriority = "high"


	freeMemoryAtShutdown = "yes"


	ownerName = ""
	ownerEmail = "@otland.net"
	url = "http://otland.net/"
	location = "Europe"

STEP 4
Add samples to DB:
News ticker sample is already in database. New sample is not needed.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'topic_df' in 'field list'' in C:\xampp\htdocs\install\install.php:569 Stack trace: #0 C:\xampp\htdocs\install\install.php(569): PDO->query('INSERT INTO z_n...') #1 {main} thrown in C:\xampp\htdocs\install\install.php on line 569

STEP 5
Set Admin Account

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\xampp\htdocs\pot\OTS_Account.php:228 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(228): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install\install.php(642): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 228