Two conflicting messages after a DB operation with negative result

[lorenzo51]

When executing an operation that violates either the referential integrity constraints (foreign key) or the unicity of an index I get two messages.
The first signals the error from the DB and that the operation was unsuccessful.
The second states that the operation was executed.
It is correct that the operation was not executed, however the second message creates confusion to the user.

 

[rob]

I've had a go at adding some rudimentary throw/catch error handling for the db insert/update code - so now if a db error occurs on storing the row the user is redirected back to the form and the db error message is shown.

 

[cheesegrits]

lorenzo - which engine are you using, InnoDB or MyISAM?

-- hugh

 

[lorenzo51]

Joomla installation is based on MyISAM tables, and the tables I've created for the lists are InnooDB.
However, after Rob's intervention answering the DB insert/update error issue, now I receive only the error message from the DB, I no longer receive the second notification message stating that the record had been inserted/updated, and that created confusion to end users.

 

[lorenzo51]

After installing the 3.07 version, the error appeared again!
Do we have any solution to this issue?
Thanks!

 

[cheesegrits]

Have you tried the latest github?

-- hugh

 

[lorenzo51]

Yes, I tried today with the latest version (Fabrik-fabrik-3.0.7-123-gf006394) and I still have the problem.