Re: SQL editor view, Add favourite disabled - Mailing list pgadmin-support

On Wed, 2013-06-19 at 18:44 +0100, Marc Cooper wrote:
> On 19/06/13 18:33, Guillaume Lelarge wrote:
> > On Wed, 2013-06-19 at 10:39 +0100, Marc Cooper wrote:
> >> On 18/06/13 22:33, Guillaume Lelarge wrote:
> >>> On Tue, 2013-06-18 at 22:19 +0100, Marc Cooper wrote:
> >>>> On 18/06/13 22:12, Guillaume Lelarge wrote:
> >>>>> On Fri, 2013-06-14 at 19:32 +0100, Marc Cooper wrote:
> >>>>>> Hi,
> >>>>>>
> >>>>>> When in the SQL editor, I can no longer add queries to my favourites.
> >>>>>>
> >>>>>> I have added entries in the past, and I can see these and access them,
> >>>>>> but I can no longer add new entries as the menu item "Add favourite..."
> >>>>>> is greyed out and disabled.
> >>>>>>
> >>>>>
> >>>>> It's disabled if you have no text in the query textbox. AFAICT, that's
> >>>>> the only reason explaining why it is disabled.
> >>>>
> >>>> Well, clearly I have a query that I'm trying to save.
> >>>>
> >>>> The problem is that the "Add favourite..." never becomes available.
> >>>>
> >>>> Is there somewhere I can report a bug? There doesn't appear to be
> >>>> anywhere on github, as far as I can see.
> >>>>
> >>>
> >>> This is where you report a bug. Unfortunately, without having a way to
> >>> reproduce your bug, a report won't get you anywhere.
> >>
> >> Ok. I purged pgadmin, located any remaining files and directories
> >> containing the string pgadmin, and reinstalled pgadmin.
> >>
> >> I added a server, opened a database, and opened the query tool. This
> >> opened a modal window that says, "Failed to read favourites file!".
> >>
> > 
> > Sounds wrong. It works for me with no file. What is the version of your
> > libxml library?
> 
> From the package meta: 2.7.8.dfsg-5.1ubuntu4.4
> 
> >> So, I opened Options, navigated to Query Tool/Favourites, which has the
> >> entry: "/home/marc/.pgadminfavourites"
> >>
> >> Sure enough, this files doesn't exist.
> > 
> > Be careful. It says that it cannot read it. Not that it cannot find it.
> 
> Sure. But it can't read it when it when it's not there :-/ However, as
> I mentioned before, some time in the past I was able to write to it, so
> I have a readable version available.
> 
> >>  So, I did:
> >>  $ touch /home/marc/.pgadminfavourites
> >>  $ chmod 664 /home/marc/.pgadminfavourites
> >>
> >> Then I restarted pgadmin.
> >>
> >> Following the same steps as above, the same modal window with the same
> >> message appears: "Failed to read favourites file!".
> >>
> > 
> > Sure, it expects to find an XML document in it. It cannot parse an empty
> > file.
> 
> Fair enough.
> 
> >> Clearly, the file now exists. Indeed, Options/Query Tool/Favourites has
> >> it selected.
> >>
> >> In addition, in ~/.pgadmin3, this line appears:
> >>
> >>   FavouritesFile=/home/marc/.pgadminfavourites
> >>
> >> Here are the pgadmin config files thus far:
> >>
> >> $ ls -la .pgadmin*
> >> -rw-rw-r-- 1 marc marc 5485 Jun 19 10:27 .pgadmin3
> >> -rw-rw-r-- 1 marc marc    0 Jun 19 10:26 .pgadminfavourites
> >> -rw-rw-r-- 1 marc marc  117 Jun 19 10:14 .pgadmin_histoqueries
> >>
> >> Any ideas? Thanks.
> >>
> > 
> > Try the file attached. It works for me.
> 
> Yes, this is readable. I can load the queries and open Manage Queries.
> But "Add favourite" is still greyed out, sadly.
> 

To be honest, I have no idea why.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com