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

error mysql sintax #119

Closed
HugoSilvaF opened this issue Dec 26, 2024 · 2 comments
Closed

error mysql sintax #119

HugoSilvaF opened this issue Dec 26, 2024 · 2 comments
Labels
bug Something isn't working need repro This bug report needs confirmation

Comments

@HugoSilvaF
Copy link

Summary

installation in txadmin

Reproduction

Installation
We highly recommend using txAdmin to install your FiveM server.
For detailed instructions, refer to Setting up a server using txAdmin.

Download the server
Download the latest FiveM artifacts and extract the files.

Start the server installation
Run FXServer.exe to begin the installation and follow all the steps.

Deploy the recipe
When prompted, select Remote URL Template:

Deployment Type

Use the raw recipe link shown below.

The Qbox Stable Recipe comes with the resources we consider stable, based on our Release Readiness guidelines.
Use this if you're looking for the most stable experience.

Since many Qbox resources are still a work-in-progress, some important resources are still considered unstable, and are currently missing from this recipe. This may result in various issues. You are expected to find alternatives by yourself, or to download the unstable versions of those resources.

Qbox Stable Recipe
https://raw.githubusercontent.com/Qbox-project/txAdminRecipe/main/qbox-stable.yaml

só when i am in the step of database i got this error

Your recipe is being executed, the server will be deployed to:
C:/Users/Hugo/Documents/vscode/txData/QboxProject_6CAE03.base/
[22:15:31] Starting deployment of Qbox Project.
[22:15:31] Running [task1:download_github]... ✔️
[22:15:32] Running [task2:move_path]... ✔️
[22:15:32] Running [task3:move_path]... ✔️
[22:15:32] Running [task4:move_path]... ✔️
[22:15:32] Running [task5:move_path]... ✔️
[22:15:32] Running [task6:move_path]... ✔️
[22:15:32] Running [task7:connect_database]... ✔️
[22:15:32] Running [task8:query_database]... ✔️
[22:15:32] Running [task9:download_github]... ✔️
[22:15:33] Running [task10:remove_path]... ✔️
[22:15:33] Running [task11:download_github]... ✔️
[22:15:34] Running [task12:download_github]... ✔️
[22:15:35] Running [task13:download_file]... ✔️
[22:15:36] Running [task14:unzip]... ✔️
[22:15:36] Running [task15:download_github]... ✔️
[22:15:37] Running [task16:waste_time]... ✔️
[22:15:47] Running [task17:download_github]... ✔️
[22:15:49] Running [task18:download_github]... ✔️
[22:15:50] Running [task19:download_file]... ✔️
[22:15:51] Running [task20:unzip]... ✔️
[22:15:51] Running [task21:download_file]... ✔️
[22:15:52] Running [task22:unzip]... ✔️
[22:15:52] Running [task23:download_github]... ✔️
[22:15:53] Running [task24:download_file]... ✔️
[22:15:53] Running [task25:download_file]... ✔️
[22:15:53] Running [task26:download_file]... ✔️
[22:15:54] Running [task27:unzip]... ✔️
[22:15:54] Running [task28:download_file]... ✔️
[22:15:56] Running [task29:unzip]... ✔️
[22:15:56] Running [task30:download_file]... ✔️
[22:15:57] Running [task31:unzip]... ✔️
[22:15:57] Running [task32:download_file]... ✔️
[22:15:58] Running [task33:unzip]... ✔️
[22:15:58] Running [task34:copy_path]... ✔️
[22:15:58] Running [task35:download_file]... ✔️
[22:15:59] Running [task36:unzip]... ✔️
[22:15:59] Running [task37:download_github]... ✔️
[22:16:00] Running [task38:download_github]... ✔️
[22:16:01] Running [task39:download_file]... ✔️
[22:16:02] Running [task40:unzip]... ✔️
[22:16:02] Running [task41:query_database]... ❌
[22:16:03] 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": "./resources/[qbx]/qbx_core/qbx_core.sql"
}
Debug/Status: ["6.0.2","Windows 10","loading task query_database"]
image

Expected behavior

Succes

Actual behavior

Error in mysql sintax

Additional context

image

Current Version

qbox-stable

Custom Resources

not

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

Manason commented Dec 26, 2024

Use mariadb. You are likely using an unsupported mysql version

@HugoSilvaF
Copy link
Author

ok

@Manason Manason closed this as not planned Won't fix, can't repro, duplicate, stale Dec 26, 2024
@github-project-automation github-project-automation bot moved this from Todo to Done in Issues Dec 26, 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