sql syntax error in qbx_core.sql

[yunglean4171]

Summary

Syntax of qbx_core seems to be wrong

Reproduction

1. insert qbx_core/qbx_core.sql into db

Expected behavior

fix syntax

Actual behavior

wrong syntax

Additional context

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"]

Current Version

latest

Custom Resources

N/A

[Ioannis3141]

I had the exact same issue today on linux. Make sure that MariaDB is actually running as MariaDB and not only as MySQL Server since they need some SQL Commands which are MariaDB exclusive.

[Frowmza]

this is fixed 8a26c79 ?