[Solved] OO Database reads wrong in Mepis 11 - why?

This forum is intended for the discussion around the use of MEPIS in an office setting as distinct from home or indivicual usage. Examples include mail merge, database construction, hardware sharing, advertising, etc..
Message
Author
User avatar
reidun
Forum Regular
Forum Regular
Posts: 249
Joined: Wed May 26, 2010 5:25 pm

[Solved] OO Database reads wrong in Mepis 11 - why?

#1 Postby reidun » Sat Jun 11, 2011 10:40 am

Hi,

I'm having trouble with my OpenOffice database. I recently installed Mepis 11 on my laptop and replaced LibreOffice with OpenOffice by using a Squeeze repository as discussed in this thread: http://forum.mepiscommunity.org/viewtopic.php?f=84&t=30753. I did this because apparently LibreOffice is not compatible with a database created in OpenOffice.

My problem is that my database reads normally on my Mepis 8.5 machine, but when I copy it to the Mepis 11 laptop and open it with the OpenOffice on there, the table shows many, many of the same record interspersed throughout, and the records are all out of order. Many records are not there at all.

I thought something got corrupted in the transfer, but I tried it again and it did the same thing.

I read somewhere that OO Base requires some kind of Java to work properly, and that it comes with an old version. I looked on the OO website, and if you download a Debian package from them it doesn't include the Java for some reason. Does it not include it from the repository? Could this be why it's acting up?

If this can't be solved, I might have to go back to 8.5 on the laptop.

BTW: I created this database entirely in OpenOffice, and didn't change anything about what SQL it uses, so I don't actually know. It's whatever is default in OO Base.

Thanks!
Last edited by reidun on Tue Jun 14, 2011 7:46 pm, edited 1 time in total.

User avatar
iridesce
Forum Regular
Forum Regular
Posts: 606
Age: 58
Joined: Wed Aug 30, 2006 1:44 am

Re: OO Database reads wrong in Mepis 11 - why?

#2 Postby iridesce » Sun Jun 12, 2011 3:47 pm

Wish I know more and could help.

Learning ins and outs of Base in LO and will be watching this thread
...Ostara.................................... minni
Image Image
...Mepis 11_64...........................Mepis 11_32

User avatar
reidun
Forum Regular
Forum Regular
Posts: 249
Joined: Wed May 26, 2010 5:25 pm

Re: OO Database reads wrong in Mepis 11 - why?

#3 Postby reidun » Mon Jun 13, 2011 2:07 pm

From what I gather from Googling, LO can't use a database created in OO.

Any help would be appreciated, or if no one knows, I might just install 8.5 on my laptop.

I have also posted this question on the OpenOffice forum, but no response there yet.

Thanks!

User avatar
GoManutd
Forum Guide
Forum Guide
Posts: 2952
Joined: Mon Jun 30, 2008 8:06 pm

Re: OO Database reads wrong in Mepis 11 - why?

#4 Postby GoManutd » Mon Jun 13, 2011 2:11 pm

the schism between the two projects has already been clearly defined. java will remain the primary language for extending Oo, while the LO devs have decided upon python.

this may be part of the reason why you're having issues opening DB files.

User avatar
Jerry3904
Forum Veteran
Forum Veteran
Posts: 15329
Joined: Wed Jul 19, 2006 6:13 am

Re: OO Database reads wrong in Mepis 11 - why?

#5 Postby Jerry3904 » Mon Jun 13, 2011 2:17 pm

If you haven't done this already, you might want to look at the LO Base forum and maybe even register and post a question there. Something like your question has in fact recently been posted (is that you?).

I have posted questions there and found the participants very knowledgeable and helpful.
Production: 4.2.0-0.bpo.1-amd64, MX-15 RC1, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB, Kingston SSD 120 GB and WesternDigital 1TB
Testing: AAO 722: 3.16-0-4-686-pae. MX-15, AMD C-60 APU, 4 GB

User avatar
Frank D. Hubeny
Forum Regular
Forum Regular
Posts: 250
Age: 64
Joined: Fri Sep 10, 2010 3:30 pm

