Re: Error during setup

Chris,

I've gotten back to testing this installation and have found that I am not able to add contacts to the database. I am, however, able to add services and parts.

I mentioned in the initial email that I was not sure that the locale was set correctly. I've found that on the new installation that Collate and Ctype are both "C" rather than en_US.UTF8 as on another recent installation (on another machine with 1.4.17 release. I'm not sure where I've gone wrong in the installation of the database, so will look at correcting that. (If you have any suggestions, please let me know... again, this is my first experience with Arch linux).

Could this be the cause of not being able to save contacts in the database? I assumed that since I am not using non-ascii characters, I would not have an issue with 'C', for collate and Ctype, which I believe is equivalent to POSIX.

Thank you,

Jerry

On Fri, Nov 6, 2015 at 6:56 AM, JBash <..hidden..> wrote:

Sure.
This happened the first time I tried to run setup.pl after the installation. Ledgersmb went through the setup process as normal, creating the database, setting region, selecting templates to load, etc. The error then occurred when I tried to add a user for that company database. After entering the information, I got the error I sent in the first message in this thread. I don't think it matters, but the user I created was to have full permissions.

I got the same error the second time (after I stopped and restarted postgresql service). At that time I noticed in the logs that it was complaining that it was a duplicate user, so I tried adding a different user (same permissions), and it completed successfully.

Are the other postgressql errors in the log of concern. I have not looked at the logs yet from my debian installation, so don't know if I'm getting similar errors there. I was concerned that I was missing something or had mis-configured something with this installation.

Thanks again for you help.
Jery

On Thu, Nov 5, 2015 at 11:13 PM, Chris Travers <..hidden..> wrote:
Hi;

Looking a the logs I am still not sure where these are coming from. Could you walk me through what you did step by step and where the error occurred?

Best Wishes,
Chris Travers

On Thu, Nov 5, 2015 at 7:40 PM, JBash <..hidden..> wrote:
Hello,

I'm getting the following error when setting up a new database using ledgersmb 1.4.18. This is an install on a new machine that has not run ledgersmb previously.

This display on the browser:

Error!

25P02: ERROR: current transaction is aborted, commands ignored until the end of transaction block at LedgerSMB.pm line 770.

dbversion: 1.4.18, company:

And in the http server (apache 2.4) error log:

2015/11/05 18:19:06 - ERROR - LedgerSMB::_error LedgerSMB.pm (639) --
25P02:ERROR: current transaction is aborted, commands ignored until end of
transaction block at LedgerSMB.pm line 770.
2015/11/05 18:19:06 - ERROR - LedgerSMB::_error LedgerSMB.pm (640) --
dbversion: 1.4.18, company:
exit at LedgerSMB.pm line 653.
Compilation failed in require at /srv/http/domain3.com/ledgersmb/setup.pl line
8.

As I said earlier, this is a new machine running arch linux that I've not had ledger on in the past, so there may be some configuration issues. During the install of postgres, I had an issue getting the locale set correctly. Is it possible that is causing this problem?

Please let me know other areas that I may need to verify.

Thanks in advance for your help.
Jerry

------------------------------------------------------------------------------

_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

--
Best Wishes,
Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.
http://www.efficito.com/learn_more

------------------------------------------------------------------------------

_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users