qb-policejob | QBCore | Page 1

valid bay Feb 22, 2025, 7:01 PM

#

Script Name:

Error : Error: qb-policejob was unable to execute a query!
19:46:22 [ script:oxmysql] Query: DELETE FROM stashitems WHERE stash = 'policetrash'
19:46:22 [ script:oxmysql] []
19:46:22 [ script:oxmysql] Table 's62353_qbcore.stashitems' doesn't exist

Whats the issue your experiencing: script with policejob does not work

What was the last thing that changed: things in the config

What measures and steps have you taken to troubleshoot this issue: we tried to find it in the config and fix it but it didn't work

Video/screenshot: screenshot i send

slate elbow Feb 22, 2025, 7:13 PM

#

your missing table from database

valid bay Feb 22, 2025, 7:14 PM

#

how should I solve it please?

slate elbow Feb 22, 2025, 7:20 PM

#

CREATE TABLE IF NOT EXISTS `stashitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stash` varchar(255) NOT NULL DEFAULT '[]',
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`stash`),
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1;

#

run this thru heidisql

#

📎 stashitems.sql

#

heres an executable SQL that will help

#

execute this and then test and you should be good

valid bay Feb 22, 2025, 7:30 PM

#

this is what it says and I don't know what to do with it

#

https://cdn.discordapp.com/attachments/1338971881688141865/1342941379889987594/Snimek_obrazovky_2025-02-22_202928.png?ex=67bb771f&is=67ba259f&hm=6d8510c5b53d82ce5d546c87658ebb45ac8e3635bf6ee91080fdaea2d209960f&

slate elbow Feb 22, 2025, 7:33 PM

#

either do i

#

i cant read that im english 🙂

#

whys there an added line at the top

#

that shouldnt be there

valid bay Feb 22, 2025, 7:34 PM

#

slate elbow i cant read that im english 🙂

oh sorryI didn't realize that

#

Error
Static Analysis:

1 errors were found during the analysis.

A new expression was found without a separator from the previous expression. (near "CREATE" at position 29)
SQL Query: Copy Documentation

SELECT * FROM stashitems CREATE TABLE IF NOT EXISTS stashitems ( id int(11) NOT NULL AUTO_INCREMENT, stash varchar(255) NOT NULL DEFAULT '[]', items longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (stash), KEY id (id) ) ENGINE=InnoDB AUTO_INCREMENT=1;

MySQL reports: Documentation

#1064 - Your syntax is a bit strange near 'CREATE TABLE IF NOT EXISTS stashitems (
id int(11) NOT NULL AUTO_INCR...' on line 2

slate elbow Feb 22, 2025, 7:35 PM

#

remove the top line as that wasnt there

#

SELECT FROM * stashes

valid bay Feb 22, 2025, 7:35 PM

#

ok i'll try it

valid bay Feb 22, 2025, 7:53 PM

#

the table is created, then I wrote in it what you sent. But there is still an error in the console

valid bay Feb 22, 2025, 8:24 PM

#

https://cdn.discordapp.com/attachments/1338971881688141865/1342955198791942206/image.png?ex=67bb83fe&is=67ba327e&hm=bd55942ce2c8dc045de8b3d0cc554597c367c3dcdf04c133f2e8ce1ddf59e1a5&

slate elbow Feb 22, 2025, 9:00 PM

#

huh?

valid bay Feb 22, 2025, 9:01 PM

#

it shows that it is misspelled

slate elbow Feb 22, 2025, 9:04 PM

#

cos that isnt what i sent u

#

u keep changing it for some reason

#

