ZNOTE ACC ERROR

[Leumon]

i got that error when i open my website

Tfs 0.4 dev
znote acc

 

[Core_]

xd table 'players_online' doesn't exist

 

[HalfAway]

Make sure you've written TFS_03 at server version in config.php.

 

[Leumon]

i changed tfs in config to _0.3 problem fixed but i get that error when i click on home
Print: - Array
(
[0] => [0.023] SELECT `name`, `level`, `experience` FROM `players` WHERE `group_id` < 2 ORDER BY `experience` DESC LIMIT 5;
[1] => [0.025] SELECT COUNT(`id`) AS `count` from `players` WHERE `online` = 1;
[2] => [0.025] SELECT COUNT(`id`) AS `id` from `accounts`;
[3] => [0.026] SELECT `n`.`id`, `n`.`title`, `n`.`text`, `n`.`date`, `p`.`name` FROM `znote_news` AS `n` INNER JOIN `players` AS `p` ON `n`.`pid` = `p`.`id` ORDER BY `n`.`id` DESC;
)





and this error when i click on shop
string(216) "SELECT `id`, `itemtype` AS `item_id`, `amount`, `price`, `created`, `anonymous`, (SELECT `name` FROM `players` WHERE `id` = `player_id`) AS `player_name` FROM `market_offers` WHERE `sale` = 1 ORDER BY `created` DESC;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'otserv.market_offers' doesn't exist


Print: - Array
(
[0] => [0.024] SELECT COUNT(`id`) AS `count` from `players` WHERE `online` = 1;
[1] => [0.025] SELECT COUNT(`id`) AS `id` from `accounts`;
)
@HalfAway

 

[HalfAway]

The market_offers is the only table missing in your database, you need to import it.

The others isn't errors just showing what queries the AAC makes.
Post your footer.php with [ code] tags.

 

[Leumon]

The market_offers is the only table missing in your database, you need to import it.

The others isn't errors just showing what queries the AAC makes.
Post your footer.php with [ code] tags.

here you are
@HalfAway

<footer>
    &copy; Znote AAC.
    <?php
    $time = microtime();
    $time = explode(' ', $time);
    $time = $time[1] + $time[0];
    $finish = $time;
    $total_time = round(($finish - $start), 4);
    echo 'Server date and clock is: '. getClock(false, true) .' Page generated in '. $total_time .' seconds. ';
    ?>
</footer>