QB Core Cant Find Ban Table?

The_Yoda · February 20, 2025, 11:43am

*Nothing added besides Qb core files at the moment. Launched loaded prior to adding. Started on zap hosting just testing around seeing what I can get to work I like the errors

Vidarr · February 20, 2025, 11:51am

Run this sql on your server to create missing tables.

github.com

qbcore-framework/qb-core/blob/main/qbcore.sql

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(50) NOT NULL,
  `cid` int(11) DEFAULT NULL,
  `license` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `money` text NOT NULL,
  `charinfo` text DEFAULT NULL,
  `job` text NOT NULL,
  `gang` text DEFAULT NULL,
  `position` text NOT NULL,
  `metadata` text NOT NULL,
  `inventory` longtext DEFAULT NULL,
  `last_updated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`citizenid`),
  KEY `id` (`id`),
  KEY `last_updated` (`last_updated`),
  KEY `license` (`license`)
) ENGINE=InnoDB AUTO_INCREMENT=1;

This file has been truncated. show original

The_Yoda · February 20, 2025, 12:05pm

hey thanks for the reply umm do u mean put this in the qb sql file on winscp? not sure where to find that location maybe i over looked it lol. not sure where to put it exactly i guess.

Vidarr · February 20, 2025, 12:28pm

I’m not familiar with zap hosting but there must be a page you can interact with database.

The_Yoda · February 20, 2025, 12:30pm

Ahh yes I do re call seeing that and I think I clicked on it just to see lol I’ll have to go back and look after work and I’ll let you know thanks again!