Issue 12799 - Loss of Autocorrect Table
Summary: Loss of Autocorrect Table
Status: CLOSED FIXED
Alias: None
Product: Writer
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1 Beta
Hardware: PC Windows 2000
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: stefan.baltzer
QA Contact: issues@sw
URL:
Keywords: oooqa
: 19543 20663 23550 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-03-28 21:47 UTC by rjwalker
Modified: 2013-08-07 14:43 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description rjwalker 2003-03-28 21:47:48 UTC
Apparent loss of entire autocorrect table data after deleting a single
pre-loaded entry then accepting. (i.e. "whic").
Comment 1 h.ilter 2003-04-01 09:01:51 UTC
Reassigned to SBA
Comment 2 michael.bemmer 2003-05-06 15:46:59 UTC
Too late for beta2, re-targeted to 1.1 RC.
Comment 3 prgmgr 2003-06-16 15:23:42 UTC
Thank you for using and supporting OOo.

Does this problem still exist in 1.1 Beta 2?

Unable to duplicate RH 9.0, 1.1 Beta 2.
Comment 4 rjwalker 2003-06-17 00:09:55 UTC
We are unable to duplicate under Windows 2000, 1.1 Beta 2. Appears
corrected. -thanks
Comment 5 prgmgr 2003-06-25 19:34:19 UTC
.
Comment 6 rblackeagle 2003-09-13 23:04:16 UTC
No, it's NOT fixed.  It just came up with a lot of users (Linux and
Windows) on the users' list.  It's a real show-stopper.  I'm not
willing to try it as I need those entries and everyone who's tried it
has had to reinstall RC4 to get them back.
Comment 7 diane 2003-09-14 01:11:06 UTC
1. Go to Tools | AutoCorrect/AutoFormat...
2. Choose the Replace tab.
3. Select the first entry in the list: Replace (c) with copyright symbol.
4. Click ok.
5. Close OpenOffice.org 1.1RC3.
6. Reopen OpenOffice.org 1.1RC3.
7. Repeat steps 1 and 2.
8. Now there is no list where there was a list under the Replace tab.

The entire replace table disappears when the first entry is deleted.
Before closing and opening OOo again, only the one entry was deleted.
When OOo was reopened, all of the list except for the one deleted line
should have shown.

My tests were on OOo 1.1RC3 running on RH9 linux.

Here is a link to the thread on the users list where we discovered this:
http://www.openoffice.org/servlets/ReadMsg?msgId=823475&listName=users
Comment 8 diane 2003-09-14 01:16:21 UTC
Tamblyne discovered this on the users list, and two of us reproduced it.
Comment 9 diane 2003-09-14 01:21:32 UTC
Changed target milestone from OOo 1.1RC to OOo 1.1.1.
Comment 10 diane 2003-09-14 01:24:14 UTC
dang...I left out a step in my previous procedure. Please add step
3a. Click Delete to remove the selected entry.
Comment 11 diane 2003-09-14 23:43:15 UTC
*** Issue 19543 has been marked as a duplicate of this issue. ***
Comment 12 jimk55 2003-09-15 03:01:34 UTC
Ho Kay... 
however 19543 indicates that this puppy is STILL not fixed! 
I had this problem with 1.1RC4 and severial others had it as well. 
On most platforms. 
There should be a way of combining these issues comments. 
They are quite complete and this si a real show stopper for many folks. 
If you delete something out of the table and have to go back to a clean Bare 
metel reload to get it back... 
REal bad for most computer users... 
JIm TE 
Comment 13 stefan.baltzer 2003-09-15 10:42:19 UTC
SBA->OS: As discussed and reproduced: After the installation of OOo,
the autocorr files are in /../share/autocor/. After they get edited
for the first time, they get copied to /../user/autocor/. This works
if the first action is ADDING an entry. If the first action is a
deletion, the English autocor files do not get written.
So the workaround is to add an entry before deleting one. This means
that a "long list" of added entries can't get lost, only the initial
list can vanish.
Reassigned to Oliver.
Comment 14 andyl 2003-09-15 18:54:25 UTC
The above comment doesn't seem to reflect my experience.  My
acor2057.dat file is already in ...\user\autocorr, and contains about
a dozen additions which I have put in.  Yet *sometimes* (not every
time!) when I delete an entry, the whole list disappears.  The
acor2057.dat file is still in ...\user\autocorr, but presumably is
corrupted in some way so can't be read (its "Date modified" shows the
time I made the deletion.)  I have a backup copy of the file which I
just copy back into that directory and that cures the problem until
the next time (quicker than reinstalling!).

