Re: [Ledger-smb-users] 1.2.18 add user error

2009-09-23 Thread Luke
Please disregard--solved my own problem. Lack of sleepedness: while the dataset existed, it had not been "created" in database administration. I was also doing it slightly wrong--the username only method is intended to work for logging in, not for creations--have to include the @company1, @comp

[Ledger-smb-users] 1.2.18 add user error

2009-09-23 Thread Luke
Hello Received the following while trying to add a new user: Error! UPDATE defaults SET value = ? WHERE setting_key = ? ERROR: current transaction is aborted, commands ignored until end of transaction block That is while trying to add a user with the same name as an existing user

Re: [Ledger-smb-users] long part numbers

2009-09-23 Thread Stroller
On 23 Sep 2009, at 15:43, Joseph wrote: > ... > Here is a typical part number: > CP-D-1X4-1315-25%-900/250-1-1-LC/PCx1-4x60mm > > When I print in html to the screen it nicely splits into two lines > CP-D-1X4-1315-25%-900/250-1-1 > LC/PCx1-4x60mm > > so there is enough room for longer description.

Re: [Ledger-smb-users] rebuild tables with OIDS

2009-09-23 Thread Joseph
On 09/23/09 22:08, Michael Richardson wrote: >The only way I was able to do this was, for each table, create a new >table with a new name, insert into newtable from oldtable, and then >rename. I can't write the SQL from the top of my head, but if you like >I'll look it up. If you can gid out a l

Re: [Ledger-smb-users] rebuild tables with OIDS

2009-09-23 Thread Michael Richardson
> "Joseph" == Joseph writes: Joseph> I need to drop the tables and rebuild with OIDS, can anybody Joseph> refresh my memory how to do it? Joseph> I upgraded the Pg-tables.sql and trying to get rid of the Joseph> error: "ERROR: column "oid" does not exist" The only way I was

[Ledger-smb-users] rebuild tables with OIDS

2009-09-23 Thread Joseph
I need to drop the tables and rebuild with OIDS, can anybody refresh my memory how to do it? I upgraded the Pg-tables.sql and trying to get rid of the error: "ERROR: column "oid" does not exist" -- Joseph -- Come bui

Re: [Ledger-smb-users] long part numbers

2009-09-23 Thread Joseph
On 09/23/09 08:31, Stroller wrote: > >On 23 Sep 2009, at 06:48, Joseph wrote: >> 1.) Does anybody know how to modify tex-invoice template so it wraps >> a long part numbers the same way as html-invoice when printing to >> the screen? > >Hi, > >Sorry, can you explain what long part numbers are doing

[Ledger-smb-users] Registrar use case: a better way?

2009-09-23 Thread Luke
Hello One of my use cases for ledgersmb, is as the backend for a domain name registrar component of a larger business. So, customers buy one or more domains, for one or more years each. The company then pays registration fees to an up-stream registrar, and the customer gets his domain(s). I am

Re: [Ledger-smb-users] long part numbers, Letter paper size

2009-09-23 Thread Stroller
On 23 Sep 2009, at 06:48, Joseph wrote: > 1.) Does anybody know how to modify tex-invoice template so it wraps > a long part numbers the same way as html-invoice when printing to > the screen? Hi, Sorry, can you explain what long part numbers are doing at present? And what they do in the h