Znote 1.5 Deathlist & SQL errors

[yasminismyworld]

Im using The Forgotten Server - Version 0.3 (Crying Damson).

And znote aac 1.5. my deathlist/killers list doesnt work:

Config.php

// Available options: TFS_02, TFS_03
    // TFS 0.2 = TFS_02
    // TFS 0.3 = TFS_03 (If ur using 0.3.6, set $config['salt'] to false)!
    // TFS 0.4 = TFS_03
    // TFS 1.0 = TFS_10 (Under developement)
    $config['TFSVersion'] = 'TFS_03';

Error

string(63) "SELECT * FROM `player_deaths` ORDER BY `date` DESC LIMIT 0, 30;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'date' in 'order clause'

deaths.php

<?php require_once 'engine/init.php'; include 'layout/overall/header.php';
$cache = new Cache('engine/cache/deaths');
if ($cache->hasExpired()) {
  
    if ($config['TFSVersion'] == 'TFS_02' || $config['TFSVersion'] == 'TFS_10') {
        $deaths = fetchLatestDeaths();
    } else if ($config['TFSVersion'] == 'TFS_03') {
        $deaths = fetchLatestDeaths_03(30);
    }
    $cache->setContent($deaths);
    $cache->save();
} else {
    $deaths = $cache->load();
}
if ($deaths) {
?>
<h1>Latest Deaths</h1>
<table id="deathsTable" class="table table-striped">
    <tr class="yellow">
        <th>Victim</th>
        <th>Time</th>
        <th>Killer</th>
    </tr>
    <?php foreach ($deaths as $death) {
        echo '<tr>';
        echo "<td>At level ". $death['level'] .": <a href='characterprofile.php?name=". $death['victim'] ."'>". $death['victim'] ."</a></td>";
        echo "<td>". getClock($death['time'], true) ."</td>";
        if ($death['is_player'] == 1) echo "<td>Player: <a href='characterprofile.php?name=". $death['killed_by'] ."'>". $death['killed_by'] ."</a></td>";
        else if ($death['is_player'] == 0) {
            if ($config['TFSVersion'] == 'TFS_03') echo "<td>Monster: ". ucfirst(str_replace("a ", "", $death['killed_by'])) ."</td>";
            else echo "<td>Monster: ". ucfirst($death['killed_by']) ."</td>";
        }
        else echo "<td>". $death['killed_by'] ."</td>";
        echo '</tr>';
    } ?>
</table>
<?php
} else echo 'No deaths exist.';
include 'layout/overall/footer.php'; ?>

(I also get Error creating accounts: this one dosnt bother me since i have account manager in game)

string(52) "SELECT `id` FROM `accounts` WHERE `name`='23423423';"
(query - SQL error)
Type: select_single (select single row from database)

Unknown column 'name' in 'where clause'

Its me or something is wrong in my database? i imported forgottenserver.sql the one that came with the server pack.

Thanks! hopefully someone helps me. i spent the last 3days trying to figure it out+surfing on the forums