search

project-error / npwd

NPWD is a FiveM phone resource written entirely in TypeScript and React.
https://projecterror.dev
Other
336 stars 277 forks source link

Fixed an explicit SQL error about dark_chat tables #1142

Closed Ericple closed 3 months ago

Ericple commented 3 months ago

Fixed an explicit SQL error that caused the UNIQUE INDEX to be too long when creating a dark chat related table.

According to the MySQL INNODB limit, when using the utf8mb4 character set, you cannot set a UNIQUE INDEX longer than 191 characters. On line 208 of import.sql, the community developer misidentifies the 255 character column defined on line 205 as the index. This caused MySql to fail to execute the statement, which in turn caused the last three data tables to fail to be created. A workaround for reference is to "change" VARCHAR(255) to "VARCHAR(191)" in line 205, but you can also set 191 to any number less than it you like.

Reference: https://dev.mysql.com/doc/refman/8.0/en/innodb-limits.html

itschip commented 3 months ago

LGTM

itschip commented 3 months ago

Thank you for fixing this! :)