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 > > *-- > > Start your own business for $10, ask me how today!!! > > www.youravon.com/lanabrummett <http://www.youravon.com/lanabrummett> > > Having a party? Need a cake? Look no further, ask for details!!!! > > www.creativecakecreations.com <http://www.creativecakecreations.com> > > Call Today (847)687-5794 > > Proud mom to Samantha www.yetanotherdomain.org/samantha > > <http://www.yetanotherdomain.org/samantha> > > > > > > > > > > -- > > Start your own business for $10, ask me how today!!! > > www.youravon.com/lanabrummett <http://www.youravon.com/lanabrummett> > > Having a party? Need a cake? Look no further, ask for details!!!! > > www.creativecakecreations.com <http://www.creativecakecreations.com> > > Call Today (847)687-5794 > > Proud mom to Samantha www.yetanotherdomain.org/samantha > > <http://www.yetanotherdomain.org/samantha> > > > > > > ------------------------------------------------------------------------ > > > > ------------------------------------------------------------------------- > > 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 > > > -- > > === The PostgreSQL Company: Command Prompt, Inc. === > Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 > Providing the most comprehensive PostgreSQL solutions since 1997 > http://www.commandprompt.com/ > > Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate > PostgreSQL Replication: http://www.commandprompt.com/products/ > > > ------------------------------------------------------------------------- > 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 > ------------------------------------------------------------------------- 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
