On 20-Apr-09, at 7:12 AM, PCS-Lists wrote:
> when posting a journal entry appears this:
> Invalid SQL: INSERT INTO perp_bank_ledger
> (trans_id
> ,line_no,bank_account,exchange_rate,payment_method,amount,currency)
> VALUES (10,0,'150347',1,0,856,'BRL'):
> Unknown column 'line_no' in 'field list'
Your database has been badly damaged. I advise against attempting
manual repair until you have determined the source of the damage.
> then I created a column name:line_no, type:INT, lenght:11 and clear
> the
> entries of this table.
> when trying to post again:
>
> Invalid SQL: INSERT INTO perp_bank_ledger
> (trans_id
> ,line_no,bank_account,exchange_rate,payment_method,amount,currency)
> VALUES (11,1,'1503470',1,0,-856,'BRL'):
> Duplicate entry '11' for key 1
You missed adding your new column into the primary key.
Nathan Gray
nathan at goarctic dot com
------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today.
Use priority code J9JMT32.
http://p.sf.net/sfu/p_______________________________________________
Perp-developers mailing list
Perp-developers@...
https://lists.sourceforge.net/lists/listinfo/perp-developers
