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

MySQL syntax error "last_logged_out" on first install #93

Closed
Chalityst opened this issue Sep 17, 2024 · 1 comment
Closed

MySQL syntax error "last_logged_out" on first install #93

Chalityst opened this issue Sep 17, 2024 · 1 comment
Labels
bug Something isn't working need repro This bug report needs confirmation

Comments

@Chalityst
Copy link

Summary

I got MySQL syntax error 'last_logged_out' error on first install in txAdmin

Reproduction

  1. Just download latest fivem server.
  2. Start FXServer.exe
  3. Setup config
  4. Run server
  5. Error

Expected behavior

I ever install QBCore before changed to QBox, MySQL fine with QBCore (Install successful)

Actual behavior

[19:55:06] Starting deployment of Qbox Stable.
[19:55:06] Running [task1:download_github]... ✔️
[19:55:07] Running [task2:move_path]... ✔️
[19:55:07] Running [task3:move_path]... ✔️
[19:55:07] Running [task4:move_path]... ✔️
[19:55:07] Running [task5:move_path]... ✔️
[19:55:07] Running [task6:connect_database]... ✔️
[19:55:07] Running [task7:query_database]... ❌
[19:55:07] Task Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF NOT EXISTS last_logged_out timestamp NULL DEFAULT NULL AFTER last_updated' at line 2
Options:
{
"action": "query_database",
"file": "./tmp/qbox/qbox.sql"
}
Debug/Status: ["7.2.2","Windows 11","loading task query_database"]

Additional context

No response

Current Version

latest qbox

Custom Resources

No

@Chalityst Chalityst added bug Something isn't working need repro This bug report needs confirmation labels Sep 17, 2024
@qbox-duck qbox-duck bot added this to Issues Sep 17, 2024
@github-project-automation github-project-automation bot moved this to Todo in Issues Sep 17, 2024
@solareon
Copy link
Contributor

Please install MariaDB as this is the recommended platform for oxmysql

@github-project-automation github-project-automation bot moved this from Todo to Done in Issues Sep 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working need repro This bug report needs confirmation
Projects
Status: Done
Development

No branches or pull requests

2 participants