Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Coredump when saving in the water editor #724

Open
mikfire opened this issue Mar 5, 2023 · 1 comment
Open

Coredump when saving in the water editor #724

mikfire opened this issue Mar 5, 2023 · 1 comment

Comments

@mikfire
Copy link
Contributor

mikfire commented Mar 5, 2023

To reproduce:

  1. Select any recipe
  2. Go to Tools -> Water Chemistry
  3. Select a base and target profile
  4. Add any salt
  5. click save
[09:44:34.936] (1diamhzmww) ERROR : int ObjectStore::impl::insertObjectInDb(QSqlDatabase&, const QObject&, bool) Error executing database query  "INSERT INTO salt (name, deleted, display, folder, addTo, amount, amount_is_weight, is_acid, percent_acid, stype) VALUES (:name, :deleted, :display, :folder, :addTo, :amount, :amount_is_weight, :is_acid, :percent_acid, :stype);" :  "ERROR:  column \"mash\" does not exist\nLINE 1: EXECUTE qpsqlpstmt_3 ('CaCl2', FALSE, TRUE, NULL, MASH, 0.00...\n                                                          ^\n(42703) QPSQL: Unable to create query"  [database/ObjectStore.cpp:756]
[09:44:34.937] (1diamhzmww) WARNING : Unable to free statement: ERROR:  current transaction is aborted, commands ignored until end of transaction block
  [:0]
[09:44:34.937] (1diamhzmww) ERROR : bool DbTransaction::commit() Unable to commit database transaction: "() QPSQL: Could not commit transaction"  [database/DbTransaction.cpp:67]
WARNING:  there is no transaction in progress
[09:44:34.939] (1diamhzmww) ERROR : int ObjectStore::impl::insertObjectInDb(QSqlDatabase&, const QObject&, bool) Error executing database query  "INSERT INTO salt (name, deleted, display, folder, addTo, amount, amount_is_weight, is_acid, percent_acid, stype) VALUES (:name, :deleted, :display, :folder, :addTo, :amount, :amount_is_weight, :is_acid, :percent_acid, :stype);" :  "ERROR:  column \"mash\" does not exist\nLINE 1: EXECUTE qpsqlpstmt_4 ('CaCl2', FALSE, TRUE, NULL, MASH, 0.00...\n                                                          ^\n(42703) QPSQL: Unable to create query"  [database/ObjectStore.cpp:756]
[09:44:34.940] (1diamhzmww) WARNING : Unable to free statement: ERROR:  current transaction is aborted, commands ignored until end of transaction block
  [:0]
[09:44:34.940] (1diamhzmww) ERROR : ASSERT: "!this->pimpl->allObjects.contains(primaryKey)" in file /home/mik/brewtarget/mik/src/database/ObjectStore.cpp, line 1224  [database/ObjectStore.cpp:1224]
@matty0ung
Copy link
Contributor

I couldn't reproduce this, and the error message is a bit puzzling. Am I right in remembering you run PostgreSQL? I'm wondering if there's some bug in the code that's supposed to abstract away that database-specific bits of SQL.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants