Re: 42883:ERROR; expected 1.3.12 error

On Mon, Mar 12, 2012 at 3:43 PM, billy akazawa <..hidden..> wrote:

Dear Chris and Jame,
Thanks so much for your quick responses.
In answer to Jame's question, I'm more or less doing this manually. I'm not very familiar with Linux, so it's a real headache. I tried using the Ubuntu guide for 1.3, but the one I used had a problem with the ledgersmb.conf (it suggested changing a few lines in it and it took me a while to figure out that that I put my own bug into the installation by doing so).

Chris, your question about postgres led me to reinstall it and make sure I have the latest version (it was 8.3 before).
It also gave me the hint to search for the /tmp/dblog_stderr file which didn't exist.

I reinstalled Postgresql and now it's at version 8.4.11.

The switch to 8.4 got me past the database creation screens accessed from:

http://localhost/ledgersmb/setup.pl

It also generated the /tmp/dblog_stderr, dbblog, and dblog_stdout files in the tmp directory at the root level.

However, now the attempt to log into the created database from http://localhost/ledgersmb/login.pl generates this message:
Error!
Database is not the expected version. Was 1.3.0, expected 1.3.12. Please re-run setup.pl against this database to correct.

The /tmp/dblog_stderr file is long, but I noticed the following:
#########
psql:/usr/share/postgresql/8.4/contrib/pg_trgm.sql:29: ERROR: permission denied for language c
psql:/usr/share/postgresql/8.4/contrib/pg_trgm.sql:105: ERROR: must be superuser to create an operator class

psql:/usr/share/postgresql/8.4/contrib/tsearch2.sql:385: ERROR: permission denied for language internal

psql:/usr/share/postgresql/8.4/contrib/tsearch2.sql:399: ERROR: must be superuser to create an operator class

psql:/usr/share/postgresql/8.4/contrib/tsearch2.sql:444: ERROR: function show_curcfg() does not exist

LINE 3: ...pg_ts_config c on cfgparser = p.oid where c.oid = show_curcf...
^HINT: No function matches the given name and argument types. You might need to add explicit type casts.
psql:/usr/share/postgresql/8.4/contrib/tsearch2.sql:444: ERROR: function show_curcfg() does not exist

LINE 3: ...pg_ts_config c on cfgparser = p.oid where c.oid = show_curcf...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
psql:/usr/share/postgresql/8.4/contrib/tsearch2.sql:465: ERROR: function _get_parser_from_curcfg() does not exist
LINE 16: parse( _get_parser_from_curcfg(), $1 ) as p,^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
psql:/usr/share/postgresql/8.4/contrib/tsearch2.sql:546: ERROR: must be superuser to create an operator class
########

I'll try to attach the file to this e-mail.
I should mention that I chose "us" for the country (Japan wasn't listed) and that I have 2 languages on my machine English (US) and Japanese.
Thanks again!! At least now I feel as if I'm making some progress...
Billy

On Mon, Mar 12, 2012 at 9:04 AM, Robert James Clay <..hidden..> wrote:

billy,

On Sun, 2012-03-11 at 19:26 -0400, billy akazawa wrote:

> I've installed ledgersmb 1.3.12 on Squeeze.

How did you do the install? Manually, using the INSTALL
documentation?

One reason I ask is that I've been working on Debian packaging for
1.3.12 & I'm getting further into being able to use the application than
you appear to be, but I'm still seeing issues. (Online editing of
Stylesheets and Templates isn't working on a test install.)

Jame

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