Re: Where are my files?

[Dan Lewis]

   You sent this request to the wrong mailing list. It should have been 
to us...@global.libreoffice.org. where general questions like yours are 
sent. You sent it to the mailing list for developers, the people who 
work on the code for LibreOffice. I have done so for you. How have you 
searched for these files, and do you know the names of them? Also, were 
you doing something in LibreOffice when it restarted? Have you used your 
operating system to search for the files, or did you just use 
LibreOffice? If you use windows, the files should be in your Document 
folder which is the default setting.


   For others on the mailing list: any replies you make to this 
question should include a CC to zhangyviv...@gmail.com as he is not 
likely yet subscribed to it.


  Dan

On 6/29/21 5:27 PM, Vivian Zhang wrote:

Hello.

LibreOffice restarted and now I can't find the files I have been 
working on for months now.


Very upsetting.

Not pleased.

Will be happy if you help me find my irreplaceable files.

Thank you.

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Feature request] Convert spreadsheets to SQL queries

[Dan Lewis]

us...@global.libreoffice.org

We suggest you become a member of the mailing lists especially if you 
will be having more questions in the future:


users+subscr...@global.libreoffice.org 



Dan


On 5/26/21 2:57 PM, Chintan from Rebhu wrote:

Thanks for letting me know.

Is there any list for users?
--
Sent from LineageOS with K-9 Mail.

On 26 May 2021 4:42:29 pm IST, Jan-Marek Glogowski  
wrote:


Hi Chintan,

Am 25.05.21 um 17:17 schrieb Chintan from Rebhu:

I frequently find myself copying data from old spreadsheets to
SQL. Would it be possible to convert spreadsheets to SQL queries? 



Feel free to open a bug report athttps://tdf.io/bugs   
 (as enhancement).
But this feature is probably better implemented as a macro or extension
by yourself.

BTW: this list is meant for development related questions, not user
requests.

ATB


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: ESC meeting agenda: 2021-03-25 16:00 Berlin time - renaming - a serious tongue-in-cheek proposal

[Dan Lewis]

Can we at least keep our language clean on this mailing list?

Dan


On 3/26/21 11:17 AM, Tor Lillqvist wrote:

> 1984 here we come ..

Oh for fuck’s sake. It’s sad to see how many reactionaries there are 
in this so-called community.


—tml

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: getting started with libreoffice online

[Dan Lewis]

I found this link:

https://documentation.libreoffice.org/en/english-documentation/

This is version 6.3. We are working on updating to 7.0, but this may 
take some time.


Dan

On 11/18/20 17:28, Marc Roos wrote:
  


Dan, can you help with this?




-Original Message-

To: libreoffice
Subject: RE: getting started with libreoffice online

  


Can anyone point me to a manual where I can just run the libreoffice
online and edit some files on a tablet for instance?

Are these strange questions wanting to know what the rest api
documentation is?


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice



___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Libreoffice online questions

[Dan Lewis]

Yes it is, so ask your question.

Dan

On 11/12/20 14:25, Marc Roos wrote:

I was a while back on this irc support and there they reffered me to the
development mailing list for libreoffice online questions. But I cannot
remember exactly what the mailinglist was, is this the correct one?







___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: calc: jumbo sheets on windows (never gonna happen)

[Dan Lewis]

I would use MySQL as a back end. In a database, all the calculations 
that you mention are created in queries using SQL. And yes, MySQL can 
handle tables with millions of rows of data. But there is a lot of 
learning that has to be done to learn how to use MySQL. Setting up the 
tables takes some time and understanding as well.


Dan

On 10/6/20 17:10, nicholas ferguson wrote:


Can I ask what kind of platform would you use for 16 million rows that 
involve calculations?


*From:*LibreOffice [mailto:libreoffice-boun...@lists.freedesktop.org] 
*On Behalf Of *Dan Lewis

*Sent:* Tuesday, October 06, 2020 2:59 PM
*To:* libreoffice@lists.freedesktop.org
*Subject:* Re: calc: jumbo sheets on windows (never gonna happen)

From my perspective, one needs to learn how to create a database in 
Base including tables, queries, forms and report when working with 
this much data. It is designed to handle large amounts of it. MySQL, 
Postgresql, and Oracle can be used as a backend  for Base being the 
front end.


Dan

On 10/6/20 12:09, Noel Grandin wrote:

Hi

i.e. very large spreadsheets of up to 16 million rows.

So I did some more investigation into this. In various places, we
need to accumulate things like row-heights and other things,
numbers which, with jumbo sheets, easily exceed 32-bits.

HOWEVER

All over the place, we pass these values through
sal_uLong/sal_Long/long/unsigned long.

Which is 32-bits on Windows. Doh!

Honestly, the only solution I can think of (and one I confidently
expect us to reject), is that we declare a flag day, and search
and replace sal_Long/sal_uLong/long/unsigned long with a 64-bit
type across the ENTIRE code base.

Regards, Noel Grandin.



___

LibreOffice mailing list

LibreOffice@lists.freedesktop.org
<mailto:LibreOffice@lists.freedesktop.org>

https://lists.freedesktop.org/mailman/listinfo/libreoffice

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: calc: jumbo sheets on windows (never gonna happen)

[Dan Lewis]

From my perspective, one needs to learn how to create a database in 
Base including tables, queries, forms and report when working with this 
much data. It is designed to handle large amounts of it. MySQL, 
Postgresql, and Oracle can be used as a backend  for Base being the 
front end.


Dan

On 10/6/20 12:09, Noel Grandin wrote:

Hi

i.e. very large spreadsheets of up to 16 million rows.

So I did some more investigation into this. In various places, we need 
to accumulate things like row-heights and other things, numbers which, 
with jumbo sheets, easily exceed 32-bits.


HOWEVER

All over the place, we pass these values through 
sal_uLong/sal_Long/long/unsigned long.


Which is 32-bits on Windows. Doh!

Honestly, the only solution I can think of (and one I confidently 
expect us to reject), is that we declare a flag day, and search and 
replace sal_Long/sal_uLong/long/unsigned long with a 64-bit type 
across the ENTIRE code base.


Regards, Noel Grandin.


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] Ability to have Snap/Flatpak/etc. for bug hunting season

[Dan Lewis]

On 5/9/20 07:11, William Gathoye (LibreOffice) wrote:

Hello everyone,

While officially not in charge of LibreOfficeFR any more on Twitter,
some people are requesting why we don't have Flatpak/Snap packages for
prereleases versions as well?

Some contributors aren't eager to test because installing the current
.deb/.rpm could interfere with their current profile. Having a simple
Flatpak/Snap/AppImage packages could ease the ongoing bug hinting process.


This can be solved fairly easily is some steps are followed. If the 
pre-release version agrees with the current version (e.g.:6.4.4.2 and 
6.4.2.2 resp.), then the pre-release needs to be installed in parallel, 
both the installation file and the help file that goes with it. How to 
do this is on the LibreOffice website. Then the bootstrap file for 
6.4.4.2 needs to be modified. The /4 needs to be /6.4.4.2 (this requires 
administrative rights). If desired, with administrative rights, the 
entire 6.4.4.2 installation folder can be moved to /opt/ next to the 
6.4.2.2 version. Now when 6.4.4.2 is first run, a new folder appears in 
~/.config/libreoffice/.


I do this all of the time.

Dan



I know some images are not managed by TDF directly, but providing one
for those we officially support could help IMHO.

Regards,


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: https://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: LO 6.2.6.1 pre-release

[Dan Lewis]

On 7/31/19 6:29 PM, Michael Weghorn wrote:

Hi Dan,

On 31/07/2019 19.20, Dan Lewis wrote:

    I have recently downloaded the x86_64 version (DEB) of the
pre-release. After installing it, I have tried to open it. It fails to
open. I use Ubuntu 18.04 which has icons on the left side of the screen.
Clicking this produced the screen shot for a while before it
disappeared. Opening it in a terminal:
/opt/libreoffice6.2/program/sbase. I got the same results. When I
replaced sbase with swriter, I still got the same result. Any others
notice this problem? This looks like a show stopper to me.

please create a bug report for this in Bugzilla [1] and also include any
output you get when trying to start LibreOffice in a terminal.

Best regards,
Michael

[1] https://bugs.documentfoundation.org/


   I have created a bug report: "*Bug 126659* 
<https://bugs.documentfoundation.org/show_bug.cgi?id=126659> - 
LibreOffice 6.2.6.1 x86_64 does not start after installing".


Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

LO 6.2.6.1 pre-release

[Dan Lewis]

   I have recently downloaded the x86_64 version (DEB) of the 
pre-release. After installing it, I have tried to open it. It fails to 
open. I use Ubuntu 18.04 which has icons on the left side of the screen. 
Clicking this produced the screen shot for a while before it 
disappeared. Opening it in a terminal: 
/opt/libreoffice6.2/program/sbase. I got the same results. When I 
replaced sbase with swriter, I still got the same result. Any others 
notice this problem? This looks like a show stopper to me.


Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Reveal code, old macros convert them to LO

[Dan Lewis]

On 7/7/19 4:35 PM, Wols Lists wrote:

On 07/07/19 17:06, Tor Lillqvist wrote:

 For the reference: we have a bug report since 2011
 https://bugs.documentfoundation.org/show_bug.cgi?id=34002
 and the corresponding openoffice bug report from 2002 is linked in the
 ticket...


Which should be a good indication that the request is unreasonable.


I think you mean "impractical" :-(

How is it unreasonable for support guys to want to be able to debug
their lusers' documents?

How is it unreasonable for people like me to want to use a modern word
processor, but be able to use it in a manner that we are comfortable,
rather than be forced into a "one size fits all" extremely uncomfortable
fairy tale bed ...

I was serious when I suggested that Uwe's best case for fixing his
documents was to "save as plain text" and start again. Bit tricky if the
document is full of graphics and other stuff ...

Cheers,
Wol


I now possess a copy of the offending .docx document and the PDF version 
of it. (It contains 1.6MB, so it will take some time.) Tomorrow, I will 
be determining what is necessary to fix it. Rather than guess as to what 
would be required, I will find out. I think this would be much more 
useful for others.  I will report back when I am finished.


Additional observation as in a personal opinion: this discussion has 
grown to a great length without really solving the problem. Such was the 
case for similar discussions before. (I seem to remember that one time 
it involved OOo prior to 3.0.)


One thing I do know: an .odt file is based on styles. The only codes 
that are used are styles. This is obvious when looking at the 
Content.xml file in the .odt zipped file. Word Perfect has a different 
set of codes which it uses. I do not see any correlation between the 
two. Without this, how can a do more than pretend to convert LO's 
styles  from WP's "reveal codes"?


Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Reveal code, old macros convert them to LO

[Dan Lewis]

On 7/4/19 8:06 AM, Thorsten Behrens wrote:

Hi Uwe,

Uwe Brauer wrote:

Is there somebody with enough knownledge in macros to translate those
macros to LO 6.2?


Perhaps - I'd suggest you upload them somewhere (provided they are
available under an open source license) & post a link here.

Preferably as a bug report at bugs.documentfoundation.org; you can
include a description on how to run them / what is expected to work
there.

All the best,

-- Thorsten

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice


I see in the two threads on this topic that there is a much discussion 
without looking at what is the basics of the ODT layout. I this is a 
mistake, and here is why.


I have some .sxw files from which I had earlier an .odt copy. From them 
I obtained the following information:


This is the ODT layout:

Which types of data source can OpenOffice.org use?
    • A database server  using Java Database Connectivity (JDBC).
    • A database server using Open Database Connectivity (ODBC).
    • The built-in dbase source.
    • The built-in Adabas source.
    • ActiveX data objects (ADO) -only available on Windows.
    • Text files.
    • Spreadsheets.
    • Address Books.
The help manual that comes with OpenOffice.org does a good job of 
describing these data sources and how to connect to them. Use 
Help>Contents>Database Functionality>Data Sources.


This is the styles markup of it:

Which types of data source can 
OpenOffice.org use?

 
 
      
           A database server
               using Java Database Connectivity (JDBC).
            
    
    
        A database server using Open 
Database Connectivity (ODBC).

        
    
    
     The built-in dbase source.
     
    
    
        The built-in Adabas source.
        
    
    
        ActiveX data objects (ADO) -only 
available on Windows.

        
    
    
        Text files.
        
    
    
        Spreadsheets.
        
    
    
        Which types of data source can 
OpenOffice.org use? 


    A database server
        using Java Database Connectivity (JDBC).
    
    
        A database server using Open 
Database Connectivity (ODBC).

        
    
        The built-in dbase source.
        
    
        The built-in Adabas source.
        
    
        ActiveX data objects (ADO) -only 
available on Windows.


        Text files.
        
    
        Spreadsheets.
        
    
        Address Books.
        
    
        The help manual that comes with 
OpenOffice.org does a good job of describing these data sources and how 
to connect to them. Use HelpContentsDatabase 
FunctionalityData Sources.

        Address Books.
        
    

The help manual that comes with 
OpenOffice.org does a good job of describing these data sources and how 
to connect to them. Use HelpContentsDatabase 
FunctionalityData Sources.



