| Summary: | EDITING: Cannot delete record | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Vince Radice <vhradice> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED INVALID | ||
| Severity: | normal | CC: | robert |
| Priority: | medium | ||
| Version: | 3.6.3.2 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | I am trying to delete one of the duplicate entries for Carrot and Celery soup. Here is the message I get. When I click Yes, nothing happens. | ||
Before you try to upload the file please run "SHUTDOWN COMPACT" as direct SQL-Command (Tools → SQL ...). You have written, that the file has about 780 MB?? Is that right? Never heard about such an expensive Database created with Base and the internal HSQLDB. Could it be that the table is linked to another table? Is "Merged"."ID" a foreign key for this other table? Then it could be you try to delete a row, which is used in another table and couldnt't be deleted. Is there really "nothing" to see after you have choosen "Yes" - not a popup with "Error deleting ..."? I was wrong. The file size as shown in Dolphin is 810 kb. As for an error popup , no, I do not get anything. What shows after I click Yes is the unchanged display from before trying to do the delete. There are 3 tables in the data base. Items, recipes, and Merged. Items and Recipes have unique keys. Merged is the relation ship between Items and Recipes. In Merged, Items and recipes are keys into the other tables. Merged.ID is not a key in a different table. I was also able to come up with more info. Using CALC, I exported all of the data from Merged into a spread sheet. I then found out that there were a lot of records with duplicate ID values. There are about 2,200 records in Merged. The highest value for id was around 1850. I did not actually count the number of duplicate records. I usually leave the data base up and open as I reference is a lot during the day. I have also had problems where LibreOffice crashes. When I restart, I get the Recovery screen where is recovers what I had open. Usually Base and 1 or 2 Calc spreadsheets. Where does Base keep the value to use for ID when I add another record? Is it possible that that value got compromised when Base crashed at some point? Using the data I had extracted to CALC, I was able to recreate the Merged table. I still have the bad table and I will upload it if necessary. I am also looking into changing from HSQL 1.8 to maybe hsql 2.2.9 If I can figure out what the conversion process entails. Could you please attach the database or send this as private mail to me? You write about duplicate "ID"-values. Isn't "ID" your primary key? Yes, ID was the key in the table. I had been having a number of crashes with 3.5 of LO due to a problem with a calculated field in a query. The problem was fixed by 3.6. I think that the crashes were the cause of my duplicate key situation. I had to rebuild my system after a file system failure. Unfortunately, I cannot find the version of the file that I had saved. I am afraid the I must close this ticket. As I said in one of my previous posts, I was able to salvage my data by dumping the data into a spread sheet and recreating the table. Thanks for the effort to pursue this problem. Vince Radice I am closing it as Resolved - invalid. I cannot supply the needed data and I have found a solution that works for me. If Invalid is not appropriate, please feel free to change as necessary |
Created attachment 69400 [details] I am trying to delete one of the duplicate entries for Carrot and Celery soup. Here is the message I get. When I click Yes, nothing happens. Problem description: Steps to reproduce: 1. ....Open Table in Table view 2. ....Locate bad record 3. ....Try to delete the record Current behavior: Record not deleted Expected behavior: Record deleted I have some erroneous records in a table. When I look at the data in Table view, I find the bad records and try to delete them. I get the confirmation message asking if I want to delete the record. I click Yes but the record is not deleted. I tried deleting a valid record (which I can put back in) and it was deleted. Libre Office version Version 3.6.3.2 (Build ID: 58f22d5) OS - Fedora FC17_64 with all current updates Engine - HSQL 1.8.1.3-7.FC17 PC - Intel quad core @ 3.00 GHZ Memory - 8 GB I have open problems in the Forums and I was able to upload my database file. Is that possible here or do I need to find the forums or report this as a bug? Thank you, Vince Radice p.s. I will upload the database file if necessary. It is about 780 mb. Platform (if different from the browser): Browser: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20100101 Firefox/16.0