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

Hello guys! Problems with Gesior AAC for TFS 1.3

jo31

New Member
Joined
May 24, 2010
Messages
70
Reaction score
1
Location
Sweden
Hello guys!
I have been getting Problems with Gesior AAC for TFS 1.3.
We recently installed Gesior AAC for TFS 1.3 and we got error when you visit the site it says "Error 500 http" and in the log file Apache it says "account.php Line 33"
 
PHP:
        $this->data = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $search_string)->fetch();

This is what it says in Line 33 in Account.php
 
Hey there i received the same error here any options to solved that?

I received that error in my log:

[29/May/2021:18:24:21 -0700] "GET / HTTP/1.1" 500 295 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36"
 
It should say something more. Like Fatal error, or something like that. There is long description of error. Copy it here.
Hi. I Have similar problem. When i go to highscores and then i try to load player from highscores (Exactly ?subtopic=characters) then appears this error msg:
Fatal error: Uncaught Error: Call to a member function fetch() on bool in /opt/lampp/htdocs/classes/account.php:31 Stack trace: #0 /opt/lampp/htdocs/classes/account.php(19): Account->load('122', 'id') #1 /opt/lampp/htdocs/classes/player.php(194): Account->__construct('122') #2 /opt/lampp/htdocs/classes/player.php(200): Player->loadAccount() #3 /opt/lampp/htdocs/pages/characters.php(40): Player->getAccount() #4 /opt/lampp/htdocs/system/load.page.php(7): include('/opt/lampp/htdo...') #5 /opt/lampp/htdocs/index.php(37): include_once('/opt/lampp/htdo...') #6 {main} thrown in /opt/lampp/htdocs/classes/account.php on line 31
My classes/account.php line 31 looks like this:
PHP:
$this->data = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $search_string)->fetch();

Do you know maybe how to solve it?
 
Hi. I Have similar problem. When i go to highscores and then i try to load player from highscores (Exactly ?subtopic=characters) then appears this error msg:

My classes/account.php line 31 looks like this:
PHP:
$this->data = $this->getDatabaseHandler()->query('SELECT ' . implode(', ', $fieldsArray) . ' FROM ' . $this->getDatabaseHandler()->tableName(self::$table) . ' WHERE ' . $search_string)->fetch();

Do you know maybe how to solve it?

Enable database debug, as stated here:


Then you will see more info about this error. Most probably missing some column.
 
Enable database debug, as stated here:


Then you will see more info about this error. Most probably missing some column.
all.png
Thank you. Amazing. I am going to fix it all.

Exactly this command fixed my problem. Like you said. Missing columns.
SQL:
ALTER TABLE accounts ADD COLUMN user_nickname VARCHAR(255) NOT NULL;
 
Last edited:
i got error in page , when got war declared guildxguild.
1697711744900.png

1697711816271.png

1697711846061.png
PHP:
<?php
defined('MYAAC') or die('Direct access not allowed!');

require __DIR__ . '/libs/OTS_GuildWars_List.php';
require __DIR__ . '/libs/OTS_Guild_List.php';
require __DIR__ . '/libs/OTS_GuildWar.php';

$hasGuildWarsNameColumn = $db->hasColumn('guild_wars', 'name1') && $db->hasColumn('guild_wars', 'name2');
$hasGuildWarsStartedColumn = $db->hasColumn('guild_wars', 'started');
$hasGuildWarsEndedColumn = $db->hasColumn('guild_wars', 'ended');
$hasGuildWarsFragLimitColumn = $db->hasColumn('guild_wars', 'frag_limit');
$hasGuildWarsDeclarationDateColumn = $db->hasColumn('guild_wars', 'declaration_date');
$hasGuildWarsBountyColumn = $db->hasColumn('guild_wars', 'bounty');

$extraQuery = '';
if ($hasGuildWarsNameColumn) {
    $extraQuery = '`guild_wars`.`name1`, `guild_wars`.`name2`, ';
}

if ($hasGuildWarsStartedColumn && $hasGuildWarsEndedColumn) {
    $extraQuery .= '`guild_wars`.`started`, `guild_wars`.`ended`, ';
}
elseif ($hasGuildWarsFragLimitColumn && $hasGuildWarsDeclarationDateColumn && $hasGuildWarsBountyColumn) {
    $extraQuery .= '`guild_wars`.`frag_limit`, `guild_wars`.`declaration_date`, `guild_wars`.`bounty`, ';
}

$orderBy = 'started';
if (!$hasGuildWarsStartedColumn && $hasGuildWarsDeclarationDateColumn) {
    $orderBy = 'declaration_date';
}

function displayGuildWars($warsDb, $warFrags, $guild = null, $isLeader = false) {
    global $twig, $hasGuildWarsNameColumn, $logged;

    $wars = [];
    foreach ($warsDb as $war) {
        $war['guildLogoPath1'] = getGuildLogoById($war['guild1']);
        $war['guildLogoPath2'] = getGuildLogoById($war['guild2']);

        if (!$hasGuildWarsNameColumn) {
            $war['name1'] = getGuildNameById($war['guild1']);
            $war['name2'] = getGuildNameById($war['guild2']);
        }

        $wars[] = $war;
    }

    $twig->display('guild-wars/templates/guild_wars.html.twig', [
        'logged' => $logged,
        'isLeader' => $isLeader,
        'guild' => $guild,
        'wars' => $wars,
        'warFrags' => $warFrags,
    ]);
}
 
Back
Top