Error loading queue_sqlite3

Need help with FileZilla Client? Something does not work as expected? In this forum you may find an answer.

Moderator: Project members

Message
Author
Auda
500 Command not understood
Posts: 2
Joined: 2018-10-23 05:10

Error loading queue_sqlite3

#1 Post by Auda » 2018-10-23 05:18

Hello, whenever I open or close the filezilla, an error message pops up as below.

An error occurred saving the transfer queue to "C\users\WS-KRSE-016\AppData\Roaming\FileZilla\queue.sqlite3".
Some queue items might not have been saved.

Is it a specific error with the particular version? If so which version should I use in order to avoid this message?
Thanks for your advice in advance !

User avatar
boco
Contributor
Posts: 26910
Joined: 2006-05-01 03:28
Location: Germany

Re: Error loading queue_sqlite3

#2 Post by boco » 2018-10-23 05:35

First, the only version you should ever be using is the very latest. Older versions are unsupported here, and updates are there for a reason. Improvements and fixes are only ever applied to the latest version's code, so, reporting problems with old versions simply doesn't make any sense. The FileZilla dev will not do any backports, whatsoever!
(Note that is a general statement and not specifically directed at yourself.)

The queue file usually holds transfers added to the queue but not processed, yet. For a faster processing, the file is a database (SQLite). The file it shows in that error has become corrupted (this can happen with every version). Just delete this file and the error will vanish. FileZilla just generates a new, good file at the next start.
No support requests over PM! You will NOT get any reply!!!
FTP connection problems? Please read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
FileZilla Pro support: https://customerforum.fileZilla-project.org

Auda
500 Command not understood
Posts: 2
Joined: 2018-10-23 05:10

Re: Error loading queue_sqlite3

#3 Post by Auda » 2018-10-23 05:45

Hello boco,
thanks for the prompt reply.
I have been always using the latest version. but few weeks ago, I saw others have simillar problem and they said this issue has been occurred only with the newest version. They also said when they downgraded version, the problem was resolved. That is why I started using lower version. It seemed like the problem has been solved for a few days when I used the lower version, but this error message has been kept popping.

Can I ask what file should I delete and where can I delete it ?
The problem is I can't find queue.sqlite3 file in the written path.
In my computer there is no Appdata folder..
Any way to find this folder ??
Thank you.

User avatar
boco
Contributor
Posts: 26910
Joined: 2006-05-01 03:28
Location: Germany

Re: Error loading queue_sqlite3

#4 Post by boco » 2018-10-23 05:54

The file is exactly where it tells you it is. However, Windows is being sneaky and hides the AppData directory from you.

Just enter %APPDATA%\FileZilla into the address bar of one Explorer window, press RETURN and it will take you there.
No support requests over PM! You will NOT get any reply!!!
FTP connection problems? Please read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
FileZilla Pro support: https://customerforum.fileZilla-project.org

User avatar
botg
Site Admin
Posts: 35507
Joined: 2004-02-23 20:49
First name: Tim
Last name: Kosse

Re: Error loading queue_sqlite3

#5 Post by botg » 2018-10-23 07:18

Downgrading is not a supported use-case. It can damage your files as older versions cannot understand the files created by newer versions.

arhak
500 Command not understood
Posts: 1
Joined: 2022-02-11 12:50
First name: arh
Last name: ak

Re: Error loading queue_sqlite3

#6 Post by arhak » 2022-02-11 12:56