I've tested it quite a few times, and what I can't find a pattern in
is when deleting an entry causes this problem and when it doesn't.  I
had thought it was only when deleting the first entry in the list -
not so.  Then I thought, only when deleting the most recent entry made
- not so.  It just seems to happen sometimes and not other times.

All this is with RC1 on WinXP by the way.
Comment 15 Oliver Specht 2003-09-23 08:25:02 UTC
.
Comment 16 jimk55 2003-09-25 22:28:52 UTC
Just checking in with RC5 yes it still does it, I note the milestone is 1.1.1 
Cool Thanks. 
JIm TE 
Comment 17 tamblyne 2003-10-06 18:05:16 UTC
*** Issue 20663 has been marked as a duplicate of this issue. ***
Comment 18 Oliver Specht 2003-10-17 15:52:43 UTC
I reproduced it by deleting the Copyright (C) symbol from the
English(US) list. I had no acor1033.dat file in the
../user/autocorrect directory for the test.
The result was a corrupted acor1033.dat zip-file that had an invalid
central directory. It was possible to repair it using zip -FF
acor1033.dat. I could not reproduce the problem with the German or the
French replace list.



Comment 19 mikhail.voytenko 2003-10-21 08:27:15 UTC
The problem can be reproduced with any language, just a number of
entries must be removed.
The cause of the problem was that UCBStorage used internal buffering
in case storage is based on stream. During flashing the stream was not
truncated before writing, so in case the new version was smaller the
result would be a corrupted package.
Comment 20 mikhail.voytenko 2003-10-30 12:20:11 UTC
Sending for testing.
Comment 21 h.ilter 2003-10-31 14:03:16 UTC
Verified with cws = ok
Comment 22 h.ilter 2003-10-31 14:03:42 UTC
Set to Verified
Comment 23 grsingleton 2003-11-13 17:19:35 UTC
Here's a workaround courtesy of John Jordan:

Having spent hours struggling with this, I finally got some
information from people on the openoffice.org e-list. This is
definitely a bug. There is some question whether it is fixed and, even
if it is, evidently a patch file is not yet available. In the
meantime, if anyone gets bitten by this bug, the following will help
you cope until a patch is available --

1) There are usually several files in the /shared/autocorr folder, in
the format acor????.dat. There is one for each language you have
installed. For example, the acor1033.dat file is for English (USA).

2) When the user makes the first change to the AutoCorrect list and
clicks on OK in the dialog box window, the acor????.dat file for that
language is supposed to be copied to the /user/autocorr folder, the
new entry added to the file, and the file written with the date and
time stamp when the user made the change.

3) If the user deletes an entry from the list, the bug sometimes
causes the acor????.dat file in the /user/autocorr folder to be
corrupted, thus the list disappears from the dialog box. Or if the
first change the user makes is a deletion sometimes the acor????.dat
file is not copied to the /user/autocorr folder at all. Deleting an
entry does not always cause this behavior -- sometimes it works fine.

4) The user can add entries and edit existing entries without
problems. It's only deleting entries that is dangerous.

So to get around the problem until there is a fix available, do not
delete any entries. If an existing entry is causing you problems and
you want to get rid of it, just edit it so the replace field is the
same as the original field. E.g., if (C) > © is causing a problem,
just edit it so it changes (C) > (C).

Also, every time you make a change, go to your /user/autocorr folder,
select the newly changed file, and copy it to the same filename,
appending something like .backup. This will give you a backup copy of
your user AutoCorrect file, so if you inadvertently do something to
cause your list to disappear, you can just copy the backup file back
to it's original name. This will save doing a Repair or Reinstall to
get your AutoCorrect list back.

Comment 24 Oliver Specht 2004-01-05 11:51:17 UTC
*** Issue 23550 has been marked as a duplicate of this issue. ***
Comment 25 mikhail.voytenko 2004-01-14 15:23:26 UTC
Reopen the issue to be checked in SRC680/readstorage
Comment 26 mikhail.voytenko 2004-01-14 15:26:16 UTC
The fix is integrated to the SRC680/readstorage workspace also.
Comment 27 stefan.baltzer 2004-01-19 14:52:16 UTC
SBA: OK in Build srx645_m25s1-1_01.8733. Closed.