The markup comes directly from the Content.xml file of either the .sxw 
or .odt file. I should mention for those who wondered but did not know: 
the mark up for both files (.sxw, its .odt copy) is identical. To open 
the Content.xml, rename the .odt or .sxw file to .zip. Then unzip it. 
When opening Content.xml, use a browser or similar program which will 
give you an outline layout.


Each of these styles (L1, P3, P4, P5) are defined in the beginning lines 
of Content.xml. For example, L1 contains the styles for "List 1"; P3 
contains the styles for "Heading 3". P4 and P5 both use the paragraph 
style "text body"; P4 also contains the list-item style "L1". Search for 
P4 in the Content.xml beginning from the top to see this.


Looking at the markup above, I do not see any way to get "reveal codes". 
I do think a macro is possible which would reveal the styles used for a 
given part of a document in outline form as above. It would have to 
gather that information from the Content.xml file. Could it then expand 
the name of given style such as L1, P3, P4, p5 so that it would appear 
in place of the style name?


For example,  becomes
style:parent-style-name="Text body" style:list-style-name="L1"> (This 
would replace the tag used in the text with the tag used in the list of 
definitions at the beginning of Content.xml.


Comments: Perhaps this could be called "reveal styles"? Also one 
personal point that I learned back when OOo 1.14 was the latest version: 
Do not use direct formatting for any reason. That is what styles are 
for. In the long run, direct formatting does not save any time even when 
you make no errors with them. But needing to change some of the direct 
formatting can be very time consuming!


A few years ago, someone needed a "pamphlet" formatted which I did for 
her using styles. Later she wanted to change some of the characteristics 
of a heading. All I had to do was to change the settings for that 
heading style. This took seconds, and all of that particular heading now 
had 

Re: [Bug 123999] time change causes the return of "parameter index out of range... using mysql and J/connector

[Dan Lewis]

I have run into a problem with this bug. I would like to download a 
daily build, but I do not know how. I have clicked on the link below, 
but I don't see any .deb files that I can download. I don't really know 
what it is that I am to download. (I use Ubuntu 18.04.) In fact, I do 
not see any builds available there. I could use some help so that I can 
test this patch to see if it works.


Dan

On 3/27/19 9:14 AM, bugzilla-dae...@bugs.documentfoundation.org wrote:


*Comment # 17 
 on 
bug 123999 
 from 
Commit Notification  *

Julien Nabet committed a patch related to this issue.
It has been pushed to "libreoffice-6-2":

https://git.libreoffice.org/core/+/15f4f8b7bfd666d69381696fe288da24302d2ecd%5E%21

tdf#123999  : ParameterNameSubstitution in mysqljdbc

It will be available in 6.2.3.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/  in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

You are receiving this mail because:

  * You reported the bug.

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Parameter out of range (here we go again.)

[Dan Lewis]

I ran into a problem yesterday when my timezone in the US went from 
standard time to daylight savings time. The MySQL J/connector 8.0.15 has 
a bug that prevents a connection to the MySQL server with a modification 
of the database name. I solved this problem. But then when I opened a 
form with a subform, the data would not load with an explanation 
beginning with "Parameter index out of range...".  I filed this bug 
report: 123999.


I and others had a similar problem when opening a database that had been 
created before LibreOffice 6.2 but opened with version 6.2. The problem 
was "db parameter-name-substitution="false" in the context.xml file in 
the database file. So this had already been removed, and the form had 
worked properly the day before the time change.


I wondered if beginning with a new database on LibreOffice 6.2.1.2 to 
connect to the MySQL server would work. It did not. In fact, when I 
edited the content.xml file, I located "db 
parameter-name-substitution="false" in it. (Is this a regression?)


Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Bug 122520 foreign key constraints

[Dan Lewis]

When upgrading MySQL 8.0.13 from 5.7, a problem occurs if any of the 
foreign key restraints contains a primary key with one or more capital 
letters in it. MySQL converts any capital letters to lower case in the 
foreign key restraint while still recognizing the primary key with its 
capital.


For example: the primary key is Primary_id and its foreign key is 
foreign_id. In practice, the restraint links these two fields: 
primary_id and foreign_id respectively. Since primary_id contains no 
data, the related tables can not be used in a query.


A warning of some type should be made stating that primary keys are not 
to have any capital letters in it.


Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Bug 122675 MySQL native connector problem with LO 6.2.0.2

[Dan Lewis]

I get the following error message when using the Base Wizard in LO 
6.2.0.2 to connect to a MySQL database.


  Can't initialize character set unknown (path: compiled_in)

I get as far as clicking the the Test Connection button. When entering 
the password and clicking OK, I get this message. I have MySQL 8.0.13 
for my back end. I set up to use SHA2 with my password. (This may well 
be the where the problems lie.)


Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Bug #122437 MySQL foreign keys and the native MySQL connector

[Dan Lewis]

When I connect to MySQL using the native connector on LO 6.2.1 RC1, I 
can not successfully create a primary-foreign key pair. Instead of 
pairing the two fields, the foreign key pairs with itself. I have also 
connected to the same database on LO 6.2.0.1 RC1 using 
mysql-connector-java-5.1.45, and the relationships appear normal.


In this case I connected to the database first using the native 
connector. But this does not really matter. When I use 
mysql-connector-java-5.1.45 first and then the native connector, the 
results are the same. The native connector shows the foreign key related 
to itself. The mysql-connector-java-5.1.45 shows the relationships as 
they should be.


I attached two snapshots to show the difference. These were taken from 
Tools > Relationships


This is definitely a show stopper.

Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Building a mysql connector based upon LibreOffice 6.1

[Dan Lewis]

Perhaps 5 years ago, I built it based upon LibreOffice 4.0 using the 
following commands in a terminal:


1)  sudo apt-get install git
2)  sudo apt-get build-dep libreoffice
3)  $ git clone git://gerrit.libreoffice.org/core
4)  cd core
5)  ./autogen.sh
6)  apt-cache search gnome-vfs
7)  sudo apt-get install libgnome-vfsmm-2.6-dev
8)  ./autogen.sh
9)  ./g checkout -b libreoffice-4-0 origin/libreoffice-4-0
10) ./autogen.sh --enable-ext-mariadb-connector --enable-bundle-mariadb 
--enable-gstreamer --disable-gstreamer-0-10

11) make fetch (if autogen.sh ends with an error)
12) make dev-install

Comments: I have also modified /etc/apt/sources.list so that item #2 
above does not cause an error. #7 was entering the result gotten when 
running #6. #9 has to be updated to -6-1 from the -4-0. Why was 
--enable-gstreamer required in this step? #12 causes an error message: 
dev-install is not a valid target.


What changes need to be made in these steps to make this connector? I 
have not found an answer to this question in all of my searches.


I do not know whether I am a member of this mailing list, so please CC 
me or send a reply directly. Thanks for any help you can provide. You 
certainly helped me greatly the last time I did this!


Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: alternatives to Firebird: sqlite

[Dan Lewis]

On 03/08/2016 06:47 AM, SOS wrote:
A disruptive solution could be to abandon the "embedded"  idea and 
replace the current embedded engine by a new engine who use a 
spreadsheet file  as a "editable" storage who is protected for 
accidental editing.
Currently the use off a spreadsheet as database works fine en is fast 
enough for most small data sets. Just makes this system, editable.
For bigger data sets, users can and will use a database off  there own 
choice yo  been connected to LO.

Greetz
Fernand
 Abandoning the "embedded" idea may be a good idea. One of the 
things that Base does is connect to a spreedsheet, but how does one use 
Base in this manner to create a relational database? Just how involved 
with such a speadsheet be? What would the RDBMS be for a relatational 
database? (DBMS is not designed for a relational database as I 
understand it.


 Dan

On 8/03/2016 9:02, Lionel Elie Mamane wrote:

On Tue, Mar 08, 2016 at 09:59:18AM +1100, Chris Sherlock wrote:


Oh, and I’m not sure if this brings much to the table, but I wonder
if we can simulate joins. After all, to get a right join you just
swap tables, and you can actually simulate a full outer join with
just a combination of other joins.

See the last part of
https://lists.freedesktop.org/archives/libreoffice/2016-March/073572.html 


"compatibility with other databases" was a reference to
https://bugs.documentfoundation.org/42165
https://cgit.freedesktop.org/libreoffice/core/commit/?id=c25bb400bbfe20b3b13237ed10935ec9d0f6d769 



In short: yes, it can be done.

All these issues add up, and in the end I summarise them as "It is
probably possible to build a 'compliant' database on top of SQLite,
but SQLite is not that by itself". That is, we can "use" SQLite as a
(big) chunk of our embedded database engine, which we would DEVELOP
OURSELVES, but it is not "take a database engine and embed it in
LibreOffice". It is "develop our own database engine, using SQLite as
a foundation that gets us many many percent of the way, but not the
full way". If someone wants to do that, and commits to maintaining it,
then fine. Glad to take patches / see it integrated. *If* it comes
with a serious intent of maintaining it! Note that the ODBC driver
basically does that. So yeah, doable. Can be redone. Maybe we could
even embed the ODBC driver in some way. I have some uncertainties
around this, because I think that ODBC drivers "need" a driver manager
(that's what the Microsoft documentations say somewhere), but I never
really understood completely why, and some FLOSS ODBC drivers *are*
meant (by their author) to be able to be used without driver manager,
I think.

See also
https://bugs.documentfoundation.org/show_bug.cgi?id=38811#c21


What SQLite does it not necessarily bad, it is *different*. Dynamic
typing has its uses and its advantages. Just as NoSQL. But it makes
them a "bad fit" for a framework centred around the "classic" / usual
strong-type SQL.



___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] [ANN] LibreOffice 4.4.6 rc2 test builds available

[Dan Lewis]

On 10/15/2015 06:54 PM, Christian Lohmaier wrote:

Hi *,

for the upcoming new version 4.4.6 the builds for RC2 are now
available on pre-releases.


 RC2 is available for Linux(deb) for 32 bit but not for 64 bit 
[That folder seems to be empty.]


Dan


It is a build in release-configuration, meaning that it will update a
previous version of LibreOffice on Windows.
Linux and Mac users can install alongside LibreOffice 5.0

See

https://wiki.documentfoundation.org/ReleasePlan/4.4#4.4.6_release

for the complete schedule.

Grab the builds from here here:

  http://dev-builds.libreoffice.org/pre-releases/

The list of fixed bugs relative to 4.4.6 final (rc2) is here:

http://dev-builds.libreoffice.org/pre-releases/src/bugs-libreoffice-4-4-6-release-4.4.6.2.log

So playing with the areas touched there also greatly appreciated  -
and validation that those bugs are really fixed.

Thanks a lot for your help,
Christian
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Bug #92434

[Dan Lewis]

  I have downloaded 5.0.0.4 RC4 this morning. I will be checking 
this bug against it. If I find a problem, do I add a comment to the bug, 
or do I file a new bug? Two days ago, I added a comment to this bug 
after testing it against that day's daily build. The bug was still 
there. I reopened it at that point. This is why I am asking. I'm not 
sure I did the right thing in reopening the bug.

 I will list my results by this afternoon (I live in eastern US).

Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Bug 92434: relation design dialog LO 5.0.0.2

[Dan Lewis]

   Willl someone check this out?
   When I use Base in 5.0.0.2, the relation design dialog causes 
LibreOffice to crash. This is true for the DEB versions (x86 AND 
x86_64). When I open the dialog, make a change, and close it; 
LibreOffice crashes. It does not  matter if I save the changes or not. 
It also crashes if I open and the close the dialog.


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] [ANN] LibreOffice 4.2.7 RC1 test builds available

[Dan Lewis]

On 10/05/2014 03:48 AM, Andras Timar wrote:

On Fri, Oct 3, 2014 at 5:31 PM, Dan Lewis elderdanle...@gmail.com wrote:

  There was a bug (regression) involving Base first appearing in 4.0.0
and fixed in 4.3.2.1. My question: will the bug fix be back ported to 4.2.7?
If not, then Base 4.2.7 is not of much use to anyone with complex forms.
FYI: it involved a subform which had a subform. Whether it is back ported or
not, it does need to be mentioned in the release notes as a problem that is
not solved until 4.3.2.1.

What is the bug number? Sometimes a fix was not backported, because
the author did not have a 4.2 build to test and did not care that much
about the old stable branch. If this was the case, then we can still
do it.

Regards,
Andras
 Here are three bug report numbers: 72696, 82150, 82720.  The first 
of these was mine and based upon 4.2.0.0 beta 2. (Bug 82151 is similar 
and has a list of 8 duplicate bug reports.)


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] [ANN] LibreOffice 4.2.7 RC1 test builds available

[Dan Lewis]

On 10/05/2014 11:56 AM, Robert Großkopf wrote:

Hi Dan,


   Here are three bug report numbers: 72696, 82150, 82720.  The first
of these was mine and based upon 4.2.0.0 beta 2. (Bug 82151 is similar
and has a list of 8 duplicate bug reports.)

Have you tested it with LO 4.2.7.1? I have downloaded the attached
database of bug 72696. Have tested it with LO 4.2.7.1. Works as expected.

The bug has been fixed since version LO 4.2.0.4 here. Could only
reproduce with LO 4.2.0.0rc1 and earlier versions of LO 4.2.

