Can't we have "download as tar.gz" from SVN web interface for bit less technical people or have a nightly built tar.gz updated and linked to website?
Just an idea. Regards On 6/7/07, Chris Travers <[EMAIL PROTECTED]> wrote: > Note that people who want the fix have three choices: > 1) Downgrade to 1.2.4 (if you don't need the performance or multibyte fixes) > 2) Download the Form.pm from > http://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2/LedgerSMB/ > 3) Let me know if these don't work for you and I will email the Form.pm > > Best Wishes, > Chris Travers > > On 6/7/07, Joshua D. Drake <[EMAIL PROTECTED]> wrote: > > Lana Brummett wrote: > > > My husband just looked at the query and made the following change: > > > > > > # diff LedgerSMB/Form.pm.orig LedgerSMB/Form.pm > > > 2399a2400 > > > > my $id_field = ( $vc eq 'customer' ) ? 'customer_id' : 'vendor_id'; > > > 2419c2420 > > > < WHERE ct.id <http://ct.id> = (select customer_id from > > > $arap where $where AND ${vc}_id IS NOT NULL order by id DESC limit 1)|; > > > --- > > > > WHERE ct.id <http://ct.id> = (select $id_field from > > > $arap where $where AND ${vc}_id IS NOT NULL order by id DESC limit 1)|; > > > > > > Was this the right thing to change or will this mess up something > > > somewhere else? It seems to have fixed my problem but I just want to > > > make sure that it will post right and that nothing else will break. > > > > > > > Yes. This is actually fixed in the upcoming 1.2.6. > > > > Joshua D. Drake > > > > > > > THanks again! > > > Lana > > > > > > On 6/7/07, *Lana Brummett* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> > > > wrote: > > > > > > We just switched over from sql-ledger 2.6.12 and we installed > > > ledgersmb 1.2.5 and I am trying to enter a vendor > > > invoice for the first time. I get this error: > > > > > > *DBD::Pg::st execute failed: ERROR: column "customer_id" does not > > > exist at character 189 > > > * > > > > > > > > > Error! > > > > > > * > > > SELECT ct.name <http://ct.name> AS vendor, ct.curr AS currency, > > > ct.id <http://ct.id> AS vendor_id, > > > current_date + ct.terms AS duedate, > > > ct.notes , > > > ct.curr AS currency > > > FROM vendor ct > > > WHERE ct.id <http://ct.id> = (select customer_id from ap where 1 = 1 > > > AND vendor_id IS NOT NULL order by id DESC limit 1) > > > ERROR: column "customer_id" does not exist at character 189 > > > > > > It looks to me like it should be saying "select vendor_id" and not > > > "select customer_id" but I can't see where this needs to be > > > changed. Any help would be appreciated! > > > > > > Thanks, > > > Lana ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
