Re: [Ledger-smb-users] Upgrade to 1.4.33 Problems

2016-09-14 Thread Dave
Hi Erik, Thanks I must have missed that along the way. Ah well 1.3.48 it is. While the database upgrade is planned, they are much more complex and slower things. Thanks Dave On 09/13/2016 02:58 PM, Erik Huelsmann wrote: > > On Tue, Sep 13, 2016 at 10:27 PM, Dave Morgan <mailto

[Ledger-smb-users] Fwd: Re: Upgrade to 1.4.33 Problems

2016-09-13 Thread Dave
Hi Erik On 09/13/2016 02:17 PM, Erik Huelsmann wrote: > Hi Dave, > > Which PostgreSQL version? > Client is 9.2.15, server is 8.4. S Upgrading the server(s) is not an option at this time, unfortunately Thanks Dave > > On Sep 13, 2016 21:59, "Dave" <mailt

[Ledger-smb-users] Upgrade to 1.4.33 Problems

2016-09-13 Thread Dave
saction block psql:./Files.sql:398: ERROR: current transaction is aborted, commands ignored until end of transaction block psql:./Files.sql:400: ERROR: current transaction is aborted, commands ignored until end of transaction block ROLLBACK Any ideas? TIA Dave -- Dave Morgan Senior Consu

[Ledger-smb-users] Cannot find 1.3.48 download.

2016-09-11 Thread Dave
Hello All, I cannot find the last 1.3.x version referenced at http://ledgersmb.org/release/1348-released Latest on sourceforge is 1.3.47 Any ideas where to find a copy? I'm getting around to upgrading TIA Dave -- Dave Morgan Senior Consultant, 100 Alberta Limited dav

Re: [Ledger-smb-users] Filing a Bug Report(s)

2014-03-23 Thread Dave
Thanks Erik, As you saw I finally figured it out. :) Thanks for your help Dave -- Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph data

[Ledger-smb-users] Filing a Bug Report(s)

2014-03-23 Thread Dave
Hi All, I know I a luser :) but where and how do I file bug-reports. I finally have time to dump all the issues we have found with 1.3.37 I went to the SourceForge pages, but nowhere do I see "File or Create a Bug report"

Re: [Ledger-smb-users] General Ledger queries

2014-03-03 Thread Dave
, that will cause problems if you get audited. > OK, but could we get an expenses claim form integrated into the system All ready exists, your employees just invoice their expenses, create a custom invoice for them if the busines

Re: [Ledger-smb-users] Client Returning to 1.2.21

2014-02-12 Thread Dave
Chris, Erik, thank you very much for your responses, comments are inline On 02/11/2014 07:15 PM, Chris Travers wrote: > On Tue, Feb 11, 2014 at 1:07 PM, Erik Huelsmann <mailto:ehu...@gmail.com>> wrote: > Hi Dave, > Thanks for the feedback! My pleasure >

[Ledger-smb-users] Client Returning to 1.2.21

2014-02-11 Thread Dave
They are willing to deal with these issues A very minor issue that the users see as huge - link to return to the trial balance at top of the accounts pages is missing HTH Dave -- -- Android apps run on Bla

Re: [Ledger-smb-users] Migration scripts: Chicken and egg

2014-02-03 Thread Dave
pl and upgrade process from LedgerSMB 1.2.21 to 1.3.36 worked perfectly. The client is a pure services company so much of the inventory and shipping side is unused, however. HTH Dave -- Managing the Performance

Re: [Ledger-smb-users] can't search on transactions

2014-01-31 Thread Dave
On 01/30/2014 04:19 PM, Erik Huelsmann wrote: > Hi Dave, > Sorry about my terse reactions earlier today; wasn't near a good keyboard at > the time. Just got back to responding less tersely when your response came in > and I decided to respond to this mail instead > of yo

Re: [Ledger-smb-users] can't search on transactions

2014-01-30 Thread Dave
transdate, a.duedate, a.netamount, a.crdate, 979: SELECT a.id, a.invnumber, a.ordnumber, a.transdate, a.crdate, 1019:GROUP BY a.id, a.invnumber, a.ordnumber, a.transdate, a.crdate,

Re: [Ledger-smb-users] can't search on transactions

2014-01-30 Thread Dave
I am wary of what other issues may exist. Or should I just return to 1.2 and wait until 1.3 is ready? Dave -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you

[Ledger-smb-users] can't search on transactions

2014-01-30 Thread Dave
same as above AP-reports->Outstanding : Does not work if Detail is selected, Summary works and accepts date info etc. Ideas? Dave -- WatchGuard Dimension instantly turns raw network data into actionable security int

Re: [Ledger-smb-users] Centos 6.5 Install troubles - Solved

