After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 101234 - Cannot save bills/invoices using SQL (Postgres) backend
Cannot save bills/invoices using SQL (Postgres) backend
Status: VERIFIED DUPLICATE of bug 90375
Product: GnuCash
Classification: Other
Component: Backend - SQL
git-master
Other Linux
: Normal normal
: ---
Assigned To: linas
linas
Depends on:
Blocks:
 
 
Reported: 2002-12-14 23:24 UTC by Roy Nicholl
Modified: 2018-06-29 20:23 UTC
See Also:
GNOME target: ---
GNOME version: 1.4



Description Roy Nicholl 2002-12-14 23:24:10 UTC
When creating an invoice and using a tax table to caclulate the tax on sale or purchase, the 
invoice total may display (and use) more than two decimal places. 
 
When one then posts the bill/invoice, the following is produced: 
 
Enter: gnc_lot_init: (lot=0x837beb8, book=0x83b4de0) 
Leave: gnc_lot_init: (lot=0x837beb8, book=0x83b4de0) 
Enter: gnc_lot_add_split: (lot=0x837beb8, split=0x834ab28) 
Error: pgendStoreOneKVPtimespecOn...(): finish query failed: 
        ERROR:  value too long for type character(4) 
 
Error: pgendStoreAuditKVPtimespec...(): send query failed: 
        another command is already in progress 
 
Error: pgendGetCache: send query failed: 
        another command is already in progress 
 
Error: pgendGetCache: send query failed: 
        another command is already in progress 
 
Error: pgend_trans_commit_edit: send query failed: 
        another command is already in progress 
 
Enter: gnc_lot_remove_split: (lot=0x837beb8, split=0x834ab28) 
Warning: PrintAmountInternal: max_decimal_places too small; limit 2, value 75.0177 
Warning: PrintAmountInternal: max_decimal_places too small; limit 2, value 75.0177 
Warning: PrintAmountInternal: max_decimal_places too small; limit 2, value 75.0177 
 
Following such a post, the next time you try to save your data the followin error is produced 
and GnuCash opens a save as dialogue to allow you to save the data into a file. 
 
The server at URL 
 
postgres://localhost/mydata?mode=single-update experienced an error or encountered bad or 
corrupt data. 
 
Of course, when you re-start GnuCash, the incvoice/bill is not in the database.
Comment 1 Christian Stimming 2002-12-28 12:23:32 UTC
If I recall correctly, pretty much all of the new business features 
are *not yet* implemented by the SQL (Postgres) backend. It will 
likely take a few more months until somebody tackles that problem.
Comment 2 Chris Lyttle 2002-12-29 22:31:23 UTC

*** This bug has been marked as a duplicate of 90375 ***
Comment 3 John Ralls 2018-06-29 20:23:17 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=101234. Please update any external references or bookmarks.