- Go to %AppData% (either by Windows + R or Explorer's address bar)
That will get you likely to C:\Users\MyName\AppData\Roaming
- Create a new folder named FileZilla
- Edit its properties to make it NOT read-only (uncheck checkbox)
- Launch FileZilla

Problem is gone

All is due to FileZilla being unable to write (create its folder) under the %AppData% directory
That may be due to system config / policies, or else FileZilla's fault?

It is present in both the Windows installer as well as the portable version

Rgds

User avatar
boco
Contributor
Posts: 26910
Joined: 2006-05-01 03:28
Location: Germany

Re: Error loading queue_sqlite3

#7 Post by boco » 2022-02-11 14:36

That may be due to system config / policies, or else FileZilla's fault?
The former. Could be possibly due to Defender's Controlled Folder Access feature being enabled.
No support requests over PM! You will NOT get any reply!!!
FTP connection problems? Please read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
FileZilla Pro support: https://customerforum.fileZilla-project.org

theMezz
500 Syntax error
Posts: 15
Joined: 2006-06-06 03:51

Re: Error loading queue_sqlite3

#8 Post by theMezz » 2022-06-08 15:09

I have the same error message with Linux Mint
I am running the newest version of filezilla as I always do.
Anyone know the fix??

Zaf9670
500 Command not understood
Posts: 1
Joined: 2022-08-19 17:48

Re: Error loading queue_sqlite3

#9 Post by Zaf9670 » 2022-08-19 17:49

Not sure if this solution would be for everyone but I just deleted the entire FileZilla roaming folder. That seems to have resolved my issue (at least for now). I'll report back if it gets broken again somehow.

User avatar
boco
Contributor
Posts: 26910
Joined: 2006-05-01 03:28
Location: Germany

Re: Error loading queue_sqlite3

#10 Post by boco » 2022-08-19 22:27

Would have been enough to just delete the mentioned file.
No support requests over PM! You will NOT get any reply!!!
FTP connection problems? Please read Network Configuration.
FileZilla connection test: https://filezilla-project.org/conntest.php
FileZilla Pro support: https://customerforum.fileZilla-project.org

farmersLSD
500 Command not understood
Posts: 2
Joined: 2017-07-10 17:33
First name: Shane
Last name: Farmer

Re: Error loading queue_sqlite3

#11 Post by farmersLSD » 2023-10-05 17:01

boco wrote:
2022-08-19 22:27
Would have been enough to just delete the mentioned file.
This works. Not sure why ever other thread about this is so convoluted or doesn't solve this issue?...

dzhigis
500 Command not understood
Posts: 2
Joined: 2023-10-11 10:48

Re: Error loading queue_sqlite3

#12 Post by dzhigis » 2023-10-11 10:59

I would like to add 5 cents to this topic.
The roaming "FileZilla" folder got created under the account which launches FileZilla and application sets folder permissions as owner and full control only for that account.
If you are managing global environment and need to fix issue by removing sqlite3 file for say hundreds users this becomes a problem - system account cannot remove that file from users appdata roaming folder due to lack of permissions.
The only scenario where the issue is not appearing is clean install on new device. Sounds like a proper bug and misconfiguration for upgrade scenario.
Attachments
2023-10-11_13-55-58.png
2023-10-11_13-55-58.png (27.43 KiB) Viewed 25867 times

User avatar
botg
Site Admin
Posts: 35507
Joined: 2004-02-23 20:49
First name: Tim
Last name: Kosse

Re: Error loading queue_sqlite3

#13 Post by botg » 2023-10-13 13:19

If you need to delete queue.sqlite3 for hundreds of users you are doing something very wrong.

Don't touch the roaming profile, in particular, don't move or copy files from one roaming profile to another. Windows takes care of the roaming aspect whenever a user logs in and out.

dzhigis
500 Command not understood
Posts: 2
Joined: 2023-10-11 10:48

Re: Error loading queue_sqlite3

#14 Post by dzhigis » 2023-10-16 11:41

Of course, usually it is not the case at all.
I am just highlighting the issue with latest filezilla version: after upgrade users are getting error message at START of filezilla - see attached screenshot. Same error appears when you are closing filezilla. This is happening during default installation for EACH user.
I am running "FileZilla_3.65.0_win64-setup.exe /S" nothing changed in parameters or installation behavior.

Previously raised topics suggesting to remove sqlite3 file and here comes another issue that it's NTFS permissions are bugged.
Attachments
sqlite3 error.png
sqlite3 error.png (40.38 KiB) Viewed 25243 times

Hersh.HaJi
500 Command not understood
Posts: 1
Joined: 2023-10-30 11:18
First name: HERSH
Last name: HaJi

Re: Error loading queue_sqlite3

#15 Post by Hersh.HaJi » 2023-10-30 11:22

Solved.

Go to %AppData% by Windows + R
That will get you likely to C:\Users\MyName\AppData\Roaming
- Delete (queue.sqlite3)
- Launch FileZilla
- Solved

Post Reply