Mike Durian wrote: > I have just installed version 1.2.0 of ledger-smb on my FreeBSD box. > I'm running postgresql version 8.1.8. > > As part of my initial configuration, I am trying to delete some > accounts I do not need. However, the delete action is failing for > me. I get the following error: > > DBD::Pg::st execute failed: ERROR: syntax error at or near "WHERE" at > character > 179 > Error! > > UPDATE parts > SET inventory_accno_id = (SELECT value::int > FROM defaults > WHERE setting_key = > 'inventory_accno_id'):: > WHERE inventory_accno_id = ? > ERROR: syntax error at or near "WHERE" at character 179 > > > Is this a known problem? Is is operator error on my part? I did notice
This does not appear to be operator error. It appears to be a bug in the query. Let me take a look. > the COMPATIBILITY file said not to use postgresql 8.1.7. Is 8.1.8 another > version to avoid? No 8.1.8 is fine. Joshua D. Drake > > Thanks, > mike > > > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & 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 > [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/ ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & 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 [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
