Re: Error deleting account

["Joshua D. Drake" <..hidden..>]

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
> ..hidden..
> 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/