2014-01-29 Thread Dave
e first quoted line is the clue. I thought about why the library could not be found and realized that maybe pg-contrib needed to be installed on the database server. And now it all works :) Dave -- Dave Morgan Senior Consultant, 100 Alberta Limited da

[Ledger-smb-users] Centos 6.5 Install troubles

2014-01-28 Thread Dave
ERROR: current transaction is aborted, commands ignored until end of transaction block And many, many of these until psql:sql/Pg-database.sql:4776: ERROR: current transaction is aborted, commands ignored until end of transaction block # At this point the website displays t

[Ledger-smb-users] Customers drop down listbox

2012-03-18 Thread Dave Coventry
agine it's an oversight. Many thanks, Dave Coventry -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure ___

Re: [Ledger-smb-users] ERROR: Permission denied for ...

2012-03-18 Thread Dave Coventry
Well, this is beyond me. I've devoted the entire weekend to upgrading my database, but it looks as though it would have been far more efficient to enter all the information by hand. It's the customer database that I'm primarily interested in, but after repeatedly trying to import it, I have to gi

[Ledger-smb-users] ERROR: Permission denied for ...

2012-03-17 Thread Dave Coventry
ation account_heading I have a feeling my imported database has permission errors. Is there any way I can fix it up? ~ Dave -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-ms

Re: [Ledger-smb-users] LedgerSMB Install fails. Cannot find Contrib script tablefunc.control in /usr/share/pgsql/contrib/.

2012-03-16 Thread Dave Coventry
Thank you. :+) On 16 March 2012 07:23, Chris Travers wrote: > On Thu, Mar 15, 2012 at 7:56 PM, Håvard Sørli wrote: >> On 16. mars 2012 00:07, Chris Travers wrote: >>> On Thu, Mar 15, 2012 at 12:41 PM, Dave Coventry   >>> wrote: >>>> Installed ledgersmb

[Ledger-smb-users] LedgerSMB Install fails. Cannot find Contrib script tablefunc.control in /usr/share/pgsql/contrib/.

2012-03-15 Thread Dave Coventry
Installed ledgersmb 1.3.13 on a fresh install of Linux Mint and get the above error. Postgres version is 9.1.3 tablefunc.control is in /usr/share/postgresql/9.1/extension/tablefunc.control Many thanks, Dave -- This SF

Re: [Ledger-smb-users] 1.2.26 Release Candidate 1 Released

2011-11-03 Thread Dave Coventry
and occurs when "Update" is pressed. If the customer has previously been billed, then the Invoice is generated without error. Kind regards, Dave Coventry On 3 November 2011 11:32, Chris Travers wrote: > Hi all; > LedgerSMB 1.2.26 Release Candidate 1 has been released.  You can get it

Re: [Ledger-smb-users] New password required.

2011-10-20 Thread Dave Coventry
On 20 October 2011 11:45, Dave Coventry wrote: > Ok, I'll do that. > > > > On 20 October 2011 11:40, Chris Travers wrote: >> Actually I spoke too soon. >> >> This was fixed in 1.2.22.  Recommend upgrading to 1.2.25 immediately. >> Then we can figure

Re: [Ledger-smb-users] New password required.

2011-10-20 Thread Dave Coventry
Ok, I'll do that. On 20 October 2011 11:40, Chris Travers wrote: > Actually I spoke too soon. > > This was fixed in 1.2.22.  Recommend upgrading to 1.2.25 immediately. > Then we can figure out what we are doing with 1.3 :-) > > Best Wishes, > Chris Travers > > --

Re: [Ledger-smb-users] New password required.

2011-10-20 Thread Dave Coventry
abase, the hours are still at 1. (This is obviously running ledgersmb 1.2.22) On 20 October 2011 11:12, Chris Travers wrote: > Hi Dave; > > Two questions: > > 1)  What version of Perl are you running? > > 2)  Does the invoice post? > > This sounds like something that

Re: [Ledger-smb-users] New password required.

2011-10-20 Thread Dave Coventry
On 20 October 2011 10:30, Chris Travers wrote: > have you run this yet? > > sudo a2enmod rewrite Yes. Run it and restarted apache2. It does not seem to change anything. > Those errors appear where? On the ledgersmb 1.2.22 invoice page after I "Post" a new invoice. -

Re: [Ledger-smb-users] New password required.

2011-10-20 Thread Dave Coventry
Thanks Chris, your input is appreciated. On 20 October 2011 09:49, Chris Travers wrote: > Maybe it is connecting but hitting the old db and not finding the > proper user credentials? I can't run the setup.pl to set the database anyway. > Do you know if these are from LedgerSMB?  I doubt we are

Re: [Ledger-smb-users] New password required.

2011-10-19 Thread Dave Coventry
Hi Chris On 20 October 2011 07:52, Chris Travers wrote: > I would have expected more here.  What about the PostgreSQL error logs? Nothing much there: ~~~ 8X root@SNECCI:/opt# tail -f /var/log/postgresql/postgresql-8.4-main.log 2011-10-20 06:51:52

