Re: [Ledger-smb-users] Debian Squeeze - 1.3.1 - en_GB error

2011-10-20 Thread Chris Travers
On Thu, Oct 20, 2011 at 9:48 AM, Laurence Southon wrote: > Hi all, > > Managed to getting running on Debian Squeeze, but I get an error when > trying to set language to en_GB in user prefs: > > Error! > > 23503:ERROR: insert or update on table "user_preference" violates > foreign key constraint "u

[Ledger-smb-users] Debian Squeeze - 1.3.1 - en_GB error

2011-10-20 Thread Laurence Southon
Hi all, Managed to getting running on Debian Squeeze, but I get an error when trying to set language to en_GB in user prefs: Error! 23503:ERROR: insert or update on table "user_preference" violates foreign key constraint "user_preference_language_fkey" DETAIL: Key (language)=(en_GB) is not prese

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

2011-10-20 Thread Chris Travers
On Thu, Oct 20, 2011 at 3:14 AM, Dave Coventry wrote: > 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. >>>

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 out what we are doing with 1.3 :-) Chris, I us

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 Chris Travers
Hi Dave; For now, I'd recommend backing up your database so you can test a fix I will be working on. The best way to do this is to: createdb -U postgres -T old_dbname new_dbname Create a new test user that connects to this new db. I am going to try to get a fix out for these errors quickly. T

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

2011-10-20 Thread Chris Travers
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 -- The demand for IT networking profession

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

2011-10-20 Thread Dave Coventry
Chris, perl 5, version 12, subversion 4 (v5.12.4) built for i686-linux-gnu-thread-multi-64int The invoice appears to post but some of the information doesn't take. Foe example I edited it (before posting) to change the invoiced hours from 1 to four, and although the invoice is in the database, th

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

2011-10-20 Thread Chris Travers
Hi Dave; Two questions: 1) What version of Perl are you running? 2) Does the invoice post? This sounds like something that is likely to affect 1.3 and 1.2 equally. I think we can look at a bug fix quickly and push it to 1.2, 1.3, and trunk for this issue (and others as they come up). Best W

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 Chris Travers
On Thu, Oct 20, 2011 at 1:13 AM, Dave Coventry wrote: > 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 any

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-20 Thread Chris Travers
Ok, few points here. On Wed, Oct 19, 2011 at 11:13 PM, Dave Coventry wrote: > 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: Ok, This is odd. I would expect a failed connection to the