Problem with acc maker znote acc

[Severyn]

Hello, I have a problem. I've just configured znoteaccmaker with the database. When I create a character, I get this message. I don't know if it's the SQL database's fault that it's not creating the character or the spawn. Thanks in advance for any help.
the account has been created but the character cannot be created anymore, there is an error
problem with character creation

I am very grateful for your help.

"""Fatal error: Uncaught mysqli_sql_exception: Table 'global3.player_skills' doesn't exist in C:\xampp\htdocs\engine\database\connect.php:89 Stack trace: #0 C:\xampp\htdocs\engine\database\connect.php(89): mysqli_query(Object(mysqli), 'INSERT INTO `pl...') #1 C:\xampp\htdocs\engine\database\connect.php(79): voidQuery('INSERT INTO `pl...') #2 C:\xampp\htdocs\engine\function\users.php(1435): mysql_insert('INSERT INTO `pl...') #3 C:\xampp\htdocs\createcharacter.php(101): user_create_character(Array) #4 {main} thrown in C:\xampp\htdocs\engine\database\connect.php on line 89""""

I am very grateful for your help.

 

[celohere]

The message is literally telling you what the problem is. Your database does not have the player_skills table. Make sure you used the correct configuration for this part:

ZnoteAAC/config.php 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

 

[Severyn]

I checked the ZNOTE Acc. I have the same CFG as you showed, and the line is all fine. So the database would be at fault. Is there any way to fix this error? Add the line to the database. Or do I need to install a different engine because this one is damaged? I should add that it's Global with Mount Real Map with Market. Has anyone had a similar problem and could help me?



When I load only the schema.sql from another engine, it creates a character. When I add a database from another engine, such as Thunder or Global, I get the same error that it can't create the character. Does anyone have a similar problem and know how to solve it? Thanks in advance for your help.

 

[celohere]

What is the server version? I'm pretty sure that tfs 1x doesn't use the player_skills table. Anyway, if you really need this table, use this command:

CREATE TABLE IF NOT EXISTS `player_skills` ( 
   `player_id` INT(11) NOT NULL, 
   `skillid` INT(11) NOT NULL,
    `value` INT(10) UNSIGNED NOT NULL DEFAULT '10',
    `count` INT(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`player_id`, `skillid`),
    FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

[Severyn]

ok thanks and where should I paste it?

the engine version is 1.2 tfs and the accmaker is znoteaccmaster

 

[celohere]

Go to phpMyAdmin, select your database, access the sql tab, CTRL+V the sql command and execute the query.

 

[Severyn]

It works, thank you very much for your help. I can't find this on Google either. I'm sure it will be useful to someone because I've seen many problems with this. The issue is solved, thank you very much

 

[celohere]

It works, thank you very much for your help. I can't find this on Google either. I'm sure it will be useful to someone because I've seen many problems with this. The issue is solved, thank you very much

I'm glad it worked. Mark it as the best answer so everyone can see that this problem has been solved.