SQLite Error

Post Reply
ebueno
Posts: 3
Joined: 28 Feb 22, 22:42

SQLite Error

Post by ebueno » 10 Apr 22, 03:56

I use a loot the memory functions to work in my enviroment and in my macros.

Sometimes when i copy some text to memory i receive the following error:
[Window Title]
PhraseExpress
[Content]
[FireDAC][Phys][SQLite] ERROR: FOREIGN KEY constraint failed

I already tried to export my macros and reimport in a clean sqlite file, but after some time the error return.

I don't have yet a way to reproduce the error, it seems random, some times happen, some times not. But when occur is always while i copyng something to memory (text only, mostly time).

ebueno
Posts: 3
Joined: 28 Feb 22, 22:42

Post by ebueno » 12 Apr 22, 05:12

up?

Technical Support
Posts: 3214
Joined: 10 Feb 06, 22:23

Post by Technical Support » 12 Apr 22, 08:40

What is your PhraseExpress version?

Could you run PhraseExpress in "Debug" mode? If the problem occures again then send us the logs created.
To create a log file on the client do the following:
- Exit PhraseExpress if it is running.
- Press and hold the SHIFT-key while launching PhraseExpress again. This will make PhraseExpress launching in debug mode. Alternatively make it start with -debug command line parameter.
- Reproduce the problem and exit PhraseExpress.

PhraseExpress creates a folder named “Debug_PhraseExpress” on your desktop. Attach the contents of the folder to your email.

ebueno
Posts: 3
Joined: 28 Feb 22, 22:42

Post by ebueno » 19 Apr 22, 00:43

Thanks for your answer.

I attaching the folder you asked me to a mail and send.
The version i using is the last one:
v16.0.119i

I tried to run a sqlite pragma over the database, but no work (probably a closed db).

Post Reply