Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] - esx_banking - oxmysql Issue #1593

Closed
Luca8120 opened this issue Jan 11, 2025 · 4 comments
Closed

[Bug] - esx_banking - oxmysql Issue #1593

Luca8120 opened this issue Jan 11, 2025 · 4 comments
Assignees
Labels
bug Something isn't working

Comments

@Luca8120
Copy link

Luca8120 commented Jan 11, 2025

Describe the bug
got this error message the first time after installing the newest esx version, when trying to withdraw or deposit money. it works but iam still getting this error

23:31:49 [ script:oxmysql] Error: esx_banking was unable to execute a query!
23:31:49 [ script:oxmysql] Query: INSERT INTO banking (identifier, label, type, amount, time, balance) VALUES (?, ?, ?, ?, ?, ?)
23:31:49 [ script:oxmysql] ["18174392d552f9fdba66b124a6fe7b44c2148988","DEPOSIT","DEPOSIT",1,1736634709000,10123384494]
23:31:49 [ script:oxmysql] Out of range value for column 'balance' at row 1

Screenshot 2025-01-11 233238

Debug Info (please complete the following information):

  • OS: Windows Server 2022
  • FiveM Artifact 12255
  • ESX Version: 1.12.3
@Luca8120 Luca8120 added the bug Something isn't working label Jan 11, 2025
@github-project-automation github-project-automation bot moved this to 🆕 To be Discussed in ESX Roadmap Jan 11, 2025
@Mycroft-Studios
Copy link
Member

how much money do u have ?

@DyroS3
Copy link
Contributor

DyroS3 commented Jan 12, 2025

This is not a problem with esx_core, this is a problem with the database storage associated with esx_bank. The current esx_bank database storage defaults to 2147483647, and you have entered 10123384494. This is clearly beyond the database's maximum capacity, which is why you are getting this error.

@Luca8120
Copy link
Author

i gave myself very much money because iam on my testing server, after i set my money to 100 million it was fixed. thank you.

@Mycroft-Studios
Copy link
Member

Issue Solved

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
Archived in project
Development

No branches or pull requests

5 participants