• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Website Error

Smokiee Jo

Website Scripter
Joined
Nov 8, 2012
Messages
217
Solutions
1
Reaction score
16
Location
Ireland
As the title says i have an error with my new Website, when i try and install the new version of 1.0 i get this error

Error occured!
Error ID: #C-5
More info: ERROR: #C-5 : Class::ConfigPHP - Key passwordType doesn't exist.

File: C:\xampp\htdocs\classes/configphp.php Line: 96
File: C:\xampp\htdocs/install.php Line: 176

i am using this website and OT that he provided which would work via website and OT

http://otland.net/threads/best-released-real-map-10-31-based-1-0.204514/

using this website.zip for the OT
https://github.com/gesior/Gesior2012/archive/TFS-1.0.zip

once i get to the 2. Check DataBase connection i get the error

if anyone could help me that would great thanks :)
 
Code:
-- Combat settings
worldType = "pvp"
hotkeyAimbotEnabled = "yes"
protectionLevel = 1
killsToRedSkull = 3
killsToBlackSkull = 6
pzLocked = 60000
removeAmmoWhenUsingDistanceWeapon = "yes"
removeChargesFromRunes = "yes"
timeToDecreaseFrags = 24 * 60 * 60 * 1000
whiteSkullTime = 15 * 60 * 1000
stairJumpExhaustion = 2000
experienceByKillingPlayers = "no"

-- Connection Config
ip = "127.0.0.1"
bindOnlyGlobalAddress = "no"
loginProtocolPort = 7171
gameProtocolPort = 7172
statusProtocolPort = 7171
maxPlayers = "1000"
motd = "Welcome to The Forgotten Server!"
onePlayerOnlinePerAccount = "yes"
allowClones = "no"
serverName = "Forgotten"
statusTimeout = 60000
replaceKickOnLogin = "yes"
maxPacketsPerSecond = 25

-- Deaths
-- NOTE: Leave deathLosePercent as -1 if you want to use the default
-- death penalty formula. For the old formula, set it to 10. For
-- no skill/experience loss, set it to 0.
deathLosePercent = -1

-- Houses
-- NOTE: set housePriceEachSQM to -1 to disable the ingame buy house functionality
housePriceEachSQM = 1000
houseRentPeriod = "never"

-- Item Usage
timeBetweenActions = 200
timeBetweenExActions = 1000

-- Map
mapName = "realmap"
mapAuthor = "Cipsoft"

-- Market
marketOfferDuration = 30 * 24 * 60 * 60
premiumToCreateMarketOffer = "yes"
checkExpiredMarketOffersEachMinutes = 60
maxMarketOffersAtATimePerPlayer = 100

-- MySQL
mysqlHost = "127.0.0.1"
mysqlUser = "root"
mysqlPass = "smokieejo007" -- changed for otland.net
mysqlDatabase = "clean"
mysqlPort = 3306
mysqlSock = ""
passwordType = "sha1"

-- Misc.
allowChangeOutfit = "yes"
freePremium = "no"
kickIdlePlayerAfterMinutes = 15
maxMessageBuffer = 4
noDamageToSameLookfeet = "no"

-- Rates
-- NOTE: rateExp is not used if you have enabled stages in data/XML/stages.xml
rateExp = 5
rateSkill = 3
rateLoot = 2
rateMagic = 3
rateSpawn = 1

-- Monsters
deSpawnRange = 2
deSpawnRadius = 50

-- Stamina
staminaSystem = "yes"

-- Startup
-- NOTE: defaultPriority only works on Windows and sets process priority.
defaultPriority = "high"
startupDatabaseOptimization = "no"

-- Status server information
ownerName = ""
ownerEmail = ""
url = "http://otland.net/"
location = "Sweden"

thats is my config.lua and once i add in passwordType = "sha1"

i get this error now :

Error occured!
Error ID:
More info: ERROR: #C-1 : Class::ConfigLUA - Line 58 of LUA config file is not valid [key: mysqlPass]

File: C:\xampp\htdocs\classes/configlua.php Line: 59
File: C:\xampp\htdocs\classes/configlua.php Line: 20
File: C:\xampp\htdocs\classes/configlua.php Line: 12
File: C:\xampp\htdocs/install.php Line: 206
 
sorry for double post, ive fixed the Above error but once i get to Step : 3. Add tables and columns to DB i get this huge error

Code:
STEP 3