CREATE TABLE IF NOT EXISTS `stashitems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `stash` varchar(255) NOT NULL DEFAULT '[]',
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`stash`),
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1;

jolly ocean Feb 22, 2025, 9:09 PM

#

Just use what he sent you.
It's not hard to copy and paste the sql code.

#

@elder helm

elder helm Feb 22, 2025, 9:16 PM

#

#

i do that and there is still an error in the console

slate elbow Feb 22, 2025, 9:40 PM

#

Show me the error ur getting

elder helm Feb 22, 2025, 9:42 PM

#

slate elbow Feb 22, 2025, 9:45 PM

#

lol

#

just screenshot it and paste here

elder helm Feb 22, 2025, 9:46 PM

#

here error and sql i have table

slate elbow Feb 22, 2025, 9:49 PM

#

cos ur databse looks fucked if im honest

elder helm Feb 22, 2025, 9:50 PM

#

why

#

so when I added it it should work right?

slate elbow Feb 22, 2025, 9:52 PM

#

not looking at your database

#

use heidiSQL

#

its much easier to use

elder helm Feb 22, 2025, 9:56 PM

#

its done bro thanks

slate elbow Feb 22, 2025, 9:56 PM

#

what did u do?

elder helm Feb 22, 2025, 9:57 PM

#

use app heidisql and I imported what you sent me

slate elbow Feb 22, 2025, 9:59 PM

#

happy days

#

glad u sorted it

elder helm Feb 22, 2025, 10:00 PM

#

thanks you very much bro

slate elbow Feb 22, 2025, 10:00 PM

#

no worries

elder helm Feb 23, 2025, 11:18 AM

#

Hi can i ask?

slate elbow Feb 23, 2025, 11:21 AM

#

?

elder helm Feb 23, 2025, 11:32 AM

#

i create a police boss menu

#

a restart server

#

and now when I select a character, I get a black screen and it doesn't want to load into the game.

#

slate elbow Feb 23, 2025, 11:36 AM

#

by looks of the error above that looks like u have error in your jobs.lua

elder helm Feb 23, 2025, 11:45 AM

#

and how do I solve it?

slate elbow Feb 23, 2025, 11:48 AM

#

why do u have so many closing brackets for lol

#

try adding a } at the very bottom

#

remove the closing bracket from line 171

elder helm Feb 23, 2025, 11:50 AM

#

okey i remove closing bracket from line 171

slate elbow Feb 23, 2025, 11:50 AM

#

and add it at very bottom

#

line 186

elder helm Feb 23, 2025, 11:51 AM

#

and should I leave the brackets on 184 183?

#

#

I still get a black screen after I select a character

elder helm Feb 23, 2025, 12:11 PM

#

I tried deleting the lspd shelf and that's probably not the whole point, when I deleted it I still have a blackscreen

jolly ocean Feb 23, 2025, 12:12 PM

#

elder helm I tried deleting the lspd shelf and that's probably not the whole point, when I ...

You need to learn to take decent screenshots, they are so hard to read

elder helm Feb 23, 2025, 12:13 PM

#

ERROR: [script:qb-multichara] > CheckPlayerData (@qb-core/server/player.lua:105)
13:10:52 [script:qb-multichara] > ref (@qb-core/server/player.lua:21)
13:10:52 [script:qb-multichara] > rawExecute (@oxmysql/dist/build.js:27186)
13:10:52 [script:qb-multichara] > processTicksAndRejections (node:internal/process/task_queues:96)
13:10:52 [script:qb-multichara]
13:10:52 [script:qb-multichara] > handler (@qb-multicharacter/server/main.lua:90)
13:10:52 [script:qb-multichara] > rawExecute (@oxmysql/dist/build.js:27186)
13:10:52 [script:qb-multichara] > processTicksAndRejections (node:internal/process/task_queues:96)

jolly ocean Feb 23, 2025, 12:13 PM

#

elder helm ERROR: [script:qb-multichara] > CheckPlayerData (@qb-core/server/player.lua:105)...

That's not a screenshot

remote hinge Feb 23, 2025, 12:14 PM

#

What is qb-core/server/player.lua:105

#

Go to the line your error references.

jolly ocean Feb 23, 2025, 12:15 PM

#

elder helm

Going by this and his bad screenshot I'd say he's still got an error with qbcore/shared/jobs.lua
@remote hinge

elder helm Feb 23, 2025, 12:15 PM

#

remote hinge Feb 23, 2025, 12:16 PM

#

Ok, so now think: why would that line throw an error? What is it referencing?

elder helm Feb 23, 2025, 12:17 PM

#

that something is wrong with jobs?

remote hinge Feb 23, 2025, 12:17 PM

#

Yes

elder helm Feb 23, 2025, 12:18 PM

#

okey and now?

remote hinge Feb 23, 2025, 12:18 PM

#

Revert your jobs back to the default - when you add a new one, use arrays properly. You don't seem to understanding the brackets.

elder helm Feb 23, 2025, 1:05 PM

#

thanks bro

#

So how do I properly create a boss menu in jobs?

remote hinge Feb 23, 2025, 1:09 PM

#

https://github.com/qbcore-framework/qb-management/blob/3375d488002e098c0486ed203c5b955d45065bee/config.lua#L6-L19

elder helm Feb 23, 2025, 1:09 PM

#

i have this setting

#

but i not see boss menu

remote hinge Feb 23, 2025, 1:14 PM

#

You need to expain things better. "I have this setting" doesn't mean anything to me.

#

What have you done, what are you expecting to work, what doesn't work.

elder helm Feb 23, 2025, 1:15 PM

#

Well, I have what you sent me set up, but I still don't see the boss menu in the game.

remote hinge Feb 23, 2025, 1:16 PM

#

Is your player set as a rank of that job that can access the boss menu?

elder helm Feb 23, 2025, 1:16 PM

#

How do I set it up?

remote hinge Feb 23, 2025, 1:17 PM

#

For example, set yourself as having the police job with a rank that can access the menu. You can see that in your shared jobs.

elder helm Feb 23, 2025, 1:17 PM

#

yes i see

#

okey i do that thanks you bro

valid bay Feb 23, 2025, 3:50 PM

#

hello can i ask for help I wanted to make cash as an item, I followed everything the video said, but this error popped up at me and I don't know what to do with it.

#

#qb-policejob