Regards

Robert
 Sorry folks for a false alarm. I had entered data on a form in the 
main form and subform. So there was no information in the subform's 
subform.  When I looked at other records in which all three had data in 
them (main form, subform, and the subform's subform), the data was where 
it should be. Changing records in the subform also changed was shown in 
its subform. So this is working correctly.  I just messed up in looking 
at the wrong records. So, there is no bug in 4.2.6.3 and 4.2.7.1 RC1.


Dan

___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Call of Tools - Options - LibreOfficeDev Base - Connections crashes master

[Dan Lewis]

On 10/03/2014 09:42 AM, Thomas Hackert wrote:

Hello @ll,
while configuring my freshly downloaded and parallel installed
(following the instructions from
https://wiki.documentfoundation.org/Installing_in_parallel) LO
master on Debian Testing i686, I discovered the following:

1. Start LO
2. Go to Tools – Options – LibreOfficeDev Base – Connections

On my system, LO immediately crashes and spits out

quote
terminate called after throwing an instance of
'com::sun::star::loader::CannotActivateFactoryException'
/quote

, when I start it from command line ... :(

Can someone else confirm this?

LO: Version: 4.4.0.0.alpha0+ Build ID:
0ada00bd9b4f10861d37b8802564a2ace7385aa2 TinderBox: Linux-rpm_deb-
x86@45-TDF, Branch:master, Time: 2014-10-01_06:15:34 (parallel
installed, following the instructions from
https://wiki.documentfoundation.org/Installing_in_parallel)
OS: Debian Testing i686

Thanks for testing
Thomas.

  I can confirm on Ubuntu 12.04 64 bit. Version: 4.4.0.0.alpha0+
Build ID: 65277f994ae25d930c15aebba0ed19f8de0abba1
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 
2014-09-29_19:47:20.

 Error message:
terminate called after throwing an instance of 
'com::sun::star::loader::CannotActivateFactoryException'


 We got identical results from this crash.

Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] [ANN] LibreOffice 4.2.7 RC1 test builds available

[Dan Lewis]

On 10/03/2014 07:37 AM, Christian Lohmaier wrote:

Hi *,

for the upcoming new version 4.2.7, the builds for rc1 are now
available on pre-releases (some Win-helppacks still uploading)

4.2.7 is the last planned released for the LibreOffice 4.2 codeline.

See

https://wiki.documentfoundation.org/ReleasePlan/4.2#4.2.7_release

for the complete schedule. (one additional rc is planned for 4.2.7)

Grab the builds from here here:

  http://dev-builds.libreoffice.org/pre-releases/

If you've a bit of time, please give them a try  report any severe
bugs not yet in bugzilla here, so we can incorporate  them into the
release notes. Please note that it takes approximately 24 hours to
populate the mirrors, so that's about the time we have to collect
feedback.

The list of fixed bugs relative to 4.2.6 final (rc3/secfix) is here:

http://dev-builds.libreoffice.org/pre-releases/src/bugs-libreoffice-4-2-7-release-4.2.7.1.log

So playing with the areas touched there also greatly appreciated  -
and validation that those bugs are really fixed.

Thanks a lot for your help,
Christian
 There was a bug (regression) involving Base first appearing in 
4.0.0 and fixed in 4.3.2.1. My question: will the bug fix be back ported 
to 4.2.7? If not, then Base 4.2.7 is not of much use to anyone with 
complex forms. FYI: it involved a subform which had a subform. Whether 
it is back ported or not, it does need to be mentioned in the release 
notes as a problem that is not solved until 4.3.2.1.


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Post Building MySQL connectors for 32 and 64 bit versions for LibreOffice 4.3 in Linux

[Dan Lewis]

On 10/02/2014 10:38 AM, Robert Großkopf wrote:

Hi Dan,


The mysql native connectors I uploaded earlier were both 32 bit. I apologize
for that. The way Nabble names uploaded files were somewhat confusing to me,
so I will try again.

32 bit mysql native connector:

mysql-connector-x86.oxt
http://nabble.documentfoundation.org/file/n4124504/mysql-connector-x86.oxt

64 bit mysql native connector:

mysql-connector-x86_64.oxt
http://nabble.documentfoundation.org/file/n4124504/mysql-connector-x86_64.oxt

Seems it is working now - better like expected.
→ I see all databases from my MariaDB - not only the database the file
is created for. Good for working whith more than one database.
→ Input of time give the right value.

Don't know where the files should be linked to:
http://extensions.libreoffice.org/extension-center/mysql-native-connector
is linked to the old linux-extensions.

http://extensions.libreoffice.org/extension-center/mysql-native-connector-for-libreoffice-4.x/releases/1.0.2
is linked to the windows-extension.

A little bit confusion. Why aren't the different connectors at the same
place. Not long ago there was a third place for a connector for Mac -
couldn't find this connector any more ...

Regards

Robert
  You raise a very good point. The first link was my creation last 
year for the Linux version. Since then, someone else has created the 
second link for windows. it would be nice if that person and I could get 
together to combine all of the mysql native connectors in one location. 
Does anyone know who that other person and email address are for contact 
purposes?


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Post Building MySQL connectors for 32 and 64 bit versions for LibreOffice 4.3 in Linux

[Dan Lewis]

On 10/01/2014 12:10 PM, Thomas Hackert wrote:

Hello Dan, *

On Tuesday, 30. September 2014 20:30 ElderDanLewis wrote:

The web page for the MySQL Native Connector to which i referred is

http://extensions.libreoffice.org/extension-center/mysql-native-connector

ah, O.K. The last time I looked there, there was no extension to
download ... :(


mysql-connector-ooo_1.oxt
http://nabble.documentfoundation.org/file/n4124313/mysql-connector-ooo_1.oxt
mysql-connector-ooo_1.oxt
http://nabble.documentfoundation.org/file/n4124313/mysql-connector-ooo_1.oxt

These are the connectors I built. Both are for Linux versions
only. The first one is suppose to be the 32 bit version and the
second one should be the 64 bit version.

Thank you very much :) Just out of interest: After I installed the
version from extension.l.o and then wanted to install your *_1.oxt
version, the Extension Manager asked me, if I wanted to replace my
already installed 1.0.3 with your *_1.oxt version, which he seems to
recognise as version 1.0.2 ... :( Is this expected? Otherwise, it
seems to work :) But I did only a quick test (is it installable? Can
I connect LO with MariaDB 10.1?) with LO 4.2.6, 4.3.1-2 and master
(Version: 4.4.0.0.alpha0+ Build ID:
ed95e1c5619e2cb2a8f6d93a1b7c45f36f1524dd TinderBox: Linux-rpm_deb-
x86@45-TDF, Branch:master, Time: 2014-09-12_11:30:45 on Debian
Testing i686, it works so far ... ;)

Thanks again and have a nice evening
Thomas.
 The version number is in the Description.xml file in the oxt file. 
I had not changed  1.02 to 1.04_3 in the 32 bit version which you 
used. I had  earlier changed this in the 64 bit version, and I thought I 
had changed this in the 32 bit version. I have now corrected this error. 
Thank you for finding it.
 I have a 32 bit MacBook running Kubuntu 14.04 and a 64 bit tower 
running Ubuntu 12.04. Both have MySQL 5.5 running. I had no problem 
installing the correct mysql connector in either of them. I Then I was 
able to access the mysql server, open a database, and even added and 
modified some data with no problems.
 I tested these connectors with LibreOffice 4.1, 4.2, and 4.3. They 
do not work with 4.1, but both work with 4.2 and 4.3.
 Whether they will work with MariaDB 10.x or not I do not know. 
This would have to be determined by someone who has it on their 
computer. I strictly use MySQL.


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Post Building MySQL connectors for 32 and 64 bit versions for LibreOffice 4.3 in Linux

[Dan Lewis]

The mysql native connectors I uploaded earlier were both 32 bit. I apologize
for that. The way Nabble names uploaded files were somewhat confusing to me,
so I will try again.

32 bit mysql native connector:

mysql-connector-x86.oxt
http://nabble.documentfoundation.org/file/n4124504/mysql-connector-x86.oxt  

64 bit mysql native connector:

mysql-connector-x86_64.oxt
http://nabble.documentfoundation.org/file/n4124504/mysql-connector-x86_64.oxt 
 



--
View this message in context: 
http://nabble.documentfoundation.org/Libreoffice-qa-MySQL-native-connector-for-OS-X-tp4123190p4124504.html
Sent from the QA mailing list archive at Nabble.com.
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] MySQL native connector for OS X

[Dan Lewis]

On 09/25/2014 03:44 AM, Bjoern Michaelsen wrote:

On Wed, Sep 24, 2014 at 07:50:56PM -0400, Robinson Tryon wrote:

On Wed, Sep 24, 2014 at 7:33 PM, Dan Lewis elderdanle...@gmail.com wrote:

Ubuntu version. I seem to recall that build-dep did not install all of
the required build environment for me and that I had to add extra stuff.

bingo!


  First and only error:

 Error running ./autogen.sh line 258.

Explanation of the error:
  Files not found:
  gstreamer-0.10
  gstreamer-0.10-plugins-base-0.10
...
So, what should I do now. My laptop (32r bit) is running Kubuntu 14.04.

The build dependencies package on *buntu doesn't include gstreamer
stuff. To fix that:

  sudo apt-get install libgstreamer0.10-dev libgstreamer-plugins-base0.10-dev

Alternatively, do:

  ./autogen.sh --enable-gstreamer --disable-gstreamer-0-10

to use the less horribly outdated gstreamer 1.0 instead of gstreamer 0.10 (as 
Ubuntu
packages do).

Best,

Bjoern
 When I ran this on Ubuntu 12.04 (64 bit), an error was generated 
even though I have gstreamer1.0 installed (a total of 20 files for this 
are listed in synaptic). The message: could not find gstreamer1.0.


(1)./autogen.sh --enable-ext-mariadb-connector 
--enable-bundle-mariadb --enable-gstreamer --disable-gstreamer-0-10


However, when I ran

( 2)   make fetch

and then reran (1), I got the same error message. then I ran (3) which 
did not produce any error message. (I also have gstreamer0.1 installed.)


(3)
./autogen.sh --enable-ext-mariadb-connector --enable-bundle-mariadb
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Post Building MySQL connectors for 32 and 64 bit versions for LibreOffice 4.3 in Linux

[Dan Lewis]

 I have now built connectors for both versions which should work 
for both MySQL and mariadb since autogen includes switches to include 
the mariadb library files.

 So, now I have some more questions:

1) How should they be numbered? I'm thinking that since they were built 
using LibreOffice 4.3 that they should be numbered 4.3.0. (At present, I 
have them numbered 1.0.4_3 which also indicates the version of 
LibreOffice used to build them.)


2) Is someone willing to test them to see if they work on their 
computers as well? This is especially true if they have installed Mariadb.


3) What about the MySQL connector 1.03 that I have placed in the 
Extension web site? Both 32 and 64 bit versions there work with 
LibreOffice through 4.4.0 alpha but only with MySQL only. They do not 
work with Mariadb as far as I know.


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Post Building MySQL connectors for 32 and 64 bit versions for LibreOffice 4.3 in Linux

[Dan Lewis]

 I have now built connectors for both versions which should work 
for both MySQL and mariadb since autogen includes switches to include 
the mariadb library files.

 So, now I have some more questions:

1) How should they be numbered? I'm thinking that since they were built 
using LibreOffice 4.3 that they should be numbered 4.3.0. (At present, I 
have them numbered 1.0.4_3 which also indicates the version of 
LibreOffice used to build them.)


2) Is someone willing to test them to see if they work on their 
computers as well? This is especially true if they have installed Mariadb.


3) What about the MySQL connector 1.03 that I have placed in the 
Extension web site? Both 32 and 64 bit versions there work with 
LibreOffice through 4.4.0 alpha but only with MySQL only. They do not 
work with Mariadb as far as I know.


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Post Building MySQL connectors for 32 and 64 bit versions for LibreOffice 4.3 in Linux

[Dan Lewis]

Top post:
 I answered this email in Nabble because I wanted to upload both 
connector files where they can be accessed. Unfortunately, I used a 
different email address than I use on the mailing list. So my reply is 
waiting for a moderator to allow it to be posted. The email I used at 
Nabble is grandpadan.le...@gmail.com  if this helps.


Dan

On 09/30/2014 12:51 PM, Thomas Hackert wrote:

Hello Dan, *,
On Tuesday, 30. September 2014 14:52 Dan Lewis wrote:


   I have now built connectors for both versions which should
   work
for both MySQL and mariadb since autogen includes switches to
include the mariadb library files.

cool, thank you very much :)

snip

2) Is someone willing to test them to see if they work on their

I would do it, if you could provide a download link ... ;)


computers as well? This is especially true if they have installed
Mariadb.

I need to install MariaDB again before I can test it, but that would
not be a problem ... ;)


3) What about the MySQL connector 1.03 that I have placed in the
Extension web site?

Which extension website? Do you mean
http://extensions.libreoffice.org/extension-center/mysql-native-connector-for-libreoffice-4.x
 or