Re: OO Database reads wrong in Mepis 11 - why?

#6 Postby Frank D. Hubeny » Mon Jun 13, 2011 3:10 pm

Good afternoon group;

I sure hope that Libre Office does not do something like that with out having some form of way to convert Open Office to Libre Office. You read of of many people having problems now with files they need to use not being seen by OO. Add another twist to the mix can not be a good thing for people wanting to use the product. But having files from another product.
Until the next time we meet thank you for taking the time out of your day to visit
with me. I enjoyed spending time with you.

Frank D. Hubeny

User avatar
Frank D. Hubeny
Forum Regular
Forum Regular
Posts: 250
Age: 64
Joined: Fri Sep 10, 2010 3:30 pm

Re: OO Database reads wrong in Mepis 11 - why?

#7 Postby Frank D. Hubeny » Mon Jun 13, 2011 4:19 pm

Good Afternoon reidun;

I do not know if this will help you. But in the above maentioned LO Forum. A person was told to go back and use Java 1.5. You have to go down the Topic List to one labled something like OO LO issues.
The reply says LO has issues useing some of the newer versions of Java.
Until the next time we meet thank you for taking the time out of your day to visit
with me. I enjoyed spending time with you.

Frank D. Hubeny

User avatar
kmathern
Forum Veteran
Forum Veteran
Posts: 9097
Age: 58
Joined: Wed Jul 12, 2006 2:26 pm

Re: OO Database reads wrong in Mepis 11 - why?

#8 Postby kmathern » Mon Jun 13, 2011 4:41 pm

GoManutd wrote:the schism between the two projects has already been clearly defined. java will remain the primary language for extending Oo, while the LO devs have decided upon python.

this may be part of the reason why you're having issues opening DB files.
Jerry3904 wrote:If you haven't done this already, you might want to look at the LO Base forum and maybe even register and post a question there. Something like your question has in fact recently been posted (is that you?).

I have posted questions there and found the participants very knowledgeable and helpful.
Frank D. Hubeny wrote:Good afternoon group;

I sure hope that Libre Office does not do something like that with out having some form of way to convert Open Office to Libre Office. You read of of many people having problems now with files they need to use not being seen by OO. Add another twist to the mix can not be a good thing for people wanting to use the product. But having files from another product.

From what I read in the first post in this thread it sounds like reidun removed LibreOffice and installed the Debian Squeeze OpenOffice.org packages, so why would his problem have anything to do with LibreOffice?

I'm guessing reidun might not have completely removed all of LibreOffice or may not have completely installed everything required For OpenOffice.org (or maybe a combination of both).

There's more to removing LibreOffice than just removing all the packages with 'libreoffice' in their names. Listed below are the packages related to LibreOffice (excluding the libreoffice-l10n-** and libreoffice-help-** packages). The packages come from here: ftp://ftp.mepis.com/mepis/pool/main/libr/libreoffice/. Note that they are all version '...3.3.2-3'. The packages highlighted in red don't contain 'libreoffice' in their name and you should make sure they've been removed because they might interfere with the installation/operation of their OpenOffice.org counterparts.
cli-uno-bridge_3.3.2-3
libreoffice-base-core_3.3.2-3
libreoffice-base_3.3.2-3
libreoffice-calc_3.3.2-3
libreoffice-common_3.3.2-3
libreoffice-core_3.3.2-3
libreoffice-dev-doc_3.3.2-3
libreoffice-dev_3.3.2-3
libreoffice-draw_3.3.2-3
libreoffice-emailmerge_3.3.2-3
libreoffice-evolution_3.3.2-3
libreoffice-filter-binfilter_3.3.2-3
libreoffice-filter-mobiledev_3.3.2-3
libreoffice-gcj_3.3.2-3
libreoffice-gnome_3.3.2-3
libreoffice-gtk_3.3.2-3
libreoffice-impress_3.3.2-3
libreoffice-java-common_3.3.2-3
libreoffice-kde_3.3.2-3
libreoffice-math_3.3.2-3
libreoffice-mysql-connector_1.0.1+LibO3.3.2-3
libreoffice-officebean_3.3.2-3
libreoffice-ogltrans_3.3.2-3
libreoffice-pdfimport_1.0.3+LibO3.3.2-3
libreoffice-presentation-minimizer_1.0.3+LibO3.3.2-3
libreoffice-presenter-console_1.1.0+LibO3.3.2-3
libreoffice-report-builder-bin_3.3.2-3
libreoffice-report-builder_1.2.1+LibO3.3.2-3
libreoffice-sdbc-postgresql_0.7.6+LibO3.3.2-3
libreoffice-style-andromeda_3.3.2-3
libreoffice-style-crystal_3.3.2-3
libreoffice-style-galaxy_3.3.2-3
libreoffice-style-hicontrast_3.3.2-3
libreoffice-style-oxygen_3.3.2-3
libreoffice-style-tango_3.3.2-3
libreoffice-wiki-publisher_1.1.1+LibO3.3.2-3
libreoffice-writer_3.3.2-3
libreoffice_3.3.2-3
libuno-cli-basetypes1.0-cil_1.0.18.0+LibO3.3.2-3
libuno-cli-cppuhelper1.0-cil_1.0.21.0+LibO3.3.2-3
libuno-cli-oootypes1.0-cil_1.0.7.0+LibO3.3.2-3
libuno-cli-ure1.0-cil_1.0.21.0+LibO3.3.2-3
libuno-cli-uretypes1.0-cil_1.0.7.0+LibO3.3.2-3

