Open zrbiao opened 2 months ago
https://www.scavengertown.top/index.php?route=/register/ Here's the registration link
If it cannot be recovered, please send a copy of the original data of nl2_users to me, thank you! I forgot to back it up
While we really cannot be responsible for any issues that occur when you modify your nameless database, I am curious what the issue is. Could you share the error logs that can be found in cache/logs/fatal-log.log
please? Use something like pastebin or a different text sharing service to send it here.
As for the regular layout, the migration file for this table can be found here
To modify an anonymous database, you only need to register with anonymous once, and then you can use other applications and servers. Don't want to register again. he authme integration needs to be registered with the server and does not comply with the whitelist rules, so it is necessary to modify the nameless database. Make it Other external applications need to connect to authme, and also need to change the database id to change the uid. failed
这是fatal-log.log
`[2024-06-07, 16:07:16] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:16] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:16] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:16] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:16] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:19] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:19] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Uncaught Exception: Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json in /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php:189 Stack trace:
thrown [2024-06-07, 16:07:24] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:24] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Uncaught Exception: Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json in /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php:189 Stack trace:
thrown [2024-06-07, 16:07:30] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:30] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Uncaught Exception: Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json in /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php:189 Stack trace:
thrown [2024-06-07, 16:07:31] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:31] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Uncaught Exception: Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json in /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php:189 Stack trace:
thrown [2024-06-07, 16:07:37] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:37] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:37] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:07:37] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:08:37] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:08:37] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:08:37] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 16:08:37] /home/www/wwwroot/mt102ifb/namelessmc/vendor/samerton/i18next/src/i18next.php(189): Invalid json /home/www/wwwroot/mt102ifb/namelessmc/custom/languages/zh_CN.json [2024-06-07, 17:35:53] /home/www/wwwroot/mt102ifb/namelessmc/cache/templates_c/d2d66bc9fbadc67dc892bfe335f64b0789697b73_0.file.header.tpl.php(100): Allowed memory size of 134217728 bytes exhausted (tried to allocate 20987904 bytes) [2024-06-07, 17:36:28] /home/www/wwwroot/mt102ifb/namelessmc/cache/templates_c/664cf728a53fdc1b05b4b45f1cba2f8f68757d98_0.file.navbar.tpl.php(251): count(): Argument #1 ($value) must be of type Countable|array, null given [2024-06-07, 17:36:36] /home/www/wwwroot/mt102ifb/namelessmc/cache/templates_c/664cf728a53fdc1b05b4b45f1cba2f8f68757d98_0.file.navbar.tpl.php(251): count(): Argument #1 ($value) must be of type Countable|array, null given [2024-06-07, 17:48:17] /home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl(262): Syntax error in template "file:/home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl" on line 262 "{/if}" unclosed {if} tag [2024-06-08, 00:34:00] /home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl(133): Syntax error in template "file:/home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl" on line 133 "" - Unexpected ".", expected one of: "}" [2024-06-08, 00:34:03] /home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl(133): Syntax error in template "file:/home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl" on line 133 "" - Unexpected ".", expected one of: "}" [2024-06-08, 00:34:06] /home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl(133): Syntax error in template "file:/home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl" on line 133 "" - Unexpected ".", expected one of: "}" [2024-06-08, 00:35:43] /home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl(133): Syntax error in template "file:/home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl" on line 133 "" - Unexpected ".", expected one of: "}" [2024-06-08, 00:52:09] /home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl(130): Syntax error in template "file:/home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl" on line 130 "" - Unexpected ".", expected one of: "}" [2024-06-08, 00:52:20] /home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl(130): Syntax error in template "file:/home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/navbar.tpl" on line 130 "" - Unexpected ".", expected one of: "}" [2024-06-09, 06:55:45] /home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/status.tpl(19): Syntax error in template "file:/home/www/wwwroot/mt102ifb/namelessmc/custom/templates/DefaultRevamp/status.tpl" on line 19 "
api.php?uuid=${uuid}
);" unknown tag 'uuid'
[2024-06-18, 15:47:21] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Database/DB.php(253): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 15:47:47] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Database/DB.php(253): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 15:52:48] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Database/DB.php(253): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 15:54:27] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Database/DB.php(253): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 15:54:44] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Database/DB.php(253): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 15:55:52] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Database/DB.php(253): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 15:56:29] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Database/DB.php(253): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 15:58:48] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Database/DB.php(253): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 16:00:56] /home/www/wwwroot/mt102ifb/odi2d7/vendor/maximebf/debugbar/src/DebugBar/DataCollector/PDO/TraceablePDOStatement.php(113): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 16:19:51] /home/www/wwwroot/mt102ifb/odi2d7/vendor/maximebf/debugbar/src/DebugBar/DataCollector/PDO/TraceablePDOStatement.php(113): SQLSTATE[HY000]: General error: 1364 Field 'RealName' doesn't have a default value
[2024-06-18, 17:31:25] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Minecraft/MinecraftProfile.php(23): MinecraftProfile::construct(): Argument #1 ($username) must be of type string, null given, called in /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Minecraft/ProfileUtils.php on line 35
[2024-06-18, 17:32:36] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Minecraft/MinecraftProfile.php(23): MinecraftProfile::construct(): Argument #1 ($username) must be of type string, null given, called in /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Minecraft/ProfileUtils.php on line 35
[2024-06-18, 17:40:25] /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Minecraft/MinecraftProfile.php(23): MinecraftProfile::__construct(): Argument #1 ($username) must be of type string, null given, called in /home/www/wwwroot/mt102ifb/odi2d7/core/classes/Minecraft/ProfileUtils.php on line 35
[2024-06-19, 03:59:17] /home/www/wwwroot/mt102ifb/odi2d7/custom/templates/DefaultRevamp/navbar.tpl(166): Syntax error in template "file:/home/www/wwwroot/mt102ifb/odi2d7/custom/templates/DefaultRevamp/navbar.tpl" on line 166 "If I can change the core/migrations / 20220517030611 _create_users_table. PHP, complete database tables to add
The database was repaired, creating a table column recovery through sql code I first delete the original column, and then through the sql code execution is normal
for reference only
ALTER TABLE
nl2_users ADD COLUMN
scoreINT(11) NULL AFTER
uuid, ADD COLUMN
avatarINT(11) NULL DEFAULT 0 AFTER
score, ADD COLUMN
permissionINT(11) NULL DEFAULT 0 AFTER
avatar, ADD COLUMN
register_atDATETIME NULL AFTER
permission, ADD COLUMN
last_sign_atDATETIME NULL AFTER
register_at, ADD COLUMN
uidINT(11) NULL AFTER
last_sign_at, ADD COLUMN
realnameVARCHAR(255) NULL AFTER
uid;
Describe the issue
Multiple application requirements nameless and authme and Other Applications database table nl2_users nameless cannot be registered after an operation to add a column All operations are running normally except registration
Developer console error: Uncaught TypeError: Cannot read properties of null (reading 'classList') at HTMLDocument. (index.php?route=/register/:131:39)
at e (jquery.min.js:2:30310)
at t (jquery.min.js:2:30612)
NamelessMC Version
2.1.0
To Reproduce
1.phpmyadmin change nl2_users table 2.Adds a new data table column
Additional Information