search

Qbox-project / txAdminRecipe

http://qbox-project.github.io
11 stars 52 forks source link

MySQL syntax error "last_logged_out" on first install #93

Closed Chalityst closed 2 months ago

Chalityst commented 2 months ago

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

solareon commented 2 months ago

Please install MariaDB as this is the recommended platform for oxmysql