[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Announcing LedgerSMB 1.3.10 - next . .



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..