Erik Huelsmann | 30 Apr 20:07 2016

LedgerSMB 1.4.28 released

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application. This release
contains the following fixes and improvements:

Changelog for 1.4.28
* Fix for 1.3 to 1.4 migration of recurring table data (David G, #1447)
* Support for fixing up data in migrations using drop-downs (Yves L)
* Fix Upgrade_Tests validation complaint on valid GIFI data (Erik H, #1443)
* Fix number formatting on locale with comma as decimal separator (Erik H)
* Fix performance issue in General Joural > Chart of Accounts screen (Erik H)
* Fix being able to close periods - regression from 1.3 (Erik H)

David G is David Godfrey
Yves L is Yves Lavoie
Erik H is Erik Huelsmann

The release can be downloaded from sourceforge at
  https://sourceforge.net/projects/ledger-smb/files/Releases/1.4.28/

These are the sha256 checksums of the uploaded files:
7c688a36c9ed37bda110a386fb16fb0c8660a5ffb008d2780aaf8a9ba90a0531  ledgersmb-1.4.28.tar.gz
64076dda805f5075295524f4ed8d47d0ecff7a20dc71db1a2340b396c23fedb0  ledgersmb-1.4.28.tar.gz.asc

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
(Continue reading)

Marjanw | 30 Apr 14:58 2016
Picon

LSMB Update from git;

Hi,

Can I update my LSMB installation using git?
That could be a nice alternative from downloading and extracting tar archives.
I would allow you to easily switch back to the previous version if something
doesn't work well.

It requires all user config must be out of the git repo, but that's not too
complicated.
In the deb package all config dirs (userspath, templates,,) are defined in
the "ledgersmb.conf" to other locations.

Only the "ledgersmb.conf" itself should be renamed in "ledgersmb.conf.template".
Than as in the deb package the active "ledgersmb.conf" can be stored elsewhere:

   ledgersmb.conf -> /opt/ledgersmb/conf/

Regards,

Marjan Waldorp
Tux4u

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Marjanw | 30 Apr 14:20 2016
Picon

prepare-company-database.pl

Hi Erik,

If you're fixing the "prepare-company-database.pl" script, can you relieve
the requirement of running from the LSMB source dir?

# ./prepare-company-database.pl
Can't locate LedgerSMB/Database.pm in  <at> INC (you may need to install the LedgerSMB::Database module)

Thanks,

Marjan

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
David Godfrey | 30 Apr 08:02 2016
Picon

Re: Bugs setting up a company database;

Hi Marjan,

On 29/04/16 22:09, Erik Huelsmann wrote:
Hi Marjan,

On Wed, Apr 27, 2016 at 5:30 PM, Marjanw <pr002603-ilmwzsczgLKG5XvV6lv2jw@public.gmane.org> wrote:
Hi all,

Before submitting bugs and/or feature requests on github I'd like to share
my experiences on this mailing list.

Thanks for taking the time to write up your installation experience! It's definitely an experience we can learn from.
 
Since I wanted the most recent LSMB version I choose to download the tar
archive (1.4.27) from Sourceforge.
I used the INSTALL file for the installation instructions.
Instead using the Debian packages I used cpanmin.us to install all
required Perl modules.

* My two cents: Move Perl the module dependency list out of the INSTALL.md
  into a separate file which can be fed to cpanminus.

It's an option, but I'm not even very hot about listing the dependencies in the INSTALL file: too much room for the various lists to get out of sync. The canonical listing of dependencies is in Makefile.PL. Would it be acceptable to refer to that from INSTALL?
One thing you may or may not be aware of (that we could add to the docs) is that you can install all dependencies without copy/pasting from INSTALL by using the command

  LedgerSMB-1.4.27$ cpanm --install-deps .
Be Aware, --install-deps installs *ALL* dependencies for ALL perl modules that LedgerSMB uses.
This may actually be not what you want as there are a *LOT* of extra modules installed that we don't really need.
eg: YAML::Syck, File::Slurp, JSON::MaybeXS, and many many others.
It also installs the Testing infrastructure packages that we use for development like Test::BDD::Cucumber

Some of the package installs may fail as well, which prevents further packages from installing.
In the case of the test I just ran Test::BDD::Cucumber failed in this case caused by an error installing YAML-Syck-1.29 because I don't have a C complier on that System

As far as I know we don't actually need Test::BDD::Cucumber on a production installation so this error only serves to prevent the rest of the dependencies from being installed.

We may be able to solve this by changing the way we include modules like Test::BDD::Cucumber, but I'll leave that to Erik to resolve as he knows the most about our current requirements.

There is also an install script in utils/install/lsmb-install.sh on master that handles 99% of use cases.
It's currently a little crude in the way it's written, and is targeted at Debian based systems but if you choose not to install the .deb packages when asked and instead install them yourself using your normal system tools, then it should work on most modern *nix systems.

I will be merging a new version of the install script hopefully this weekend, it fixes a couple of minor issues and adds some improvements.
If you use it please let me know, or better yet drop in on IRC via https://vector.im/#/room/#ledgersmb:matrix.org and chat with me so I can point you at the fix I've done (affects creation of the database admin user)
I'm normally known as dcg_mx on IRC although I will sometimes show as M-dcg


Would that be an acceptable alternative, in your opinion?
 
Then I stumbled over the section "Initializing a company database".
First I tried setting up a database using "setup.pl" via the browser,
but failed since I missed the trick of specifying a non-existant
company name.

* For all stupid users like me, it might be a good idea to add a
  menu button "create new company database" in setup.pl

Excellent. I've implemented this both for master/1.5 and 1.4 today. Since 1.4 changes are frozen for the 1.4.28 release, your proposal will be part of 1.4.29 -- in roughly 2 weeks.

Peeking in the actual INSTALL.md on github learned that above issue
has been addressed: a paragraph was added to demystify this.

* Please backport this paragraph to the 1.4.27 INSTALL file

I'll do that before the 1.4.28 release, but the paragraph might need to be adjusted because we have the "Create" button now?
 
Since setup.pl failed I tried to create the company database using
the "prepare-company-database.sh" script.

Ok. I'm correct to understand that *if* you had known about the trick of filling out a non-existing database, you wouldn't have gone down this route and setup.pl would not have failed, or is setup.pl still failing even though you now know about the non-existing database trick?
 
No luck!
It emerged this script has several bugs:

209: su -c ""
The su lacks the argument of the Linux user "postgres".
This causes the script to fail: "Peer Authentication failed"

254: if ! test "x$pgsql_contrib_dir" = "xignored"
Typo. Should be: if ! test "x$pgsql_contrib_dir" = "xignore"

288: person__save(NULL,
pgsql function "person__save" fails because in LSMB 1.4 two new args
were added to this function.
As a result no "admin" user is created, rendering the DB unusable
for login.

In commit 7d09fc9d (2015-11-21 Erik Huelsmann) the script
"prepare-company-database.sh" has been dropped completely.
However:

* INSTALL.md still refers to the non-existing script
  "prepare-company-database.sh"

Ok. Given the bugs you list and the fact that the script is gone from master/1.5, I'd say we should remove the script from 1.4.29+ as well. Changing the documentation should happen on master/1.5 as well as 1.4 and can probably be done before 1.4.28. I'll get it done before the release.
 
It seems the shell script "prepare-company-database.sh" has been
replaced by it Perl variant "prepare-company-database.pl".
So I gave that script a try.

Right. Well, actually that script was implemented along-side of prepare-company-database.sh and is distributed in 1.4 as well as master/1.5. There's no problem to delete the .sh script in 1.4, but regardless, it seems from your experience below that the script needs to be tested and fixed too.
 
But alas, the A's were not in my cards:

# ./tools/prepare-company-database.pl --company tuxtest2 --coa /usr/share/ledgersmb/sql/coa/be/chart/G
eneral.sql --password LSMB
DBI connect('dbname=tuxtest2','',...) failed: fe_sendauth: no password supplied at ./tools/prepare-com
pany-database.pl line 159.
Can't call method "prepare" on an undefined value at ./tools/prepare-company-database.pl line 164.

I stopped hacking here.

Right. Understandably. Thanks again for reporting your problems. I hope the documentation improvements in 1.4.28 and the "Create" button in 1.4.29 take us a good step toward being self-explanatory.

Please report any future problems either here or in the GitHub issue tracker!


--
Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.


Regards
David G

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Marjanw | 27 Apr 17:30 2016
Picon

Bugs setting up a company database;

Hi all,

Before submitting bugs and/or feature requests on github I'd like to share
my experiences on this mailing list.

Since I wanted the most recent LSMB version I choose to download the tar
archive (1.4.27) from Sourceforge.
I used the INSTALL file for the installation instructions.
Instead using the Debian packages I used cpanmin.us to install all
required Perl modules.

* My two cents: Move Perl the module dependency list out of the INSTALL.md
  into a separate file which can be fed to cpanminus.

Then I stumbled over the section "Initializing a company database".
First I tried setting up a database using "setup.pl" via the browser,
but failed since I missed the trick of specifying a non-existant
company name.

* For all stupid users like me, it might be a good idea to add a
  menu button "create new company database" in setup.pl

Peeking in the actual INSTALL.md on github learned that above issue
has been addressed: a paragraph was added to demystify this.

* Please backport this paragraph to the 1.4.27 INSTALL file

Since setup.pl failed I tried to create the company database using
the "prepare-company-database.sh" script.
No luck!
It emerged this script has several bugs:

209: su -c ""
The su lacks the argument of the Linux user "postgres".
This causes the script to fail: "Peer Authentication failed"

254: if ! test "x$pgsql_contrib_dir" = "xignored"
Typo. Should be: if ! test "x$pgsql_contrib_dir" = "xignore"

288: person__save(NULL,
pgsql function "person__save" fails because in LSMB 1.4 two new args
were added to this function.
As a result no "admin" user is created, rendering the DB unusable
for login.

In commit 7d09fc9d (2015-11-21 Erik Huelsmann) the script
"prepare-company-database.sh" has been dropped completely.
However:

* INSTALL.md still refers to the non-existing script
  "prepare-company-database.sh"

It seems the shell script "prepare-company-database.sh" has been
replaced by it Perl variant "prepare-company-database.pl".
So I gave that script a try.
But alas, the A's were not in my cards:

# ./tools/prepare-company-database.pl --company tuxtest2 --coa /usr/share/ledgersmb/sql/coa/be/chart/G
eneral.sql --password LSMB
DBI connect('dbname=tuxtest2','',...) failed: fe_sendauth: no password supplied at ./tools/prepare-com
pany-database.pl line 159.
Can't call method "prepare" on an undefined value at ./tools/prepare-company-database.pl line 164.

I stopped hacking here.

Regards,

Marjan Waldorp
Tux4u

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Erik Huelsmann | 27 Apr 16:47 2016
Picon
Gravatar

[Notification for translators] LedgerSMB 1.4.28-rc2 released

Hi all,

As per the message below, I've just uploaded the 1.4.28-rc2 package, which means that Transifex (https://www.transifex.com/ledgersmb/ledgersmb/) will be updating any outdated translations in the next 24 hours.

Please update translations before Saturday 19.00CET for changes you want incorporated in 1.4.28.

On a related note: for those who want to contribute to the project: our project has 45 translations registered, with 33 translations partially completed, but unmaintained. Among these are Swedish, Finnish, Spanish and French. Please feel free to sign up as a translator, even if you can only translate a few strings per week. Your translations for 1.4.x are automatically copied to 1.3.x and 1.5.x by Transifex, so while the total translation corpus is ~13'000 strings, effectively only some 4'200 need to be translated.


Thanks!


Regards,


Erik.

---------- Forwarded message ----------
From: Erik Huelsmann <ehuels-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
Date: Wed, Apr 27, 2016 at 4:35 PM
Subject: LedgerSMB 1.4.28-rc2 released
To: Development discussion for LedgerSMB <ledger-smb-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org>


Hi,

I've just uploaded 1.4.28-rc2 with the intent to release it as 1.4.28, barring any major regressions. This is the intended release note:

===============
The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application. This release
contains the following fixes and improvements:

Changelog for 1.4.28
* Fix for 1.3 to 1.4 migration of 'recurring' table data (David G, #1447)
* Support for fixing up data in migrations using drop-downs (Yves L)
* Fix Upgrade_Tests validation complaint on valid GIFI data (Erik H, #1443)
* Fix number formatting on locale with comma as decimal separator (Erik H)
* Fix performance issue in General Joural > Chart of Accounts screen (Erik H)
* Fix being able to close periods - regression from 1.3 (Erik H)

David G is David Godfrey
Yves L is Yves Lavoie
Erik H is Erik Huelsmann
===============


Please test and report your findings!

--
Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.



--
Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@...
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Arne Hanssen | 16 Apr 12:37 2016
Picon

Upgrading 1.3.47 to 1.4.27: No duplicate meta_numbers.

Hi.  I'm trying to upgrade on my Xubuntu Linux 15.10 system, my second 
attempt.  This time all goes well until running setup.pl. After logging 
in and answering Yes to upgrade from 1.3 I get this response:
-----------------------------------------
No duplicate meta_numbers
Make sure all meta numbers are unique.

meta_number        description
[00000]
[00000]

[Save and Retry]
-----------------------------------------
(The brackets around '00000' is to illustrate that both these are inside 
a box, 'Save and Retry' is a button).

How can I fix this?  Everything is running on my PC (localhost), but I'm 
using virtual host 'ledgersmb' (which also is 127.0.0.1) - worked ok in 
1.3.47.

Apache2 error log looks like this:

[Sat Apr 16 11:46:19.337846 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: DBD::Pg::st execute failed: ERROR: function 
public.setting_get(unknown) does not exist: 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.337880 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: LINE 1: SELECT * FROM 
"public"."setting_get"('ignore_version'): 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.337887 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215:                       ^: 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.337908 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: HINT:  No function matches the given name and 
argument types. You might need to add explicit type casts. at 
LedgerSMB.pm line 577.: /mnt/home/www/ledgersmb/login.pl, referer: 
http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338105 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
LedgerSMB::dberror LedgerSMB.pm (761) -- Logging SQL State 42883, error 
7, string ERROR:  function public.setting_get(unknown) does not exist: 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338123 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: LINE 1: SELECT * FROM 
"public"."setting_get"('ignore_version'): 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338130 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215:                       ^: 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338147 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: HINT:  No function matches the given name and 
argument types. You might need to add explicit type casts.: 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338201 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
LedgerSMB::_error LedgerSMB.pm (639) -- Internal Database Error: 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338218 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: More information has been reported in the 
error logs at LedgerSMB.pm line 764.: /mnt/home/www/ledgersmb/login.pl, 
referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338272 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
LedgerSMB::_error LedgerSMB.pm (640) -- dbversion: 1.4.27, company: 
postgres: /mnt/home/www/ledgersmb/login.pl, referer: 
http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338696 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
LedgerSMB::_error LedgerSMB.pm (639) -- exit at LedgerSMB.pm line 653.: 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338772 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: 2016/04/16 11:46:19 - ERROR - 
LedgerSMB::_error LedgerSMB.pm (640) -- dbversion: 1.4.27, company: 
postgres: /mnt/home/www/ledgersmb/login.pl, referer: 
http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338794 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: exit at LedgerSMB.pm line 653.: 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:19.338808 2016] [cgi:error] [pid 28432] [client 
127.0.0.1:42510] AH01215: Compilation failed in require at 
/mnt/home/www/ledgersmb/login.pl line 8.: 
/mnt/home/www/ledgersmb/login.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:26.924842 2016] [cgi:error] [pid 28434] [client 
127.0.0.1:42542] AH01215: LedgerSMB::Upgrade_Tests=HASH(0x9785720) at 
LedgerSMB/Scripts/setup.pm line 654.: /mnt/home/www/ledgersmb/setup.pl, 
referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:46:26.924879 2016] [cgi:error] [pid 28434] [client 
127.0.0.1:42542] AH01215: LedgerSMB::Upgrade_Tests=HASH(0x9785720) at 
LedgerSMB/Scripts/setup.pm line 654.: /mnt/home/www/ledgersmb/setup.pl, 
referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:47:09.375897 2016] [cgi:error] [pid 28451] [client 
127.0.0.1:42548] AH01215: 1 at LedgerSMB/Scripts/setup.pm line 710.: 
/mnt/home/www/ledgersmb/setup.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:47:09.376878 2016] [cgi:error] [pid 28451] [client 
127.0.0.1:42548] AH01215: 2 at LedgerSMB/Scripts/setup.pm line 710.: 
/mnt/home/www/ledgersmb/setup.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:47:09.377143 2016] [cgi:error] [pid 28451] [client 
127.0.0.1:42548] AH01215: 3 at LedgerSMB/Scripts/setup.pm line 710.: 
/mnt/home/www/ledgersmb/setup.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:47:09.379524 2016] [cgi:error] [pid 28451] [client 
127.0.0.1:42548] AH01215: DBD::Pg::db begin_work failed: Already in a 
transaction at LedgerSMB/Scripts/setup.pm line 717.: 
/mnt/home/www/ledgersmb/setup.pl, referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:47:09.388428 2016] [cgi:error] [pid 28451] [client 
127.0.0.1:42548] AH01215: LedgerSMB::Upgrade_Tests=HASH(0xa56fb68) at 
LedgerSMB/Scripts/setup.pm line 654.: /mnt/home/www/ledgersmb/setup.pl, 
referer: http://ledgersmb/setup.pl
[Sat Apr 16 11:47:09.388448 2016] [cgi:error] [pid 28451] [client 
127.0.0.1:42548] AH01215: LedgerSMB::Upgrade_Tests=HASH(0xa56fb68) at 
LedgerSMB/Scripts/setup.pm line 654.: /mnt/home/www/ledgersmb/setup.pl, 
referer: http://ledgersmb/setup.pl

