[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 --- Comment #9 from t...@tim-passingham.co.uk --- (In reply to Xisco Faulí from comment #8) > ok, let's close this issue then. Feel free to put it back to UNCONFIRMED it > if you reproduce the problem again. OK. Thanks. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 Xisco Faulí changed: What|Removed |Added Resolution|--- |WORKSFORME Status|UNCONFIRMED |RESOLVED --- Comment #8 from Xisco Faulí --- ok, let's close this issue then. Feel free to put it back to UNCONFIRMED it if you reproduce the problem again. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 --- Comment #7 from QA Administrators --- [Automated Action] NeedInfo-To-Unconfirmed -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 QA Administrators changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 --- Comment #6 from t...@tim-passingham.co.uk --- As I said, the system on which this issue occurred has moved on to get around this issue. Further I had to back off 1.6.2 for several reasons. My attempts to reproduce this issue on a new, simple, database have not been successful thus far. I will try again once I have a 1.6.2 that works for me. It is possible that the problem was related to my using 1.6.1.5 version of the MySQL(Native) connector on 1.6.2. As I have suggested, please feel to close this report off, or ask me to do so. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org --- Comment #5 from Xisco Faulí --- 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.) -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 --- Comment #4 from t...@tim-passingham.co.uk --- Having been able to reproduce this on my application many times, and found a work around (basically setting default values at form load time rather by using if 'isNew' in the 'After Change' event to set defaults) I now can't reproduce the problem, even by reverting to the old macro behaviour. I don't know if this was related to jdbc or native connectors or something else If I get a native connector at some later date in the ubuntu version I'll try that. Sorry to use up your time (I hate it when stuff becomes unpredictable in this way!). If I manage to get the problem to return, I'll report again. With permission, I had better close this as 'notabug'. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #3 from Alex Thurgood --- Ideally, we'd need a sample db with the macro and associated instructions for use. It doesn't have to be hsqldb (although it would help). You could provide us with a DDL statement for the mysql table, and a sample ODB file containing the macro and tell us how you linked to your mysql instance (driver version and any parameters passed), so that we could adapt the ODB to our test environments. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 --- Comment #2 from Alex Thurgood --- (In reply to tim from comment #1) Can't comment on the firing of events issue, although there have been previous reports of macros not wokring because certain events do not fire in the expected sequence, so it wouldn't be totally surprising. > Mysql(Native) to MySql(JDBC), only to find that the mysql java jdbc > connector doesn't work any more for Mariadb, so found and installed the > Mariadb one. Yes, the latest mysql-java connector 8.x has at least one issue, bug 119139 (as yet unconfirmed), relating to timestamps, timezones and possibly datetime fields. It would be nice if this could be confirmed, however it does seem linked to that particular driver version (moving back to older versions solves the problem, but creates others). > > Now 6.2.1.1 worked OK (so far at least) so I upgraded again to the ubuntu > pre-release, and re-installed the libreoffice-mysql-connector. However, > that seems to be invisible when trying to change the database connection > back to Native. It should still be working with the libreoffice-mysql-connector, assuming you are using the corresponding version built for the ubuntu pre-release. I wasn't aware that one was provided in either pre-releases or snaps, so I'm somewhat surprised that you found one. If you are using the native connector from the previous distro-released version of LO, then there is absolutely no guarantee that it will work with a pre-release, in my experience. > 2. Has Mysql(Native) been dropped for mariadb (or all mysql)? No, not to my knowledge. The conenctor on most Linux distribs is now built with mariadb libraries (libmariadb) instead of mysql libraries (libmysqlclient). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 123597] IsNew not set for new data forms - was OK in 6.1.5
https://bugs.documentfoundation.org/show_bug.cgi?id=123597 t...@tim-passingham.co.uk changed: What|Removed |Added CC||t...@tim-passingham.co.uk --- Comment #1 from t...@tim-passingham.co.uk --- I have found a work around for this problem. It seems that the timing of events has changed. Previously there was time for the form and record to be marked as new one it had been opened before the 'after change' event was triggered. In 6.2.1.1 that wasn't true, but the IsNew status did get set later on. However, Having gone back to 6.1.5.1 and got things working with some possible workarounds, I installed 6.2.1 from Libreoffice (not ubuntu ppa), and found it was very unstable, crashing a lot. I changed from Mysql(Native) to MySql(JDBC), only to find that the mysql java jdbc connector doesn't work any more for Mariadb, so found and installed the Mariadb one. Now 6.2.1.1 worked OK (so far at least) so I upgraded again to the ubuntu pre-release, and re-installed the libreoffice-mysql-connector. However, that seems to be invisible when trying to change the database connection back to Native. To conclude, in 6.2.2.1: 1. There seem to be timing changes for form open events that mean some macros may fail (in my case the IsNew function) 2. Has Mysql(Native) been dropped for mariadb (or all mysql)? Apologies for the stream-of-consciousness and testing nature of this report. I appreciate there may end up be 0, 1 or 2 faults here. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs