Ask Your Question
0

Base 5.1.1.3 Crashing Regularly

asked 2016-04-01 18:30:48 +0200

VagrantAsylum gravatar image

updated 2016-04-01 18:44:54 +0200

I'm using Base in LibreOffice 5.1.1.3, a fresh install. I have a table with 216 records that I'm creating a handful of Queries for. Upon editing the query and closing the window, Base crashes nearly 85% of the time. I've tried saving the query, not saving the query, saving the entire database as a whole prior to closing the window, nothing seems to prevent the program from crashing unexpectedly due to an unknown error.

For a while it wasn't a big deal, the auto recovery was annoying and time consuming to constantly have to effectively close and reopen the program, however the last time this happened the auto-recovery was "interrupted" and I've managed to lose a bunch of my work.

Any thoughts, ideas, tips?

edit retag flag offensive close merge delete

Comments

What's your OS and OS version? Have you found anything relevant in the Base BUG REPORTS?

frofa gravatar imagefrofa ( 2016-04-02 00:14:12 +0200 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2016-04-05 23:52:09 +0200

jay Arr gravatar image

Strongly suggest you SPLIT your database.

There is a tutorial about on how to do it in easy stages here. and there is also a wizard to help.

In my experience, of using BASE to develop a large application over 6-9 months, this one action significantly reduces the very annoying crash-almost-every-time.

Somewhere, I forget where, I read a technical explanation of why the crashing occurs. From memory, and I could be wrong, it's to do with having the database in-core along with everything else of LO.

edit flag offensive delete link more

Comments

It has to do with the compressing and uncompressing the Base file when opening and closing it.

Ratslinger gravatar imageRatslinger ( 2016-04-11 00:24:16 +0200 )edit
0

answered 2016-04-10 22:44:27 +0200

Michel_1495 gravatar image

I can only agree above suggestion. Split! I have a win pc, just installed lo to 5.1.2.2 & I use the mysql database from USBwebserver v8 (www.usbwebserver.net) & the extension Native Mysql connector 1.02. You can use lo base to create-edit tables & relationships or use phpadmin.

edit flag offensive delete link more

Comments

sorry, below ....

Michel_1495 gravatar imageMichel_1495 ( 2016-04-10 22:45:01 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-04-01 18:30:48 +0200

Seen: 664 times

Last updated: Apr 10 '16