--

-- 
Best regards
Arne Hanssen

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
Erik Huelsmann | 10 Apr 14:00 2016

LedgerSMB 1.4.27 released

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application. This release
contains the following fixes and improvements:

* Added note to batch list that all are locked (Chris T)
* Allow multiple logins per user, all with own locks (Chris T, #1418)
* Fixes meaningless subtotals on recon search results (Chris T, #995)
* SQL Ledger 3.0 migration support (Yves L/Erik H)
* Fix random column ordering in PNL & B/S comparison (Yves L)

 Special thanks to Stig Berg for finishing the Norwegian Bokmal translation

Chris T is Chris Travers
Yves L is Yves Lavoie
Erik H is Erik Huelsmann

The release can be downloaded from sourceforge at
  https://sourceforge.net/projects/ledger-smb/files/Releases/1.4.27/

These are the sha256 checksums of the uploaded files:
d12d846a4813785139b96c58f9d71dbd843c9743f1d9ac04bc1bec25be668a1b  ledgersmb-1.4.27.tar.gz
724ee1e6937bc340cbf390f52c8e5b7570060edad21c7a718184667f8f2e7e0d  ledgersmb-1.4.27.tar.gz.asc

------------------------------------------------------------------------------
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/
gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532
Nicolas Couchoud | 31 Mar 21:36 2016

Problems with AP transactions

  Hi,

  I just began using LedgerSMB. I have version 1.3.46 packaged by Debian
jessie-backports.
  I have two problems with my first AP transaction :
1) In the reports (General Journal -> Reports or Reports -> Chart of
accounts), in the description field, I obtain the name of the vendor,
instead of the description I wrote when editing the transaction.

2) When trying to post the paying of the transaction (Cash -> Payment), I
obtain an Internal server error, and the Apache logs contain this :

