rebel1324 / NutScript

A free role-play framework for Garry's Mod.
http://nutscript.net
MIT License
66 stars 32 forks source link

Change in database causing migration to break #364

Closed Rubberbandits closed 3 years ago

Rubberbandits commented 3 years ago

https://github.com/rebel1324/NutScript/blob/d92c761459d7495d7dec7c2837b3575513f8dd55/gamemode/core/libs/sv_database.lua#L361

This change in the column data type from INT(11) UNSIGNED to INT(12) breaks foreign key constraints that nut_invdata uses. Alongside that, the migration script doesn't check if the next inventory it's going to try to migrate is even a valid row in the database, causing a script error at the end of inventory migration. This doesn't break the migration, but requires a server restart for anyone to connect.

its-johnny commented 3 years ago

Ty Rusty