shortUrl error

myc818

New Member
YetiShare User
YetiShare Supporter
Dec 24, 2020
28
3
3
I just upgraded the 5.3 version and found a big problem, shortUrl is not case sensitive

4Jgz
4JgZ

The system treats the two shortUrls as duplicates, and most of my files cannot be accessed.
 

Derek1244

New Member
YetiShare User
YetiShare Supporter
Jul 17, 2020
11
3
3
I had the same issue and opened a ticket. Navigate to Site Configuration >> System Tools >> Database Browser >> Execute SQL:

Code:
ALTER TABLE `file` CHANGE `shortUrl` `shortUrl` varchar(255) COLLATE 'utf8_bin' NULL AFTER `originalFilename`;
Cheers
 

myc818

New Member
YetiShare User
YetiShare Supporter
Dec 24, 2020
28
3
3
I had the same issue and opened a ticket. Navigate to Site Configuration >> System Tools >> Database Browser >> Execute SQL:

Code:
ALTER TABLE `file` CHANGE `shortUrl` `shortUrl` varchar(255) COLLATE 'utf8_bin' NULL AFTER `originalFilename`;
Cheers
thanks