[Thu Mar 31 21:24:11.120351 2016] [cgi:error] [pid 25942] [client
129.199.61.141:1789] AH01215: Can't use string ("{}") as an ARRAY ref while
"strict refs" in use at LedgerSMB/DBObject/Payment.pm line 800., referer:
https://www.archicubes.ens.fr/ledgersmb/payment.pl
[Thu Mar 31 21:24:11.120406 2016] [cgi:error] [pid 25942] [client
129.199.61.141:1789] AH01215: Compilation failed in require at
/usr/share/ledgersmb/payment.pl line 8., referer:
https://www.archicubes.ens.fr/ledgersmb/payment.pl
[Thu Mar 31 21:24:11.140593 2016] [cgi:error] [pid 25942] [client
129.199.61.141:1789] Premature end of script headers: payment.pl, referer:
https://www.archicubes.ens.fr/ledgersmb/payment.pl

This second problem is, of course, much more annoying because it seems I
just cannot post the payment of a transaction !

  How can I solve this ?
  Thanks in advance for helping me !

  Regards.

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
Chris Bennett | 30 Mar 23:38 2016
Picon
Gravatar

Message I got about an open source survey

----- Forwarded mess

Date: Wed, 30 Mar 2016 14:48:38 +0000
From: 
To: 
Subject: Form forums.ledgersmb.org

