Sql-database error cant connect

[52Emir]

ofc i opening xampp
pls help

[Tuncion]

You are missing the database table fivem.bans the fivem stands for your db name and bans is the missing table.

Execute this SQL:

CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `license` varchar(50) DEFAULT NULL,
  `discord` varchar(50) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `expire` int(11) DEFAULT NULL,
  `bannedby` varchar(255) NOT NULL DEFAULT 'LeBanhammer',
  PRIMARY KEY (`id`),
  KEY `license` (`license`),
  KEY `discord` (`discord`),
  KEY `ip` (`ip`)
) ENGINE=InnoDB AUTO_INCREMENT=1;

See https://github.com/qbcore-framework/qb-core/blob/main/qbcore.sql

[_4iY]

It tells you what the issue is Table 'fivem.bans' doesn't exist
Make sure that you import all of the SQL files that come with your framework, or simply disable the feature that checks for bans in QB-Core so it doesn’t try to access that table and use another way of banning people.

[52Emir]

thank you so much