MEPIS Community Forum

A Linux operating system based on Debian Stable
View unanswered posts | View unsolved topics | View active topics |



Reply to topic  [ 11 posts ]  Go to page 1, 2  Next
[Solved] OO Database reads wrong in Mepis 11 - why? 
Author Message
Forum Regular
Forum Regular

Joined: Wed May 26, 2010 5:25 pm
Posts: 159
Location: Alberta, Canada
Has thanked: 20 times
Have thanks: 6 times
Post # 276710
Post [Solved] OO Database reads wrong in Mepis 11 - why?
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.



Sat Jun 11, 2011 10:40 am
Profile
Forum Regular
Forum Regular
User avatar

Joined: Wed Aug 30, 2006 1:44 am
Posts: 606
Location: Midway between the Washington State rainforest, ocean and volcanoes
Has thanked: 773 times
Have thanks: 69 times
Post # 276813
Post Re: OO Database reads wrong in Mepis 11 - why?
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


Sun Jun 12, 2011 3:47 pm
Profile
Forum Regular
Forum Regular

Joined: Wed May 26, 2010 5:25 pm
Posts: 159
Location: Alberta, Canada
Has thanked: 20 times
Have thanks: 6 times
Post # 276888
Post Re: OO Database reads wrong in Mepis 11 - why?
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!


Mon Jun 13, 2011 2:07 pm
Profile
Forum Guide
Forum Guide
User avatar

Joined: Mon Jun 30, 2008 8:06 pm
Posts: 2952
Has thanked: 52 times
Have thanks: 376 times
Post # 276889
Post Re: OO Database reads wrong in Mepis 11 - why?
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.


Mon Jun 13, 2011 2:11 pm
Profile
Forum Veteran
Forum Veteran
User avatar

Joined: Wed Jul 19, 2006 6:13 am
Posts: 10296
Location: Geneva NY
Has thanked: 2994 times
Have thanks: 1915 times
Post # 276890
Post Re: OO Database reads wrong in Mepis 11 - why?
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: 32 bit, 3.14-0.bpo.1-686-pae. MX-14.2, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB DDR3, / and /home on Kingston SSD 120 GB, data on WesternDigital 1TB, Dell SP2309W monitor.


Mon Jun 13, 2011 2:17 pm

Jerry3904 thanked by: iridesce
Profile
Forum Regular
Forum Regular
User avatar

Joined: Fri Sep 10, 2010 3:30 pm
Posts: 250
Location: PALM BAY, FLORIDA U.S.A.
Has thanked: 38 times
Have thanks: 32 times
Post # 276897
Post Re: OO Database reads wrong in Mepis 11 - why?
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


Mon Jun 13, 2011 3:10 pm
Profile
Forum Regular
Forum Regular
User avatar

Joined: Fri Sep 10, 2010 3:30 pm
Posts: 250
Location: PALM BAY, FLORIDA U.S.A.
Has thanked: 38 times
Have thanks: 32 times
Post # 276904
Post Re: OO Database reads wrong in Mepis 11 - why?
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


Mon Jun 13, 2011 4:19 pm
Profile
Forum Veteran
Forum Veteran
User avatar

Joined: Wed Jul 12, 2006 2:26 pm
Posts: 7115
Has thanked: 390 times
Have thanks: 2317 times
Post # 276906
Post Re: OO Database reads wrong in Mepis 11 - why?
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.
Quote:
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



Mon Jun 13, 2011 4:41 pm
Profile
Forum Veteran
Forum Veteran
User avatar

Joined: Wed Jul 19, 2006 6:13 am
Posts: 10296
Location: Geneva NY
Has thanked: 2994 times
Have thanks: 1915 times
Post # 276907
Post Re: OO Database reads wrong in Mepis 11 - why?
Quote:
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: 32 bit, 3.14-0.bpo.1-686-pae. MX-14.2, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB DDR3, / and /home on Kingston SSD 120 GB, data on WesternDigital 1TB, Dell SP2309W monitor.


Mon Jun 13, 2011 4:54 pm
Profile
Forum Regular
Forum Regular

Joined: Wed May 26, 2010 5:25 pm
Posts: 159
Location: Alberta, Canada
Has thanked: 20 times
Have thanks: 6 times
Post # 276908
Post Re: OO Database reads wrong in Mepis 11 - why?
Quote:
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.

Quote:
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!


Mon Jun 13, 2011 5:10 pm
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 11 posts ]  Go to page 1, 2  Next

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.