[A_MailFromName]: Dominic Markowski
[J_MailFromAddress]: dominic.markowski <at> smail.inf.h-brs.de

Dear Sirs,

my name is Dominic Markowski, I'm a student at the Hochschule Bonn
Rhein Sieg University of Applied Sciences and I'm writing my master
thesis about innovation during development of open source business
application software.

A major part of my thesis depends on the analysis of the open source
communities. You received this e-mail, because I identified it, as the
major contact address of one of the projects, where I’m researching on.
Now I’m asking you, to take place in a survey and to distribute it in
your community. Here is the link:

http://limesurvey.j-source.de/index.php/848325?lang=en

The survey is available in English and German and takes 5 to 15
minutes. The results will be presented on an open source software
conference in Germany and on a System Science Conference in the USA
(if I get enough results). To increase the publicity of your software,
I need as much as replies as possible of your community.

Please let me know, if you are interested in the results of my elaboration.

Yours sincerely

Dominic Markowski

-

Sehr geehrte Damen und Herren,

mein Name ist Dominic Markowski, ich bin Student an der Hochschule
Bonn Rhein Sieg University of Applied Sciences und ich schreibe zur
Zeit meine Masterarbeit über Innovation bei der Entwicklung von Open
Source Unternehmenssoftware.

Ein wesentlicher Bestandteil meiner Arbeit basiert auf der Analyse von
Open Source Comminities. Sie erhalten diese E-Mail, da ich Sie als
Primäre Kontaktadresse von ei-nem der Projekte, die ich Erforsche,
identifiziert habe.