http://extensions.openoffice.org/en/project/mysql-driver-apache-openoffice? I 
do not see any one at the first site ... :(


Both 32 and 64 bit versions there work with
LibreOffice through 4.4.0 alpha but only with MySQL only. They do
not work with Mariadb as far as I know.

I have not tested it by now, as I am not sure, which extension site
you mean, sorry ... :(
Have a nice evening
Thomas.



___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] MySQL native connector for OS X

[Dan Lewis]

On 09/24/2014 07:50 PM, Robinson Tryon wrote:

sudo apt-get install libgstreamer0.10-dev libgstreamer-plugins-base0.10-dev
 Thank you very much! I entered this in a command line and then 
reran autogen.sh successful.


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] MySQL native connector for OS X

[Dan Lewis]

On 09/22/2014 11:59 AM, Dan Lewis wrote:
   Can MySQL be accessed on an Apple computer using a native 
connector? If so, what is the URL for where it is located? If not, how 
can it be accessed and the URL for the connector's location?
   A couple of years ago, I made a MySQL native connectors for Linux 
32 and 64 bit. Should these be updated? What version should they be 
made against?


Dan 
  Follow-up question to the second paragraph: Can some one point me 
in the right direction to build the MySQL native connectors for Linux 32 
and 64 bit? I seem to have lost the instructions that Alex provided me 
with a couple of years ago. (He was a great help to me.)


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] MySQL native connector for OS X

[Dan Lewis]

   Can MySQL be accessed on an Apple computer using a native connector? 
If so, what is the URL for where it is located? If not, how can it be 
accessed and the URL for the connector's location?
   A couple of years ago, I made a MySQL native connectors for Linux 32 
and 64 bit. Should these be updated? What version should they be made 
against?


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Critical bug Base: No refreshing and connection to subsubforms any more

[Dan Lewis]

On 08/22/2014 09:48 AM, Robert Großkopf wrote:

Hi *,

there seems to be a critical bug in Base since LO 4.3.0.0alpha. Three
bugdescriptions (
https://bugs.freedesktop.org/show_bug.cgi?id=82720
https://bugs.freedesktop.org/show_bug.cgi?id=82884
https://bugs.freedesktop.org/show_bug.cgi?id=82905 )
show all the same behavior: If you use a form with a subform and a
subsubform (a subform from a subform), data in the subsubform aren't
refreshed and input of new data is impossible. So many databases
wouldn't be usable any more with Base 4.3.

Regards

___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
 I downloaded the database for 82720 and 82884 to test them using 
Version: 4.4.0.0.alpha0+

Build ID: b6da6a887a0417be02e123a6d19837123e58b94f
TinderBox: Linux-rpm_deb-x86@45-TDF, Branch:master, Time: 
2014-08-09_07:47:21. (Kubuntu 14.04 x86 DEB)


 In both cases, I was able to add data to the subform B which is a 
subform of subform A. I have clicked the Save icon in the Navigation Bar 
and saved the saved data. When I then cycle through the rows of subform 
A, the added data in subform B appears when it should. So, I believe 
that someone has solved the problem using this master build or later.
 I made comments in both bugs, but I did not make any changes in 
their status.


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: LO 4.3 Base - problems with sub forms

[Dan Lewis]

On 08/05/2014 02:56 AM, Alex McMurchy wrote:

After I wrote the note I too realised that my application had a form that had a 
sub form with a sub form. I raised Bug 82151 for this and attached a very cut 
down version of my application that should demonstrate the problem.

Alex
 Bug #82151 is a duplicate of #81976. Bug #82150 has also been 
filed, and it too is a duplicate of 81976. This bug makes it impossible 
to have a form that contains a main form, its subform, and a subform to 
the subform.


Dan




On Monday 04 Aug 2014 14:41:26 elderdanlewis wrote:

The problem is Base in 4.3.0.4. I have a form that has a subfom with a 
subfom. As you notice, 4.2.6.2 does not have this problem. I will be filing bug 
reports later late today.

Dan

 Original message 
From: Alex McMurchy mcmurchy1917-libreoff...@yahoo.co.uk
Date:08/04/2014  4:12 AM  (GMT-05:00)
To: libreoffice@lists.freedesktop.org
Subject: LO 4.3 Base - problems with sub forms

Since and including LO 4.3 I've started having problems with sub forms

I have two tables Subscribers and Payments which are linked on Subscriber_ID.

I have a form Data_Entry the main details of the form contains the data for 
one particular Subscriber from the Subscribers table. The form also has a sub form 
that contains the payment details for that subscriber linked on Subscriber_Id.

Upto and including LO 4.2.4  this has worked flawlessly for the past 15 months.

Load the form and see the last viewed subscriber details with matching payment 
details - Correct.

Select a different subscriber from a drop down box,  the contents of main form 
changes to reflect the new subscriber and the contents of the sub form changes 
to the new subscribers payment details - Correct.


Since 4.3 what I get is this -

Load the form and see the last viewed subscriber details with matching payment 
details - Correct.

Select a different subscriber from a drop down box,  the contents of main form 
changes to reflect the new subscriber. The contents of the sub form doesn't 
change  it still reflects the payments from the previous subscriber - Wrong.

Restart LO.

Load the form and see the last viewed subscriber details with matching payment 
details - Correct.

Select a different subscriber from a drop down box,  the contents of main form 
changes to reflect the new subscriber. The contents of the sub form doesn't 
change  it still reflects the payments from the previous subscriber - Wrong.


So the work around is to select a new subscriber, see the wrong payment 
details. Close LO. Start LO and load the form and see the correct payment 
details - bizarre.

I've had a quick search in bugzilla but found nothing. Will have another search 
later today and if I don't find anything will raise a bug report with the above 
detail. Then flesh it out with the steps to take to replicate the bug.

In the meantime has anyone seen this or any thoughts on the matter.


Alex
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] Base 4.3.0.4 has serious problems with forms with subforms within subforms

[Dan Lewis]

 There are now three bug reports on this particular problem: 81976, 
82150 (mine), and 82151 (filed by the person who mentioned the problem 
in the user list).  I have marked mine as a duplicate of 81976. Between 
the three bug reports, there are three databases which exhibit the 
problem. How much confirmation is needed? Any idea when this might be 
fixed? ( 81976 was filed for 4.3.0.0RC).



Dan

On 08/04/2014 04:06 PM, elderdanlewis wrote:
Bug report 82150. As promised I attached an ODB file with the problem. 
It's part of the Base guide.


Dan


 Original message 
From: Joel Madero
Date:08/04/2014 3:41 PM (GMT-05:00)
To: Dan Lewis ,libreoffice-qa@lists.freedesktop.org
Subject: Re: [Libreoffice-qa] Base 4.3.0.4 has serious problems with 
forms with subforms within subforms


Sure thing - just link us to the bug report and make sure there are 
repro steps on the bug report. Thanks!



Best,
Joel


On 08/04/14 12:32, Dan Lewis wrote:
The same embedded database with subforms within subforms will 
open and work properly using 4.2.6.2. I am using Debian x86_64 
version. Specifically, the primary-foreign key pair are not joined 
within the form. If a query is created with all the controls of the 
form, all the information is visible. If controls are placed in the 
form for this primary-foreign key pair, the controls do NOT have the 
same value regardless of what record is selected.
   I will be filing a bug shortly. It would be nice if someone could 
verify this problem. I will also upload the database to the bug report.


Dan


___
List Name: Libreoffice-qa mailing list
Mail address:Libreoffice-qa@lists.freedesktop.org
Change settings:http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems?http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more:http://wiki.documentfoundation.org/Netiquette
List archive:http://lists.freedesktop.org/archives/libreoffice-qa/




___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Base 4.3.0.4 has serious problems with forms with subforms within subforms

[Dan Lewis]

The same embedded database with subforms within subforms will open 
and work properly using 4.2.6.2. I am using Debian x86_64 version. 
Specifically, the primary-foreign key pair are not joined within the 
form. If a query is created with all the controls of the form, all the 
information is visible. If controls are placed in the form for this 
primary-foreign key pair, the controls do NOT have the same value 
regardless of what record is selected.
   I will be filing a bug shortly. It would be nice if someone could 
verify this problem. I will also upload the database to the bug report.


Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: ATTENTION, creators of mysql-connector-ooo.oxt (--enable-ext-mariadb-connector)

[Dan Lewis]

Top post: I am the one that created the Linux 32 bit and 64 bit version 
of the extension. However, I no longer have 24/7 access to the Internet 
so I can not create the updates to either extension. Please advise.


--Dan

On 10/19/2013 05:52 PM, Lionel Elie Mamane wrote:

If you use the LO git repo or release tarballs to build the
mysql-connector-ooo.oxt extension (via --enable-ext-mariadb-connector,
formerly --enable-ext-mysql-connector) then use/distribute it, then
please be aware that as a consequence of
http://bugs.freedesktop.org/70496 I have *disabled* internal
libmariadb (client library) in favour of system
libmysqlclient. Please use libmysqlclient, and not libmariadb, due to
the above bug, which leads to crashes/freezes.

I (and your users) would appreciate if you regenerated your builds.


To build off the master branch, make sure you have:

 commit 02a11749da521e8e2099b464c0fcbebce9e95e22
 Author: Lionel Elie Mamane lio...@mamane.lu
 Date:   Sat Oct 19 22:57:40 2013 +0200

   fdo#70496 revert to using libmysqlclient

   Change-Id: I5b98b5e7840e4f1c6005aee0c1f43ef814ecf77b

or newer, then configure with:
--enable-ext-mariadb-connector --with-system-mariadb 
--enable-bundle-mariadb

GNU/Linux distributions will want to use --disable-bundle-mariadb
(which is the default), while people distributing an .oxt for
general consumption (cross-distro GNU/Linux, MacOS X, Microsoft
Windows, ...) will want --enable-bundle-mariadb.


To build of the libreoffice-4-1 branch, use the feature/base-preview
branch or cherry-pick from master:

 commit 02a11749da521e8e2099b464c0fcbebce9e95e22
 Author: Lionel Elie Mamane lio...@mamane.lu
 Date:   Sat Oct 19 22:57:40 2013 +0200

   fdo#70496 revert to using libmysqlclient

   Change-Id: I5b98b5e7840e4f1c6005aee0c1f43ef814ecf77b

Then, proceed as with master.



___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-qa] Report Builder Bug #68190

[Dan Lewis]

 I have just filed this bug about a property for header, Detail, 
and footer sections of the Report Builder. The problem is with the 
*Force New Page* property. This sets the page breaks for a report. For 
LibreOffice 4.1.0.4, the names used in this property do not match where 
the page breaks appear.


What I get are the following results:

None: the page breaks appears after the last control of the section.
Before: the page break appears before and after the section.
After: the page break appears before the section.
Before and after: no page breaks appear.

 It would be nice is some developer could rearrange the order so 
the names match the location of the page breaks.


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] [ANN] LibreOffice 4.1.0 RC4 test builds available for smoketesting

[Dan Lewis]

On 07/26/2013 07:48 AM, Petr Mladek wrote:

(another attempt to post this to the mailing list)

Dan Lewis píše v Čt 25. 07. 2013 v 11:55 -0400:

  There still seems to be a problem with 4.1.0.4 for Debian x86. I
downloaded it for my Ubuntu laptop and then installed. It installs
in /opt/libreoffice4.1. However, when I click on soffice in
the /opt/libreoffice4.1/program folder, version 4.0.3.3 appears when I
click on Help  About LibreOffice. The download was from
http://dev-builds.libreoffice.org/pre-releases/.
  I'm now sure what happened since I installed version 4.0.3.3 when
it first came out.
  Another thing: Today's installation added 4.1.0.4 to my menu.
However, if I double click any of the LibreOffice 4.1.0.4, the 4.0.3.3
is the one that runs.

I see two possibilities:

1. The old version 4.1.0.3 might still be running because of
quickstarter. Please, try to kill the process soffice.bin.

2. The update failed and you did not notice it. Note that there
was a dependency problem with the debian-menus package, see
https://bugs.freedesktop.org/show_bug.cgi?id=67041

Please, make sure that you really have the 4.1.0.3-4 packages
installed.


Best Regards,
Petr
   I'm not sure what happened, and I still do not understand it all. I 
don't use quickstarter with my Debian LibreOffice versions. It is 
possible that the version 4.0.3.3 was running at the time I tried to 
start 4.1.0.4.

What puzzles me is that I got the splash screen appeared when I did this.
   This morning, I clicked the 4.1.0.4 menu item for LibreOffice. This 
time, the Help  About LibreOffice shows the version as 4.1.0.4. So, 
problem solved.


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] [ANN] LibreOffice 4.1.0 RC4 test builds available for smoketesting

[Dan Lewis]

 There still seems to be a problem with 4.1.0.4 for Debian x86. I 
downloaded it for my Ubuntu laptop and then installed. It installs in 
/opt/libreoffice4.1. However, when I click on soffice in the 
/opt/libreoffice4.1/program folder, version 4.0.3.3 appears when I click 
on Help  About LibreOffice. The download was from 
http://dev-builds.libreoffice.org/pre-releases/.
 I'm now sure what happened since I installed version 4.0.3.3 when 
it first came out.
 Another thing: Today's installation added 4.1.0.4 to my menu. 
