Help, setting up server

[jjoohansson]

Hey, Im trying to fix my own full custom 12.86 server. I kinda need help..

Im following this guide: [Basic][Windows] Canary + Uniform Server + ZnoteAAC - OpenTibiaBR (https://majestyotbr.gitbook.io/opentibiabr/projects/canary/infrastructure/basic-windows-canary-+-uniform-server-+-znoteaac)

But idk where to put login.php file and i get a error message on my homepage saying: Configuration error! Cannot save cache to memory, but it is configured to do so. You need to enable PHP extension APCu to enable memory cache. Install it or set $config['cache']['memory'] to false! Ubuntu install: sudo apt install php-apcu


Can anyone help me?

 

[ralke]

Go to config.php and change 'memory' to false

        // Store cache in memory/RAM? Requires PHP extension APCu
        'memory' => true

 

[celohere]

Just put the login.php on znote www folder.

 

[jjoohansson]

Go to config.php and change 'memory' to false

        // Store cache in memory/RAM? Requires PHP extension APCu
        'memory' => true

Thank you, this helped out. Now i have a new problem:

string(403) "SELECT p.name, p.vocation, p.skill_club AS value, za.flag , p.lookbody AS body, p.lookfeet AS feet, p.lookhead AS head, p.looklegs AS legs, p.looktype AS type, p.lookaddons AS addons FROM players AS p INNER JOIN znote_accounts AS za ON p.account_id=za.account_id WHERE p.group_id < 2 ORDER BY p.skill_club DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'canary.znote_accounts' doesn't exist

What do i do?

Post automatically merged: Jul 11, 2022

Just put the login.php on znote www folder.

I followed the step and it worked, thank you so much.

I have a new error

string(403) "SELECT p.name, p.vocation, p.skill_club AS value, za.flag , p.lookbody AS body, p.lookfeet AS feet, p.lookhead AS head, p.looklegs AS legs, p.looktype AS type, p.lookaddons AS addons FROM players AS p INNER JOIN znote_accounts AS za ON p.account_id=za.account_id WHERE p.group_id < 2 ORDER BY p.skill_club DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'canary.znote_accounts' doesn't exist

Post automatically merged: Jul 11, 2022

Thank you, this helped out. Now i have a new problem:

string(403) "SELECT p.name, p.vocation, p.skill_club AS value, za.flag , p.lookbody AS body, p.lookfeet AS feet, p.lookhead AS head, p.looklegs AS legs, p.looktype AS type, p.lookaddons AS addons FROM players AS p INNER JOIN znote_accounts AS za ON p.account_id=za.account_id WHERE p.group_id < 2 ORDER BY p.skill_club DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'canary.znote_accounts' doesn't exist

What do i do?

Post automatically merged: Jul 11, 2022

I followed the step and it worked, thank you so much.

I have a new error

string(403) "SELECT p.name, p.vocation, p.skill_club AS value, za.flag , p.lookbody AS body, p.lookfeet AS feet, p.lookhead AS head, p.looklegs AS legs, p.looktype AS type, p.lookaddons AS addons FROM players AS p INNER JOIN znote_accounts AS za ON p.account_id=za.account_id WHERE p.group_id < 2 ORDER BY p.skill_club DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'canary.znote_accounts' doesn't exist

I dont understand, where should i search? In what map?

 

[celohere]

Thank you, this helped out. Now i have a new problem:

string(403) "SELECT p.name, p.vocation, p.skill_club AS value, za.flag , p.lookbody AS body, p.lookfeet AS feet, p.lookhead AS head, p.looklegs AS legs, p.looktype AS type, p.lookaddons AS addons FROM players AS p INNER JOIN znote_accounts AS za ON p.account_id=za.account_id WHERE p.group_id < 2 ORDER BY p.skill_club DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'canary.znote_accounts' doesn't exist

What do i do?

Post automatically merged: Jul 11, 2022

I followed the step and it worked, thank you so much.

I have a new error

string(403) "SELECT p.name, p.vocation, p.skill_club AS value, za.flag , p.lookbody AS body, p.lookfeet AS feet, p.lookhead AS head, p.looklegs AS legs, p.looktype AS type, p.lookaddons AS addons FROM players AS p INNER JOIN znote_accounts AS za ON p.account_id=za.account_id WHERE p.group_id < 2 ORDER BY p.skill_club DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'canary.znote_accounts' doesn't exist

Post automatically merged: Jul 11, 2022

I dont understand, where should i search? In what map?

Did you import the znote schema.sql?

 

[ralke]

Thank you, this helped out. Now i have a new problem:

string(403) "SELECT p.name, p.vocation, p.skill_club AS value, za.flag , p.lookbody AS body, p.lookfeet AS feet, p.lookhead AS head, p.looklegs AS legs, p.looktype AS type, p.lookaddons AS addons FROM players AS p INNER JOIN znote_accounts AS za ON p.account_id=za.account_id WHERE p.group_id < 2 ORDER BY p.skill_club DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'canary.znote_accounts' doesn't exist

What do i do?

Post automatically merged: Jul 11, 2022

I followed the step and it worked, thank you so much.

I have a new error

string(403) "SELECT p.name, p.vocation, p.skill_club AS value, za.flag , p.lookbody AS body, p.lookfeet AS feet, p.lookhead AS head, p.looklegs AS legs, p.looktype AS type, p.lookaddons AS addons FROM players AS p INNER JOIN znote_accounts AS za ON p.account_id=za.account_id WHERE p.group_id < 2 ORDER BY p.skill_club DESC LIMIT 0, 100;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Table 'canary.znote_accounts' doesn't exist

Post automatically merged: Jul 11, 2022

I dont understand, where should i search? In what map?

Like celo said, you're missing schemas

ZnoteAAC/engine/database/znote_schema.sql at master · Znote/ZnoteAAC

Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. - Znote/ZnoteAAC

github.com

Run them as SQL query