Re: Announcing LedgerSMB 1.3.10 - next . .

[Philip Rhoades <..hidden..>]

Chris,


On 2012-02-05 02:35, Chris Travers wrote:
> On Sat, Feb 4, 2012 at 7:32 AM, Chris Travers 
> <..hidden..
> [2]> wrote:
>
> > On Sat, Feb 4, 2012 at 7:25 AM, Philip Rhoades <..hidden..
> > [1]> wrote:
> >
> > > Chris,
> > >
> > > On 2012-02-05 00:19, Chris Travers wrote:
> > > > so drop tablefunc_crosstab_2, tablefunc_crosstab_3, and
> > > > tablefunc_crosstab_4 from template1.
> > >
> > > Did that as we went before . .
> > >
> > > > Then you should be good.
> > >
> > > NOTICE: ÂCREATE TABLE / PRIMARY KEY will create implicit index
> > > "menu_acl_pkey" for table "menu_acl"
> > > ERROR: Âfunction connectby(text, text, text, text, text,
> > > integer, text)
> > > does not exist
> > > LINE 5: Â FROM (connectby(menu_node::text, id::text,
> > > parent::t...
> > > Â Â Â Â Â Â Â Â ^
> > > HINT: ÂNo function matches the given name and argument types.
> > > You might
> > > need to add explicit type casts.
> > > ERROR: Âcurrent transaction is aborted, commands ignored until
> > > end of
> > > transaction block
> > > ERROR: Âc . .
> >
> > Can you successfully create extension in a new database?


-bash-4.2$ dropdb ext_test
-bash-4.2$ createdb ext_test
-bash-4.2$ psql ext_test
psql (9.1.2)

ext_test=# CREATE EXTENSION connectby;
ERROR:  could not open extension control file 
"/usr/share/pgsql/extension/connectby.control": No such file or 
directory
ext_test=#


> > I know you say you need to get this up shortly. ÂIf we cant resolve
> > it like this I could open a paid support case for you. ÂI could
> > probably take it up tomorrow night. Â(I could email you my ssh key
> > if you need it).
> >
> > BEST WISHES,
> > Chris TraversÂ
> >
> > > > I will probably look at documenting this since it may bite
> > > other
> > > > people. ÂI am wondering if this was restored from an update.
> > > ÂIf
> > > > not, I wonder if something crazy is going on with the package
> > > you are
> > > > using. ÂOn the latter, I suppose only time will give us a
> > > pattern of
> > > > other failures.
> > >
> > > Thanks,
> > >
> > > Phil.
> > > --
> > > Philip Rhoades
>
> Of course if we arent to that point I would be happy to keep helping
> you out this way too.


It is starting to be too hard/slow - maybe my best option is to set up 
a virtual Fedora 16 x86_64 machine and install there and worry about 
re-integrating into my production machine sometime later?  Then, at 
least, I could start getting the accounting done . .

Thanks,

Phil.
--
Philip Rhoades

GPO Box 3411
Sydney NSW	2001
Australia
E-mail:  ..hidden..