However, if I double click any of the LibreOffice 4.1.0.4, the 4.0.3.3 
is the one that runs.


--Dan

On 07/23/2013 08:16 PM, Thorsten Behrens wrote:

Hi *,

QA found a number of problems that were initially addressed via a
hotfix for the Linux packages, but then resulted in a fully new build
today - we're now uploading builds of LibreOffice 4.1.0 RC4 to a
public (but non-mirrored - so don't spread news too widely!) place, as
soon as they're available. Grab them here:

  http://dev-builds.libreoffice.org/pre-releases/

If you've a bit of time, please give them a try  report *critical*
bugs, especially regressions relative to prior RCs here, so we can
incorporate them into the release notes. Please note that it takes
approximately 24 hours to populate the mirrors, so that's about the
time we have to collect feedback.

The list of fixed bugs vs. 4.1.0 RC3 is available here

  
http://dev-builds.libreoffice.org/pre-releases/src/bugs-libreoffice-4-1-0-release-4.1.0.4.log

I'd like to especially ask QA volunteers from the following locales,
to please verify the fix of fdo#67093:

as
bg
br
gl
lt
pt-BR
pt
ru
sv
te
uk
zh-CN
zh-TW

Thanks a lot for your help,

-- Thorsten


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: Direct csv import into Base table

[Dan Lewis]

On 06/03/2013 06:05 AM, Zolnai Tamás wrote:

Hi Lionel,

   I'm working on a new feature in Base again. It's just a little user 
helper feature to make available the direct import of an csv file into 
table, without open Calc and copypaste the content from it to Base. I 
already have the plan to implement it and it seems to me that it will 
work not just with csv files but all Calc compatible format (in this 
case only the first sheet will be imported, but later it can be 
extended). I will use up the code which lies under the OLE-object 
feature of Writer, which already contains the csv import.
   The only question is where this feature would be reachable. I have 
two ideas and I think all of these two places should be used:
   1. Table view - Tasks. Add a 4th option like Import Table From 
File This point contains all other places which are almost the 
duplicates of this Tables list (e.g. Insert menu with label Table 
(Import)... ).
   2. Table view - Tables - context menu. The label can be Import 
Table


If you agree with these points than I send a mail to the ux mailing 
list for a new icon which can be displayed in the Tasks list and in 
the menu.


Best Regards,
Tamás

 Pardon me for making a comment. Base can connect to a CSV file now 
using the Base wizard. It seems like what you want to do could be made 
part of this wizard. At least this makes more sense to me since it is 
creating or modifying a database.


--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Direct csv import into Base table

[Dan Lewis]

On 06/03/2013 03:59 PM, Zolnai Tamás wrote:


2013/6/3 Dan Lewis elderdanle...@gmail.com 
mailto:elderdanle...@gmail.com


On 06/03/2013 06:05 AM, Zolnai Tamás wrote:

Hi Lionel,

   I'm working on a new feature in Base again. It's just a
little user helper feature to make available the direct import
of an csv file into table, without open Calc and copypaste
the content from it to Base. I already have the plan to
implement it and it seems to me that it will work not just
with csv files but all Calc compatible format (in this case
only the first sheet will be imported, but later it can be
extended). I will use up the code which lies under the
OLE-object feature of Writer, which already contains the csv
import.
   The only question is where this feature would be reachable.
I have two ideas and I think all of these two places should be
used:
   1. Table view - Tasks. Add a 4th option like Import
Table From File This point contains all other places
which are almost the duplicates of this Tables list (e.g.
Insert menu with label Table (Import)... ).
   2. Table view - Tables - context menu. The label can be
Import Table

If you agree with these points than I send a mail to the ux
mailing list for a new icon which can be displayed in the
Tasks list and in the menu.

Best Regards,
Tamás

 Pardon me for making a comment. Base can connect to a CSV
file now using the Base wizard. It seems like what you want to do
could be made part of this wizard. At least this makes more sense
to me since it is creating or modifying a database.


Yes, it might be the way. But I don't see where this wizard modifying 
a database. I see only opening, creating and connecting 
functionalities, but nothing about modifying. What you mean under 
modifying?



Best Regards,
Tamás

 I appear to have gotten ahead of myself. You are right. the wizard 
presently only creates a new database, opens an existing present 
database, or connect to a database. It seems to me that what you are 
proposing is modifying a database by adding a table to it from a CSV file.
So my suggest is to include your proposal as a four part for the 
base wizard which would become create new database, open existing 
database, connect to database, or modify a database by adding a CSV file 
as a table.


--Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] [ANNOUNCE] libreoffice-4.1.0.0.alpha1 tag created

[Dan Lewis]

On 05/08/2013 06:19 PM, Pedro wrote:

Hi all

1)

Under Options, LibreOffice, Personalization there is a new setting:
Background Image

To which Background does this image apply?

I assumed it would be the application background (when a document is not
loaded)...

If it is, then it doesn't work under Windows
 Personalization refers to personas that firefox introduced. The 
LibreOffice user mailing list contains a somewhat lengthly discussion 
about personans some time back. You might want to search the archives.


--Dan



2)

The About dialog is wrong again in Alpha 1... it seems to be correct every
other day...
https://bugs.freedesktop.org/show_bug.cgi?id=58034

It should be something like

Version: 4.1.0.0.alpha1
Build ID: 67ce08e2c64a6615abc90d3a3c442f90d86fa69
TinderBox: Win-x86@6, Branch:master, Time: 2013-05-03_06:12:36

not

Version: 4.1.0.0.alpha1
Build ID: 67ce08e2c64a6615abc90d3a3c442f90d86fa69



--
View this message in context: 
http://nabble.documentfoundation.org/Libreoffice-qa-ANNOUNCE-libreoffice-4-1-0-0-alpha1-tag-created-tp4054044p4054732.html
Sent from the QA mailing list archive at Nabble.com.
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Purposes for the Integer field types in LibO 4.0.2

[Dan Lewis]

Below is a table of Field Types for Integers, their lengths and ranges 
as listed in the LibreOffice 4.0.2.2 Base Table Design dialog.


/*Field Type name*/



/*Field Type*/



/*Length*/



/*Range*/

Tiny Integer



[TINYINT]



3



-128 to 127 (signed)
0 to 255

Small Integer



[SMALLINT]



5



-32,768 to 32,767

Integer



[MEDIUMINT]



7




Integer



[INTEGER]



10



-2,147,483,648 to 2,147,483,647

Integer



[INT]



10




BigInt



[BIGINT]



19



-9,223,372,036,854,775,808 to

9,223,372,036,854,775,807


 I have some questions about them.
1) What is the difference between [INT]  and [INTEGER]?
2) Do they have the same range?
3) What purpose does each of these field types serve?
4) Is there a link that describes the information for all of the field 
types used by the Table Design dialog?

5) What is the range for [MEDIUMINT]?

--Dan

___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Purposes for the Integer field types in LibO 4.0.2

[Dan Lewis]

Hello Robert,
 Thanks for the quick reply. You were right: I had a MySQL database 
when opened a table in Design View to see what the Field Types were in 
LO 4.0.2.2. I found MEDIUMINT when I searched my user guide for MySQL. 
It listed the lengths for these field types in terms of Bytes instead of 
bits. (I understand the meaning of both.) Once I saw what you had 
written, I understood how each of these lengths were written: 1 bit for 
the + or -, and the rest of the bits contain the number.
 I also have a copy of the HSQLDB 1.8 user guide on my hard drive 
and have seen this table there also.


--Dan

On 04/19/2013 02:37 PM, Robert Großkopf wrote:

Hello Dan,

the list you created I couldn't read so well, so I add a new list:
The data-types of the HSQLDB are defined in the description of the
HSQLDB. You can find the description here:
http://www.hsqldb.org/doc/1.8/guide/

[TINYINT]
-128 to 127

2⁸ (8 Bit) (-7 Bit to +7 Bit-1)

[SMALLINT]
-32,768 to 32,767

2¹⁶ (16 Bit) (-15 Bit to +15 Bit-1)

[INTEGER][INT]
-2,147,483,648 to 2,147,483,647

2³² (32 Bit) (-31 Bit to +31 Bit-1)

[BIGINT]
-9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

2⁶⁴ (64 Bit) (-63 Bit to +63 Bit-1)

Hope this will be readable. All types have the same range as the Java-types.


   I have some questions about them.
1) What is the difference between [INT]  and [INTEGER]?

No difference, see the HSQLDB-description


2) Do they have the same range?

See 1)


3) What purpose does each of these field types serve?

With every type is described, how much memory is needed for it.


4) Is there a link that describes the information for all of the field
types used by the Table Design dialog?

The shown field-types are different when you use different databases.
For the fields-types of the HSQLDB you have to look in the description
of the HSQLDB


5) What is the range for [MEDIUMINT]?

This isn't shown in the GUI, when you open a HSQLDB. I have just opend
LO 4.0.3.1 for have a look. Tis type isn't a type of the HSQLDB. Could
be you have found this type, when connecting to a MySQL-database. The
range of this type is
2²⁴ (24 Bit)
The unsigned versions of the datatype you could not chose with the
HSQLDB. The Java-Integer-Datatypes are all signed.

Regards,

Robert
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: Basic font for labels in a Base form

[Dan Lewis]

On 04/16/2013 02:05 AM, Lionel Elie Mamane wrote:

On Thu, Mar 28, 2013 at 10:43:30AM -0400, Dan Lewis wrote:

  Edit a Base form using LibreOffice 4.0.2.2 (32 bit Debian).
Control+right click a label in the form. Select Control from the
context menu. Click the elliplse ( ... ) for the Font property.
Click the Font tab in the Character dialog.
   Why is it that the Family font listed contains eight different
fonts as the (Default) font? Tools  Options  LibreOffice Writer

Basic Fonts permits me to select my fonts and font sized that I

want to use. Why does Base ignore these selections?
  Observation: LibreOffice 4.0.2.1 64 bit Debian uses the fonts I
selected in Tools  Options  LibreOffice Writer  Basic Fonts.

I don't know, and your reproductions instructions are not detailed
enough for me to understand. If there is a bug, I'd be glad to
understand it (our bugzilla is the best place for discussing bugs) and
review/commit a patch fixing it.

 Edit a Base form. Click one of the controls and then click the 
Control tool which opens the Properties dialog. Go down to the Font 
property. Click the ellipse to its right to open the Character dialog. 
For 4.0.2.2 (64 bit), the family font is Liberation Sans which is what I 
selected as mentioned above. However, for 4.0.2.2 (32 bit), the Font 
Property shows (Default). Clicking its ellipse, I opened the Character 
dialog. In the Font tab, I saw this as the font family (I copied this 
from the dialog):
Segoe UI;Tahoma;Arial Unicode MS;Lucida Sans Unicode;DejaVu Sans;Albany 
AMT;Albany;Arial;Nimbus Sans L;Interface 
User;Geneva;Dialog;Lucida;Helvetica;Helmet;Interface System;Sans Serif.
 Additional comment: Below the font family list was this quote: 
This font has not been installed. The closest available font will be used.


--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] [ANN] LibreOffice 3.6.6 RC2 available

[Dan Lewis]

On 04/10/2013 07:55 AM, Bjoern Michaelsen wrote:

On Tue, Apr 09, 2013 at 09:36:20PM -0400, Dan Lewis wrote:

   Next question. Has there been a change in where LibreOffice is
located? I installed LibreOffice 3.6.6.2 using the commands you gave
me above. This installed it in /usr/lib/libreoffice rather than
/opt/libreoffice3.6.  As a result I have 3.5.6.2 installed as well
as 3.6.6.2.

/usr/lib/libreoffice is the properly packaged build from Ubuntu/Debian
packaging. /opt/libreoffice is the TDF builds which are backwards compatible
with ancient distros. Dont use them, if you can get properly packaged builds
IMHO.

Best,

Bjoern

  Sorry, I meant 3.6.5.2 *not* 3.5.6.2.
  But I am still a bit confused about what is available at the PPA. 
I thought I was getting the build from TDF rather than from 
Ubuntu/Debian. Yet, when I opened Synaptic and looked at what I had 
installed, it indicated that I had gotten the  build from Ubuntu/Debian, 
namely 1:3.6.6~RC2-0ubuntu~precise~ppa2. That download was approximately 
97 MB. The TDF built download (3.6.6.2) is 179 MB.
So, what are the difference between these two builds? Since I am 
involved in TDF documentation, I probably need to continue to download 
the builds from the TDF website.
 Thanks for sending me a copy of what you posted to QA. It was very 
