Page 1 of 1
Sqlite Browser
Posted: Fri Jul 03, 2015 10:28 am
by jadO
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.
Re: Sqlite Browser
Posted: Fri Jul 03, 2015 12:35 pm
by xnview
no error in the changed path in database?
Re: Sqlite Browser
Posted: Fri Jul 03, 2015 9:13 pm
by jadO
xnview wrote:no error in the changed path in database?
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.
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
Posted: Sat Jul 04, 2015 6:17 am
by m.Th.
jadO wrote:xnview wrote:no error in the changed path in database?
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.
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.
1.) Unicode issue?
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
Posted: Sat Jul 04, 2015 3:40 pm
by jadO
m.Th. wrote:jadO wrote:xnview wrote:no error in the changed path in database?
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.
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.
1.) Unicode issue?
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?
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.
Re: Sqlite Browser
Posted: Tue Jul 07, 2015 5:14 am
by xnview
do you want to send me the old and new database??
Re: Sqlite Browser
Posted: Mon Aug 24, 2015 4:50 am
by jadO
Somehow I managed to fix this issue but I cannot remember how.