or DELIMITER expected, got 'jetbrainsRiderDummyI...'

Unable to resolve table 'Scores'

Unable to resolve table 'Users'

Unable to resolve table 'Scores'

Unable to resolve table 'Slots'

The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, shogo82148/actions-setup-mysql@v1.14.1, actions/setup-dotnet@v3, actions/upload-artifact@v3, im-open/process-dotnet-test-results@v2.2.5. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/

Support for 'async void' unit tests is being removed from xUnit.net v3. To simplify upgrading, convert the test to 'async Task' instead. (https://xunit.net/xunit.analyzers/rules/xUnit1048)

Support for 'async void' unit tests is being removed from xUnit.net v3. To simplify upgrading, convert the test to 'async Task' instead. (https://xunit.net/xunit.analyzers/rules/xUnit1048)

Support for 'async void' unit tests is being removed from xUnit.net v3. To simplify upgrading, convert the test to 'async Task' instead. (https://xunit.net/xunit.analyzers/rules/xUnit1048)

Support for 'async void' unit tests is being removed from xUnit.net v3. To simplify upgrading, convert the test to 'async Task' instead. (https://xunit.net/xunit.analyzers/rules/xUnit1048)

Support for 'async void' unit tests is being removed from xUnit.net v3. To simplify upgrading, convert the test to 'async Task' instead. (https://xunit.net/xunit.analyzers/rules/xUnit1048)

Support for 'async void' unit tests is being removed from xUnit.net v3. To simplify upgrading, convert the test to 'async Task' instead. (https://xunit.net/xunit.analyzers/rules/xUnit1048)

The following artifacts were uploaded using a version of actions/upload-artifact that is scheduled for deprecation: "lighthouse-test-results-Linux". Please update your workflow to use v4 of the artifact actions. Learn more: https://github.blog/changelog/2024-04-16-deprecation-notice-v3-of-the-artifact-actions/

Unknown HTML entity 'centerdot'

Expression is always false according to nullable reference types' annotations

Conditional access qualifier expression is never null according to nullable reference types' annotations

Conditional access qualifier expression is never null according to nullable reference types' annotations

Selector photo-subjects is never used

Variable 'stringWriter' is captured by the 'using' statement and will be automatically disposed when the execution gets out of the scope

Empty statement is redundant

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Possible performance issues caused by unlimited string length

Usage of navigational property can return incomplete data

Usage of navigational property can return incomplete data

Usage of navigational property can return incomplete data

Path '$PROJECT_DIR$/ProjectLighthouse.Servers.Website/logo-mono.png' is not found

Path '$PROJECT_DIR$/ProjectLighthouse.Servers.Website/assets' is not found

Path '$PROJECT_DIR$/ProjectLighthouse.Servers.Website/assets/slotCardBackground.png' is not found

Path '$PROJECT_DIR$/ProjectLighthouse.Servers.Website/assets/slotCardBackground.png' is not found

Path '$PROJECT_DIR$/ProjectLighthouse.Servers.Website/Pages/Partials/postComment' is not found

Path is outside of the website

Path '$PROJECT_DIR$/ProjectLighthouse.Servers.Website/assets' is not found

Path is outside of the website

Missing required 'alt' attribute

Missing required 'alt' attribute

Missing required 'alt' attribute

Missing required 'alt' attribute

Missing required 'alt' attribute

Missing required 'alt' attribute

Localizable string: 'digestKey:'

Localizable string: 'Digest failed'

Localizable string: 'computed digest:'

Localizable string: 'altDigestKey:'

Field 'applicationStartedRegistration' is assigned but its value is never used

Field 'database' is assigned but its value is never used

Return value must be disposed but method 'GetEnumerator' is not annotated with \[MustDisposeResource\]

Type cast is redundant

Initializing property by default value is redundant

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

Redundant nullable directive

The nullable warning suppression expression is redundant

Using directive is not required by the code and can be safely removed

Using directive is not required by the code and can be safely removed

Using directive is not required by the code and can be safely removed

Using directive is not required by the code and can be safely removed

Using directive is not required by the code and can be safely removed

Specify string culture explicitly

Specify string culture explicitly

Auto-property accessor 'Username.get' is never used

Auto-property accessor 'AnalyticsEnabled.set' is never used

Auto-property accessor 'CaptchaEnabled.set' is never used

Auto-property accessor 'BlockedIds.get' is never used

Auto-property accessor 'Platform.get' is never used

Auto-property accessor 'CurrentRoom.get' is never used

Auto-property accessor 'Configuration.get' is never used

Auto-property accessor 'Platform.get' is never used

Auto-property accessor 'Game.get' is never used

Auto-property accessor 'RedisId.get' is never used

Auto-property accessor 'RedisId.get' is never used

Auto-property accessor 'Game.get' is never used

Auto-property accessor 'PlayerCount.get' is never used

Auto-property accessor 'TotalPlayerCount.get' is never used

Auto-property accessor 'ScoreId.get' is never used

Auto-property accessor 'Timestamp.get' is never used

Unused nullable directive

Unused nullable directive

The header 'Authorization' can be accessed using the Authorization property

Redundant parentheses

Redundant parentheses

Redundant parentheses

Redundant parentheses

Qualifier 'this.' is redundant

Add trailing comma to conform to code style

Add trailing comma to conform to code style

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Auto-property can be made get-only

Member 'RecursivelyPrepare' does not access instance data and can be marked as static

Prefer a 'TryGetValue' call over a Dictionary indexer access guarded by a 'ContainsKey' check to avoid double lookup

Change return type of method 'FixScores' from 'System.Collections.Generic.IEnumerable' to 'System.Collections.Generic.List' for improved performance

Change type of variable 'footerBlob' from 'LBPUnion.ProjectLighthouse.Tickets.TicketData' to 'LBPUnion.ProjectLighthouse.Tickets.BlobData' for improved performance

Change type of variable 'userBlob' from 'LBPUnion.ProjectLighthouse.Tickets.TicketData' to 'LBPUnion.ProjectLighthouse.Tickets.BlobData' for improved performance

Prefer comparing 'Count' to 0 rather than using 'Any()', both for clarity and for performance

Prefer 'static readonly' fields over constant array arguments if the called method is called repeatedly and is not mutating the passed array

Prefer 'static readonly' fields over constant array arguments if the called method is called repeatedly and is not mutating the passed array

Prefer 'static readonly' fields over constant array arguments if the called method is called repeatedly and is not mutating the passed array

Prefer 'static readonly' fields over constant array arguments if the called method is called repeatedly and is not mutating the passed array

Prefer the string comparison method overload of 'string.StartsWith(string)' that takes a 'StringComparison' enum value to perform a case-insensitive comparison, but keep in mind that this might cause subtle changes in behavior, so make sure to conduct thorough testing after applying the suggestion, or if culturally sensitive comparison is not required, consider using 'StringComparison.OrdinalIgnoreCase'

Prefer using 'string.Equals(string, StringComparison)' to perform a case-insensitive comparison, but keep in mind that this might cause subtle changes in behavior, so make sure to conduct thorough testing after applying the suggestion, or if culturally sensitive comparison is not required, consider using 'StringComparison.OrdinalIgnoreCase'

Prefer the string comparison method overload of 'string.Contains(string)' that takes a 'StringComparison' enum value to perform a case-insensitive comparison, but keep in mind that this might cause subtle changes in behavior, so make sure to conduct thorough testing after applying the suggestion, or if culturally sensitive comparison is not required, consider using 'StringComparison.OrdinalIgnoreCase'

Prefer using 'string.Equals(string, StringComparison)' to perform a case-insensitive comparison, but keep in mind that this might cause subtle changes in behavior, so make sure to conduct thorough testing after applying the suggestion, or if culturally sensitive comparison is not required, consider using 'StringComparison.OrdinalIgnoreCase'

Prefer using 'string.Equals(string, StringComparison)' to perform a case-insensitive comparison, but keep in mind that this might cause subtle changes in behavior, so make sure to conduct thorough testing after applying the suggestion, or if culturally sensitive comparison is not required, consider using 'StringComparison.OrdinalIgnoreCase'

Prefer using 'string.Equals(string, StringComparison)' to perform a case-insensitive comparison, but keep in mind that this might cause subtle changes in behavior, so make sure to conduct thorough testing after applying the suggestion, or if culturally sensitive comparison is not required, consider using 'StringComparison.OrdinalIgnoreCase'

Use 'string.IndexOf(char)' instead of 'string.IndexOf(string)' when you have a string with a single char

Use 'string.StartsWith(char)' instead of 'string.StartsWith(string)' when you have a string with a single char

Use 'string.StartsWith(char)' instead of 'string.StartsWith(string)' when you have a string with a single char

Use 'string.StartsWith(char)' instead of 'string.StartsWith(string)' when you have a string with a single char

Method DeleteComment passes 'Type' as the paramName argument to a ArgumentOutOfRangeException constructor. Replace this argument with one of the method's parameter names. Note that the provided parameter name should have the exact casing as declared on the method.

Call the ArgumentOutOfRangeException constructor that contains a message and/or paramName parameter

Call the ArgumentOutOfRangeException constructor that contains a message and/or paramName parameter

Method CreateFromBytes passes 'npTicket.TitleId' as the paramName argument to a ArgumentNullException constructor. Replace this argument with one of the method's parameter names. Note that the provided parameter name should have the exact casing as declared on the method.

Non-constant fields should not be visible

Dictionary lookup can be simplified with 'GetValueOrDefault'

Class 'SwaggerFilter' is never instantiated

Class 'PhotoEntity' has some virtual members but no inheritors

Class 'ModerationCaseEntity' has some virtual members but no inheritors

Convert constructor into member initializers

Convert constructor into member initializers

Convert constructor into member initializers

Convert into '?:' expression

Convert into 'return' statement

Convert into 'return' statement

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Convert into primary constructor

Query can return incomplete data for related entities

Query can return incomplete data for related entities

Part of loop's body can be converted into LINQ-expression but another 'GetEnumerator' method will be used

Part of loop's body can be converted into LINQ-expression but another 'GetEnumerator' method will be used

Method 'IsUsernameValid' can be made static

Property 'LastLogout' can be made private

Class 'OverriddenRoot' can be made private

Property 'RoomIdIncrement' can be made private

Method 'ImageExists' can be made private

Property 'CurrentPlatform' can be made private

Field 'NormalCollection' can be made private

Accessor 'BodyHeader.set' can be made private

Property 'CurrentVersion' can be made private

Field 'LittleBigPlanetVitaTitleIds' can be made private

Property 'RootTag' can be made private

Property 'RootTag' can be made private

Method 'SendWebhook' can be made private

Field 'LittleBigPlanetPSPTitleIds' can be made private

Field 'LittleBigPlanet1TitleIds' can be made private

Field 'LittleBigPlanet3TitleIds' can be made private

Property 'LastLogin' can be made private

Method 'OnApplicationStarted' can be made private

Field 'UserRecentlyDivedIn' can be made private

Property 'ApplicationLifetime' can be made private

Property 'RootTag' can be made private

Method 'LogDebug' can be made private

Property 'next' can be made protected

Constructor 'ExcludeNamespaceXmlWriter' can be made protected

Method 'RemoveAsync' can be made protected

Merge into logical pattern

Merge into logical pattern

Merge into logical pattern

Merge into pattern

Merge into pattern

Merge into pattern

Method has async overload

should specify alternative text

should specify alternative text

should specify alternative text

should specify alternative text

should specify alternative text

should specify alternative text

Put local function 'SlotCount' after 'return'

Field 'Reviews' is assigned but its value is never used

Field 'Scores' is assigned but its value is never used

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only

Property can be made init-only