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

Re: Announcing LedgerSMB 1.3.10 - next . .





On Sat, Feb 4, 2012 at 8:59 PM, Philip Rhoades <..hidden..> wrote:
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=#

It's the tablefunc extension.  That provides connectby().

Best Wishes,
Chris Travers 


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

------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users