[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Error deleting account

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

 UPDATE parts
 SET inventory_accno_id = (SELECT value::int
 FROM defaults
 WHERE setting_key =
 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


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
Ledger-smb-users mailing list


      === 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

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/