thoughtful of you. I am subscribed to the QA mailing list so this will 
not be necessary. (I also am subscribed to the DEV, documentation, and 
user mailing lists (I'm not sure how important this is to others.


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Bug 63388: Mail Merge Email

[Dan Lewis]

  I have filed this bug because I can not get LibreOffice to test 
the settings I enter into
Tools  Options  LibreOffice Writer  Main Merge. It freezes everytime. 
All the information I enter is copied from the Account Settings in 
Thunderbird. I have verified that the password I entered will open Gmail 
on the Google website. I use IMAP rather than POP3.
  Do others have this problem? Is there something special that I am 
not doing to cause LO to freeze when running this test?


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] [ANN] LibreOffice 3.6.6 RC2 available

[Dan Lewis]

On 04/09/2013 02:11 PM, Bjoern Michaelsen wrote:

Hi all,

On Mon, Apr 08, 2013 at 09:15:33AM +0200, Thorsten Behrens wrote:

The release is available for Windows, Linux and Mac OS X from our QA
builds download page at

   http://www.libreoffice.org/download/pre-releases/

... and Ubuntu users can test the versions for Ubuntu 12.10 (quantal) and
Ubuntu 12.04 (LTS precise) at this ppa:

  https://launchpad.net/~libreoffice/+archive/libreoffice-3-6

for a few days already. Sorry for the late notification.

Best,

Bjoern
___

 The ppa for 64 bit does not seem to work. The instructions for 
using ppa refer to using the command line. Yet, the  technical 
information for the ppa is designed to be used with Ubuntu's Update Manager:


debhttp://ppa.launchpad.net/libreoffice/libreoffice-3-6/ubuntu  precise  main
deb-srchttp://ppa.launchpad.net/libreoffice/libreoffice-3-6/ubuntu  precise  
main

Was this link for 32 or 64 bit?

--Dan


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] [ANN] LibreOffice 3.6.6 RC2 available

[Dan Lewis]

On 04/09/2013 03:37 PM, Bjoern Michaelsen wrote:

Hi,

On Tue, Apr 09, 2013 at 02:42:28PM -0400, Dan Lewis wrote:

  The ppa for 64 bit does not seem to work. The instructions for
using ppa refer to using the command line. Yet, the  technical
information for the ppa is designed to be used with Ubuntu's Update
Manager:

deb http://ppa.launchpad.net/libreoffice/libreoffice-3-6/ubuntu  precise  main
deb-src http://ppa.launchpad.net/libreoffice/libreoffice-3-6/ubuntu  precise  
main

Was this link for 32 or 64 bit?

Both. ;)

  sudo add-apt-repository ppa:libreoffice/libreoffice-3-6
  sudo apt-get update
  sudo apt-get install libreoffice

should get you 3.6.6.

Best,

Bjoern
  Next question. Has there been a change in where LibreOffice is 
located? I installed LibreOffice 3.6.6.2 using the commands you gave me 
above. This installed it in /usr/lib/libreoffice rather than 
/opt/libreoffice3.6.  As a result I have 3.5.6.2 installed as well as 
3.6.6.2.


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: LibreOffice prints on tuesdays

[Dan Lewis]

On 04/01/2013 06:14 AM, Bjoern Michaelsen wrote:

Hi,

I am happy to be able to be able to provide a prototype of the LibreOffice
prints on Tuesdays extension here:

  http://skyfromme.wordpress.com/2013/04/01/libreoffice-prints-on-tuesdays-only/

I consider this an important feature an would love to see see it bundled with
LibreOffice 4.0 and 4.1, and will propose so on the ESC call. Any feedback on
this is welcome.

Best,

Bjoern
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

 What is the purpose of this extension? Why print only on Tuesdays?


___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: LibreOffice prints on tuesdays

[Dan Lewis]

On 04/01/2013 09:47 AM, Anthonys Lists wrote:

On 01/04/2013 11:49, Luc Castermans wrote:

Op 01-04-13 12:43, Dan Lewis schreef:

On 04/01/2013 06:14 AM, Bjoern Michaelsen wrote:

Hi,

I am happy to be able to be able to provide a prototype of the 
LibreOffice

prints on Tuesdays extension here:

http://skyfromme.wordpress.com/2013/04/01/libreoffice-prints-on-tuesdays-only/ 



I consider this an important feature an would love to see see it 
bundled with
LibreOffice 4.0 and 4.1, and will propose so on the ESC call. Any 
feedback on

this is welcome.

Best,

Bjoern
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

 What is the purpose of this extension? Why print only on Tuesdays?



April 1st is not on Tuesday


It is - it'll take a year to get it debugged and then it'll work fine 
when required...


Cheers,
Wol



 Are you sure that it will only take a year??? I am thinking it 
might take 6 years :-D


--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] talkyoo issues

[Dan Lewis]

On 03/29/2013 06:18 AM, Florian Effenberger wrote:
No, unfortunately not - we cannot get SIP routing for these numbers, 
and if we were to buy numbers in foreign countries, it would cost a 
few hundred if not thousand EUR per month...


Jonathan Aquilina wrote on 2013-03-28 23:47:

I have a suggestion. Would it be possible to have another VoIP server
such as asterisk using the same numbers as a backup in case talkyoo has
issues?

 Has anyone considered Google Hangout which is a part of Google 
Plus? Would this work?


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Basic font for labels in a Base form

[Dan Lewis]

 Edit a Base form using LibreOffice 4.0.2.2 (32 bit Debian). 
Control+right click a label in the form. Select Control from the context 
menu. Click the elliplse ( ... ) for the Font property. Click the Font 
tab in the Character dialog.
  Why is it that the Family font listed contains eight different 
fonts as the (Default) font? Tools  Options  LibreOffice Writer  
Basic Fonts permits me to select my fonts and font sized that I want to 
use. Why does Base ignore these selections?
 Observation: LibreOffice 4.0.2.1 64 bit Debian uses the fonts I 
selected in Tools  Options  LibreOffice Writer  Basic Fonts.


--Dan

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

TestExtension.oxt: What is its purpose?

[Dan Lewis]

 I recently built LibreOffice on 4.0 while also building a 
mysql-connector-ooo. In the same folder as this one I found two other 
extensions: reportbuilder.oxt and TestExtension.oxt. What purpose does 
the latter serve, and how should it be used? I have searched for 
information about it, but found nothing.


--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Missing service SvgWriter - forgotten when rebasing with AOO

[Dan Lewis]

  Thanks for the information. Over the weekend, I have built a 
linux MySQL connector for both x86 and x86-64 using the LibreOffice 4.0 
branch.
  Now to determine how to modify the .oxt file so that its 
information is correct, but this is another subject. Time to do some 
research before asking more questions.


--Dan

On 03/10/2013 09:29 AM, Markus Mohrhard wrote:

snip

You should not use master if you want something for productive use.
Use the 4.0 branch where everything is still like before.

Testing master is of course appreciated but you should also note that
it is still unstable and incompatible changes might happen. To
announce these changes or fix them we still have a few months to the
4.1 release. IF you want to build the MySQL Connector use the
libreoffice-4-0 branch which should work for all 4.0.x builds.

Regards,
Markus
 I have already used master to create a 32 bit 
mysql-connector.ooo.oxt for Linux. this connector works on LibreOffice 
4.0.0.3, 4.0.1.2, as well as 4.1.0.0 alpha (built from master) but not 
for 3.6 or earlier.
 The web page is rather unclear as to how to use git to get the 4.0 
branch.

___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Missing service SvgWriter - forgotten when rebasing with AOO

[Dan Lewis]

On 03/11/2013 12:24 PM, Rodolfo wrote:

2013/3/11 Jonathan Aquilina eagles051...@gmail.com:

Its quite simple a git checkout BRANCH NAME. one thing I will admit is that
im not sure how to get a list of available branches for checkout.

Just do a
$ git branch

Actually, once the development tools have been installed, the steps are:

1)  $ git clone git://gerrit.libreoffice.org/core
2)  cd core
3)  ./autogen.sh --enable-ext-mysql-connector --with-system-mysql
4)  make fetch
5)  ./g checkout -b libreoffice-4-0 origin/libreoffice-4-0

 Step 3 contains the options that apply to autogen.sh.
 Step 4 is only needed to correct any errors listed in Step 3.

 I read and reread the web page describing how to create a build 
from source before I could understand what the directions are.


--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-qa] Questions about contents of an extension file (mysql-connector-ooo.oxt

[Dan Lewis]

 I'm not sure to which mailing list this should go to. Perhaps 
someone could tell me. I have created a linux mysql-connector (x86 and 
.x86-64). There are things that I want to know about the contents of the 
extension.


Questions about changing the description.xml file in the extension:

1) How do I change this to refer strictly to LibreOffice, or should I 
change it?


description xmlns=http://openoffice.org/extensions/description/2006; 
xmlns:d=http://openoffice.org/extensions/description/2006;

xmlns:xlink=http://www.w3.org/1999/xlink;

2) How do I change the dependencies to LibreOffice 4.0?

dependencies
 OpenOffice.org-minimal-version value=3.3 
d:name=OpenOffice.org 3.3/

/dependencies

Questions about changing the manifest.xml file in the extension:

1) Can I change the reference to OOo to LO? If so, what part should be 
changed? Can /data/org/openoffice/Office/ be changed to 
libreoffice/Office as long as the openoffice folder is renamed to 
/data/libreoffice/Office/? (The path to the Drivers.xcu will have to be 
changed.)


manifest:manifest xmlns:manifest=http://openoffice.org/2001/manifest;
manifest:file-entry 
manifest:media-type=application/vnd.sun.star.uno-components;platform=linux_x86

manifest:full-path=components.rdb/
manifest:file-entry 
manifest:media-type=application/vnd.sun.star.configuration-data

manifest:full-path=registry/data/org/openoffice/Office/DataAccess/Drivers.xcu/
/manifest:manifest

Questions about changing the components.rdb

1) Can it be modified to replace openoffice with libreoffice?

2) How can I get the extension's license to appear and require consent 
when installing the extension?


--Dan

___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: Missing service SvgWriter - forgotten when rebasing with AOO

[Dan Lewis]

On 03/07/2013 11:47 AM, Noel Grandin wrote:

how about you give it a try and ask back here if you have difficulties.

On Thursday, 7 March 2013, Fernand Vanrie wrote:

Michael ,

OK ,  but we need SVG and a working Native mySQL connector :-)

so: any news about a volonteer to compile Connector for 4.0
(windows) ?

Greetz

Fernand

Hi Fernand,

On Thu, 2013-03-07 at 08:45 +0100, Fernand Vanrie wrote:

any change the SVG stuff and this repairs happens also for
later 3.6
releases ?

That seems unlikely; one reason is that I'd expect the
SVG code to be
significantly different for 3.6 :-)

HTH,

Michael.

 What good will it be to get a volunteer to build a mysql connector 
for 4.0 if the connector can not be build? There are problems on OS X 
and LInux because of changes made in autogen.sh. This needs to be fixed 
first before finding a volunteer.

 Until recently, this is used to configure the connector:
./autogen.sh --enable-ext-mysql-connector --with-system-mysql.

 In the last couple of days, this has been changed (without 
seemingly any documentation on this mailing list) to:

./autogen.sh --enable-ext-mariadb-connector --with-system-mariadb.

 One other problem in building this connector that did not exist 
prior to the change from mysql to mariadb: autogen.sh does not find the 
installed version of mariadb. This also prevents building the connector.

 This is the output containing the errors:

checking whether to build the MariaDB/MySQL Connector extension... yes
checking which MariaDB to use... external
checking for mariadb_config... no
checking MariaDB version... ./configure: line 21356: --version: command 
not found

./configure: line 21357: --version: command not found
./configure: line 21358: test: : integer expression expected
configure: error: too old, use 5.0.x or 5.1.x
Error running configure at ./autogen.sh line 201.
 It appears that this problem should be corrected first before 
trying to build the MariaDB/MySQL connector.


--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

[Libreoffice-qa] proposed mysql-connector-ooo for 32 bit Linux for LibreOffice 4.X

[Dan Lewis]

 I have built  this connector while also building LibreOffice 4.0.1 
alpha. I am also beginning the process to add it to the Extensions on 
the LO website. Since the previous 32 bit connector for mysql no longer 
works for 4.X, I wonder if this will change the information needed to 
make it available to the Extensions pages. LO 4.0.1.2 recognizes it as 
MySQL Connector 1.0.2.

  So, any suggestions as what to do in a case like this?

--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: Building MySQL-Connector on Ubuntu 12.04 32 bit

[Dan Lewis]

On 02/27/2013 05:55 AM, Stephan Bergmann wrote:

On 02/27/2013 02:10 AM, Dan Lewis wrote:
1) git clone git://gerrit.libreoffice.org/core libo to get the source 
code.

2) cd libo
3) ./autogen.sh --enable-ext-mysql-connector --with-system-mysql
4) make dev-install 21 | tee build.log

  While running #4, I saw 2 notes in the Terminal:
Recompile with -Xlint: deprication for details
Recompile with -Xlint: uncheck for details


Those are harmless warnings from javac, about somewhat smelly places 
in the source.  (See 
http://docs.oracle.com/javase/6/docs/technotes/tools/solaris/javac.html, 
-Xlint:deprecation shows a description of each use or override of a 
deprecated member or class and -Xlint:unchecked shows more detail 
for unchecked conversion warnings that are mandated by the Java 
Language Specification.)


Stephan


  Work that I have completed:
