• 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!

geisor problem need urgent help!!

Arrish

Arrish

New Member
Joined
May 28, 2009
Messages
320
Reaction score
1
Location
Sweden
this is what i get when i want to type in the admin password for
geisor 0.3.3, im using the mystic spirit 0.2.1 tfs why wont it work???
i give + rep


Code: 
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:229 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\install.php(467): OTS_Account->load(1) #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Account.php on line 229
 
Sort by date Sort by votes
here is line 229
<code>
$this->data = $this->db->query('SELECT ' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('name') . ', ' . $this->db->fieldName('password') . ', ' . $this->db->fieldName('email') . ', ' . $this->db->fieldName('blocked') . ', ' . $this->db->fieldName('rlname') . ', ' . $this->db->fieldName('location') . ', ' . $this->db->fieldName('page_access') . ', ' . $this->db->fieldName('premdays') . ', ' . $this->db->fieldName('lastday') . ', ' . $this->db->fieldName('created') . ' FROM ' . $this->db->tableName('accounts') . ' WHERE ' . $this->db->fieldName('id') . ' = ' . (int) $id)->fetch();</code>
 
Upvote 0 Downvote
Please can someone tell me what iam doing wrong ? , i have these prob : when i click set path this come Warning: Error parsing C:/Users/AARMAN/Desktop/tfs/config.lua on line 142 in C:\xampp\htdocs\install.php on line 156.
and then when i want to check database connection this comes:
Warning: Error parsing C:/Users/AARMAN/Desktop/tfs/config.lua on line 142 in C:\xampp\htdocs\install.php on line 183
and then when i click on step 3 add tables and columns this comes :
Warning: Error parsing C:/Users/AARMAN/Desktop/tfs/config.lua on line 142 in C:\xampp\htdocs\install.php on line 183.*
please someone explain what iam doing wrong i have followed the tutorials but still , iam giving + rep for the one helping me
 
Upvote 0 Downvote
the first error all away up it says you dont have Name in your table account add that.

and could you tell us whats on like 142 at config.lua?
is it writen with green
like
-- Blablabla
if yes remove that line.
 
Upvote 0 Downvote
What do you mean adda a name in table account, or installing the admin acc can someone explain little better please? , i took the config from my server and copy/pasted it in httpdoc folder in xamp , this is line 142 in config:
-- default is -1, so it stays untouched (automaticaly assigned by OS). iam newbie at this website thing otherwise the other thing ican pretty good , can someone add on msn or something and explain better please? or just write here
 
Upvote 0 Downvote
Yes i downloaded 0.3.4 and then when i replace it with the 0.2.1 and start 0.3.4 it says cannot make connection to sqldatabase acces denied something , i have fixed this database thing in config , i dunno why it get cannot make connection to sqldatabase , it worked with the 0.2.1
please help i give rep i really need website
 
Upvote 0 Downvote
this is what it comes up
Failed connecting to database - MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: NO) (1045)

> ERROR: Couldn't estabilish connection to SQL database!
 
Upvote 0 Downvote
Arrish said:
this is what it comes up
Failed connecting to database - MYSQL ERROR: Access denied for user 'root'@'localhost' (using password: NO) (1045)

> ERROR: Couldn't estabilish connection to SQL database!
Click to expand...

you did't seted your password.

and for ur first error add this in to your ask database
PHP: 
ALTER TABLE `accounts` ADD `name` VARCHAR(32) NOT NULL DEFAULT '0';
when you done that add this
UPDATE `accounts` SET `name` = `id`

and remove this line from your config.lua
PHP: 
-- default is -1, so it stays untouched (automaticaly assigned by OS).

and last but change in config.lua this
PHP: 
	mysqlHost = "localhost"
	mysqlPort = 3306
	mysqlUser = "root"
	mysqlPass = ""
	mysqlDatabase = ""
Change this to that down caus in tfs 0.2 it use that above and in 0.3.4 it use the down one
PHP: 
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = ""
	sqlPass = ""
	sqlDatabase = ""

good luck with your server and if ya need help post here.
 
Upvote 0 Downvote
now i get this error
[Error - Items::loadFromOtb] Another (client) version of items.otb is required.

> ERROR: Unable to load items (OTB)!

what to do?:S
 
Upvote 0 Downvote
Arrish said:
Please can someone tell me what iam doing wrong ? , i have these prob : when i click set path this come Warning: Error parsing C:/Users/AARMAN/Desktop/tfs/config.lua on line 142 in C:\xampp\htdocs\install.php on line 156.
and then when i want to check database connection this comes:
Warning: Error parsing C:/Users/AARMAN/Desktop/tfs/config.lua on line 142 in C:\xampp\htdocs\install.php on line 183
and then when i click on step 3 add tables and columns this comes :
Warning: Error parsing C:/Users/AARMAN/Desktop/tfs/config.lua on line 142 in C:\xampp\htdocs\install.php on line 183.*
please someone explain what iam doing wrong i have followed the tutorials but still , iam giving + rep for the one helping me
Click to expand...

parsing errors are fixed in this way: goto C:\xampp\htdocs\install.php open install.php with wordpad and goto line 156/183
and add @ before parse


Arrish said:
now i get this error
[Error - Items::loadFromOtb] Another (client) version of items.otb is required.

> ERROR: Unable to load items (OTB)!

what to do?:S
Click to expand...

did you put 2 tfs in eachother?? i mean did you copy one tfs in another tfs map??
 
Upvote 0 Downvote
Thx guys but now when i replace the item.otb i get these problems

Loading groups
[Warning - Groups::loadFromXml] Cannot load groups file.
Info: failed to load external entity "data/XML/groups.xml"
ERROR: Unable to load groups!
any idea how to fix? ++ rep
 
Upvote 0 Downvote
remove everything in groups.xml

and try this

Code: 
<?xml version="1.0" encoding="UTF-8"?>
<groups>
	<group id="1" name="Player"/>
	<group id="2" name="Tutor" flags="16809984" customFlags="3" access="1"/>
	<group id="3" name="Senior Tutor" flags="68736352256" customFlags="15" access="2" violationAccess="1" maxVips="200"/>
	<group id="4" name="Gamemaster" flags="3808558964575" customFlags="257215" access="3" violationAccess="3" depotLimit="3000" maxVips="300" outfit="75"/>
	<group id="5" name="Community Manager" flags="3840774348794" customFlags="781823" access="4" violationAccess="4" depotLimit="4000" maxVips="400" outfit="266"/>
	<group id="6" name="God" flags="3845069447162" customFlags="2097151" access="5" violationAccess="4" depotLimit="5000" maxVips="500" outfit="302"/>
</groups>
 
Upvote 0 Downvote
Back
Top