[PAID] Codesign Vehicle Garage

Help error mysql

Static analysis:

3 errors were found during the analysis.

A comma or closing bracket was expected. (near “(” at position 389)
Unexpected start of statement. (near “model” at position 390)
Unknown declaration type. (near “USING” at position 399)
SQL query: Copy

– IF YOU PLAN TO CHANGE THE NAMES OF THE garage_id’s IN THE CONFIG.LUA, THEN MAKE SURE YOU CHANGE THE DEFAULT garage_id NAME ALSO. CREATE TABLE IF NOT EXISTS vehicles ( name VARCHAR(60) NOT NULL COLLATE ‘utf8mb4_bin’, model VARCHAR(60) NOT NULL COLLATE ‘utf8mb4_bin’, price INT(11) NOT NULL, category VARCHAR(60) NULL DEFAULT NULL COLLATE ‘utf8mb4_bin’ PRIMARY KEY (model) USING BTREE, ) COLLATE=‘utf8mb4_bin’ ENGINE=InnoDB

MySQL Said: Documentation

#1067 - Invalid default value for ‘category’

Hi there , you have given an option to disable to store the not owned cars . But cars owned by others can store by anyone. Is there any solution for it

With that option enabled, cars owned by other players can not be stored

Hello, we do not offer any support on the forums, check your dms for more info

Changelog v4.2.0

Add

  • Added the players job label instead of the name to the job garage UI.
  • Added some more locales for the UI to the locales_ui.js.
  • Added gang garages. This is drag and drop on QBCore but its very easy to add compatibility with any other gang resource.
  • Added a config option to disable the inside garage without needing to make any other changes.
  • Added on duty checks alongside the job checks.
  • Added a new config option to allow certain jobs to remove fake plates.
  • Added a vehicle lockpick system for unlocking locked owned vehicles.
  • Added a 3rd argument to the server customise me’s check and remove money functions to allow you to add the money from impound fees to police society for example.
  • Added a config option to disable the return vehicle feature.
  • Added a new chat command to delete private garages.
  • Added checks to warn you if one of your vehicles in qbcores shared vehicle table has been formatted incorrectly.

Edit

  • Disabled some features by default to ensure easier installation for newer developers.

Fix

  • Fixed a typo in the provided SQL file.
  • Fixed an error when using the QBCore property garage that occurred when a property did not have the coords set.
  • Fixed the issue where players could spawn their vehicles from other players property garage.
  • Fixed QBCore perms.
  • Fixed a bug with blacklisting vehicles in the inside garage.
  • Fixed a issue with 1 locale for cd_drawtextui being encrypted causing issues using other draw text resources.
  • Fixed the cd_drawtextui from not updating instantly when spawning a vehicle from the job garage.
  • Fixed a typo in the SQL file.
  • Added extra checks to warn you when there is issues with your vehicle props data caused by other scripts adding incorrect data to it.
  • Fixed a typo in the vehicle lock system possibly causing issues.
  • When a car is unimpounded the in_garage state gets set back to 1 so the player dosnt have to pay a return vehicle fee.
  • Fixed a typo with the garage tax amount being $0 when using the default price calculator method.

Only took us 2 years :sweat_smile: but have finally released an updated showcase video of the Garage!

Added the required template to the post

Code is accessible No (however majority is accessible)
Subscription-based No
Lines (approximately) 9500+ (not including locales & libraries)
Requirements Dependencies listed above
Support Yes