Kodi tvOS db rar/smb? strFilename path problem

[keivanshahin]

Bug report

Describe the bug

Here is a clear and concise description of what the problem is:

Sign for watched or continue is not showing up when listing file in directory.

Expected Behavior

Here is a clear and concise description of what was expected to happen:

Sign for watched or continue is usually to the left of the file when browsing within "videos"

Actual Behavior

Normal "dot" is showed to the left of the file but i am able to select as watched and the "playCount" updates the value in database, also do get information if i would like to continue watching the video from specific time.

Possible Fix

To Reproduce

Steps to reproduce the behavior:

1. i REPLACE(strFilename, '%2f', '%2F') in the database and it works correct.

not working:
"rar://smb%3a%2f%2fjoker%2fshare%2ftv%2fmy_movie.rar/my_movie.mkv"

working:
"rar://smb%3a%2F%2Fjoker%2Fshare%2Ftv%2Fmy_movie.rar/my_movie.mkv"

Debuglog

The debuglog can be found here:
from windows:
not working, strFilename contains %2f , debug mode:
https://paste.kodi.tv/tegiyuqavu.kodi

working, strFilename contains %2F , debug mode:
https://paste.kodi.tv/vulisuxofa.kodi

Screenshots

Here are some links or screenshots to help explain the problem:

Additional context or screenshots (if appropriate)

Here is some additional context or explanation that might help:

Your Environment

Used Operating system:

• tvOS

• Windows

• Operating system version/name:
  latest tvOS
  Windows 10, 1909

• Kodi version:
  kodi-20200112-90f9e710-master-tvos.deb
  KodiSetup-20200114-93974255-master-x64.exe

note: Once the issue is made we require you to update it with new information or Kodi versions should that be required.
Team Kodi will consider your problem report however, we will not make any promises the problem will be solved.

[xbmc-gh-bot]

Thank you for using Kodi and our issue tracker. This is your friendly Kodi GitHub bot 😉

It seems that you have not followed the template we provide and require for all bug reports (or have opened a roadmap item by accident). Please understand that following the template is mandatory and required for the team to be able handle the volume of open issues efficiently.

Please edit your issue message to follow our template and make sure to fill in all fields appropriately. The issue will be closed after one week has passed without satisfactory follow-up from your side.

This is an automatically generated message. If you believe it was sent in error, please say so and a team member will remove the "Ignored rules" label.

[keivanshahin]

i believe hope Ignored rules is wrong, i cant really add more,

[fuzzard]

Debug log can be obtained by downloading the container in xcode.

Xcode -> Window -> Devices and Simulators

Click on your apple TV, Kodi should show in "Installed Apps". Click on it to select then click on the cog wheel and select "Download Container". Select a folder to download it to.

Once the xcappdata file has been downloaded, go to it in finder, right click and "Show Package Contents"

AppData -> Library -> Caches and you will see the Kodi.log file.

This can probably be down easier via the loguploader Addon https://kodi.wiki/view/Add-on:Kodi_Logfile_Uploader but i havent tried it, so give it a whirl and report back i guess.

[keivanshahin]

Debug log from windows added now

[1337v411]

While waiting for a bugfix I've created two mysql triggers to take care of the issue:

CREATE TRIGGER fix_strPath_bug
BEFORE INSERT ON path
FOR EACH ROW set NEW.strPath = replace(NEW.strPath, '%2f', '%2F');

CREATE TRIGGER fix_strFilename_bug
BEFORE INSERT ON files
FOR EACH ROW set NEW.strFilename = replace(NEW.strFilename, '%2f', '%2F');