1) I have built a mysql-connector-ooo.oxt along with LibreOffice Version 
4.1.0.0.alpha0+ (Build ID: f2e706d87399911e300c0101c876e44f2819c50). 
This is a 32 bit build.
2) I have used these two builds to connect to a MySQL 5.5 server 
locally. Very little testing done yet other than opening forms and 
looking the contents of a couple of queries.
3) I have used them to connect to a MySQL 5.5 on a network remotely. 
Similar regular testing.
4) I ran LibreOffice Version 4.0.1.1 (Build ID: 
2c0c17a6e4bee0ee28131ea4bdc47edc700d659). I installed the 
mysql-connector-ooo.oxt file on 4.0.1.1. (Extension Manager show it to 
be version 1.0.2.) I can also connect locally or remotely to the two 
MySQL 5.5 servers and ran similar testing.
5) I installed this MySQL Connector 1.0.2 on 4.0.1.1, but I can not 
connect to either server.
6) I am beginning a 3.6 version beginning with git checkout -b 
libreoffice-3-6 origin/libreoffice-3-6

.

--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Building MySQL-Connector on Ubuntu 12.04 32 bit

[Dan Lewis]

On 02/27/2013 05:55 AM, Stephan Bergmann wrote:

On 02/27/2013 02:10 AM, Dan Lewis wrote:
1) git clone git://gerrit.libreoffice.org/core libo to get the source 
code.

2) cd libo
3) ./autogen.sh --enable-ext-mysql-connector --with-system-mysql
4) make dev-install 21 | tee build.log
 A couple of days ago I ran #1 to get the source code. Since that 
time I have been using a copy of it to run the other steps.
 Today added to #4: 21 | tee autogen.log and ran it. This is all 
references to mysql during that run. Perhaps there is a problem with this?


checking whether to build the MySQL Connector extension... yes
checking for MySQL prerequisites... external MySQL
checking for mysql_config... /usr/bin/mysql_config
checking MySQL version... OK
checking for MySQL Client library... includes -I/usr/include/mysql, libraries 
-L/usr/lib/i386-linux-gnu -lmysqlclient -lpthread -lz -lm -lrt -ldl
checking MySQL Connector/C++... internal

--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Building MySQL-Connector on Ubuntu 12.04 32 bit

[Dan Lewis]

On 02/27/2013 05:55 AM, Stephan Bergmann wrote:

On 02/27/2013 02:10 AM, Dan Lewis wrote:
1) git clone git://gerrit.libreoffice.org/core libo to get the source 
code.

2) cd libo
3) ./autogen.sh --enable-ext-mysql-connector --with-system-mysql
4) make dev-install 21 | tee build.log

  While running #4, I saw 2 notes in the Terminal:
Recompile with -Xlint: deprication for details
Recompile with -Xlint: uncheck for details

Additional problems after running #4:
a) Both mysql-connector-ooo.oxt that were built have a size: 432891 
bites. (Too small)

b) mysqlc.uno.so: 589K (too small)
c: No libmysql.so.16 (AOO mysql-connector-ooo-1.0.1-linux-intel.oxt 
contains this file and it has size 4.5 MB)


Question: Where do I look in the build.log file to locate what is 
causing the built for this connector to be so small and have a missing file?


--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: Building MySQL-Connector on Ubuntu 12.04 32 bit

[Dan Lewis]

On 02/27/2013 11:28 AM, Dan Lewis wrote:

On 02/27/2013 05:55 AM, Stephan Bergmann wrote:

On 02/27/2013 02:10 AM, Dan Lewis wrote:
1) git clone git://gerrit.libreoffice.org/core libo to get the 
source code.

2) cd libo
3) ./autogen.sh --enable-ext-mysql-connector --with-system-mysql
4) make dev-install 21 | tee build.log

  While running #4, I saw 2 notes in the Terminal:
Recompile with -Xlint: deprication for details
Recompile with -Xlint: uncheck for details

Additional problems after running #4:
a) Both mysql-connector-ooo.oxt that were built have a size: 432891 
bites. (Too small)

b) mysqlc.uno.so: 589K (too small)
c: No libmysql.so.16 (AOO mysql-connector-ooo-1.0.1-linux-intel.oxt 
contains this file and it has size 4.5 MB)


Question: Where do I look in the build.log file to locate what is 
causing the built for this connector to be so small and have a missing 
file?


--Dan
 Added comment: I searched the build.log file for libmysql.so. The 
file does not contain it explaining why it is not in the output. But why?


--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Building MySQL-Connector on Ubuntu 12.04 32 bit

[Dan Lewis]

1) git clone git://gerrit.libreoffice.org/core libo to get the source code.
2) cd libo
3) ./autogen.sh --enable-ext-mysql-connector  --with-system-mysql
4) make dev-install 21 | tee build.log

 While running #4, I saw 2 notes in the Terminal:
Recompile with -Xlint: deprication for details
Recompile with -Xlint: uncheck for details
 First of all how do I recompile after make dev-install?

--Dan
___
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice

Re: [Libreoffice-qa] [libreoffice-users] Re: MySQL-Connector

[Dan Lewis]

On 02/22/2013 08:24 AM, Alex Thurgood wrote:

Le 22/02/2013 14:02, Dan Lewis a écrit :

Hi Dan,


  Some very good news!!! ... and some questions.
  Last evening, I deleted the libo folder and basically began again
using git. I let make run overnight. This morning, I accidentally ran
make install getting an error message of not being able to create a
folder in /usr/... . So, I used sudo make install instead. The build
was installed in /usr/lib/... . So, being curious, I tried sudo make



Hmm, you should've probably done a make dev-install instead of make 
install, as now, you've got a link to your dev build in your 
/usr/lib/, i.e. it will have overwritten any default LO installation 
that you already had, I think. The advantage of make dev-install is 
that it keeps everything in your LO development directory.




install instead. The build was installed within the solver folder as it
should be. I made ooenv executable and ran it. Since then I have run
soffice and looked at Help  About LibreOffice. I now have my own alpha
build number!
  One further test: I ran Base in my new LO-DEV opening MySQL.odb
which connects to my MySQL server. (This is a copy of the file I use to
connect to MySQL. So, if it becomes corrupted, I still have the original
database file.) I successfully connected to the MySQL server.
  Again because I was curious, I looked at the libreoffice
configuration folder, specifically the extension folder. It contained
buildid file which contained a number. I checked this number against the
build number of my new Alpha version. They matched.
 It appears that I have created an alpha version of the MySQL native
connector. So where is this connector in the extension folder? What is
the next step to convert it into the .oxt final version?


The connector itself isn't alpha anything, as the actual connector 
libary code doesn't change version much, and was only bumped to 1.0.2 
last year with a change in the requirement for the version of 
libmysqlclient.


As for its whereabouts, you should be able to find it here :

/core/workdir/unxlngx6.pro/ExtensionTarget/mysql-connector-ooo.oxt

and

/core/solver/unxlngx6.pro/bin/mysql-connector-ooo.oxt

and

/core/mysqlc/unxlngx6.pro/bin/mysql-connector-ooo.oxt


In my builds, it has a size of about 2Mb. This is because the 
connector links to libmysqlclient and libmysqlcppconn, whereas on the 
Mac, it is packaged altogether with these libraries (or at least it 
should be) leading to an OXT file that weighs in at about 4Mb.


Alex


 What I have done:
Created a folder for the files for the LO build: LO-Build.
Added the AOO mysql-native-connector 1.0.1 to LO 4.0.0.3, and closed LO.
Installed libmysqlclient18 and libmysqlcppconn5
Used git to download the master build.
Ran autogen.sh --with-ext-mysql-connector --with-system-mysq
Ran make dev-install
Made ooenv executable and ran it.
Ran soffice in the program folder of my new alpha build.
 But when I searched for mysql-connector on the command line (I ran 
sudo updatedb first). I found a folder named 
lu17qwu9.tmp_/mysql-connector-ooo-1.0.1-linux-intel.oxt. This is located at
/home/dan/.config/libreoffice/4/user/uno_packages/cache/uno_packages/. I 
had earlier also installed the same mysql-native-connector on LO 
3.6.5.2. If it matters, doing this search I found a similar folder in 
/home/dan/.config/libreoffice/4/user/uno_packages/cache/uno_packages/:

luxhljqk.tmp_/mysql-connector-ooo-1.0.1-linux-intel.oxt/.
 So, the question is this: Where is the mysql-connector that was 
suppose to be built with LO?


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Stagnant NEEDINFO bugs

[Dan Lewis]

On 02/06/2013 09:50 AM, Robert Großkopf wrote:

Hi Alex,

After suffering from the last two mass closure / re-initialisations of
status of a fair number of bugs I had spent time in opening, but for
lack of a dedicated developer / interest in those particular areas of LO
at the time (OSX bugs, Base bugs) they never got any attention, I for
one, will not be interested in this happening yet again.

All open bugs in Base today: 225
Bugs, which are Unconfimed: 27
Bugs, which are Needinfo: 26
I don't think that we need automatically way to get these bugs away.
Problem of many of these bugs: They couldn't be confirmed by everybody,
because there are special configurations with external databases or Mac.
What we need: developers, who will work on bugs in Base. There are many
bugs New and opened since the first version of LO.

Robert
 I agree with Robert. This also goes to a complaint that I saw on 
the LibreOffice user list. The person wanted more time spent by the 
developers on removing the bugs that exist in LO and less time on 
producing more code that contains more bugs. This is poor planning. From 
Robert's data, 172 open bugs have not had a developer correct . These 
are the ones that have been confirmed and contained enough data for a 
developer to begin work. That is 76% of the bugs reported for Base.
 A bug reporting system is only as good as the resources allocated 
to fixing the bugs. Otherwise, people send in bug reports that may or 
may not even have a developer look at them. Meanwhile, another milestone 
is reached as a newer version comes out containing some of these bugs. 
Where is the quality assurance in that?
 The symptom we have is many bug reports that need additional 
information. But what is causing this? Could it be that there are too 
many versions being produced at the same time? (3.6.5 and 4.0.0) 
Personally, I think LO (perhaps the BOD) needs to look at what is being 
done and what effects it is having on the product they are making 
available for downloading.


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Weird crash of LO 4.0.0 RC2 on starting Python and Java wizards

[Dan Lewis]

On 01/28/2013 03:49 AM, Jean-Baptiste Faure wrote:

Hi all,

Please, could you try to reproduce the crash I described in the bug
report 59931 : https://bugs.freedesktop.org/show_bug.cgi?id=59931

For the moment I am alone who can reproduce this bug ...

Best regards.
JBF
 Sorry, but LO 4.0.0.2  (Ubuntu 12.04 LTS  32 and 64 bit: tested on 
2 computers) does not crash under the conditions you mention.


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Bug 59481 - FILEOPEN: Linux rpm: Native MySQL-connector aoo-my-sdbc-1.1.0 didn't work any more with LO 4.0

[Dan Lewis]

On 01/21/2013 11:55 AM, Lionel Elie Mamane wrote:

On Sat, Jan 19, 2013 at 11:17:20AM -0500, Terrence Enger wrote:

On Fri, 2013-01-18 at 08:04 -0800, Joel Madero wrote:

Can someone triage this one? Thanks in advance!

And there has been quit a bit of subsequent discussion.
I wonder just what Lionel was proposing [1] after the announcement
[2] of changed licence for the mariadb / mysql client library.

I was commenting that for LibreOffice, this is not sufficient. We, as
a project, have decided not to ship (binaries compiled from) GPL
code in our main product, that is LibreOffice (we do ship GPL code
that does not end up in LibreOffice, e.g. in
http://cgit.freedesktop.org/libreoffice/contrib/dev-tools/tree/make-3.82-gbuild
).

The MySQL native (SDBC) connector is made as follows::

  MySQL SDBC connector itself (SISSL / Apache / LGPL licence,
   depending on version)
using
  MySQL Connector/C++ (GPL)
using
  MySQL Connector/C (AKA libmysql or client Library) (GPL)


Swapping out the MariaDB client library for the MySQL client library
brings the picture to:

  MySQL SDBC connector itself
using
  MySQL Connector/C++ (GPL)
using
  libmariadb (LGPL)

So still not OK for integration into LibreOffice proper, because still
a GPL component.

For us to be able to ship the MySQL SDBC connector (with our current
self-imposed policy), one of these things has to be done:

1) Write an Apache/BSD/LGPL/... licensed clone of MySQL
Connector/C++

OR

2) Change the MySQL SDBC connector to not need MySQL Connector/C++,
but use libmysql/libmariadb directly (these are API-compatible; we
would ship with libmariadb, but if a downstream user would want to
swap it with libmysql, technically there should be no problem)

But that's only *our* policy. Any third party can make a different
choice, and e.g. Debian has made another choice and *does* ship GPL
code, including the MySQL Connector/C++ and the MySQL SDBC connector
for use with LibreOffice. It is my understanding any such third party
would be allowed to upload the MySQL SDBC connector for use with
LibreOffice to extensions.libreoffice.org; I don't see on that website
a policy that forbids that. If any such third party would do that, at
least for Microsoft Windows and MacOS X, I believe it would make some
of our users happier.

 Then perhaps it is time to reconsider *your* policy. Or, perhaps 
you should explain to us what problem does the GPL license present to 
LibreOffice? This seems a little hypocritical. You will not include GPL 
licensed code in LO that you make available for download. Yet, the same 
website can contain extensions that include GPL licensed code. As a 
result, we the users of LO may have to use inferior software in the 
extensions because you will not provide us with a good SDBC to connect 
to MySQL or MariaDB.
 There is another possibility: provide a JDBC that can be used. Is 
