[pgadmin-support] Failed to write to history file

[michel boekestein]

Hi,



every time I execute a query using the Query Tool in PGAdmin, the message
"Failed to write to history file!" appears.

The queries do execute correctly.

The history file exists, and I can write in it using a text editor.

Changing the path name in pgAdmin's "File|Options|Query tool files |
History file path" makes pgAdmin hang.

I am using Windows 7, PostgreSQL 9.1.2, pgAdmin 1.14.1



Thanks in advance for your help,



Michel

[Guillaume Lelarge]

Post by michel boekestein
Hi,
every time I execute a query using the Query Tool in PGAdmin, the message
"Failed to write to history file!" appears.
The queries do execute correctly.
The history file exists, and I can write in it using a text editor.
Changing the path name in pgAdmin's "File|Options|Query tool files |
History file path" makes pgAdmin hang.
I am using Windows 7, PostgreSQL 9.1.2, pgAdmin 1.14.1

Is there any accent in the file path? pgAdmin tries to use it as a UTF8
string, but it may bring some issues with different encodings, just as
Windows.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

[michel boekestein]

No, there's no accent in the file path. It's here:

C:\Users\boekestein\AppData\Roaming\postgresql\pgadmin_histoqueries.xml


Op 25 februari 2012 00:26 schreef Guillaume Lelarge

Post by Guillaume Lelarge

Post by michel boekestein
Hi,
every time I execute a query using the Query Tool in PGAdmin, the message
"Failed to write to history file!" appears.
The queries do execute correctly.
The history file exists, and I can write in it using a text editor.
Changing the path name in pgAdmin's "File|Options|Query tool files |
History file path" makes pgAdmin hang.
I am using Windows 7, PostgreSQL 9.1.2, pgAdmin 1.14.1

Is there any accent in the file path? pgAdmin tries to use it as a UTF8
string, but it may bring some issues with different encodings, just as
Windows.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

[Guillaume Lelarge]

Post by michel boekestein
C:\Users\boekestein\AppData\Roaming\postgresql\pgadmin_histoqueries.xml

Please, don't top-post.

OK, so, if it cannot write in this file, is the file writable? can you
open it, and change a query for example?
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

[Guillaume Lelarge]

Post by Guillaume Lelarge

Post by michel boekestein
C:\Users\boekestein\AppData\Roaming\postgresql\pgadmin_histoqueries.xml

Please, don't top-post.
OK, so, if it cannot write in this file, is the file writable? can you
open it, and change a query for example?

yes.

If I send you a patch to get more informations, can you apply it and
compile pgAdmin?

If you cannot compile it, can you send me your history file and the
query you execute before you get this message?

Oh, and can you check on 1.14.2, see if it still fails?
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

[michel boekestein]

Op 27 februari 2012 22:28 schreef Guillaume Lelarge

Post by michel boekestein
C:\Users\boekestein\AppData\Roaming\postgresql\pgadmin_histoqueries.xml

Post by Guillaume Lelarge
Please, don't top-post.
OK, so, if it cannot write in this file, is the file writable? can you
open it, and change a query for example?

yes.

If I send you a patch to get more informations, can you apply it and
compile pgAdmin?

I'm afraid I can't

Post by michel boekestein
If you cannot compile it, can you send me your history file and the
query you execute before you get this message?

It executes before every query. See attachment for the history file.

Post by michel boekestein
Oh, and can you check on 1.14.2, see if it still fails?

Yep, it still fails

Post by michel boekestein
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

[Guillaume Lelarge]

Post by michel boekestein
Op 27 februari 2012 22:28 schreef Guillaume Lelarge

Op 27 feb. 2012 om 15:28 heeft Guillaume Lelarge

On Mon, 2012-02-27 at 11:34 +0100, michel boekestein

Post by michel boekestein
C:\Users\boekestein\AppData\Roaming\postgresql

\pgadmin_histoqueries.xml

Please, don't top-post.
OK, so, if it cannot write in this file, is the file

writable? can you

open it, and change a query for example?

yes.

If I send you a patch to get more informations, can you apply it and
compile pgAdmin?
I'm afraid I can't
If you cannot compile it, can you send me your history file and the
query you execute before you get this message?
It executes before every query. See attachment for the history file.
Oh, and can you check on 1.14.2, see if it still fails?
Yep, it still fails

Well. I tried with your file, and don't have any issues. I'm unable to
reproduce your issue.
--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

[Michel Boekestein]

Post by Guillaume Lelarge

Post by michel boekestein
C:\Users\boekestein\AppData\Roaming\postgresql\pgadmin_histoqueries.xml

Please, don't top-post.
OK, so, if it cannot write in this file, is the file writable? can you
open it, and change a query for example?

yes.