[Libreoffice-bugs] [Bug 116253] 'NULL' appears as default text in text and combo boxes when editing a newly inserted record in a form's table control

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116253

Howard Johnson <BridgeportContractor at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEEDINFO                    |RESOLVED

--- Comment #7 from Howard Johnson <BridgeportContractor at gmail.com> ---
@ Xisco Faulí,

1) Using HeidiSQL I first made a copy of my underlying MySQL database (using an
an sql dump),

2) then manually edited the dump to change the reload target name, and 

3) then reloaded the database/tables to the newly named database, and then

4) also copied the broken LO .odb to a new file, and then

5) in LO pointed this new .odb to the new database from step 3, (by changing
the database it was defaulting to, and also editing a whole bunch of SQL in
queries and forms in it),

and the problem went away.  (Yes the bug went away).


So then 

6) I took another copy of the new working .odb, and 

7) again re-pointed it back to the old MySQL database and tables, 

and it also works properly.


So it appears to me that somehow my original .odb got corrupted.  And then
somehow strangely by just copying it and re-pointing it to a new copy of the
database this fixed it.


Baffled, but pleased that the bug is gone, at least for now.


Thanks for looking at this.

I marked this as RESOLVED, but not sure what you want with it, i.e. FIXED?

- H

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180606/01125a70/attachment.html>