Search Issue Tracker
Active
Under Consideration for 2021.3.X, 2022.3.X, 6000.0.X
Votes
23
Found in
2021.3.39f1
2022.3.34f1
6000.0.7f1
7000.0.0a1
Issue ID
UUM-74229
Regression
No
[HDRP] Shadows are rendered in uneven sections when moving in the Scene view
How to reproduce:
1. Open the “IN-78502“ project
2. Open the “SampleScene“
3. Move forwards and backwards in the Scene view
4. Observe the Scene view
Expected result: The shadows are rendered smoothly
Actual result: The shadows render in uneven sections
Reproducible with: 2021.3.39f1, 2022.3.34f1, 6000.0.7f1
Reproducible on: Windows 10
Not reproducible on: Windows 11
Add comment
All about bugs
View bugs we have successfully reproduced, and vote for the bugs you want to see fixed most urgently.
Latest issues
- NullReferenceException is thrown when adding a Blur Renderer Feature
- [Linux] Dropdown Menus are filled with empty entries when the Menu intersects with the Editors borders
- [HDRP] [Metal] Tiled artefacts when using DRS
- [HDRP] Empty template starts with incorrect Physically Based Sky ground
- Big chunk of "Untracked" memory in the Memory Profiler screenshot when a custom .obj file is loaded while in Play Mode
darrin5698
Aug 07, 2024 09:11
It seems like you are encountering an issue with the maximum index length in MySQL, which can be affected by the storage engine and character set being used. Here are some steps you can take to resolve this issue:
Check the Character Set and Collation:
Ensure that the character set and collation of your database and table are the same as the source. The error might be caused by differences in character set and collation settings, which affect the maximum length of indexed columns.
sql
Copy code
SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';
Compare the values on both the source and destination databases.
Adjust the Index Length:
If the character set is utf8mb4, each character can take up to 4 bytes, which reduces the maximum length of an indexed column. For utf8mb4, the maximum length of a varchar index is 191 characters.
You can modify the index length to fit within the limit:
sql
Copy code
ALTER TABLE kunena_aliases DROP INDEX index_name;
ALTER TABLE kunena_aliases ADD INDEX (column_name(191));
Adjust the length to 191 or less to ensure compatibility.
Check the MySQL Configuration:
Some MySQL settings might differ between the accounts, causing this issue. Specifically, check the innodb_large_prefix setting, which allows longer index prefixes for InnoDB tables.
sql
Copy code
SHOW VARIABLES LIKE 'innodb_large_prefix';
If it's set to OFF, you might need to enable it:
sql
Copy code
SET GLOBAL innodb_large_prefix = 'ON';
Also, ensure that innodb_file_format is set to Barracuda and innodb_file_per_table is enabled:
sql
Copy code
SHOW VARIABLES LIKE 'innodb_file_format';
SHOW VARIABLES LIKE 'innodb_file_per_table';
If necessary, you can set these values in your MySQL configuration file (my.cnf or my.ini):
ini
Copy code
[mysqld]
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix = 1
Split the Table Export and Import:
Export the kunena_aliases table separately and import it using a tool that can handle large indexes more gracefully, such as MySQL Workbench or phpMyAdmin.
Temporary Change the Column Type:
You mentioned changing the column type to a smaller varchar length, which allowed the import. After the import, you can try to alter the table structure to revert to the original length, but ensure the index length is within limits:
sql
Copy code
ALTER TABLE kunena_aliases MODIFY column_name VARCHAR(255);
ALTER TABLE kunena_aliases DROP INDEX index_name;
ALTER TABLE kunena_aliases ADD INDEX (column_name(191));
Backup and Restore with Akeeba:
Ensure that Akeeba Backup is configured to handle large tables and indexes. Check the backup settings for any options related to database handling, and adjust them if necessary.
If none of these solutions resolve the issue, you might need to contact your hosting provider to ensure there are no hidden differences in the MySQL configurations between the two accounts. They might also be able to provide additional insights or adjust the necessary settings to allow the import to proceed without issues.
avantikaggn
Aug 01, 2024 20:36
russian-escorts-in-delhi.escortsites.biz/