Nabend zusammen, ich wollte mich hier mal erkundigen worin genau meine Problematik liegt. Die Log hänge ich hier an.
Danke für Hilfe jeder Art.
Problem ist:
Shops gehen nicht, jobs werden nicht angezeigt.
Sofern ich die Datenbank einfüge:
kommt ab " skills " darf kein vorgabewert ( default ) haben.
Gefühlt fügt er mir die halbe Datenbank nicht ein.
Hier einfach mal die Log.
Code
[ script:EasyAdmin] YEEEET 1
[ script:EasyAdmin] [ script:EasyAdmin] EasyAdmin: webadmin-lua is not installed on this Server, webadmin features unavailable
[ script:gcphone] [m3:uber] - Started!
[ script:monitor] [txAdminClient] Threads and commands set up. All Ready.
[script:disc-inventor] Whitelisted by 5MSERVERS.COM IP: 89.163.227.152
[script:disc-inventor] SCRIPT ERROR: @disc-inventoryhud/server/drop.lua:13: table index is nil
[script:plategenerato] Unique Plates Seeded - 1621352146
[script:esx-fivem-bus] Whitelisted by 5MSERVERS.COM IP: 89.163.227.152
[ script:LegacyFuel] Whitelisted by 5MSERVERS.COM IP: 89.163.227.152
[ script:fivem_Purge] fivem_Purge: Started
(node:22410) [DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead.
(node:22410) [DEP0095] DeprecationWarning: timers.enroll() is deprecated. Please use setTimeout instead.
(node:22410) [DEP0126] DeprecationWarning: timers.active() is deprecated. Please use timeout.refresh() instead.
(node:22410) [DEP0126] DeprecationWarning: timers.active() is deprecated. Please use timeout.refresh() instead.
[ citizen-server-impl] server thread hitch warning: timer interval of 250 milliseconds
[ script:mysql-async] [ERROR] ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
(node:22410) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.
(node:22410) [DEP0096] DeprecationWarning: timers.unenroll() is deprecated. Please use clearTimeout instead.
[ script:mysql-async] [ERROR] [MySQL] [police] An error happens on MySQL for query "UPDATE owned_vehicles SET `stored`=true WHERE `stored`=false AND `job`='police'": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [furni] An error happens on MySQL for query "SELECT * FROM INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='database2' AND TABLE_NAME='allhousing'": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [Inventory-Sorter] An error happens on MySQL for query "SELECT * FROM items": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [datastore] An error happens on MySQL for query "SELECT * FROM datastore": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [accounts] An error happens on MySQL for query "SELECT * FROM addon_account": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query "SELECT * FROM vehicle_categories": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [tp-nitro] An error happens on MySQL for query "SELECT * FROM nitro_vehicles": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [fivem_dispach] An error happens on MySQL for query "SELECT identifier,firstname,lastname FROM users WHERE 1": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [admin] An error happens on MySQL for query "CREATE TABLE IF NOT EXISTS `esx_manager_warns` (
[ script:mysql-async] `id` INT(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
[ script:mysql-async] `warned` text NOT NULL,
[ script:mysql-async] `reason` text NOT NULL,
[ script:mysql-async] `date` text
[ script:mysql-async] );
[ script:mysql-async] CREATE TABLE IF NOT EXISTS `esx_manager_bans` (
[ script:mysql-async] `identifier` VARCHAR(60) PRIMARY KEY NOT NULL,
[ script:mysql-async] `name` TEXT NOT NULL,
[ script:mysql-async] `reason` LONGTEXT NOT NULL
[ script:mysql-async] )": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [5m_vehicleshop] An error happens on MySQL for query "SELECT * FROM jobs": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [vehicleshop] An error happens on MySQL for query "SELECT * FROM vehicle_categories": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [boatshop] An error happens on MySQL for query "SELECT * FROM boat_categories": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [tprp_base] An error happens on MySQL for query "SELECT * FROM items": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [tprp_base] An error happens on MySQL for query "SELECT * FROM jobs": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [disc-inventoryhud] An error happens on MySQL for query "DELETE FROM disc_inventory WHERE type = "drop"": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [5m-skills] An error happens on MySQL for query "CREATE TABLE IF NOT EXISTS `5m_skills` (
[ script:mysql-async] identifier VARCHAR(100) PRIMARY KEY NOT NULL,
[ script:mysql-async] skills LONGTEXT NULL DEFAULT '[]'
[ script:mysql-async] )": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [crafting] An error happens on MySQL for query "SELECT * FROM craftingtables": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [fivemserver_hacker] An error happens on MySQL for query "SELECT identifier, job FROM users": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [society] An error happens on MySQL for query "SELECT * FROM jobs": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [allhousing] An error happens on MySQL for query "SELECT * FROM information_schema.COLUMNS": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [chames_motel] An error happens on MySQL for query " CREATE TABLE IF NOT EXISTS `world_storages` (
[ script:mysql-async] `storageId` varchar(255) NOT NULL,
[ script:mysql-async] `storageData` longtext NOT NULL,
[ script:mysql-async] PRIMARY KEY (`storageId`)
[ script:mysql-async] ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[ script:mysql-async] ": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [chames_motel] An error happens on MySQL for query " CREATE TABLE IF NOT EXISTS `james_motels` (
[ script:mysql-async] `uuid` varchar(255) NOT NULL DEFAULT '',
[ script:mysql-async] `owner` varchar(50) NOT NULL,
[ script:mysql-async] `name` varchar(50) NOT NULL,
[ script:mysql-async] `lastRent` bigint(20) NOT NULL DEFAULT '0',
[ script:mysql-async] PRIMARY KEY (`uuid`)
[ script:mysql-async] ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[ script:mysql-async] ": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [esx_adminmode-1.2] An error happens on MySQL for query "SELECT license,name FROM adminmode_identifiers": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [disc-inventoryhud] An error happens on MySQL for query "SELECT * FROM disc_inventory_itemdata": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [disc-inventoryhud] An error happens on MySQL for query "SELECT * FROM items WHERE LCASE(name) LIKE '%weapon_%'": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [chames_keys] An error happens on MySQL for query " CREATE TABLE IF NOT EXISTS `world_keys` (
[ script:mysql-async] `uuid` bigint(20) NOT NULL DEFAULT '0',
[ script:mysql-async] `owner` varchar(50) NOT NULL,
[ script:mysql-async] `keyData` longtext NOT NULL,
[ script:mysql-async] PRIMARY KEY (`uuid`)
[ script:mysql-async] ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[ script:mysql-async] ": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:furni] furni does not have required SQL table.
[script:fivem_dispach] SCRIPT ERROR: @fivem_dispach/server/main.lua:25: bad argument #1 to 'for iterator' (table expected, got nil)
[script:fivem_dispach] > ref (@fivem_dispach/server/main.lua:25)
[script:fivem_dispach] > <unknown> (@mysql-async/mysql-async.js:14431)
[ script:mysql-async] [ script:mysql-async] [ script:mysql-async] [ script:mysql-async] [ script:mysql-async] [ script:chames_keys] 2021-05-18 17:35:46 [chames_keys] Refreshed keys in database. [script:fivemserver_h] SCRIPT ERROR: @fivemserver_hacker/server.lua:57: attempt to get length of a nil value (local 'result')
[script:fivemserver_h] > fn (@mysql-async/lib/MySQL.lua:197)
[ script:society] SCRIPT ERROR: @society/server/main.lua:18: attempt to get length of a nil value (local 'result')
[ script:society] > fn (@mysql-async/lib/MySQL.lua:197)
[ script:mysql-async] [ERROR] [MySQL] [chames_motel] An error happens on MySQL for query " SELECT
[ script:mysql-async] *
[ script:mysql-async] FROM
[ script:mysql-async] james_motels
[ script:mysql-async] ": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [chames_motel] An error happens on MySQL for query " SELECT
[ script:mysql-async] storageId, storageData
[ script:mysql-async] FROM
[ script:mysql-async] world_storages
[ script:mysql-async] ": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query "SELECT * FROM vehicles": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:allhousing] Failed sql startup
[script:Inventory-Sor] SCRIPT ERROR: @Inventory-Sorter/server/main.lua:12: attempt to get length of a nil value (local 'items')
[script:Inventory-Sor] > fn (@mysql-async/lib/MySQL.lua:197)
[ script:datastore] SCRIPT ERROR: @datastore/server/main.lua:9: attempt to get length of a nil value (local 'result')
[ script:datastore] > fn (@mysql-async/lib/MySQL.lua:197)
[ script:accounts] SCRIPT ERROR: @accounts/server/main.lua:9: attempt to get length of a nil value (local 'result')
[ script:accounts] > fn (@mysql-async/lib/MySQL.lua:197)
[ script:tp-nitro] SCRIPT ERROR: @tp-nitro/server/main.lua:9: attempt to get length of a nil value (local 'vehicles')
[ script:tp-nitro] > fn (@mysql-async/lib/MySQL.lua:197)
[script:esx_adminmode] SCRIPT ERROR: @esx_adminmode-1.2/server.lua:218: bad argument #1 to 'for iterator' (table expected, got nil)
[script:esx_adminmode] > refreshNameCache (@esx_adminmode-1.2/server.lua:218)
[script:esx_adminmode] > callback (@esx_adminmode-1.2/server.lua:64)
[script:esx_adminmode] > fn (@mysql-async/lib/MySQL.lua:197)
[script:5m_vehiclesho] SCRIPT ERROR: [string "ESX = nil
..."]:14: attempt to get length of a nil value (local 'result')
[script:5m_vehiclesho] > fn (@mysql-async/lib/MySQL.lua:197)
[ script:tprp_base] SCRIPT ERROR: @tprp_base/server/common.lua:35: attempt to get length of a nil value (local 'result')
[ script:tprp_base] > fn (@mysql-async/lib/MySQL.lua:197)
[ script:chames_motel] SCRIPT ERROR: @chames_motel/server/main.lua:23: bad argument #1 to 'for iterator' (table expected, got nil)
[ script:chames_motel] > ref (@chames_motel/server/main.lua:23)
[ script:chames_motel] > <unknown> (@mysql-async/mysql-async.js:14431)
[ script:mysql-async] [ script:mysql-async] [ script:mysql-async] [ script:mysql-async] [ERROR] [MySQL] [vehicleshop] An error happens on MySQL for query "SELECT * FROM vehicles": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [boatshop] An error happens on MySQL for query "SELECT * FROM boats": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:vehicleshop] SCRIPT ERROR: @vehicleshop/server/main.lua:30: attempt to get length of a nil value (local 'vehicles')
[ script:vehicleshop] > fn (@mysql-async/lib/MySQL.lua:197)
[ script:boatshop] SCRIPT ERROR: @boatshop/server/main.lua:28: attempt to get length of a nil value (local 'vehicles')
[ script:boatshop] > fn (@mysql-async/lib/MySQL.lua:197)
[ svadhesive] Server license key authentication succeeded. Welcome!
[ script:EasyAdmin] EasyAdmin Version Check failed!
[ script:EasyAdmin] [ script:EasyAdmin] EasyAdmin: screenshot-basic is not installed on this Server, screenshots unavailable
[ script:mysql-async] [ERROR] [MySQL] [CrewSystem] An error happens on MySQL for query "CREATE TABLE IF NOT EXISTS ranking_crew(id int AUTO_INCREMENT, name varchar(100), created TIMESTAMP DEFAULT CURRENT_TIMESTAMP, members int DEFAULT 1, kills int, PRIMARY KEY(id))": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:mysql-async] [ERROR] [MySQL] [CrewSystem] An error happens on MySQL for query "CREATE TABLE IF NOT EXISTS crew(id int AUTO_INCREMENT, name varchar(100), identifier varchar(100), grade varchar(50), PRIMARY KEY(id))": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ citizen-server-impl] fff [ citizen-server-impl] cccc ff xx xx rr rr eee [ citizen-server-impl] cc ffff xx rrr r ee e [ citizen-server-impl] cc ff xx ... rr eeeee [ citizen-server-impl] ccccc ff xx xx ... rr eeeee [ citizen-server-impl] [ citizen-server-impl] Authenticated with cfx.re Nucleus: https://ld0n3xl-kp5eo6.users.cfx.re/
[ script:mysql-async] [ERROR] [MySQL] [CrewSystem] An error happens on MySQL for query "SELECT * FROM crew": ER_ACCESS_DENIED_ERROR: Access denied for user 'nebuu'@'localhost' (using password: NO)
[ script:CrewSystem] SCRIPT ERROR: @CrewSystem/Server/Configurate.lua:17: bad argument #1 to 'pairs' (table expected, got nil)
[ script:CrewSystem] > ref (@CrewSystem/Server/Configurate.lua:17)
[ script:CrewSystem] > <unknown> (@mysql-async/mysql-async.js:14431)
[ script:mysql-async] [ citizen-server-impl] -- [server notice: hostname_rework]
[ citizen-server-impl] You don't have sv_projectName/sv_projectDesc set.
[ citizen-server-impl] These variables augment sv_hostname and fix your server name being cut off in the server list.
[ citizen-server-impl] Use `sets sv_projectName ..` and `sets sv_projectDesc ..` to set them.
[ citizen-server-impl] [ citizen-server-impl] -- [server notice: tebex_not_set]
[ citizen-server-impl] ================
[ citizen-server-impl] Monetize your server using Tebex! Visit https://tebex.io/fivem for more info.
[ citizen-server-impl] ================
[ citizen-server-impl] [ script:allhousing] Completed house table check successfully.