there a license problem with that also? I know there is a potential Java 
problem.


--Dan


How would this compare in effort and benefit to the job of making
the mysql extension work with LibreOffice 4.0?

The MySQL extension just needs to be compiled/linked against
LibreOffice 4.0; then it should work. No development work needed. Only
building (for GNU/Linux and MacOS (if necessary): on an OS install as
old as what the extension wants to be compatible with).

So, here's how it compares in effort and benefit, it being the
stuff described in the ESC minutes that you linked to.

  - MUCH more work

  - MUCH more benefit, since it would allow the MySQL SDBC connector to
be bundled with LibreOffice. I will *gladly* review a patch that
does that!


Just by the way, does this change of licence return mysql to
consideration for LO's built-in database [4]?

No, because this is only the client library, not the database engine
itself. For our embedded database, we want to ship a database
engine. The database engine is still GPL. Be it MySQL or MariaDB.



___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Bug 59481 - FILEOPEN: Linux rpm: Native MySQL-connector aoo-my-sdbc-1.1.0 didn't work any more with LO 4.0

[Dan Lewis]

On 01/19/2013 03:43 AM, Robert Großkopf wrote:

Hello Dan,

I have reported
https://bugs.freedesktop.org/show_bug.cgi?id=59481
(FILEOPEN: Linux rpm: Native MySQL-connector aoo-my-sdbc-1.1.0 didn't
work any more with LO 4.0)
and
https://bugs.freedesktop.org/show_bug.cgi?id=59516
(FILEOPEN: Native MySQL-connector couldnt be installed under Windows in
LO 4.0)

I looked through the bugs reports for possible duplication. I
found 59481 (Linux 32 bit RPM) which is this one,
59533 (Windows 32 bit), and 59516 (Windows 32 bit). All of them have the
same problem: the MySQL native connector can not be used to connect to a
MySQL data source. I use Ubuntu 12.04 LTS 32 bit, and I have the same
problem with the MySQL native connector. My conclusion is that the 32
bit version of it has a regressive bug. I can use this connector with LO
3.5.7.2 and 3.6.4.3 but not 4.0.0.1RC.
   Being new at this, should I change Platform to All for 59481?
Should 59533 and 59516 be marked as duplicates? Should I mark 59481 as
confirmed? I believe that these are the things that need to be done.

There is a difference in the behavior under Linux and Windows. The old
connector 1.0.1 doesn't work under Linux since 3.5. So you could only
connect with the 1.1.0 of AOO. Under Linux this connector could be
installed in LO 4.0.0.1 rc. Under Windows the installation fails.
Linux-user might think: Connector is installed, no error appears, should
work - but it doesn't: ... No SDBC driver was found for the given URL.
 OK, I understand. Perhaps this points to a possible bug in the 
Extension Manager itself. The AOO version of this connector seems to 
install, but it fails to enable the connector. I have clicked the 
connector, and two buttons appear: Enable and Delete. When I click the 
Enable button, I get the error message.
 Seems to me that installing an extension should also enable it. 
Then if someone wants to disable an extension, he can open the Extension 
Manager to do this. This might be a bug, or is it a feature request?


--Dan

First I thought it was the same problem at Windows, but it wasn't (I
have no Window here at all, so it is reported from other persons by mail
to me). So I have to report another bug. See
https://bugs.freedesktop.org/show_bug.cgi?id=59481#c1

Only one bug in one report I have often heard. So I linked this two
reports with See also ...

Bug 59533 is a duplicate of 59516. Don't know, why the reporter is
writing a new bug. He always noticed bug 59481 and then he could also
notice the link to bug 59516. I will mark this report as a duplicate.

Regards

Robert
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] Spam on this mailing list

[Dan Lewis]

Can someone do something about the spam that is being sent to 
libreoffice-qa@lists.freedesktop.org?


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Bug 59481 - FILEOPEN: Linux rpm: Native MySQL-connector aoo-my-sdbc-1.1.0 didn't work any more with LO 4.0

[Dan Lewis]

On 01/18/2013 11:04 AM, Joel Madero wrote:

Can someone triage this one? Thanks in advance!


Best Regards,
Joel


   I looked through the bugs reports for possible duplication. I 
found 59481 (Linux 32 bit RPM) which is this one,
59533 (Windows 32 bit), and 59516 (Windows 32 bit). All of them have the 
same problem: the MySQL native connector can not be used to connect to a 
MySQL data source. I use Ubuntu 12.04 LTS 32 bit, and I have the same 
problem with the MySQL native connector. My conclusion is that the 32 
bit version of it has a regressive bug. I can use this connector with LO 
3.5.7.2 and 3.6.4.3 but not 4.0.0.1RC.
  Being new at this, should I change Platform to All for 59481? 
Should 59533 and 59516 be marked as duplicates? Should I mark 59481 as 
confirmed? I believe that these are the things that need to be done.


--Dan

___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Impress bug

[Dan Lewis]

 Yes, I'm believe it is fixed. I opened the presentation using LO 
3.6.4.3 and got the same logo that you did. It did mess it up that is 
for sure. LO 4.0 Beta shows the logo as it should be; LO 3.6.4.3 does not.


--Dan

On 12/15/2012 01:33 PM, Karl Leo wrote:

Dear Cor,
thanks for your help! Maybe I created some confusion here. The file 
Libre_graphics_bug.odt attached does open well on my computer 
(Thinkpad t400s, 4GB, Ubuntu 12.04, LO 3.6.4.3).
However, the Fraunhofer logo is rendered incorrectly (upper graph in 
Logo_problem.png). The correct rendering is the one shown as lower 
graph in that file.
I could not test it on 4.0 myself  because on my computer I use at 
work, LO 4.0 crashed at startup, I do not have access to it over the 
weekend.
What I wanted to achieve with my posting is to help others find out 
whether this (for me very annoying bug) is solved in 4.0, and if I 
understand your and Dan's mail correctly, it is fixed... Hope I am 
right...

Best regards
Karl




On 15.12.2012 15:12, Cor Nouws wrote:

Dear Karl,

Thanks for writing and your information!

Karl Leo wrote (15-12-12 12:43)


[...] It cannot even render the logo
of the Fraunhofer society correctly (see enclosed file)


The file opens perfect for me on Ubuntu 12:04 and LibreOffice 4.0.0 
beta1.



I could not contribute so far because on my computer (thinkpad T400s
with Ubuntu 12.04.1), LO 4.0.0 crashes at startup...


Then maybe we can help you?
How did you install it?
Would you be able to remove the user profile for 4.0 and start again?

Kind regards,

Cor






___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] 4.0 Test week/marathon Re: [...-qa] 3.7 bug hunt party ?

[Dan Lewis]

 Perhaps a little bit OT, but what is the correct link to download 
the 4.0.0 Beta? Below I saw


Beta1 build is in progress. Linux and MAC packages are even already available 
at
http://dev-builds.libreoffice.org/pre-releases/;

but the only Beta available at this link is for the Intel Mac. I have a 
partition on my hard drive for Ubuntu 12.04 64  bit but no Deb files I can use 
to test Base.

--Dan


On 12/06/2012 06:16 AM, Petr Mladek wrote:

Cor Nouws píše v St 05. 12. 2012 v 10:53 +0100:

Hi Michael,

Michael Meeks wrote (05-12-12 10:34)


So - my hope would be that our Beta1 would be of a better quality than
previous betas out of the door :-) but lets see.

Yep - fully agree with even such an expectation.



I did some very basic testing yesterday and did not find any problem, so
I am much more optimistic now ;-)

Why was I so careful? If you look at
http://dev-builds.libreoffice.org/pre-releases/src/commits-libreoffice-4-0-release-4.0.0.0-alpha1-to-beta1.log
there were about 1350 commits between alpha1 and beta1. Master was
hardly buidable entire Monday and big part of Tuesday. I wanted to be
rather careful with any promises and estimations.


Still the natural behaviour of devs to do a lot of work, push late
and take some risks, should be closely watched ;-)

I am afraid that we could not do much about this. We could encourage
but this is natural behavior for most people.

In fact, I want to say a big thank you to all developers. Of course,
there was some pain. But after all this has been the easiest beta1 from
my point of view in compare with older releases.

I think that testing from Thursday 13 to Wednesday 19th is perfectly fine and
beta1 state looks promising for it.



When is the freeze for RC1 planned? It would be useful to have testing
done so that the devs that are available, could do something with the
result before the RC1?

Quite; I think the details you want are all in the wiki:
http://wiki.documentfoundation.org/ReleasePlan/4.0

Know that, but fail to read when freeze for RC1 is - or is that the
range Jan 7 - Jan 13, 2013 ?
That doesn't help much with strict planning of a QA event..

Heh, it describes real life. We used exact dates in the past but there
were delays of few days from time time. The typical proceeding is
described at http://wiki.documentfoundation.org/ReleasePlan#Dates. We
are one day behind with beta1 so far.

I am looking forward to see the test week/marathon happen. Thanks a lot
for organizing it.


Best Regards,
Petr



___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] 4.0 Test week/marathon Re: [...-qa] 3.7 bug hunt party ?

[Dan Lewis]

On 12/03/2012 01:13 PM, Joel Madero wrote:
On Mon, Dec 3, 2012 at 7:29 AM, Petr Mladek pmla...@suse.cz 
mailto:pmla...@suse.cz wrote:


Hi Cor,

I am happy to hear from you.

Cor Nouws pís(e v Ne 02. 12. 2012 v 23:34 +0100:
 Hi all,

 After the few initial mails about this, and looking at 'the'
agenda, I
 propose the following:

 Have either
a)  a LibreOffice 4.0 Test Week from Monday 10 - Sunday 16th

I am slightly scared what would happen if beta1 is not usable in the
end. Today's build still seems to work but people are still
pushing last
minute features... :-)

 or
b)  a LibreOffice 4.0 Test marathon from Thursday 13 -
Wednesday 19th

We will already have freeze for beta2 at this point but it still looks
like the best compromise to me. Well, I might be to pessimistic ;-)

 (A full week from 17-23 would be to close to Xmas, IMO).

Yup, people will be busy with getting Xmas presents these days :-)

 With the promise that
   -  we mobilise as much people from our regular teams to show
up for
 support of new-bees;
   - we of course provide comprehensive, clear info to get started;
   - we focus both on random testing, scenario's and bug triage.

 By spreading it over 7 days, it's easier for people to feel able
to join :-)

 Initial announcements would not be too hard. Could do that
 Monday/Tuesday (evening).
 Exchange among team members for availability can be done later
this week.
 Preparing info is rather easy...

Sounds great. Thanks a lot for taking care of it.


I'd be able to participate off and on. My wife's and my birthday falls 
in that range as well as of course Christmas stuff and a few other 
things.


I want to learn how to do these random tests, any pointers? I'll also 
be triaging throughout this week and focusing on bugs reported against 
Version 4 master/alpha



Regards and thanks for leading this one,

Joel

P.S. Adding a few people to this one

--
*Joel Madero*
LibO QA Volunteer
jmadero@gmail.com mailto:jmadero@gmail.com
 Random tests: I could use some pointers as well. My specialty is 
Base. I noticed that there are only 3 random test for it, and all of 
them had locks. Seems to me that there should be more than 3. There is 
the creation of a database from beginning to end. What about modifying 
an existing database? What about connecting to a database such as MySQL, 
HSQLDB, text, spreadsheet, etc.?


--Dan Lewis
LibO QA Volunteer
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

Re: [Libreoffice-qa] Second Opinion - FDO#54981 FILEOPEN: Libre office can't open a MS Access database 2003.

[Dan Lewis]

On 10/19/2012 03:37 PM, Joel Madero wrote:

I need a second opinion on this one. Thanks all
https://bugs.freedesktop.org/show_bug.cgi?id=54981


Regards,
Joel

--
*Joel Madero*
LibO QA Volunteer
jmadero@gmail.com mailto:jmadero@gmail.com

 I use Ubuntu 12.04 LTS. I installed the MDBTool after which I 
downloaded the file from the Bug report. I had no problem exporting the 
file's tables in CSV format to a separate folder.
 I then created a Base database document file connecting to the 
text files in this folder. I used 3 versions of LO to open the database 
document file: 3.4.6, 3.5.6, and 3.6.2.
 3.4.6 reported an error: The data could not be loaded. The query 
could not be executed. It contains no valid columns. This was true for 
all tables.
 3.5.6 and 3.6.2 both loaded the data into all the tables. I could 
upload a zipped file containing the exported files to this Bug report if 
someone wants to see them.


--Dan





___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/


___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/

[Libreoffice-qa] New member

[Dan Lewis]

 I am Dan Lewis, who is writing chapters for the Base Guide. In 
doing so, I use Base of the latest versions of LO. This reveals bugs in 
it.  I have filed a few bug reports including one this morning. Writing 
is my priority, but I can also apply what I have learned when I have 
time when it comes to bugs in Base.


--Dan
___
List Name: Libreoffice-qa mailing list
Mail address: Libreoffice-qa@lists.freedesktop.org
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/