AAC Znote Acc 1.6 for TFS 1.2 - Table 'znote.players' doesn't exist

[Xedoxo]

Hi,

Next my problem are Table 'znote.players' doesn't exist. Other ideal inject to database.

1. Uncaught mysqli_sql_exception: Table 'znote.players' doesn't exist

Log:

2024/06/13 14:56:02 [error] 14301#14301: *61 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught mysqli_sql_exception: Table 'znote.players' doesn't exist in /home/app/znote/engine/database/connect.php:67

Stack trace:

#0 /home/app/znote/engine/database/connect.php(67): mysqli_query()

#1 /home/app/znote/engine/function/users.php(146): mysql_select_multi()

#2 /home/app/znote/layout/sub/index.php(34): fetchAllNews()

#3 /home/app/znote/index.php(11): include('...')

#4 {main}

  thrown in /home/app/znote/engine/database/connect.php on line 67" while reading response header from upstream, client: 220.146.123.229, server: _, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/run/php/php8.3-fpm-znote.sock:", host: "194.182.91.155"

 

[Gesior.pl]

Next my problem are Table 'znote.players' doesn't exist. Other ideal inject to database.

Acc. maker expects OTS database to be installed.
Before you install any acc. maker, install OTS and it's database.
If OTS starts (no error about database on ./tfs start), you can start acc. maker installation.

If it's official 1.2, you can install OTS database using (MariaDB/mysql server must be already installed in linux):

mysql
CREATE DATABASE tfs;
exit;
wget -q https://github.com/otland/forgottenserver/blob/1.2/schema.sql
mysql tfs < schema.sql

and in Znote configure it to use database named tfs.
If it's some custom OTS ignore wget -q https://github.com/otland/forgottenserver/blob/1.2/schema.sql and use mysql tfs < xx.sql with your OTS database schema file.