Ask Your Question

Base problems

asked 2017-01-31 00:08:08 +0100

cscj01 gravatar image

I have 4 LO databases from the old OO days. Each time I have upgraded, everything has worked well This time I have a number of issues. First, my auto increment columns (all are defined as integer) are not working properly with LO 5.1 on Ubuntu 16.04 x64. If I try to add a new record there is a zero in the field rather than the correct number. I can tell Base to add (save) the record, but it doesn't, and it doesn't tell me it hasn't saved it. I have another table that uses that AI column in the first table as a foreign key. When I try to add that information, I get a MySQL error. because of the foreign key constraint and the fact that the first record (row) in the first table was not updated. Secondly, I have another table that is populated by a query. When I open the form, there is nothing in the table. If I go to the queries and execute it from there, it works properly. I am using MySQL 5.1.7 and everything works fine in both MySQL from the command line as well as from Workbench. Can anyone offer any insight? Thanks.

edit retag flag offensive close merge delete


Question is a bit confusing. Are all these databases MySQL databases? If not, embedded or split (old or new split). Have similar set-up in Xubuntu and Mint 18 currently using LO v5.2.3.3 without problems. Have used v5.1.4.2 before and no problems. Is this a distro version? Any recent conversions of these "older" DB's?

Ratslinger gravatar imageRatslinger ( 2017-01-31 02:01:31 +0100 )edit

All DBs are MySQL access is direct.

cscj01 gravatar imagecscj01 ( 2017-01-31 06:54:14 +0100 )edit

What about LO version - distro or from LO?

Ratslinger gravatar imageRatslinger ( 2017-01-31 06:56:36 +0100 )edit

As I said LO version is It is a Ubuntu distro version.

cscj01 gravatar imagecscj01 ( 2017-01-31 17:03:20 +0100 )edit

Thank you. I knew the version just not if it was distro. I asked because this has been a problem source on occasion. However, as indicated in my answer I already loaded the distro version and can't find any problem.

Ratslinger gravatar imageRatslinger ( 2017-01-31 17:17:58 +0100 )edit

This is really funky. Only one of my forms malfunctions as described above. I have many that work properly. I can't find anything different as far as design except the query that does not load the table is a Union ALL, but the 2 queries that make up the Union are of tables that are identical in all respects except values. And the query works if I go to the query itself within LO. Also, I have no idea why the auto increment field is resetting to zero when I try to add a new row.

cscj01 gravatar imagecscj01 ( 2017-02-01 05:00:16 +0100 )edit

If I am reading everything correctly, you can add a record in SQL Workbench but not in the form and the query works in the query section but not in the form. If that is the case, then it appears something is definitely wrong within the form.

Ratslinger gravatar imageRatslinger ( 2017-02-01 05:44:51 +0100 )edit

You are correct as to the way things are working. What baffles me is that this form has worked for several versions of both OO and LO and many versions of Ubuntu. Perhaps it has to do with something unique to Ubuntu 16.04 and LO (distro).

cscj01 gravatar imagecscj01 ( 2017-02-01 18:41:09 +0100 )edit

Here's something else strange about the table not displaying anything on the form. If I execute the query from Base Queries, I get 4,260 rows. When I load the form, I get 4,260 rows with nothing being displayed. This tells me the query is being executed but not displayed. In the table Control, Visible is set to Yes. Very odd to me.

cscj01 gravatar imagecscj01 ( 2017-02-01 18:58:56 +0100 )edit

What you are saying is possible. Have seen in recent months where Ubuntu distro was producing a problem not present in regular LO version. Keep in mind this is rare. Only ran across 3 or 4 different occasions in all of 2016 (just one in Ubuntu). My reconstruction produced no problems and I do have multiple SQL (regular query & also macro) statements with joins and unions.

Ratslinger gravatar imageRatslinger ( 2017-02-01 19:02:53 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-01-31 08:24:09 +0100

Ratslinger gravatar image

Switched over to Ubuntu 16.04 which was installed about a month ago. Was going to review it again after abandoning it 18 mos. ago. I have LO v5.1.4.2 (distro) installed on it & MySQL v5.7.17 with MySQL Workbench v6.3.

Loaded about a dozen tables with a few thousand records over the tables from another system I use almost daily.

All works fine. Auto-increment working in all tables which have it. Queries work fine. Tables display data and work fine. Form all OK.

And as stated earlier, I'm using later versions from LO which also work without problem. Can't imagine what is causing your problem.

Some of this stuff originated from back on LO v4.4.2 and possibly earlier.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-31 00:08:08 +0100

Seen: 106 times

Last updated: Jan 31 '17