Solved Guilds.php Gesior Acc error

[Gabriel Tibiano]

I'm getting this error, could anyone fix this code for me?
I'm using this guilds.php
guilds.php - gesior-aac - A new Gesior-AAC - Google Project Hosting

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'join_date' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:1821 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(1821): PDO->query('SELECT `join_da...') #1 C:\xampp\htdocs\guilds.php(249): OTS_Player->getCustomField('join_date') #2 C:\xampp\htdocs\index.php(250): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1821

 

[Cronox]

change your folder
POT
change for this folder
pot rar

 

[Gabriel Tibiano]

everything? o;
still sending error..
it's an database missing field, i guess..

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'join_date' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:1811 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(1811): PDO->query('SELECT `join_da...') #1 C:\xampp\htdocs\guilds.php(249): OTS_Player->getCustomField('join_date') #2 C:\xampp\htdocs\index.php(250): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1811

 

[Cronox]

Execute this SQL Query:

ALTER TABLE `guilds` ADD COLUMN `join_date` INT( 11 ) NOT NULL DEFAULT '0';

 

[Gabriel Tibiano]

this error now..
o:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'join_date' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:1821 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(1821): PDO->query('SELECT `join_da...') #1 C:\xampp\htdocs\guilds.php(249): OTS_Player->getCustomField('join_date') #2 C:\xampp\htdocs\index.php(250): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1821

 

[Gabriel Tibiano]

Bring
Up
My
Post

 

[Krashe]

Execute this SQL Query:

ALTER TABLE `guilds` ADD COLUMN `join_date` INT( 11 ) NOT NULL DEFAULT '0';

Do what this guy said and it will work

 

[Gabriel Tibiano]

did u read my post?
http://otland.net/f16/guilds-php-gesior-acc-error-139002/#post1337794

 

[Gabriel Tibiano]

Bump

 

[Gabriel Tibiano]

Nobody knew help me
so i tried to manage it and i solvedd

				$main_content .= '</TABLE></TD><td>'.date("M d Y", $player->getCustomField("join_date")).'</td></TR>';

to

				$main_content .= '</TABLE></TD><td>'.date("M d Y", $guild->getCustomField("join_date")).'</td></TR>';

$player -> $guild​

wrong fields in DB​

using this code..

ALTER TABLE `guilds` ADD COLUMN `join_date` INT( 11 ) NOT NULL DEFAULT '0';

 

[Cykotitan]

Why would guilds have a join_date and not the players

 

[Gabriel Tibiano]

yes, I thought about it, but keep according to the tag that the guy said

 

[calle145]

Change to modern acc?