Add tables and columns to DB
Installer try to add new tables and columns to database.
Query:    ALTER TABLE `accounts` ADD `key` VARCHAR(20) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'key'
Could not add column key to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `email_new` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'email_new'
Could not add column email_new to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `email_new_time` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'email_new_time'
Could not add column email_new_time to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `rlname` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'rlname'
Could not add column rlname to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `location` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'location'
Could not add column location to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `page_access` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'page_access'
Could not add column page_access to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `email_code` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'email_code'
Could not add column email_code to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `next_email` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'next_email'
Could not add column next_email to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `premium_points` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'premium_points'
Could not add column premium_points to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `create_date` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'create_date'
Could not add column create_date to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `create_ip` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'create_ip'
Could not add column create_ip to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `last_post` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'last_post'
Could not add column last_post to table accounts. Already exist?
Query:    ALTER TABLE `accounts` ADD `flag` VARCHAR(80) NOT NULL DEFAULT ''
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'flag'
Could not add column flag to table accounts. Already exist?
Query:    ALTER TABLE `guilds` ADD `description` TEXT NOT NULL DEFAULT ''
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'description'
Could not add column description to table guilds. Already exist?
Query:    ALTER TABLE `guilds` ADD `guild_logo` MEDIUMBLOB NULL DEFAULT NULL
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'guild_logo'
Query:    ALTER TABLE `guilds` ADD `guild_logo` MEDIUMBLOB NOT NULL DEFAULT ''
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'guild_logo'
Could not add column guild_logo to table guilds. Already exist?
Query:    ALTER TABLE `guilds` ADD `create_ip` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'create_ip'
Could not add column create_ip to table guilds. Already exist?
Query:    ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'balance'
Could not add column balance to table guilds. Already exist?
Query:    ALTER TABLE `players` ADD `deleted` TINYINT(1) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'deleted'
Could not add column deleted to table players. Already exist?
Query:    ALTER TABLE `players` ADD `description` VARCHAR(255) NOT NULL DEFAULT ''
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'description'
Could not add column description to table players. Already exist?
Query:    ALTER TABLE `players` ADD `comment` TEXT NOT NULL DEFAULT ''
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'comment'
Could not add column comment to table players. Already exist?
Query:    ALTER TABLE `players` ADD `create_ip` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'create_ip'
Could not add column create_ip to table players. Already exist?
Query:    ALTER TABLE `players` ADD `create_date` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'create_date'
Could not add column create_date to table players. Already exist?
Query:    ALTER TABLE `players` ADD `hide_char` INT(11) NOT NULL DEFAULT '0'
SQLSTATE:    42S21
Driver code:    1060
Error message:    Duplicate column name 'hide_char'
Could not add column hide_char to table players. Already exist?
Query:    CREATE TABLE `z_ots_comunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SQLSTATE:    42S01
Driver code:    1050
Error message:    Table 'z_ots_comunication' already exists
Could not create table z_ots_comunication. Already exist?
Query:    CREATE TABLE `z_shop_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SQLSTATE:    42S01
Driver code:    1050
Error message:    Table 'z_shop_offer' already exists
Could not create table z_shop_offer. Already exist?
Query:    CREATE TABLE `z_shop_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` varchar(255) NOT NULL default '', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SQLSTATE:    42S01
Driver code:    1050
Error message:    Table 'z_shop_history_item' already exists
Could not create table z_shop_history_item. Already exist?
Query:    CREATE TABLE `z_forum` ( `id` int(11) NOT NULL auto_increment, `first_post` int(11) NOT NULL default '0', `last_post` int(11) NOT NULL default '0', `section` int(3) NOT NULL default '0', `replies` int(20) NOT NULL default '0', `views` int(20) NOT NULL default '0', `author_aid` int(20) NOT NULL default '0', `author_guid` int(20) NOT NULL default '0', `post_text` text NOT NULL, `post_topic` varchar(255) NOT NULL, `post_smile` tinyint(1) NOT NULL default '0', `post_date` int(20) NOT NULL default '0', `last_edit_aid` int(20) NOT NULL default '0', `edit_date` int(20) NOT NULL default '0', `post_ip` varchar(15) NOT NULL default '0.0.0.0', PRIMARY KEY (`id`), KEY `section` (`section`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SQLSTATE:    42S01
Driver code:    1050
Error message:    Table 'z_forum' already exists
Could not create table z_forum. Already exist?
Tables and columns added to database.
Go to STEP 4 - Add samples

im trying to fix this atm but i really can not find any Solution Possible :S
 
Back
Top