I have a strange issue with Sqlite Browser. I need to change folder paths manually as I am moving files outside of XnviewMP.
Now when I export the Folders from xnview.db and import them without changing anything and check inside XnviewMP then the categories are no longer working.
In fact, before exporting I can click on categories and get presented the files that are present. After importing the categories are present but dont show any files anymore. This without having changed the exported and imported file.
I was just wondering if there is any special way to do that.
Sqlite Browser
Moderators: helmut, XnTriq, xnview
Re: Sqlite Browser
No, the weird thing is I do not change anything. All I do at this point is exporting it and importing it. I do not touch the data and change something.xnview wrote:no error in the changed path in database?
I would assume that I should be able to export the data and import them again whithout any issues. This is why I am confused and need to check what is the problem.
Re: Sqlite Browser
1.) Unicode issue?jadO wrote:No, the weird thing is I do not change anything. All I do at this point is exporting it and importing it. I do not touch the data and change something.xnview wrote:no error in the changed path in database?
I would assume that I should be able to export the data and import them again whithout any issues. This is why I am confused and need to check what is the problem.
Are all your paths in Latin (ANSI) alphabet?
Your SQLite browser is Unicode compilant?
2.) AutoInc/Generators issue?
When you (re)import perhaps the Primary Keys are (re)generated automatically while their values as Foreign Keys in the Categories table remains the same?
m. Th.
- Dark Themed XnViewMP 1.7.1 64bit on Win11 x64 -
- Dark Themed XnViewMP 1.7.1 64bit on Win11 x64 -
Re: Sqlite Browser
Thanks for your suggestion. Still I have no clue why I am having these issues. When I simply export the data with Sqlite Browser and import them again without changing them, I would expect that Sqlite Browse takes care that the data does not get changed. When I check what has been imported I do not see any issues. But when I start XnviewMP then it behaves like the data has been altered.m.Th. wrote:1.) Unicode issue?jadO wrote:No, the weird thing is I do not change anything. All I do at this point is exporting it and importing it. I do not touch the data and change something.xnview wrote:no error in the changed path in database?
I would assume that I should be able to export the data and import them again whithout any issues. This is why I am confused and need to check what is the problem.
Are all your paths in Latin (ANSI) alphabet?
Your SQLite browser is Unicode compilant?
2.) AutoInc/Generators issue?
When you (re)import perhaps the Primary Keys are (re)generated automatically while their values as Foreign Keys in the Categories table remains the same?
Re: Sqlite Browser
Somehow I managed to fix this issue but I cannot remember how.