Sqlite Browser

Ask for help and post your question on how to use XnView MP.

Moderators: helmut, XnTriq, xnview

Post Reply
jadO
Posts: 490
Joined: Wed Apr 29, 2015 6:36 am

Sqlite Browser

Post 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.
User avatar
xnview
Author of XnView
Posts: 46238
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: Sqlite Browser

Post by xnview »

no error in the changed path in database?
Pierre.
jadO
Posts: 490
Joined: Wed Apr 29, 2015 6:36 am

Re: Sqlite Browser

Post 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.
User avatar
m.Th.
XnThusiast
Posts: 1676
Joined: Wed Aug 16, 2006 6:31 am
Contact:

Re: Sqlite Browser

Post 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?
m. Th.

- Dark Themed XnViewMP 1.7.1 64bit on Win11 x64 -
jadO
Posts: 490
Joined: Wed Apr 29, 2015 6:36 am

Re: Sqlite Browser

Post 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.
User avatar
xnview
Author of XnView
Posts: 46238
Joined: Mon Oct 13, 2003 7:31 am
Location: France
Contact:

Re: Sqlite Browser

Post by xnview »

do you want to send me the old and new database??
Pierre.
jadO
Posts: 490
Joined: Wed Apr 29, 2015 6:36 am

Re: Sqlite Browser

Post by jadO »

Somehow I managed to fix this issue but I cannot remember how.
Post Reply