#1398 Sqlite error:attempt to write a readonly database (8) while running:

[Anonymous]

Originally created by: chrisnei...@gmail.com

*What steps will reproduce the problem?*
1. Start fgfs with custom joystick config
2. Crashes with this error
Sqlite error:attempt to write a readonly database (8) while running:
        INSERT OR REPLACE INTO stat_cache (path, stamp) VALUES (?,?)

*What is the expected output? What do you see instead?*
I expect the game to work

*Any output in the console (black window)?*
Sqlite error:attempt to write a readonly database (8) while running:
        INSERT OR REPLACE INTO stat_cache (path, stamp) VALUES (?,?)

*What FlightGear version are you using (when using GIT version, please
mention date)?*
3.0.0

*What operating system and graphics card?*
win7 64 bit

*Please provide any additional information below or as attachment (Avoid
expiring external links, such as to imageshack/pastebin/...).*

Everything had been working fine before hand for weeks with my custom joystick config
I recently started using fgcom this seemed to be working
I made a change to the js config and exited from fgcom now I get this error when ever there is a js config with any data in it

FG works fine under all conditions that i tried except when...

I have a js config in my personal AppData directory with something in it

Meaning if the file is blank, no problems
If the file is a copy of the working built-in js config but in my personal directory FG will fail

[Anonymous]

Originally posted by: chrisnei...@gmail.com

deleting the flightgear directory and re-installing makes no difference

[Anonymous]

Originally posted by: chrisnei...@gmail.com

I needed to delete the personal FG directory
close this case

[Anonymous]

Originally posted by: gijsrooy

Issue 1416 has been merged into this issue.

[Anonymous]

Originally posted by: chrisnei...@gmail.com

This has happened twice to me now, both times was with editing the joystick config.
The actual files to delete are the cache files in your personal FG directory

[Anonymous]

Originally posted by: jvgod96

Well, my Issue has been merged into this one, and I want to tell you Mr. chrisnei that I have the same problem in my fgfs, and I use Keyboard and Mouse only.

Everything was normal until I changed the directories for FlightGear. I paid attention though to edit all the file folders options to run the game. Even the splash screen appears, but the game crashes when loading, and the same message error appears...

I ask that somebody please tell me what's going on so I can fix this damn thing up

[Anonymous]

Originally posted by: chrisnei...@gmail.com

The cache files in your *personal* flightgear directory are corrupted, delete them all

[Anonymous]

Originally posted by: jvgod96

Excuse me, which files am I supposed to delete? Can you name them? I only found cache files in my terrasync directory, but these aren't going to change a thing, are they?

If you can, name the folders where I can find these caches, and also the file type they are saved as...

[Anonymous]

Originally posted by: chrisnei...@gmail.com

Not the system flight gear directory
DO NOT go to c:\Program files\flightgear\

They are in your personal flightgeat directory, e.g. c:\users\jvgod96\flightgear.org\ or something like that

You need to look in the *USERS* directory

[Anonymous]

Originally posted by: chrisnei...@gmail.com

C:\Users\<yourusername>\AppData\Roaming\flightgear.org\

[Anonymous]

Originally posted by: jvgod96

Ok, I understand, but I can't find this "AppData" directory... I've had problems in the past with this same folder, it seems it had simply disappeared from my PC... :/

Well, thx anyway, nice flying to you

Below, there is an image of my user directory. Ignore the non-english folders, just notice that there is no "AppData" saved here...

[Anonymous]

Originally posted by: chrisnei...@gmail.com

Manually type the address into the address bar

[Anonymous]

Originally posted by: jvgod96

It doesn't work because the directory seems to be crashed. I've tried it many times, but when I do, a message error appears, saying that the directory doesn't exist, even if we know it does. Probably it is a problem with the Windows, I'll check it out later.

Anyway, I managed to exclude the cache file manually, over the Properties screen of my user. I lost all my FlightGear files saved in the folder, but I don't care, at least I can now play the game :)

[Anonymous]

Originally posted by: chrisnei...@gmail.com

Entering an address like this doesn't work?

C:\Users\jvgod96\AppData\

Maybe its in a different location or its not called AppData
if you search for flightgear.org you should find the directory where it is kept.
Actually you should be able to copy and paste the home directory used in fgrun

[Anonymous]

Originally posted by: jvgod96

Hehey, that's correct, I just found this directory in another address. It was on the file I copied from my old computer, I don't know how it went there though '-'

Well, I will try to delete the cache file as you said and run the game. I finally found my AppData, and already moved it to the correct place...

[Anonymous]

Originally posted by: chrisnei...@gmail.com

This issue can be closed

[Anonymous]

Originally posted by: NasalMusician

(No comment was entered for this change.)

Status: Expired

[Anonymous]

Originally posted by: NasalMusician

Issue 1460 has been merged into this issue.

[Anonymous]

Originally posted by: dars...@gmail.com

Please help I get the same problem!!!!!!!!! Help please, I don't know what to do please help and explain me clearly what to do!!!!!!!!!!!!

[Anonymous]

Originally posted by: chrisnei...@gmail.com

See reply #9

[Anonymous]

Originally posted by: dars...@gmail.com

my flightgear is stored in E:\Program Files\Flightgear

[Anonymous]

Originally posted by: chrisnei...@gmail.com

read all the comments the problem is not where flightgear is stored its your personal files for flightgear are stored

[Anonymous]

Originally posted by: cr...@crazywolff.de

just some more infos:

I often have this problem with Windows, most often after some openGL deadlock where i have to do a hard reset to reboot to Windows.

Then, under Users\username\AppData\Roaming\flightgear.org it is sufficient to delete fgfs.pid. There should be no need to dele the whole personal FG directory.

[Anonymous]

Originally posted by: dars...@gmail.com

please explain me how do it because i am very bad in computer but i really like this game please explain me how to resolve this issue. i really dont understand big words. please help me!!!!!!

[Anonymous]

Originally posted by: dars...@gmail.com

im really disesperate and i really want to play flightgear. i dont want to delete flightgear but please help me!!!!!!!!

[Anonymous]

Originally posted by: chrisnei...@gmail.com

Ask a friend to show you what is meant by your personal user directory, where it is and how to view it