Access denied for user to database 'es_extended

[anonymonstr]

hey guys, so ive added everything i need es_extended and made sure it runs, it does, but now i am trying to add esx_extraitems and i keep getting this message

USE es_extended;INSERT INTO items (name, label, weight, rare, can_remove) VALUES
(‘darknet’, ‘Dark Net’, 1, 0, 1),
(‘binoculars’, ‘Binoculars’, 1, 0, 1),
(‘boxbig’, ‘Ammo Box Big’, 1, 0, 1),
(‘boxsmall’, ‘Ammo Box Small’, 1, 0, 1),
(‘bulletproof’, ‘Bullet-Proof Vest’, 1, 0, 1),
(‘drill’, ‘Drill’, 1, 0, 1),
(‘firstaidkit’, ‘First Aid Kit’, 1, 0, 1),
(‘lockpick’, ‘Lock Pick’, 1, 0, 1),
(‘oxygenmask’, ‘Oxygen Mask’, 1, 0, 1),
(‘repairkit’, ‘Repair Kit’, 1, 0, 1),
(‘tirekit’, ‘Tire Kit’, 1, 0, 1),
(‘vehgps’, ‘Vehicle GPS’, 1, 0, 1)
;INSERT INTO shops (store, item, price) VALUES
(‘RobsLiquor’, ‘darknet’, 25),
(‘RobsLiquor’, ‘binoculars’, 10),
(‘RobsLiquor’, ‘boxbig’, 60),
(‘RobsLiquor’, ‘boxsmall’, 25),
(‘RobsLiquor’, ‘bulletproof’, 300),
(‘RobsLiquor’, ‘drill’, 180),
(‘RobsLiquor’, ‘firstaidkit’, 80),
(‘RobsLiquor’, ‘lockpick’, 20),
(‘RobsLiquor’, ‘oxygenmask’, 400),
(‘RobsLiquor’, ‘repairkit’, 150),
(‘RobsLiquor’, ‘tirekit’, 25),
(‘RobsLiquor’, ‘vehgps’, 25)
;;
/* SQL Error (1044): Access denied for user ‘zap619854-1’@’%’ to database ‘es_extended’ /
/ Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 0 of 3 queries: 0.000 sec. */

please help

[rLx1]

hello friend,

if I remember correctly the database name on zap hosting is something like zap232323232 and not es_extended.

So what you need to do to edit the first line of the import to USE YOURDATABASENAMEHERE ;

Regards

[anonymonstr]

Thanks for the reply. So where it says USER. I replay es_extended with the file name? Or my full zap code?

[rLx1]

hello.
where it says use es_extended you replace es_exnteded with your zap hosting database name

[anonymonstr]

okay that worked… now in stuck with this … -_- lol any idea please?

[rLx1]

Hello sir,

You are getting this error because using an older version of es_extended.
To fix it just change weight to limit and re-insert the file.

Thanks