Hey, in ps-mdt README, they say that to fix the illegal collations error I should change the collation to a diffrent one, will this make qbx_core not function properly?
#Quick question about collations
north cobalt
Line from ps mdt
ALTER TABLE players CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
north cobalt
Let my try to update it, I do not have the latest version since I got the owner to change from QBCore to Qbox. Will update that, thanks for the note
gleaming dragon
yep
north cobalt
Updated to the latest version of ps-mdt, reran the sql from the latest release of ps-mdt, still getting the same error.
north cobalt
Line from ps mdt
```ALTER TABLE players CONVERT TO CHARACTER SET utf8mb4 COLLATE...
The colation is diffrent, I'm just not sure if I can change it
stuck dock
change the general one to unicode. That alter table is incorrect.
And yes, it will make qbx_core run incorrectly
north cobalt
change the general one to unicode. That alter table is incorrect.
That's the query from ps-mdt, my current collation is the unicode one
north cobalt
and run the sql titled `qbox.sql`?
files from ps-mdt latest release, doesn't seem to have that file if you meant that its supposed to be in the mdt files
north cobalt
You still have general in ps-mdt tables most likely
ps-mdt doesn't work, if the collations are general
gleaming dragon
files from ps-mdt latest release, doesn't seem to have that file if you meant th...
ummm
what are you downloading
...
stuck dock
qbx_core doesn't use general at all, only unicode
north cobalt
my baaaaad
gleaming dragon
thats a good thing
north cobalt
ik :DDDDD
gleaming dragon
but in this case, they didnt push a new release when they accepted my pr
north cobalt
they should have made it a release, sad
north cobalt
qbx_core doesn't use general at all, only unicode
If you look at qbx_core at the sql file, if I was converting from QBCore, it doesn't replace the collations for everything, only for the citizenid
stuck dock
Ok. We should change that but it probably doesn't break anyone's server... yet.
north cobalt
Everything seems to function, but the collation is set to unicode only when the table gets created, you see it :D
Second thing with the sql, the server already has alot of information there, so I can't delete the tables, would have to backup, delete all the mdt files, add the ones from qbox.sql and then re-add the information, this could also be changed
Maybe I'm incorrect with this, give me a minute to try
Yep, not changed with the current sql, would need to backup all of the information and then run the sql