Ich möchte Sie bitten, an der folgenden Umfrage teilzunehmen und den
Link zur Um-frage in Ihrer Community zu verteilen. Hier ist der Link:

http://limesurvey.j-source.de/index.php/848325?lang=de

Die Umfrage ist in Englisch und Deutsch verfügbar und dauert 5 bis
15Minuten. Die Ergebnisse werden auf einer Open Source Software
Konferenz in Deutschland und auf einer Wirtschaftsinformatik-Konferenz
in den USA präsentiert (insofern genug Ergeb-nisse vorliegen). Zur
Erhöhung der Publicity Ihrer Software, benötige ich so viele
Rückmeldungen wie möglich aus Ihrer Community.

Falls Sie Interesse an den Ergebnissen haben, dann lassen Sie es mich wissen.

Mit freundlichen Grüßen

Dominic Markowski
[MailRequestName]: forums.ledgersmb.org
[MailRequestSubject]: Request from forums.ledgersmb.org Contact page.
----- End forwarded message -----

Link works, I did not take complete survey.
LedgerSMB was not listed, so I was unable to get past that question.

Not sure if it is spam or not.

Chris Bennett

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785471&iu=/4140
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
Arne Hanssen | 27 Mar 19:01 2016
Picon

Change description of gl transaction.

Is it possible to change the description of an entry in the gl table?
Seems like this has change some time ago.  I'm using 1.3.47 and I get 
this error:

# UPDATE gl SET description='Kont. Arne H.' WHERE id='630';

ERROR:  null value in column "person_id" violates not-null constraint
DETAIL:  Failing row contains (630, gl, 16-031, null, UPDATE, 2016-03-27 
17:45:33.702631, null, 2398).
CONTEXT:  SQL statement "INSERT INTO audittrail 
(trans_id,tablename,reference, action, person_id)
values (t_row.id,TG_RELNAME,t_reference, TG_OP, person__get_my_entity_id())"
PL/pgSQL function gl_audit_trail_append() line 19 at SQL statement

The contents is this:

# select * from gl where id='630';

  id  | reference |    description    | transdate  | person_id | notes | 
approved | department_id
-----+-----------+-------------------+------------+-----------+-------+----------+---------------
  630 | 16-031    | Kont. Arnstein I. | 2016-03-11 | |       | t        
|             0
(1 row)

This is not a big deal, I don't bother to make any correction 
transactions from within LSMB for this minor error, but it woud be nice 
to correct this in the db (as I now and then must do for transdate in 
table acc_trans when I forget to set correct date on save/post and 
today's date is used).  I used to correct dates i gl table also, but 
this isn't allowed enymore?

--

-- 
Vennlig hilsen / Best regards      |\     ___,,--,        _
Arne Hanssen, Senja, Norway        /,`--''        \-,,__,'/
[ Linux counter #102028  <at>  ]       |,4   ) )_    ) /~-----'
[ http://linuxcounter.net ]------'---^~(_/-_)--(_/_)-------
	

------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140

Gmane