mozilla-libreoffice_3.3.2-3
openoffice.org-dtd-officedocument1.0_1.0+LibO3.3.2-3
python-uno_3.3.2-3
ttf-opensymbol_2.4.3+LibO3.3.2-3
uno-libs3_1.7.0+LibO3.3.2-3
ure_1.7.0+LibO3.3.2-3


User avatar
Jerry3904
Forum Veteran
Forum Veteran
Posts: 15329
Joined: Wed Jul 19, 2006 6:13 am

Re: OO Database reads wrong in Mepis 11 - why?

#9 Postby Jerry3904 » Mon Jun 13, 2011 4:54 pm

From what I read in the first post in this thread it sounds like reidun removed LibreOffice and installed the Debian Squeeze OpenOffice.org packages, so why would his problem have anything to do with LibreOffice?
Right you are--I misread OP.
Production: 4.2.0-0.bpo.1-amd64, MX-15 RC1, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB, Kingston SSD 120 GB and WesternDigital 1TB
Testing: AAO 722: 3.16-0-4-686-pae. MX-15, AMD C-60 APU, 4 GB

User avatar
reidun
Forum Regular
Forum Regular
Posts: 249
Joined: Wed May 26, 2010 5:25 pm

Re: OO Database reads wrong in Mepis 11 - why?

#10 Postby reidun » Mon Jun 13, 2011 5:10 pm

From what I read in the first post in this thread it sounds like reidun removed LibreOffice and installed the Debian Squeeze OpenOffice.org packages, so why would his problem have anything to do with LibreOffice?


That is what I did. The only reason it would have anything to do with LO, is that if OO gets dropped in the future, it would be nice if LO could seamlessly read OO files.

There's more to removing LibreOffice than just removing all the packages with 'libreoffice' in their names. Listed below are the packages related to LibreOffice (excluding the libreoffice-l10n-** and libreoffice-help-** packages). The packages come from here: ftp://ftp.mepis.com/mepis/pool/main/libr/libreoffice/. Note that they are all version '...3.3.2-3'. The packages highlighted in red don't contain 'libreoffice' in their name and you should make sure they've been removed because they might interfere with the installation/operation of their OpenOffice.org counterparts.


I did check, and I didn't have any of the files in red installed, so should be good there.

I also asked this question on the OO forum, and someone replied saying that the database not reading properly is a known bug in 3.2.1, and to solve it download 3.3 directly from the OO site. I think I will try this, as much as I hate not being able to use the repositories, which make installing/updating sooo much easier!

Will post my results after installing 3.3.

Thanks all!


Return to “Office”

Who is online

Users browsing this forum: No registered users and 1 guest