Re: [Ledger-smb-users] New password required.

2011-10-19 Thread Dave Coventry
Thanks Chris. I'm not sure which httpd you mean. tail -f /var/log/apache2/access.log: 8X ~~~ 127.0.0.1 - - [20/Oct/2011:07:31:50 +0200] "GET /ledgersmb/admin.pl HTTP/1.1" 401 363 "-" "Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.1 (KHTML, like Gecko) Ubuntu/11.10

[Ledger-smb-users] New password required.

2011-10-19 Thread Dave Coventry
that is the problem. Regards, Dave Coventry -- The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Ciosco

Re: [Ledger-smb-users] Importing Data

2011-10-04 Thread Dave Babb
Thanks Chris, My son in helping me too. You have given me what I need to know to move data at this time. If I do need to take it deeper (which I will if my customer accepts LedgerSMB), I'll post back for the specific URL on where to post. Thanks!

[Ledger-smb-users] Importing Data

2011-10-04 Thread Dave Babb
that would trigger SQL to generate this field? Or something else? Assistance will be appreciated. Sincerely and respectfully, Dave -- All the data continuously generated in your IT infrastructure contains a def

Re: [Ledger-smb-users] 1.3RC4 New DB

2011-10-04 Thread Dave Babb
I used the script to delete the database, then launched the setup.pl script from the web browser. Here is what happened. This is just an FYI. I can get back up and running by running the bsah scriptsBut you said to use one or the otherSo I choose to attempt to setup things in the web-brows

Re: [Ledger-smb-users] 1.3RC4 Installation Latest Log messages

2011-10-03 Thread Dave Babb
d submitt? Or a separate document on how to get LedgerSMB up and running under Debian? Again, Thank You! Dave PS: I wish you a safe flight! Minus being felt-out in the airport by TSA. :-) -- All the data continu

Re: [Ledger-smb-users] 1.3RC4 Installation Latest Log messages

2011-10-03 Thread Dave Babb
Roger that..Is there a way around it to setup the database type? -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, f

Re: [Ledger-smb-users] 1.3RC4 Installation Latest Log messages

2011-10-03 Thread Dave Babb
Here are the latest steps I've taken: a) Pulled from SVN b) Nuked the old "error.log" in acache's dirtree. c) Restart apache2 to re-initialize error.log, albeit empty. d) Used the "orthodox" script to delete the old company. e) Used the orthodox script to recreate the company. f) Went to this URL:

Re: [Ledger-smb-users] 1.3RC4 Installation Different Runtime Error

2011-10-03 Thread Dave Babb
user = admin pass = admin database = aci Thank you for the assistance in getting me up and running. Dave.. [Mon Oct 03 22:25:24 2011] [notice] Apache/2.2.16 (Debian) configured -- resuming normal operations DBD::Pg::st execute failed: ERROR: column "version" does n

Re: [Ledger-smb-users] 1.3RC4 Installation HTTP 404 issue help request Log messages

2011-10-03 Thread Dave Babb
hen the fixes. Thank You for the assistance. Sincerely and respectfully, Dave -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, secur

Re: [Ledger-smb-users] 1.3RC4 Installation HTTP 404 issue help request Log messages

2011-10-03 Thread Dave Babb
#/var/log/apache2/error.log [Mon Oct 03 20:56:48 2011] [notice] Apache/2.2.16 (Debian) configured -- resuming normal operations Can't open config file 'ledgersmb.conf' (no such file or directory) at LedgerSMB/Sysconfig.pm line 106 Compilation failed in require at lsmb-request.pl line 23. BEGIN

Re: [Ledger-smb-users] 1.3RC4 Installation HTTP 404 issue help request

2011-10-03 Thread Dave Babb
Jeff kindly pointed out that I had two "l"'s in the ledgersmb-httpd.conf file where the Alias is declared. Other than that being slightly embarrassing for me , That changed the behaviour to a 500 error. Again, help and assistance will be appr

Re: [Ledger-smb-users] 1.3RC4 Installation HTTP 404 issue help request

2011-10-03 Thread Dave Babb
t and editing of the file Dave -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and mor

[Ledger-smb-users] 1.3RC4 Installation HTTP 404 issue help request

2011-10-03 Thread Dave Babb
The Ol'e 404 Error. Distro: Debian Squeeze Installation path: "/usr/local/ledgersmb" URL's Failing: (none actually working) http://localhost/ledgersmb/setup.pl http://localhost/ledgersmb/login.pl I did chown -R the install dir with www-data:www-data. Apache is running. And has been restarte

[Ledger-smb-users] Migrating LedgerSMB

2010-11-19 Thread Dave Coventry
? ~ Dave Coventry -- Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time crea

[Ledger-smb-users] LedgerSMB and Postgre 8.4

2010-01-28 Thread Dave Coventry
? Considering the vintage of the installation. ~ Dave Coventry -- The Planet: dedicated and managed hosting, cloud storage, colocation Stay online with enterprise data centers and the best network in the business Choose

Re: [Ledger-smb-users] Import scripts

2008-08-21 Thread Dave Coventry
Date: Wed, 20 Aug 2008 08:24:38 -0700 From: "Chris Travers" <[EMAIL PROTECTED]> > There is no script however. What you need to do is: > 1) create a temporary table with the same column number as your > spreadsheet. Usually I use text fields for everything because I find > that is easier to deal w

[Ledger-smb-users] Import scripts

2008-08-20 Thread Dave Coventry
Hi, How is the repository of scripts coming on for Ledgersmb? I have a couple of spreadsheets with sales items, costs and prices. Is there a script that I can use to pull these into the Postgres database? Many Thanks, Dave Coventry

Re: [Ledger-smb-users] Data import Scripts

2008-07-15 Thread Dave Coventry
Any progress made on this? Many thanks, Dave Coventry 2008/7/11 Dave Coventry <[EMAIL PROTECTED]>: > Hi, > > Does the project have scripts to import cvs files into the postgres database? > > Regar

[Ledger-smb-users] Data import Scripts

2008-07-11 Thread Dave Coventry
Hi, Does the project have scripts to import cvs files into the postgres database? Regards, Dave Coventry - Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite

Re: [Ledger-smb-users] Access Denied on Administrator login

2007-12-08 Thread Dave Coventry
Gosh, Chris, that was quick! >Hmmm. That doesn't look like an MD5 sum to me :-) >UPDATE users_conf SET password = md5('uscvt4acutr'). In my defense, you had used square brackets after md5 in your original post, so I thought that it was a typo. Not a good excuse, I know Anyway, that

Re: [Ledger-smb-users] Access Denied on Administrator login

2007-12-07 Thread Dave Coventry
dgersmb # su ledgersmb Then UPDATE users_conf SET password = 'uscvt4acutr' WHERE id = (select id from users where username = 'admin'); Which generates the following error: ERROR: new row for relation "users_conf" violates check co

[Ledger-smb-users] Access Denied on Administrator login

2007-12-07 Thread Dave Coventry
can I change the administrator password? The ledgersmb.conf file contains the correct password. Regards, Dave Coventry - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to

Re: [Ledger-smb-users] Location of Database

2007-12-06 Thread Dave Coventry
Thank you Phil and Chris! I'll look into it. - SF.Net email is sponsored by: Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.

[Ledger-smb-users] Location of Database

2007-12-06 Thread Dave Coventry
Hi, I'm setting up a server which I've partitioned into /, /home and swap. I plan to keep, all data on the /home partition, is there a way I can specify that Postgres keeps it's database on that partition? Many Thanks,

Re: [Ledger-smb-users] Using Latex to create PDFs

2007-06-01 Thread Dave Coventry
king List" and the last lists configured printers. Does the middle drop-down give you Postscript & PDF options? There's also an HTML option on my system. see attached screenshots. The first has "Transaction" and "Receipt", no mention of "Invoice", "

Re: [Ledger-smb-users] Using Latex to create PDFs

2007-05-31 Thread Dave Coventry
ault extension: cls) Enter file name: snip= > Stroller. Thank you for your assistance. -- Dave Coventry Tel (home): +27(0)31 3092301 Tel (office): +27(0)31 2058448 Cell: +27(0)82 9000179 ---

Re: [Ledger-smb-users] Using Latex to create PDFs

2007-05-30 Thread Dave Coventry
As far as I can tell, it *is* installed. Stroller wrote: > On 30 May 2007, at 08:59, Dave Coventry wrote: > >> How do I set up Latex so that I can email pdfs? >> > > Install LaTeX via your distro's package manager and ensure that: > >$

[Ledger-smb-users] Using Latex to create PDFs

2007-05-30 Thread Dave Coventry
Hi, How do I set up Latex so that I can email pdfs? Thanks you. -- Dave Coventry Tel (home): +27(0)31 3092301 Tel (office): +27(0)31 2058448 Cell: +27(0)82 9000179 - This SF.net email is sponsored by DB2 Express

Re: [Ledger-smb-users] Tallying hours was - Re: drafting invoices

2007-03-22 Thread Dave Coventry
ure a draft Invoice would really help here either. David Tangye wrote: > On Thu, 2007-03-22 at 13:02 +0200, Dave Coventry wrote: > >> If I am doing a job for a client, I need to tally the hours that the job >> has taken on the invoice (plus any incidental expenses). >>

Re: [Ledger-smb-users] drafting invoices

2007-03-22 Thread Dave Coventry
business topics through brief surveys-and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > ___ > Ledger-smb-users mailing list > Le