Description: I Libreoffice 6.0.7.3. Linux-mint 19.1 cinnamon MySQL Connector 1.0.2 MariaDB on a Synology Disk Station The only way I can delete a record is to open the Base-File, load the table and use the menu "delete record". All other ways I have tested did not work. The buttons on the bars I use to manage records are always inactive. Steps to Reproduce: 1.Create a form with the rights to delete records in a writer or calc documents drawpage with a one simple table. 2.Use a table control field and a navigation bar 3.Choose a record Actual Results: The Delete Button on the navigation bar is never active. You can't delete any record. Expected Results: The delete button on the navigation bar should be active and it should be possible to delete a record. Reproducible: Always User Profile Reset: No Additional Info: It must be a problem with the MySQL connector 1.0.2 because there is no such problem with other connectors. An other user has tested using Mint 18.3 with LO v6.2.3.2, MySQL and SDBC connector and have same result. Using a JDBC connector there was no problem. Edit: ODBC connector was also OK.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
@Andreas : As an ODB file on its own won't provide enough information, please provide the following further information: - type and version of database server backend ; - mariadb/mysql database dump or table schema or DDL so that we can try and reproduce the same data setup; The main difference, from a code perspective, between 6.0.7 and 6.2 is that the mariadb connector code got directly integrated into 6.2, whereas in 6.0.7 it was still built and packaged separately as an extension. From a UI perspective, is there any difference in behaviour if you switch to a different VCL backend, e.g. X11 instead of GTK3 (see how to set vcl backend when starting LO). Are the versions that were tested downloaded from TDF or are they packages provided by the Mint/Ubuntu packagers ? You mention that another user had a similar problem with Mint 18.3 and LO6232, but was this version an Ubuntu snap, or the TDF download ?
FWIW, I tested this with: Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.5 Threads CPU : 4; OS : Linux 4.15; UI Render : par défaut; VCL: gtk3; Locale : fr-FR (fr_FR.UTF-8); Calc: group Mysql server : remote instance MySQL 5.7.15 MariaDB native connector : 1.0.2 (default Mint package) and could not reproduce. 1) Opened an ODB file configured to connect to remote MySQL instance with native mariadb connector. 2) Opened a table in data edit mode 3) Right mouse button click on table entry at left hand side 4) Choose Delete record 5) Record deleted.
Further test with a form created from a table. 1) Create form from test table using form wizard. 2) Add default table grid control 3) Save form and open for data editing. 4) Select an entry in the table grid, right mouse button click, Delete 5) Record deleted successfully.
Further test: 1) Load form. 2) Choose record 3) Click on delete record toolbar button in Form navigation toolbar. 4) Confirm message to delete record 5) Record deleted I should have added that with the other tests, I was also asked if I was sure that I wanted to delete the record.
Thanks. I got an update (Version 5.5.62-0091) for MariaDB since and now (almost) all is working. I had this problem for several moths working with the newest updates with Linux-Mint and Synology Disk Stations MariaDB. I tryed to build a sample-table but it only worked properly with SQL-Code.
Somebody elsewhere on LO bugzilla had reported other issues with writing/deleting LO files to a Synology workstation share, so I'm assuming that the problem lies with Synology... Closing this as WFM