search

qbcore-framework / qb-core

FiveM RP Framework Core :muscle:
GNU General Public License v3.0
585 stars 964 forks source link

BUG: sql file doesnt create the playeritems table #35

Closed mooseh closed 3 years ago

mooseh commented 3 years ago

when loading into my server I get the following message `[qb-core] An error happens for query "SELECT * FROM `playeritems` WHERE `citizenid` = '****' : []": ER_NO_SUCH_TABLE: Table 'mooseh_fivem.playeritems' doesn't exist


I checked the SQL file and it doesn't create the playeritems table, making for a bad install from the get go.
mooseh commented 3 years ago

found a fix in KASH4's Repo

CREATE TABLE IF NOT EXISTS `playeritems` (
  `id` int(11) NOT NULL,
  `citizenid` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `amount` int(11) NOT NULL,
  `info` text DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `slot` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
GhzGarage commented 3 years ago

That table already exists...

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