HELP Please!

FiveM Server Development QBCore
, , , , ,
1

i tried to enter the server but it says : [qbcore] - unable to find the bans table in the database. please ensure you have imported the sql file correctly.

I tried everything that i saw here and on youtube but nothing seems to help.

Can anyone help me please?

2

Make sure you have bans table inside your database
image

3

i do have
image

4

Check if the mysql is started or not . Then in servercfg the database name if that’s correct

5

image
is this supose to be like this?

6

you need look at server console

7

already did that… and now it appears this:

image
image918×106 18.8 KB

8

check if the xampp is like that or not

image
image674×471 25.5 KB

9

it doesn’t work. And i use MariaDB, HeidiSQL, DBeaver and MySQL Workbench. Sooo, i don’t know what’s wrong.

10

im guessing a connection issue.

11

What can I do? :sweat_smile:

12

Ok check your database inside Heidi sql
If you need more info contact me via discord

1 Like
13

which one are you on your discord?

14

JustDark

1 Like
15

I sent you a message in DM

1 Like
16

Hi mscrf, since _Hasib mentioned it might be a connection issue, there are a few common things that usually cause this specific error in QBCore:

  1. Check your MySQL Password: In your server.cfg, your connection string is: mysql://root:root@localhost/QB8Core_9B93D5... This means your password is set to root. However, if you are using a default XAMPP installation, the default password for the root user is usually empty (blank). Try changing your connection string to this (notice the colon : with nothing after it): set mysql_connection_string "mysql://root:@localhost/QB8Core_9B93D5?charset=utf8mb4" (If you manually set your MySQL password to ‘root’ in XAMPP/PhpMyAdmin, then keep it as is. If you didn’t set a password, use the empty one above.)
  2. Verify Database Name: Open HeidiSQL and look at the left sidebar. Make sure the database is named exactly QB8Core_9B93D5. If the database is named something else (like just qbcore or fivem), update the name in your server.cfg connection string to match it.
  3. Table Location: Inside HeidiSQL, click on the QB8Core_9B93D5 database to expand it. Do you see the bans table inside that specific database? Sometimes the table is accidentally imported into the test or mysql system database instead of the server’s main database.

Try checking these three points and restart your server. This should fix the “unable to find the bans table” error.

1 Like
17

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.